public ArrayList<ActionEvent> getAllItems(Context context, boolean isHistory) {
DatabaseHelper dh = new DatabaseHelper(context, TABLE_NAME);
SQLiteDatabase db = dh.getReadableDatabase();
ArrayList<ActionEvent> aeList = new ArrayList<ActionEvent>();
Cursor c =
db.query(
TABLE_NAME,
null,
KEY_IS_HISTORY + "='" + getBooleanToLong(isHistory) + "'",
null,
null,
null,
"_id" + " DESC");
while (c.moveToNext()) {
ActionEvent ae =
new ActionEvent(
c.getString(c.getColumnIndex(KEY_ACTION_NAME)),
c.getLong(c.getColumnIndex(KEY_START_TIMESTAMP)),
c.getString(c.getColumnIndex(KEY_ACTION_NOTE)),
getLongToBoolean(c.getLong(c.getColumnIndex(KEY_IS_HISTORY))),
c.getLong(c.getColumnIndex(KEY_START_DEALY)),
c.getLong(c.getColumnIndex(KEY_START_DEALY)));
ae.setBreakTimestamp(c.getLong(c.getColumnIndex(KEY_BREAK_TIMESTAMP)));
ae.setState(c.getString(c.getColumnIndex(KEY_STATE)));
aeList.add(ae);
}
c.close();
db.close();
return aeList;
}
public boolean update(Context context, ActionEvent ae) {
ContentValues target = new ContentValues();
target.put(KEY_STATE, ae.getEventState());
target.put(KEY_BREAK_TIMESTAMP, ae.getBreakTimestamp());
target.put(KEY_IS_HISTORY, getBooleanToLong(ae.isHistory()));
target.put(KEY_BREAK_DEALY, ae.getBreakDelay());
return update(context, ae, target);
}
private boolean update(Context context, ActionEvent ae, final ContentValues target) {
DatabaseHelper dh = new DatabaseHelper(context, TABLE_NAME);
SQLiteDatabase db = dh.getWritableDatabase();
if (db.isOpen()) {
db.update(
TABLE_NAME,
target,
KEY_START_TIMESTAMP + "=?",
new String[] {Long.toString(ae.getStartTimestamp())});
db.close();
return true;
} else {
db.close();
return false;
}
}
private boolean isInsert(SQLiteDatabase db, ActionEvent ae) {
Cursor c =
db.query(
TABLE_NAME,
new String[] {KEY_START_TIMESTAMP},
KEY_START_TIMESTAMP + "=" + ae.getStartTimestamp(),
null,
null,
null,
null);
// check the record
if (c.getCount() > 0) {
c.close();
db.close();
return true;
} else {
c.close();
db.close();
return false;
}
}
public boolean insert(Context context, ActionEvent ae) {
DatabaseHelper dh = new DatabaseHelper(context, TABLE_NAME);
SQLiteDatabase db = dh.getWritableDatabase();
ContentValues target = null;
if (db.isOpen()) {
target = new ContentValues();
target.put(KEY_ACTION_NAME, ae.getActionEventName());
target.put(KEY_START_TIMESTAMP, ae.getStartTimestamp());
target.put(KEY_STATE, ae.getEventState());
target.put(KEY_BREAK_TIMESTAMP, ae.getBreakTimestamp());
target.put(KEY_IS_HISTORY, getBooleanToLong(ae.isHistory()));
target.put(KEY_ACTION_NOTE, ae.getNoteContent());
target.put(KEY_START_DEALY, ae.getStartDelay());
target.put(KEY_BREAK_DEALY, ae.getBreakDelay());
db.insert(TABLE_NAME, null, target);
} else {
db.close();
return false;
}
target = null;
return isInsert(db, ae);
}