Package org.jitterbit.integration.database.info

Examples of org.jitterbit.integration.database.info.DatabaseColumn

44
45
46
47
48
49
50
51
52
        DatabaseObject[] dbObjects = dbInfo.getDatabaseObjects();
        objects = createObjectMap(dbObjects);
        keyMap = new KeyMap(dbObjects);
        BeginEndQuote quotes = getBeginEndQuote(dbInfo);
        for (String key : getKeysAsStrings(dbInfo)) {
            DatabaseColumn col = getColumn(key, quotes);
            keyMap.addKey(col);
        }
    }
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
    }

    private static List<DatabaseColumn> createColumns(DatabaseObject dbObj, boolean withPK) {
        List<DatabaseColumn> columns = new ArrayList<DatabaseColumn>();
        for (int n = 0; n < 6; ++n) {
            DatabaseColumn c = new DatabaseColumn(dbObj, "Column " + (n + 1), null, 0, null, true, withPK && n == 0, 0,
                            0);
            columns.add(c);
        }
        return columns;
    }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
        this.includeSchema = includeSchema;
    }

    public DatabaseTable createOrdersTable() {
        DatabaseTable table = new DatabaseTable("Orders", "public");
        DatabaseColumn col = new DatabaseColumn(table, "OrderId", "int", 0, null, false, true);
        table.addColumn(col);
        table.addColumn(new DatabaseColumn(table, "CustomerId", "int", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "OrderDate", "date", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "ShippedDate", "date", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "ShipVia", "int", 0, null, false, false));
        return checkSchema(table);
    }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
57
        return checkSchema(table);
    }

    public DatabaseTable createOrderDetailsTable() {
        DatabaseTable table = new DatabaseTable(quotes.escapeNameIfNeeded("Order Details"), "public");
        DatabaseColumn col = new DatabaseColumn(table, "OrderId", "int", 0, null, false, true);
        table.addColumn(col);
        col = new DatabaseColumn(table, "ProductId", "int", 0, null, false, true);
        table.addColumn(col);
        table.addColumn(new DatabaseColumn(table, "UnitPrice", "money", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "Quantity", "int", 0, null, false, false));
        return checkSchema(table);
    }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
        return checkSchema(table);
    }

    public DatabaseTable createProductsTable() {
        DatabaseTable table = new DatabaseTable(quotes.escapeNameIfNeeded("Products"), "public");
        table.addColumn(new DatabaseColumn(table, "ProductId", "int", 0, null, false, true));
        table.addColumn(new DatabaseColumn(table, "Name", "varchar", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "Type", "varchar", 0, null, false, false));
        return checkSchema(table);
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
        return checkSchema(table);
    }

    public DatabaseTable createOrderLogTable() {
        DatabaseTable table = new DatabaseTable(quotes.escapeNameIfNeeded("Order.Log"), "public");
        DatabaseColumn col = new DatabaseColumn(table, "OrderId", "int", 0, null, false, true);
        table.addColumn(col);
        table.addColumn(new DatabaseColumn(table, quotes.escapeNameIfNeeded("Log.A"), "string", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, quotes.escapeNameIfNeeded("Log.B"), "string", 0, null, false, false));
        return checkSchema(table);
    }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
        return 3;
    }

    @Override
    public Object getValueAt(int index) {
        DatabaseColumn col = (DatabaseColumn) getUserObject();
        switch (index) {
        case 0:
            return col;
        case 1:
            return col.getDataTypeString();
        case 2:
            return Boolean.valueOf(col.isPrimaryKey());
        default:
            throw new IndexOutOfBoundsException("Index: " + index);
        }
    }
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
33
public class FieldRelationshipJUnitTest {

    @Test
    public void testGetters() {
        DatabaseTable orders = new DatabaseTable("orders", "public");
        DatabaseColumn pk = new DatabaseColumn(orders, "orderid", "serial", 0, null, false, true);
        DatabaseTable orderDetails = new DatabaseTable("order details", "public");
        DatabaseColumn fk = new DatabaseColumn(orderDetails, "orderid", "int", 0, null, false, false);
        FieldRelationship rel = new FieldRelationship(pk, fk);
        assertSame(rel.getParentColumn(), pk);
        assertSame(rel.getChildColumn(), fk);
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
45
    }
   
    @Test
    public void testEquality() {
        DatabaseTable orders = new DatabaseTable("orders", "public");
        DatabaseColumn pk = new DatabaseColumn(orders, "orderid", "serial", 0, null, false, true);
        DatabaseTable orderDetails = new DatabaseTable("order details", "public");
        DatabaseColumn fk = new DatabaseColumn(orderDetails, "orderid", "int", 0, null, false, false);
        FieldRelationship rel_1 = new FieldRelationship(pk, fk);
        FieldRelationship rel_2 = new FieldRelationship(pk, fk);
        FieldRelationship rel_3 = new FieldRelationship(pk, pk);
        assertEquals(rel_1, rel_2);
        assertEquals(rel_1.hashCode(), rel_2.hashCode());
View Full Code Here
92
93
94
95
96
97
98
99
100
101
        return null;
    }

    private boolean isColumnNodeAccepted(TreeTableNode node) {
        if (node instanceof ColumnNode) {
            DatabaseColumn column = (DatabaseColumn) node.getUserObject();
            return filter.acceptsColumn(column);
        }
        return true;
    }
View Full Code Here
TOP

Related Classes of org.jitterbit.integration.database.info.DatabaseColumn

  • org.jitterbit.integration.client.database.serverapi.MockOdbcInfoProvider
  • org.jitterbit.integration.client.database.ui.DatabaseColumnsTable
  • org.jitterbit.integration.client.database.ui.primarykeys.TreeBasedPrimaryKeyDefinerTest
  • org.jitterbit.integration.client.database.ui.sqlbuilder.tree.ColumnNode
  • org.jitterbit.integration.client.database.ui.sqlbuilder.tree.DbObjectsTreeModel
  • org.jitterbit.integration.client.database.ui.sqlbuilder.tree.TreeTransferHandler
  • org.jitterbit.integration.client.ui.interchange.entity.transformation.database.DatabaseObjectBuilder$VisitorImpl
  • org.jitterbit.integration.client.ui.structure.editor.db.EditedStructureSchemaChange
  • org.jitterbit.integration.client.ui.structure.editor.db.PrimaryKeysCreator
  • org.jitterbit.integration.client.ui.structure.editor.db.rels.DropdownLinkKeysDefiner$LinkDefiner
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.