Package org.tmatesoft.sqljet.core.table

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

265
266
267
268
269
270
271
272
273
274
275
        Assert.assertNull(openTable);
    }

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

            public Object run(SqlJetDb db) throws SqlJetException {
                db.dropIndex("test1_name_index");
                db.dropIndex("test1_value_index");
                return null;
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
        Assert.assertNull(db.getSchema().getIndex("test1_value_index"));
    }

    @Test
    public void dropAll() throws SqlJetException {
        db.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                // /Set<String> indices = db.getSchema().getIndexNames();
                Set<String> tables = db.getSchema().getTableNames();
                for (String tableName : tables) {
                    ISqlJetTableDef tableDef = db.getSchema().getTable(tableName);
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
        final File createFile = File.createTempFile(SCHEMA_TEST, null);
        if (DELETE_COPY)
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        createDb.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                logger.info(createTable.toString());
                db.createIndex("CREATE INDEX test_index ON test(name);");
View Full Code Here
329
330
331
332
333
334
335
336
337
338
339
        if (DELETE_COPY)
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        createDb.getOptions().setEncoding(SqlJetEncoding.UTF16LE);
        createDb.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                logger.info(createTable.toString());
                db.createIndex("CREATE INDEX test_index ON test(name);");
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
        final File createFile = File.createTempFile(SCHEMA_TEST, null);
        if (DELETE_COPY)
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        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 )");
                logger.info(createTable.toString());
                db.createIndex("CREATE INDEX test_index ON test(name);");
View Full Code Here
384
385
386
387
388
389
390
391
392
393
394
        final File createFile = File.createTempFile(SCHEMA_TEST, null);
        if (DELETE_COPY)
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        createDb.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                createDb.getOptions().setCacheSize(1000);
                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                logger.info(createTable.toString());
View Full Code Here
421
422
423
424
425
426
427
428
429
430
431
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        createDb.getOptions().setAutovacuum(true);
        createDb.getOptions().setIncrementalVacuum(true);
        createDb.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {

                final ISqlJetTableDef createTable = db
                        .createTable("create table test( id integer primary key, name text )");
                logger.info(createTable.toString());
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
        final File createFile = File.createTempFile(SCHEMA_TEST, null);
        if (DELETE_COPY)
            createFile.deleteOnExit();

        final SqlJetDb createDb = SqlJetDb.open(createFile, true);
        createDb.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                createDb.getOptions().setSchemaVersion(123);
                return null;
            }
        });
View Full Code Here
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
    }

    @Test(expected = SqlJetException.class)
    public void createIndexUniqueFail() 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 )");
                logger.info(createTable.toString());
                final ISqlJetIndexDef createIndex = db.createIndex("create unique index index_test_text on test(name)");
                logger.info(createIndex.toString());
                return null;
            }
        });
        db.close();
        db.open();
        db.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                final ISqlJetTable openTable = db.getTable("test");
                openTable.insert(null, "test");
                openTable.insert(null, "test");
                return null;
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
                    SqlJetDb db = null;
                    try {
                        final int n = i++;
                        db = SqlJetDb.open(file, true);
                        synchronized (TransactionTask.class) {
                            db.runWriteTransaction(new ISqlJetTransaction() {
                                public Object run(SqlJetDb db) throws SqlJetException {
                                    return workInTransaction(db, n);
                                }
                            });
                        }
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.