@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());
}
