com.j256.ormlite.table.TableUtils#createTableIfNotExists

Source File: DatabaseHelper.java From SightRemote with GNU General Public License v3.0

6 votes

@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
    try {
        TableUtils.createTableIfNotExists(connectionSource, BolusDelivered.class);
        TableUtils.createTableIfNotExists(connectionSource, BolusProgrammed.class);
        TableUtils.createTableIfNotExists(connectionSource, EndOfTBR.class);
        TableUtils.createTableIfNotExists(connectionSource, Offset.class);
        TableUtils.createTableIfNotExists(connectionSource, PumpStatusChanged.class);
        TableUtils.createTableIfNotExists(connectionSource, TimeChanged.class);
        TableUtils.createTableIfNotExists(connectionSource, CannulaFilled.class);
        TableUtils.createTableIfNotExists(connectionSource, DailyTotal.class);
        TableUtils.createTableIfNotExists(connectionSource, CartridgeInserted.class);
        TableUtils.createTableIfNotExists(connectionSource, BatteryInserted.class);
        TableUtils.createTableIfNotExists(connectionSource, TubeFilled.class);
        TableUtils.createTableIfNotExists(connectionSource, OccurenceOfAlert.class);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

6 votes

@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
    try {
        if (L.isEnabled(L.DATABASE))
            log.info("onCreate");
        TableUtils.createTableIfNotExists(connectionSource, TempTarget.class);
        TableUtils.createTableIfNotExists(connectionSource, BgReading.class);
        TableUtils.createTableIfNotExists(connectionSource, DanaRHistoryRecord.class);
        TableUtils.createTableIfNotExists(connectionSource, DbRequest.class);
        TableUtils.createTableIfNotExists(connectionSource, TemporaryBasal.class);
        TableUtils.createTableIfNotExists(connectionSource, ExtendedBolus.class);
        TableUtils.createTableIfNotExists(connectionSource, CareportalEvent.class);
        TableUtils.createTableIfNotExists(connectionSource, ProfileSwitch.class);
        TableUtils.createTableIfNotExists(connectionSource, TDD.class);
        TableUtils.createTableIfNotExists(connectionSource, InsightHistoryOffset.class);
        TableUtils.createTableIfNotExists(connectionSource, InsightBolusID.class);
        TableUtils.createTableIfNotExists(connectionSource, InsightPumpID.class);
        database.execSQL("INSERT INTO sqlite_sequence (name, seq) SELECT \"" + DATABASE_INSIGHT_BOLUS_IDS + "\", " + System.currentTimeMillis() + " " +
                "WHERE NOT EXISTS (SELECT 1 FROM sqlite_sequence WHERE name = \"" + DATABASE_INSIGHT_BOLUS_IDS + "\")");
        database.execSQL("INSERT INTO sqlite_sequence (name, seq) SELECT \"" + DATABASE_INSIGHT_PUMP_IDS + "\", " + System.currentTimeMillis() + " " +
                "WHERE NOT EXISTS (SELECT 1 FROM sqlite_sequence WHERE name = \"" + DATABASE_INSIGHT_PUMP_IDS + "\")");
    } catch (SQLException e) {
        log.error("Can't create database", e);
        throw new RuntimeException(e);
    }
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetExtededBoluses() {
    try {
        TableUtils.dropTable(connectionSource, ExtendedBolus.class, true);
        TableUtils.createTableIfNotExists(connectionSource, ExtendedBolus.class);
        updateEarliestDataChange(0);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleExtendedBolusChange();
}

Source File: OrmLiteDatabaseHelper.java From android-atleap with Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
    try {
        List<Class<?>> classes = getUriMatcher().getClasses();
        for (Class clazz : classes) {
            TableUtils.createTableIfNotExists(connectionSource, clazz);
        }
    } catch (SQLException e) {
        Log.e(TAG, "Cannot create database", e);
    }
}

Source File: BaseOrmLiteSQLiteHelper.java From file-downloader with Apache License 2.0

5 votes

@Override
public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
    // 通过TableUtils这个类新建Module类对应的表
    try {
        // 通过TableUtils类创建所有的表
        for (Class<?> table : supportTables) {
            TableUtils.createTableIfNotExists(connectionSource, table);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source File: TreatmentService.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetTreatments() {
    try {
        TableUtils.dropTable(this.getConnectionSource(), Treatment.class, true);
        TableUtils.createTableIfNotExists(this.getConnectionSource(), Treatment.class);
        DatabaseHelper.updateEarliestDataChange(0);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleTreatmentChange(null, true);
}

Source File: TreatmentService.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

@Override
public void onCreate() {
    super.onCreate();
    try {
        if (L.isEnabled(L.DATATREATMENTS))
            log.info("onCreate");
        TableUtils.createTableIfNotExists(this.getConnectionSource(), Treatment.class);
    } catch (SQLException e) {
        log.error("Can't create database", e);
        throw new RuntimeException(e);
    }
}

Source File: FoodService.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetFood() {
    try {
        TableUtils.dropTable(this.getConnectionSource(), Food.class, true);
        TableUtils.createTableIfNotExists(this.getConnectionSource(), Food.class);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleFoodChange();
}

Source File: FoodService.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

@Override
public void onCreate() {
    super.onCreate();
    try {
        if (L.isEnabled(L.DATAFOOD))
            log.info("onCreate");
        TableUtils.createTableIfNotExists(this.getConnectionSource(), Food.class);
    } catch (SQLException e) {
        log.error("Can't create database", e);
        throw new RuntimeException(e);
    }
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetTDDs() {
    try {
        TableUtils.dropTable(connectionSource, TDD.class, true);
        TableUtils.createTableIfNotExists(connectionSource, TDD.class);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetProfileSwitch() {
    try {
        TableUtils.dropTable(connectionSource, ProfileSwitch.class, true);
        TableUtils.createTableIfNotExists(connectionSource, ProfileSwitch.class);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleProfileSwitchChange();
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetCareportalEvents() {
    try {
        TableUtils.dropTable(connectionSource, CareportalEvent.class, true);
        TableUtils.createTableIfNotExists(connectionSource, CareportalEvent.class);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleCareportalEventChange();
}

Source File: Database.java From PacketProxy with Apache License 2.0

5 votes

public <T,ID> Dao<T, ID> createTable(Class<T> c, Observer observer) throws Exception
{
	addObserver(observer);
	TableUtils.createTableIfNotExists(source, c);
	Dao<T, ID> dao = DaoManager.createDao(source, c);
	return dao;
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetTemporaryBasals() {
    try {
        TableUtils.dropTable(connectionSource, TemporaryBasal.class, true);
        TableUtils.createTableIfNotExists(connectionSource, TemporaryBasal.class);
        updateEarliestDataChange(0);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    VirtualPumpPlugin.getPlugin().setFakingStatus(false);
    scheduleTemporaryBasalChange();
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

public void resetTempTargets() {
    try {
        TableUtils.dropTable(connectionSource, TempTarget.class, true);
        TableUtils.createTableIfNotExists(connectionSource, TempTarget.class);
    } catch (SQLException e) {
        log.error("Unhandled exception", e);
    }
    scheduleTemporaryTargetChange();
}

Source File: ORMLiteIntegrationTest.java From tutorials with MIT License

5 votes

@BeforeClass
public static void setup() throws SQLException {
    connectionSource = new JdbcPooledConnectionSource("jdbc:h2:mem:myDb");
    TableUtils.createTableIfNotExists(connectionSource, Library.class);
    TableUtils.createTableIfNotExists(connectionSource, Address.class);
    TableUtils.createTableIfNotExists(connectionSource, Book.class);

    libraryDao = DaoManager.createDao(connectionSource, Library.class);

    bookDao = DaoManager.createDao(connectionSource, Book.class);
}

Source File: DatabaseHelper.java From AndroidAPS with GNU Affero General Public License v3.0

5 votes

@Override
public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
    try {
        this.oldVersion = oldVersion;
        this.newVersion = newVersion;

        if (oldVersion < 7) {
            log.info(DatabaseHelper.class.getName(), "onUpgrade");
            TableUtils.dropTable(connectionSource, TempTarget.class, true);
            TableUtils.dropTable(connectionSource, BgReading.class, true);
            TableUtils.dropTable(connectionSource, DanaRHistoryRecord.class, true);
            TableUtils.dropTable(connectionSource, DbRequest.class, true);
            TableUtils.dropTable(connectionSource, TemporaryBasal.class, true);
            TableUtils.dropTable(connectionSource, ExtendedBolus.class, true);
            TableUtils.dropTable(connectionSource, CareportalEvent.class, true);
            TableUtils.dropTable(connectionSource, ProfileSwitch.class, true);
            onCreate(database, connectionSource);
        } else if (oldVersion < 10) {
            TableUtils.createTableIfNotExists(connectionSource, InsightHistoryOffset.class);
            TableUtils.createTableIfNotExists(connectionSource, InsightBolusID.class);
            TableUtils.createTableIfNotExists(connectionSource, InsightPumpID.class);
            database.execSQL("INSERT INTO sqlite_sequence (name, seq) SELECT \"" + DATABASE_INSIGHT_BOLUS_IDS + "\", " + System.currentTimeMillis() + " " +
                    "WHERE NOT EXISTS (SELECT 1 FROM sqlite_sequence WHERE name = \"" + DATABASE_INSIGHT_BOLUS_IDS + "\")");
            database.execSQL("INSERT INTO sqlite_sequence (name, seq) SELECT \"" + DATABASE_INSIGHT_PUMP_IDS + "\", " + System.currentTimeMillis() + " " +
                    "WHERE NOT EXISTS (SELECT 1 FROM sqlite_sequence WHERE name = \"" + DATABASE_INSIGHT_PUMP_IDS + "\")");
        } else if (oldVersion < 11) {
            database.execSQL("UPDATE sqlite_sequence SET seq = " + System.currentTimeMillis() + " WHERE name = \"" + DATABASE_INSIGHT_BOLUS_IDS + "\"");
            database.execSQL("UPDATE sqlite_sequence SET seq = " + System.currentTimeMillis() + " WHERE name = \"" + DATABASE_INSIGHT_PUMP_IDS + "\"");
        }
    } catch (SQLException e) {
        log.error("Can't drop databases", e);
        throw new RuntimeException(e);
    }
}

Source File: OrmLiteHelper.java From AndroidQuick with MIT License

5 votes

private void createTable() {
    try {
        TableUtils.createTableIfNotExists(connectionSource, User.class);
        TableUtils.createTableIfNotExists(connectionSource, Tag.class);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source File: OrmLiteHelper.java From AndroidQuick with MIT License

5 votes

private void update(SQLiteDatabase db, int from) {
    try {
        switch (from) {
            case 1:
                TableUtils.createTableIfNotExists(connectionSource, User.class);
                break;
            default:
                createTable();
                break;
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source File: DatabaseHelper.java From android-viewer-for-khan-academy with GNU General Public License v3.0

4 votes

@Override
public void onUpgrade(final SQLiteDatabase database,
		final ConnectionSource connectionSource, final int oldVersion, final int newVersion) {
	
	
	if (oldVersion < 111) {
		// Create new Caption table.
		try {
			TableUtils.createTableIfNotExists(connectionSource, Caption.class);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	if (oldVersion < 114) {
		// Could instead create an ORMLite pojo for topicvideo and do this with TableUtils.
		database.execSQL("CREATE TABLE IF NOT EXISTS `topicvideo` (`_id` INTEGER PRIMARY KEY AUTOINCREMENT, `topic_id` VARCHAR, `video_id` VARCHAR )");
	}
	
	if (newVersion >= 111) {
		
		// Played with the idea of putting this all into an AsyncTask, but
		//  1) Can crash the app. For example, in 114 upgrade we add topicvideo table; if it doesn't exist and user reaches a video list, we 
		//     crash. Worse, if we do crash here the app is broken. Db version has been bumped, so this code doesn't get another chance to run.
		//  2) To prevent crash, tried showing AlertDialog. The context we get here is "not an application context", so trying to show a window
		//     (or sometimes a toast) crashes us with a null window token error. I dug deep to try to pass in a useful context with no luck.
		//     See branch temp/pass_context_to_helper.
		//  3) It doesn't take very long (truncate / reload full video and topic tables is just a few seconds, not long enough for ANR on Fire HD)
		
		new DatabaseImporter(context).import_(DATABASE_RESOURCE_ID, "temp");
		SQLiteDatabase tempDb = new TempHelper(context).getReadableDatabase();
		
		if (oldVersion < 111) {
			do111Upgrade(database, tempDb);
		}
		
		if (oldVersion < 114 && newVersion >= 114) {
			// add topicvideo table
			do114Upgrade(database, tempDb);
		}
		
		if (oldVersion < 120 && newVersion >= 120) {
			// add video.dlm_id column
			do120Upgrade(database, tempDb);
		}
		
		tempDb.close();
		context.deleteDatabase(TempHelper.DB_NAME);
		
		// Update download status from storage. This recovers any lost during library updates in 1.1.3.
		database.beginTransaction();
		try {
			for (String yid : getAllDownloadedYoutubeIds()) {
				database.execSQL("update video set download_status=? where youtube_id=?", new Object[] {Video.DL_STATUS_COMPLETE, yid});
			}
			database.setTransactionSuccessful();
		} finally {
			database.endTransaction();
		}
				
	}
		
}

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