Package org.tmatesoft.sqljet.core.table

Examples of org.tmatesoft.sqljet.core.table.ISqlJetTransaction

110
111
112
113
114
115
116
117
118
119
120
        Assert.assertTrue(false);
    }

    @Test
    public void createTableTestUnique() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text unique )");
                final ISqlJetTable openTable = db.getTable(createTable.getName());
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
        });
    }

    @Test(expected = SqlJetException.class)
    public void createTableTestUniqueFail() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text unique )");
                final ISqlJetTable openTable = db.getTable(createTable.getName());
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        Assert.assertFalse(false);
    }

    @Test
    public void createIndexTest() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                final ISqlJetTable openTable = db.getTable(createTable.getName());
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
        });
    }

    @Test(expected = SqlJetException.class)
    public void createIndexFailTable() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                db.createIndex("CREATE INDEX test_name_index ON test(name);");
                return null;
            }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
        Assert.assertFalse(false);
    }

    @Test(expected = SqlJetException.class)
    public void createIndexFailColumn() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                final ISqlJetTable openTable = db.getTable(createTable.getName());
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
        Assert.assertFalse(false);
    }

    @Test(expected = SqlJetException.class)
    public void createIndexFailName() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                final ISqlJetTable openTable = db.getTable(createTable.getName());
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
    }

    @Test
    public void createIndexRepCache() throws SqlJetException, FileNotFoundException, IOException {
        final SqlJetDb repCache = SqlJetDb.open(copyFile(new File(REP_CACHE_DB), DELETE_COPY), true);
        repCache.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                db.createIndex("CREATE INDEX rep_cache_test_index ON " + REP_CACHE_TABLE
                        + "(hash, revision, offset, size, expanded_size);");
                final ISqlJetTable openTable = repCache.getTable(REP_CACHE_TABLE);
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
    }

    @Test
    public void createTableRepCache() throws SqlJetException, FileNotFoundException, IOException {
        final SqlJetDb repCache = SqlJetDb.open(copyFile(new File(REP_CACHE_DB), DELETE_COPY), true);
        repCache.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                final ISqlJetTable openTable = repCache.getTable(createTable.getName());
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
    }

    @Test
    public void dropTableRepCache() throws SqlJetException, FileNotFoundException, IOException {
        final SqlJetDb repCache = SqlJetDb.open(copyFile(new File(REP_CACHE_DB), DELETE_COPY), true);
        repCache.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                db.dropTable(REP_CACHE_TABLE);
                return null;
            }
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
        Assert.assertNull(openTable);
    }

    @Test
    public void dropTableTest1() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {

            public Object run(SqlJetDb db) throws SqlJetException {
                db.dropTable("test1");
                return null;
            }
View Full Code Here
TOP

Related Classes of org.tmatesoft.sqljet.core.table.ISqlJetTransaction

  • org.tmatesoft.sqljet.browser.core.data.DataTableModel
  • org.tmatesoft.sqljet.core.AbstractNewDbTest
  • org.tmatesoft.sqljet.core.internal.table.SqlJetCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetIndexOrderCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetIndexScopeCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetRowNumCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetTable
  • org.tmatesoft.sqljet.core.internal.table.SqlJetTableDataCursor
  • org.tmatesoft.sqljet.core.schema.CaseInsensitiveNamesTest
  • org.tmatesoft.sqljet.core.schema.ConcurrentSchemaModificationTest$TransactionTask
    • 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.