List<MobileLedgerProfile> result = new ArrayList<>();
SQLiteDatabase db = MLDB.getReadableDatabase();
try (Cursor cursor = db.rawQuery("SELECT uuid, name, url, use_authentication, auth_user, " +
- "auth_password FROM profiles", null))
+ "auth_password FROM profiles order by order_no", null))
{
while (cursor.moveToNext()) {
- result.add(new MobileLedgerProfile(cursor.getString(0), cursor.getString(1), cursor.getString(2), cursor.getInt(3) == 1, cursor.getString(4),
+ result.add(new MobileLedgerProfile(cursor.getString(0), cursor.getString(1),
+ cursor.getString(2), cursor.getInt(3) == 1, cursor.getString(4),
cursor.getString(5)));
}
}
return result;
}
+ public static void storeProfilesOrder() {
+ SQLiteDatabase db = MLDB.getWritableDatabase();
+ db.beginTransaction();
+ try {
+ int orderNo = 0;
+ for (MobileLedgerProfile p : Data.profiles.getList()) {
+ db.execSQL("update profiles set order_no=? where uuid=?",
+ new Object[]{orderNo, p.getUuid()});
+ orderNo++;
+ }
+ db.setTransactionSuccessful();
+ }
+ finally {
+ db.endTransaction();
+ }
+ }
public static List<MobileLedgerProfile> createInitialProfileList() {
List<MobileLedgerProfile> result = new ArrayList<>();
MobileLedgerProfile first =
public void set_option_value(String name, long value) {
set_option_value(name, String.valueOf(value));
}
+ public void removeFromDB() {
+ SQLiteDatabase db = MLDB.getWritableDatabase();
+ Log.d("db", String.format("removinf progile %s from DB", uuid));
+ db.execSQL("delete from profiles where uuid=?", new Object[]{uuid});
+ }
}