public Audit getAudit(long id) { SQLiteDatabase db = this.getReadableDatabase(); String selectQuery = "SELECT * FROM " + TABLE_AUDITS + " WHERE " + KEY_ID + " = " + id; Log.e(LOG, selectQuery); Cursor c = db.rawQuery(selectQuery, null); if (c != null) c.moveToFirst(); Audit pd = new Audit(); pd.setId(c.getInt(c.getColumnIndex(KEY_ID))); pd.setName(c.getString(c.getColumnIndex(KEY_NAME))); pd.setScore((c.getInt(c.getColumnIndex(KEY_SCORE)))); pd.setStore_id((c.getInt(c.getColumnIndex(KEY_STORY_ID)))); return pd; }
/** * .Return List Audits * * @return */ public List<Audit> getAllAudits() { List<Audit> audit = new ArrayList<Audit>(); String selectQuery = "SELECT * FROM " + TABLE_AUDITS; Log.e(LOG, selectQuery); SQLiteDatabase db = this.getReadableDatabase(); Cursor c = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (c.moveToFirst()) { do { Audit pd = new Audit(); pd.setId(c.getInt((c.getColumnIndex(KEY_ID)))); pd.setName((c.getString(c.getColumnIndex(KEY_NAME)))); pd.setStore_id((c.getInt(c.getColumnIndex(KEY_STORY_ID)))); pd.setScore((c.getLong(c.getColumnIndex(KEY_SCORE)))); // adding to todo list audit.add(pd); } while (c.moveToNext()); } return audit; }