Exemple #1
0
  // Upgrading database
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    this.db = db;
    Log.i(Constants.TAG, "Upgrading database version from " + oldVersion + " to " + newVersion);

    UpgradeProcessor.process(oldVersion, newVersion);

    try {
      for (String sqlFile : AssetUtils.list(SQL_DIR, mContext.getAssets())) {
        if (sqlFile.startsWith(UPGRADE_QUERY_PREFIX)) {
          int fileVersion =
              Integer.parseInt(
                  sqlFile.substring(
                      UPGRADE_QUERY_PREFIX.length(),
                      sqlFile.length() - UPGRADE_QUERY_SUFFIX.length()));
          if (fileVersion > oldVersion && fileVersion <= newVersion) {
            execSqlFile(sqlFile, db);
          }
        }
      }
      Log.i(Constants.TAG, "Database upgrade successful");

    } catch (IOException e) {
      throw new RuntimeException("Database upgrade failed", e);
    }
  }
Exemple #2
0
 // Creating Tables
 @Override
 public void onCreate(SQLiteDatabase db) {
   try {
     Log.i(Constants.TAG, "Database creation");
     execSqlFile(CREATE_QUERY, db);
   } catch (IOException exception) {
     throw new RuntimeException("Database creation failed", exception);
   }
 }