@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<Note> Get_Notes() {
try {
notes_list.clear();
SQLiteDatabase db = this.getReadableDatabase();
SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
builder.setTables(NotesContract.Note.FTS_TABLE_NAME);
String[] projection = NotesContract.Note.getNotesColumns();
Cursor cur = builder.query(db, projection, null, null, null, null, null, null);
if (cur != null) {
cur.moveToFirst();
do {
Note note = new Note();
note.setNoteId(Integer.valueOf(cur.getString(0)));
note.setNoteTitle(cur.getString(1));
note.setNoteText(cur.getString(2));
// add to list now:
notes_list.add(note);
} while (cur.moveToNext());
}
cur.close();
return notes_list;
} catch (Exception e) {
Log.e("SELECT All notes", " " + e);
}
return notes_list;
}
// SELECT operations
// single note (based on note ID; returns Note) - FTS
Note Get_Note(int id) {
SQLiteDatabase db = this.getReadableDatabase();
SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
builder.setTables(NotesContract.Note.FTS_TABLE_NAME);
String[] projection = NotesContract.Note.getNotesColumns();
String selection = " docid = ?";
String[] noteId = new String[] {String.valueOf(id)};
Cursor cur = builder.query(db, projection, selection, noteId, null, null, null, null);
if (cur != null) {
cur.moveToFirst();
}
// now create Note object:
Note note = new Note(Integer.parseInt(cur.getString(0)), cur.getString(1), cur.getString(2));
cur.close();
return note;
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(NotesContract.Note.getSqlCreateEntries());
db.execSQL(NotesContract.Tag.getSqlCreateEntries());
}
