Java Code Examples for com.j256.ormlite.table.TableUtils#createTable()

The following examples show how to use com.j256.ormlite.table.TableUtils#createTable() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: DBEmailQueueTest.java    From passopolis-server with GNU General Public License v3.0 6 votes vote down vote up 
@Test
public void testTimeZone() throws SQLException {
  // create a temporary H2 connection
  JdbcConnectionSource connection = new JdbcConnectionSource("jdbc:h2:mem:");
  TableUtils.createTable(connection, DBEmailQueue.class);
  Dao<DBEmailQueue, Integer> dao = DaoManager.createDao(connection, DBEmailQueue.class);

  DBEmailQueue email = DBEmailQueue.makeInvitation("[email protected]", "[email protected]", "pw");
  dao.create(email);

  // Force a daylight savings time string in the DB
  setRawDate(connection, email.getId(), "2013-05-17T14:47:59.864022");
  Date t = dao.queryForId(email.getId()).getAttemptedTime();
  assertEquals("2013-05-17T14:47:59.864Z", DBEmailQueue.getUtcIsoFormat().format(t));
  assertEquals(1368802079864L, t.getTime());

  // Set a date/time in standard time, not daylight time
  setRawDate(connection, email.getId(), "2013-11-04T15:38:11.997012");
  t = dao.queryForId(email.getId()).getAttemptedTime();
  assertEquals("2013-11-04T15:38:11.997Z", DBEmailQueue.getUtcIsoFormat().format(t));
  assertEquals(1383579491997L, t.getTime());
}
Example 2
Source File: DatabaseHelper.java    From ormlite-android-gradle-plugin with Apache License 2.0 6 votes vote down vote up 
/**
 * This is called when the database is first created. Usually you should call createTable statements here to create
 * the tables that will store your data.
 */
@Override
public void onCreate(SQLiteDatabase db, ConnectionSource connectionSource) {
    try {
        Log.i(DatabaseHelper.class.getName(), "onCreate");
        TableUtils.createTable(connectionSource, SimpleData.class);
    } catch (SQLException e) {
        Log.e(DatabaseHelper.class.getName(), "Can't create database", e);
        throw new RuntimeException(e);
    }

    // here we try inserting data in the on-create as a test
    RuntimeExceptionDao<SimpleData, Integer> dao = getSimpleDataDao();
    long millis = System.currentTimeMillis();
    // create some entries in the onCreate
    SimpleData simple = new SimpleData(millis);
    dao.create(simple);
    simple = new SimpleData(millis + 1);
    dao.create(simple);
    Log.i(DatabaseHelper.class.getName(), "created new entries in onCreate: " + millis);
}
Example 3
Source File: DataBaseHelper.java    From privacy-friendly-shopping-list with Apache License 2.0 6 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase database, final ConnectionSource connectionSource)
{
    try
    {
        setupClasses();
        PFALogger.debug(getClass().getName(), ON_CREATE, START);
        for ( Class aClass : entityClasses )
        {
            TableUtils.createTable(connectionSource, aClass);
        }
    }
    catch ( Exception e )
    {
        PFALogger.error(getClass().getName(), ON_CREATE, e);
    }
}
Example 4
Source File: DatabaseHelperImpl.java    From marvel with MIT License 5 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase sqliteDatabase, ConnectionSource connectionSource) {
    try {
        // Create tables. This onCreate() method will be invoked only once of the application life time i.e. the first time when the application starts.
        TableUtils.createTable(connectionSource, CharacterModel.class);

    } catch (SQLException e) {
        Log.e(DatabaseHelper.class.getName(), "Unable to create database", e);
    }
}
Example 5
Source File: DatabaseHelper.java    From AndroidDatabaseLibraryComparison with MIT License 5 votes vote down vote up 
/**
 * This is called when the database is first created. Usually you should call createTable statements here to create
 * the tables that will store your data.
 */
@Override
public void onCreate(SQLiteDatabase db, ConnectionSource connectionSource) {
    try {
        Log.i(DatabaseHelper.class.getName(), "onCreate");
        TableUtils.createTable(connectionSource, AddressBook.class);
        TableUtils.createTable(connectionSource, AddressItem.class);
        TableUtils.createTable(connectionSource, Contact.class);
        TableUtils.createTable(connectionSource, SimpleAddressItem.class);
    } catch (SQLException e) {
        Log.e(DatabaseHelper.class.getName(), "Can't create database", e);
        throw new RuntimeException(e);
    }
}
Example 6
Source File: SimpleMain.java    From ormlite-jdbc with ISC License 5 votes vote down vote up 
/**
 * Setup our database and DAOs
 */
private void setupDatabase(ConnectionSource connectionSource) throws Exception {

	accountDao = DaoManager.createDao(connectionSource, Account.class);

	// if you need to create the table
	TableUtils.createTable(connectionSource, Account.class);
}
Example 7
Source File: DataPersisterMain.java    From ormlite-jdbc with ISC License 5 votes vote down vote up 
/**
 * Setup our database and DAOs
 */
private void setupDatabase(ConnectionSource connectionSource) throws Exception {

	/*
	 * We register our own persister for DateTime objects. ORMLite actually has a built in one but it has to use
	 * reflection.
	 */
	DataPersisterManager.registerDataPersisters(DateTimePersister.getSingleton());

	userDao = DaoManager.createDao(connectionSource, User.class);

	// if you need to create the table
	TableUtils.createTable(connectionSource, User.class);
}
Example 8
Source File: DatabaseHelper.java    From iSCAU-Android with GNU General Public License v3.0 5 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource) {
    try{
        TableUtils.createTable(connectionSource, ClassModel.class);
    }catch (SQLException e) {
        Log.e(DatabaseHelper.class.getName(), "Unable to create datbases", e);
    }
}
Example 9
Source File: DatabaseHelperAndroidStarter.java    From AndroidStarter with Apache License 2.0 5 votes vote down vote up 
@DebugLog
@Override
public void onCreate(@NonNull final SQLiteDatabase poDatabase, @NonNull final ConnectionSource poConnectionSource) {
    try {
        TableUtils.createTable(poConnectionSource, RepoEntity.class);
    } catch (final SQLException loException) {
        if (BuildConfig.DEBUG && DEBUG) {
            Logger.t(TAG).e(loException, "");
        }
    }
}
Example 10
Source File: DatabaseHelper.java    From XMPPSample_Studio with Apache License 2.0 5 votes vote down vote up 
public void onCreate(SQLiteDatabase paramSQLiteDatabase,
                     ConnectionSource paramConnectionSource) {
    for (int i = 0; i < daoList.length; i++) {
        try {
            TableUtils.createTable(paramConnectionSource, daoList[i]);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
Example 11
Source File: ORMLiteExecutor.java    From android-orm-benchmark-updated with Apache License 2.0 5 votes vote down vote up 
@Override
public long createDbStructure() throws SQLException {
    long start = System.nanoTime();
    ConnectionSource connectionSource = mHelper.getConnectionSource();
    TableUtils.createTable(connectionSource, User.class);
    TableUtils.createTable(connectionSource, Message.class);
    return System.nanoTime() - start;
}
Example 12
Source File: LocalSqliteDriverImpl.java    From mae-annotation with GNU General Public License v3.0 5 votes vote down vote up 
public void createAllTables(ConnectionSource source) throws MaeDBException {
    for (Dao dao : allDaos) {
        try {
            TableUtils.createTable(source, dao.getDataClass());
        } catch (SQLException e) {
            throw catchSQLException(e);
        }

    }
}
Example 13
Source File: DBHelper.java    From OkhttpDownloader with Apache License 2.0 5 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase database,
                     ConnectionSource connectionSource)
{
    try
    {
        TableUtils.createTable(connectionSource, DownloadInfo.class);
    } catch (SQLException e)
    {
        e.printStackTrace();
    }
}
Example 14
Source File: DatabaseHelper.java    From Walrus with GNU General Public License v3.0 5 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase db, ConnectionSource connectionSource) {
    try {
        TableUtils.createTable(connectionSource, Card.class);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}
Example 15
Source File: DbHelperUtils.java    From q-municate-android with Apache License 2.0 5 votes vote down vote up 
public static void onCreate(ConnectionSource connectionSource, Class<?>[] tables) {
    try {
        for (Class clazz : tables) {
            TableUtils.createTable(connectionSource, clazz);
        }
    } catch (SQLException e) {
        ErrorUtils.logError(e);
    }
}
Example 16
Source File: ExtentTagTest.java    From mae-annotation with GNU General Public License v3.0 5 votes vote down vote up 
protected void setupDatabase(ConnectionSource source) throws Exception {
    eTagDao = DaoManager.createDao(source, ExtentTag.class);
    tagTypeDao = DaoManager.createDao(source, TagType.class);
    attTypeDao = DaoManager.createDao(source, AttributeType.class);
    attDao = DaoManager.createDao(source, Attribute.class);
    charIndexDao = DaoManager.createDao(source, CharIndex.class);

    lTagDao = DaoManager.createDao(source, LinkTag.class);
    argTypeDao = DaoManager.createDao(source, ArgumentType.class);
    argDao = DaoManager.createDao(source, Argument.class);

    dropAllTables(source);

    TableUtils.createTable(source, CharIndex.class);
    TableUtils.createTable(source, ExtentTag.class);
    TableUtils.createTable(source, TagType.class);
    TableUtils.createTable(source, AttributeType.class);
    TableUtils.createTable(source, Attribute.class);

    TableUtils.createTable(source, LinkTag.class);
    TableUtils.createTable(source, ArgumentType.class);
    TableUtils.createTable(source, Argument.class);

    noun = new TagType("NOUN", "N", false);
    verb = new TagType("VERB", "V", false);
    tagTypeDao.create(noun);
    tagTypeDao.create(verb);

}
Example 17
Source File: BaseDaoImplTest.java    From ormlite-core with ISC License 5 votes vote down vote up 
@Test
public void testIsTableExists() throws Exception {
	Dao<TableExists, Integer> dao = createDao(TableExists.class, false);
	assertFalse(dao.isTableExists());
	TableUtils.createTable(connectionSource, TableExists.class);
	assertTrue(dao.isTableExists());
	TableUtils.dropTable(connectionSource, TableExists.class, true);
	assertFalse(dao.isTableExists());
}
Example 18
Source File: DatabaseHelper.java    From mOrgAnd with GNU General Public License v2.0 5 votes vote down vote up 
@Override
public void onCreate(SQLiteDatabase db, ConnectionSource connectionSource) {
    try {
        Log.i(DatabaseHelper.class.getName(), "onCreate");
        TableUtils.createTable(connectionSource, OrgNode.class);
        TableUtils.createTable(connectionSource, OrgFile.class);
    } catch (SQLException e) {
        Log.e(DatabaseHelper.class.getName(), "Can't create database", e);
        throw new RuntimeException(e);
    }
}
Example 19
Source File: OrmLiteDatabaseHelper.java    From android-atleap with Apache License 2.0 5 votes vote down vote up 
/**
 * {@inheritDoc}
 */
@Override
public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
    try {
        List<Class<?>> classes = getUriMatcher().getClasses();
        for (Class clazz : classes) {
            TableUtils.dropTable(connectionSource, clazz, true);
            TableUtils.createTable(connectionSource, clazz);
        }
    } catch (SQLException e) {
        Log.e(TAG, "Cannot upgrade database", e);
    }
}
Example 20
Source File: DBHelper.java    From ShadowsocksRR with Apache License 2.0 4 votes vote down vote up 
@Override
public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
    if (oldVersion != newVersion) {
        try {
            if (oldVersion < 7) {
                profileDao.executeRawNoArgs("DROP TABLE IF EXISTS 'profile';");
                onCreate(database, connectionSource);
                return;
            }
            if (oldVersion < 8) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN udpdns SMALLINT;");
            }
            if (oldVersion < 9) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN route VARCHAR DEFAULT 'all';");
            } else if (oldVersion < 19) {
                profileDao.executeRawNoArgs("UPDATE `profile` SET route = 'all' WHERE route IS NULL;");
            }
            if (oldVersion < 10) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN auth SMALLINT;");
            }
            if (oldVersion < 11) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN ipv6 SMALLINT;");
            }
            if (oldVersion < 12) {
                profileDao.executeRawNoArgs("BEGIN TRANSACTION;");
                profileDao.executeRawNoArgs("ALTER TABLE `profile` RENAME TO `tmp`;");
                TableUtils.createTable(connectionSource, Profile.class);
                profileDao.executeRawNoArgs(
                        "INSERT INTO `profile`(id, name, host, localPort, remotePort, password, method, route, proxyApps, bypass," +
                                " udpdns, auth, ipv6, individual) " +
                                "SELECT id, name, host, localPort, remotePort, password, method, route, 1 - global, bypass, udpdns, auth," +
                                " ipv6, individual FROM `tmp`;");
                profileDao.executeRawNoArgs("DROP TABLE `tmp`;");
                profileDao.executeRawNoArgs("COMMIT;");
            } else if (oldVersion < 13) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN tx LONG;");
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN rx LONG;");
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN date VARCHAR;");
            }

            if (oldVersion < 15) {
                if (oldVersion >= 12) {
                    profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN userOrder LONG;");
                }
                int i = 0;
                for (Profile profile : profileDao.queryForAll()) {
                    if (oldVersion < 14) {
                        profile.individual = updateProxiedApps(context, profile.individual);
                    }
                    profile.userOrder = i;
                    profileDao.update(profile);
                    i += 1;
                }
            }


            if (oldVersion < 16) {
                profileDao.executeRawNoArgs("UPDATE `profile` SET route = 'bypass-lan-china' WHERE route = 'bypass-china'");
            }

            if (oldVersion < 19) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN dns VARCHAR DEFAULT '8.8.8.8:53';");
            }

            if (oldVersion < 20) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN china_dns VARCHAR DEFAULT '114.114.114.114:53,223.5.5.5:53';");
            }

            if (oldVersion < 21) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN protocol_param VARCHAR DEFAULT '';");
            }

            if (oldVersion < 22) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN elapsed LONG DEFAULT 0;");
            }

            if (oldVersion < 23) {
                profileDao.executeRawNoArgs("ALTER TABLE `profile` ADD COLUMN url_group VARCHAR DEFAULT '';");
            }

            if (oldVersion < 24) {
                TableUtils.createTable(connectionSource, SSRSub.class);
            }
        } catch (Exception e) {
            VayLog.e(TAG, "onUpgrade", e);
            app.track(e);

            try {
                profileDao.executeRawNoArgs("DROP TABLE IF EXISTS 'profile';");
            } catch (SQLException e1) {
                VayLog.e(TAG, "onUpgrade", e);
            }
            onCreate(database, connectionSource);
        }
    }
}