Package org.jitterbit.integration.database.info

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

31
32
33
34
35
36
37
38
            test.dispose();
        }
    }

    private static void testUsingMetaData(DatabaseColumnRetrieverTest test) throws SQLException {
        DatabaseObject table = new DatabaseTable("sourcestab", null);
        test.listColumns(table);
    }
View Full Code Here
30
31
32
33
34
35
36
37
        generator = new XsdNameGenerator("", quotes);
    }

    @Test
    public void ensureSimpleCasesWork() {
        DatabaseTable table = new DatabaseTable("orders", "public");
        assertEquals(table.getName() + ".xsd", generator.getXsdName(table));
    }
View Full Code Here
36
37
38
39
40
41
42
43
        assertEquals(table.getName() + ".xsd", generator.getXsdName(table));
    }

    @Test
    public void ensurePossiblyInvalidCharactersAreEscaped() {
        DatabaseTable table = new DatabaseTable("order:details", "public");
        assertEquals("order_details" + ".xsd", generator.getXsdName(table));
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
        assertEquals("order_details" + ".xsd", generator.getXsdName(table));
    }

    @Test
    public void ensureReservedWordsAreDetected() {
        DatabaseTable table = new DatabaseTable("con", "public");
        assertEquals("con_" + ".xsd", generator.getXsdName(table));
        table = new DatabaseTable("NUL", "public");
        assertEquals("NUL_" + ".xsd", generator.getXsdName(table));
    }
View Full Code Here
51
52
53
54
55
56
57
58
    }

    @Test
    public void ensureQuotesAreRemoved() {
        String name = "orders";
        DatabaseTable table = new DatabaseTable(quotes.escapeName(name), "public");
        assertEquals(name + ".xsd", generator.getXsdName(table));
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
        assertEquals(name + ".xsd", generator.getXsdName(table));
    }

    @Test
    public void ensureQualifiedNamesAreHandled() {
        DatabaseTable table = new DatabaseTable("orders", "public");
        String qualifiedName = quotes.getQualifiedName(table);
        table = (DatabaseTable) table.createCopy(table.getSchema(), qualifiedName);
        assertEquals("public.orders.xsd", generator.getXsdName(table));
    }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    }

    @Test
    public void ensureThatDbNameIsIncludedIfPresent() {
        generator = new XsdNameGenerator("prod", quotes);
        DatabaseTable table = new DatabaseTable("orders", "public");
        assertEquals("prod.orders.xsd", generator.getXsdName(table));
        generator = new XsdNameGenerator("prod:1", quotes);
        table = new DatabaseTable("orders", "public");
        assertEquals("prod_1.orders.xsd", generator.getXsdName(table));
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
        objs[1] = createCharactersTable();
        return objs;
    }
   
    private DatabaseTable createEpisodesTable() {
        DatabaseTable table = new DatabaseTable("Episodes", "Seinfeld");
        DatabaseColumn col = new DatabaseColumn(table, "EpisodeId", "int", 0, null, false, true);
        table.addColumn(col);
        table.addColumn(new DatabaseColumn(table, "SeasonId", "int", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "Name", "string", 0, null, false, false));
        table.addColumn(new DatabaseColumn(table, "RunningTime", "int", 0, null, false, false));
        return table;
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
        table.addColumn(new DatabaseColumn(table, "RunningTime", "int", 0, null, false, false));
        return table;
    }

    private DatabaseTable createCharactersTable() {
        DatabaseTable table = new DatabaseTable("Characters", "Seinfeld");
        DatabaseColumn col = new DatabaseColumn(table, "CharacterId", "int", 0, null, false, true);
        table.addColumn(col);
        table.addColumn(new DatabaseColumn(table, "EpisodeId", "int", 0, null, false, true));
        table.addColumn(new DatabaseColumn(table, "Name", "string", 0, null, false, true));
        return table;
    }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
    private static final String[] SYNONYM_NAMES = { "Beautiful_Handsome", "Quiet_Calm", "Fast_Quick" };

    private static List<DatabaseTable> createTables() {
        List<DatabaseTable> tables = new ArrayList<DatabaseTable>();
        for (int n = 0; n < TABLE_NAMES.length; ++n) {
            DatabaseTable t = new DatabaseTable(TABLE_NAMES[n], "");
            for (DatabaseColumn c : createColumns(t, (n % 2) == 0)) {
                t.addColumn(c);
            }
            tables.add(t);
        }
        return tables;
    }
View Full Code Here
TOP

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

  • org.jitterbit.integration.client.connect.db2xml.wizard.XsdNameGeneratorJUnitTest
  • org.jitterbit.integration.client.database.DbColumnInfoCreator
  • org.jitterbit.integration.client.database.serverapi.MockOdbcInfoProvider
  • org.jitterbit.integration.client.database.ui.primarykeys.TreeBasedPrimaryKeyDefinerTest
  • org.jitterbit.integration.client.ui.interchange.entity.transformation.database.DatabaseObjectBuilder$VisitorImpl
  • org.jitterbit.integration.client.ui.structure.editor.db.BeginEndQuoteGuesserJUnitTest
  • org.jitterbit.integration.client.ui.structure.editor.db.SingleTableWhereClausePageUiTest
  • org.jitterbit.integration.client.ui.structure.editor.db.TableCreator
  • org.jitterbit.integration.client.ui.structure.editor.db.UpdateSourceDatabasePageUiTest
  • org.jitterbit.integration.data.structure.database.DatabaseTableJUnitTest
    • 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.