private void copyBetweenDatabases() {
DatabaseHelper dbHelper = new DatabaseHelper(this);
try {
dbHelper.openDataBase(false);
} catch (SQLException e) {
e.printStackTrace();
}
List<TestContainer> list = dbHelper.getTests();
dbHelper.close();
DatabaseHelper.DB_NAME =
DatabaseHelper.DB_NAME.equals(DatabaseHelper.DB_AM)
? DatabaseHelper.DB_RU
: DatabaseHelper.DB_AM;
dbHelper = new DatabaseHelper(this);
try {
dbHelper.openDataBase(true);
} catch (SQLException e) {
e.printStackTrace();
}
for (int i = 0; i < list.size(); i++) {
int newDbProgress = dbHelper.getTests().get(i).getProgress();
int oldDbProgress = list.get(i).getProgress();
if (oldDbProgress != newDbProgress) {
dbHelper.updateProgress(i + 1, oldDbProgress);
}
}
dbHelper.close();
}
private void copyOldData() {
SharedPreferences preferences = null;
try {
preferences = getSharedPreferences("tests", 0);
} catch (Exception e) {
}
if (preferences != null) {
DatabaseHelper db = new DatabaseHelper(this);
try {
db.openDataBase(true);
} catch (SQLException e) {
e.printStackTrace();
}
for (int i = 1; i <= 62; ++i) {
String name = "Test" + String.valueOf(i);
String percent = preferences.getString(name, null);
if (percent != null) {
int progress = Integer.parseInt(percent.substring(0, percent.length() - 1));
if (progress != db.getTests().get(i - 1).getProgress()) db.updateProgress(i, progress);
}
}
db.close();
preferences.edit().clear().commit();
}
}