@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub db.execSQL(NotesContract.Note.getSqlDeleteEntries()); db.execSQL(NotesContract.Tag.getSqlDeleteEntries()); onCreate(db); }
public ArrayList<Tag> Get_Tags() { try { SQLiteDatabase db = this.getReadableDatabase(); SQLiteQueryBuilder builder = new SQLiteQueryBuilder(); builder.setTables(NotesContract.Tag.FTS_TABLE_NAME); String[] projection = NotesContract.Tag.getTagColumns(); Cursor cur = builder.query(db, projection, null, null, null, null, null, null); if (cur != null) { cur.moveToFirst(); do { Tag tag = new Tag(); tag.setTagId(Integer.valueOf(cur.getString(1))); tag.setTagName(cur.getString(2)); // add tag to list tags_list.add(tag); } while (cur.moveToNext()); } cur.close(); return tags_list; } catch (Exception e) { Log.e("SELECT All tags", " " + e); } return tags_list; }
// retrieve single tag - FTS public Tag Get_Tag(int id) { SQLiteDatabase db = this.getReadableDatabase(); SQLiteQueryBuilder builder = new SQLiteQueryBuilder(); builder.setTables(NotesContract.Tag.FTS_TABLE_NAME); String[] projection = NotesContract.Tag.getTagColumns(); String selection = " docid = ?"; String[] tagId = new String[] {String.valueOf(id)}; Cursor cur = builder.query(db, projection, selection, tagId, null, null, null, null); if (cur != null) { cur.moveToFirst(); } Tag tag = new Tag(Integer.parseInt(cur.getString(0)), cur.getString(1)); cur.close(); return tag; }
@Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL(NotesContract.Note.getSqlCreateEntries()); db.execSQL(NotesContract.Tag.getSqlCreateEntries()); }