public void deleteTran(Account acct, String transID) {
String[] args = {Integer.toString(acct.ID), transID};
db.beginTransaction();
try {
db.delete("trans", "acct_id=? and trans_id=?", args);
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
private void updateTran(Transaction trans) {
db.beginTransaction();
try {
ContentValues newValue = tranValues(trans);
String[] args = {Integer.toString(trans.ID)};
db.update("trans", newValue, "_id=?", args);
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
private void updateAccount(Account acct) {
db.beginTransaction();
try {
ContentValues newValue = acctValues(acct);
String[] args = {Integer.toString(acct.ID)};
db.update("acct", newValue, "_id=?", args);
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
private int addAccount(Account acct) {
db.beginTransaction();
int acct_id;
try {
ContentValues newValue = acctValues(acct);
acct_id = (int) db.insertOrThrow("acct", "name", newValue);
acct.ID = acct_id;
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
return acct_id;
}
public Cursor acctList(String constraint) {
if (constraint == null) {
return db.query("acct", AC_COLS, null, null, null, null, "name");
} else {
return db.query(
"acct",
AC_COLS,
"name like ?",
new String[] {"%" + constraint + "%"},
null,
null,
"name");
}
}
private int addTran(Transaction trans) {
db.beginTransaction();
int tran_id;
try {
ContentValues newValue = tranValues(trans);
tran_id = (int) db.insertOrThrow("trans", "acct_id", newValue);
trans.ID = tran_id;
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
return tran_id;
}
private static Cursor getMesesDiferentes() throws SQLException {
SQLiteDatabase conn = null;
Cursor rs = null;
String consulta = " Select distinct month from session ";
try {
conn = BaseDatos.getConn();
rs = conn.rawQuery(consulta, null);
} catch (SQLException e) {
throw (e);
}
return rs;
}
private boolean tranExists(Transaction trans) {
String[] args = {Integer.toString(trans.acct.ID), trans.transID};
Cursor cur = db.query("trans", ID_COLS, "acct_id=? and trans_id=?", args, null, null, null);
try {
return cur.moveToNext();
} finally {
cur.close();
}
}
public Account getAccount(int ID) {
Account acct = null;
String[] args = {Integer.toString(ID)};
Cursor cur = db.query("acct", AC_COLS, "_id=?", args, null, null, null);
try {
if (!cur.moveToNext()) return null;
acct = getAccountFromCursor(cur);
} finally {
cur.close();
}
return acct;
}
public void establishAccount(ServiceAcctInfo acct) {
String[] args = {Integer.toString(acct.ID)};
Cursor cur = db.query("acct", AC_COLS, "service_id=?", args, null, null, null);
try {
if (cur.moveToNext()) return;
} finally {
cur.close();
}
Account newAcct = new Account();
newAcct.serviceId = acct.ID;
newAcct.name = acct.desc;
addAccount(newAcct);
}
public void close() {
db.close();
}
public void wipeTable(SQLiteDatabase db) {
for (String cmd : DROP_TABLE) {
db.execSQL(cmd);
}
onCreate(db);
}
@Override
public void onCreate(SQLiteDatabase db) {
for (String cmd : CREATE_TABLE) {
db.execSQL(cmd);
}
}
