private synchronized void addAccount(final RedditAccount account, final SQLiteDatabase inDb) {
final SQLiteDatabase db;
if (inDb == null) db = getWritableDatabase();
else db = inDb;
final ContentValues row = new ContentValues();
row.put(FIELD_USERNAME, account.username);
if (account.refreshToken == null) {
row.putNull(FIELD_REFRESH_TOKEN);
} else {
row.put(FIELD_REFRESH_TOKEN, account.refreshToken.token);
}
row.put(FIELD_PRIORITY, account.priority);
db.insert(TABLE, null, row);
reloadAccounts(db);
updateNotifier.updateAllListeners();
if (inDb == null) db.close();
}
public void deleteAccount(RedditAccount account) {
final SQLiteDatabase db = getWritableDatabase();
db.delete(TABLE, FIELD_USERNAME + "=?", new String[] {account.username});
reloadAccounts(db);
updateNotifier.updateAllListeners();
db.close();
}
public synchronized void setDefaultAccount(final RedditAccount newDefault) {
final SQLiteDatabase db = getWritableDatabase();
db.execSQL(
String.format(
"UPDATE %s SET %s=(SELECT MIN(%s)-1 FROM %s) WHERE %s=?",
TABLE, FIELD_PRIORITY, FIELD_PRIORITY, TABLE, FIELD_USERNAME),
new String[] {newDefault.username});
reloadAccounts(db);
db.close();
updateNotifier.updateAllListeners();
}