Package org.tmatesoft.sqljet.core.schema

Examples of org.tmatesoft.sqljet.core.schema.ISqlJetTableDef

224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
    @Test
    public void tableDef() throws SqlJetException {
        final ISqlJetTable table = dbCopy.getTable(TABLE);

        final ISqlJetTableDef tableDef = table.getDefinition();

        Assert.assertNotNull(tableDef);

        final String tableName = tableDef.getName();

        Assert.assertNotNull(tableName);
        Assert.assertEquals(TABLE, tableName);

        final List<ISqlJetColumnDef> columns = tableDef.getColumns();

        Assert.assertNotNull(columns);
        Assert.assertEquals(4, columns.size());
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
    @Test
    public void createDbInMemory() throws Exception {
        SqlJetDb db = new SqlJetDb(SqlJetDb.IN_MEMORY, true);
        db.open();
        try {
            final ISqlJetTableDef tDef = db.createTable("create table t(a integer primary key, b text);");
            final ISqlJetTable t = db.getTable(tDef.getName());
            t.insert(null, "hello");
            t.insert(null, "world");
            db.runReadTransaction(new ISqlJetTransaction() {
                public Object run(SqlJetDb db) throws SqlJetException {
                    final ISqlJetCursor c = t.open();
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
        assertEquals(SqlJetTypeAffinity.NUMERIC, SqlJetTypeAffinity.decode("byte"));
    }

    public void testSchema() throws SqlJetException {
        String sql = "create table t (c1 int primary key, c2 varchar, c3 super double, c4 short unique, c5 blob, c6)";
        ISqlJetTableDef table = new SqlJetTableDef(parse(sql), 0);
        ISqlJetColumnDef c1 = table.getColumn("c1");
        assertEquals(SqlJetTypeAffinity.INTEGER, c1.getTypeAffinity());
        ISqlJetColumnDef c2 = table.getColumn("c2");
        assertEquals(SqlJetTypeAffinity.TEXT, c2.getTypeAffinity());
        ISqlJetColumnDef c3 = table.getColumn("c3");
        assertEquals(SqlJetTypeAffinity.REAL, c3.getTypeAffinity());
        ISqlJetColumnDef c4 = table.getColumn("c4");
        assertEquals(SqlJetTypeAffinity.NUMERIC, c4.getTypeAffinity());
        ISqlJetColumnDef c5 = table.getColumn("c5");
        assertEquals(SqlJetTypeAffinity.NONE, c5.getTypeAffinity());
        ISqlJetColumnDef c6 = table.getColumn("c6");
        assertEquals(SqlJetTypeAffinity.NONE, c6.getTypeAffinity());
    }
View Full Code Here
TOP

Related Classes of org.tmatesoft.sqljet.core.schema.ISqlJetTableDef

  • org.tmatesoft.sqljet.browser.core.data.DataTableModel
  • org.tmatesoft.sqljet.browser.core.schema.SchemaTreeModel
  • org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema
  • org.tmatesoft.sqljet.core.internal.table.SqlJetTable
  • org.tmatesoft.sqljet.core.lang.SqlJetTypeAffinityTest
  • org.tmatesoft.sqljet.core.table.DbInMemoryTest
  • org.tmatesoft.sqljet.core.table.SqlJetTableTest
  • org.tmatesoft.sqljet.examples.tutorial.Tutorial
  • org.tmatesoft.sqljet.issues._128.InsertOrUpdateDoesntWorkTest
  • org.tmatesoft.sqljet.issues._134.AutoincrementTest
    • 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.