@Override
public void onCreate(SQLiteDatabase db) {
for (String table : _builder.getTables()) {
String sqlStr = null;
try {
sqlStr = _builder.getSQLCreate(table);
} catch (DataAccessException e) {
EvtLog.e(this.getClass().getName(), e);
}
if (sqlStr != null) db.execSQL(sqlStr);
}
db.setVersion(_version);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
ArrayList<String> scripts = databaseUpgrade(oldVersion, newVersion);
if (scripts == null || scripts.size() == 0) {
for (String table : _builder.getTables()) {
String sqlStr = _builder.getSQLDrop(table);
db.execSQL(sqlStr);
}
onCreate(db);
} else {
for (int i = 0; i < scripts.size(); ++i) {
String sql = scripts.get(i);
if (!(sql.trim().equals("") || sql.trim().startsWith("--"))) {
db.execSQL(scripts.get(i));
}
}
}
}
