/* Insert new request into table 'request' */
void insertRequest(int number) {
// Log.i("PRIME", "Table : request : Inside insertRequest() : No -> "
// + number);
SQLiteDatabase db = this.getWritableDatabase();
// ??
String timeStamp = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
// Log.i("PRIME", "DbHandler : insertRequest() "
// + "howmany -> " + number);
ContentValues values = new ContentValues();
values.put("howmany", number);
values.put("current_count", 0);
values.put("is_complete", "N");
values.put("created_time", timeStamp);
values.put("tstamp", timeStamp);
try {
// Inserting Row
db.insertOrThrow(TABLE_REQUEST, null, values);
} catch (android.database.sqlite.SQLiteConstraintException e) {
Log.e("PRIME", "insertRequest : SQLiteConstraintException:" + e.getMessage());
} catch (android.database.sqlite.SQLiteException e) {
Log.e("PRIME", "SQLiteException:" + e.getMessage());
} catch (Exception e) {
Log.e("PRIME", "Exception:" + e.getMessage());
}
db.close(); // Closing database connection
}
public void insertPrimeNo(int nthNo, int primeNo) {
// Log.v("PRIME", "Table : prime : Inside insertPrimeNo()");
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("nthno", nthNo);
values.put("primeno", primeNo);
try {
// Inserting Row
db.insertOrThrow(TABLE_PRIME, null, values);
} catch (android.database.sqlite.SQLiteConstraintException e) {
Log.e("PRIME", "insertPrimeNo() : SQLiteConstraintException:" + e.getMessage());
} catch (android.database.sqlite.SQLiteException e) {
Log.e("PRIME", "insertPrimeNo() : SQLiteException:" + e.getMessage());
} catch (Exception e) {
Log.e("PRIME", "insertPrimeNo() : Exception:" + e.getMessage());
}
db.close(); // Closing database connection
}
/**
* Saves the given task to the database.getDatabase(). Task must already exist. Returns true on
* success.
*
* @param task
* @return true if save occurred, false otherwise (i.e. nothing changed)
*/
public boolean save(Task task) {
boolean saveSuccessful = false;
if (task.getId() == Task.NO_ID) {
try {
saveSuccessful = createNew(task);
} catch (SQLiteConstraintException e) {
if (e.getMessage().contains(Task.REMOTE_ID_PROPERTY_NAME)) {
// Tried to create task with remote id that already exists
saveSuccessful = false;
TodorooCursor<Task> cursor =
query(Query.select(Task.ID).where(Task.REMOTE_ID.eq(task.getValue(Task.REMOTE_ID))));
if (cursor.getCount() > 0) {
cursor.moveToFirst();
task.setId(cursor.get(Task.ID));
saveSuccessful = saveExisting(task);
}
}
}
} else {
saveSuccessful = saveExisting(task);
}
return saveSuccessful;
}
