Compare Java and Clojure Tableau TDE API

make-order.clj

(require [clj-tableau.dataextract :refer :all])

(def table-definition
  {
   :collation Collation/EN_GB
   :columns   ["Purchased"        Type/DATETIME
               "Product"          Type/CHAR_STRING
               "uProduct"         Type/UNICODE_STRING
               "Price"            Type/DOUBLE
               "Quantity"         Type/INTEGER
               "Taxed"            Type/BOOLEAN
               "Expiration Date"  Type/DATE
               "Produkt"         [Type/CHAR_STRING Collation/DE]]})

(def test-data
  (repeatedly
    #(vec [ [2012 7 3 11 40 12 4550] "Beans" "uniBeans" 1.08
           (rand-int 100) (rand-nth [true false]) [2029 1 1] "Bohnen" ] )))

(defn print-table-definition
  [table]
  (dorun (map println (get table :def)))
  table)

(try
  (with-extract [order "order-clojure.tde"]
                (->
                  (table order "Extract" table-definition)
                  (print-table-definition)
                  (add-rows (take 10 test-data))))
  (catch Exception e
    (clojure.stacktrace/root-cause e)))

MakeOrder.java

// -----------------------------------------------------------------------
// The information in this file is the property of Tableau Software and
// is confidential.
//
// Copyright (C) 2012  Tableau Software.
// Patents Pending.
// -----------------------------------------------------------------------
// externalapi/samples/com/tableausoftware/demos/MakeOrder.java
// -----------------------------------------------------------------------
package com.tableausoftware.demos;

import com.tableausoftware.TableauException;
import com.tableausoftware.DataExtract.*;

public final class MakeOrder {

    // Define the table's schema
    private static TableDefinition makeTableDefinition() throws TableauException {
        TableDefinition tableDef = new TableDefinition();
        tableDef.setDefaultCollation(Collation.EN_GB);

        tableDef.addColumn("Purchased",       Type.DATETIME);
        tableDef.addColumn("Product",         Type.CHAR_STRING);
        tableDef.addColumn("uProduct",        Type.UNICODE_STRING);
        tableDef.addColumn("Price",           Type.DOUBLE);
        tableDef.addColumn("Quantity",        Type.INTEGER);
        tableDef.addColumn("Taxed",           Type.BOOLEAN);
        tableDef.addColumn("Expiration Date", Type.DATE);

        // Column with non-default collation
        tableDef.addColumnWithCollation("Produkt", Type.CHAR_STRING, Collation.DE);

        return tableDef;
    }

    // Print a Table's schema to stderr.
    private static void printTableDefinition(TableDefinition tableDef) throws TableauException {
        int numColumns = tableDef.getColumnCount();
        for ( int i = 0; i < numColumns; ++i ) {
            Type type = tableDef.getColumnType(i);
            String name = tableDef.getColumnName(i);

            System.err.format("Column %d: %s (%#06x)\n", i, name, type.getValue());
        }
    }

    // Insert a few rows of data
    private static void insertData(Table table) throws TableauException {
        TableDefinition tableDef = table.getTableDefinition();
        Row row = new Row(tableDef);

        row.setDateTime(  0, 2012, 7, 3, 11, 40, 12, 4550); // Purchased
        row.setCharString(1, "Beans");                      // Product
        row.setString(    2, "uniBeans");                   // uProduct
        row.setDouble(    3, 1.08);                         // Price
        row.setDate(      6, 2029, 1, 1);                   // Expiration date
        row.setCharString(7, "Bohnen");                     // Produkt

        for ( int i = 0; i < 10; ++i ) {
            row.setInteger(4, i * 10);                      // Quantity
            row.setBoolean(5, i % 2 == 1);                  // Taxed
            table.insert(row);
        }
    }

    public static void main( String[] args ) {

        try (Extract extract = new Extract("order-java.tde")) {

            Table table;
            if (!extract.hasTable("Extract")) {
                // Table does not exist; create it
                TableDefinition tableDef = makeTableDefinition();        
                table = extract.addTable("Extract", tableDef);
            }
            else {
                // Open an existing table to add more rows
                table = extract.openTable("Extract");
            }

            TableDefinition tableDef = table.getTableDefinition();
            printTableDefinition(tableDef);

            insertData(table);
        }
        catch (Throwable t) {
            t.printStackTrace(System.err);
        }
    }
}