public List<Favorite> getAllFavorite() {
List<Favorite> favoriteItems = new ArrayList<Favorite>();
String selectQuery = "SELECT * FROM " + TABLE_FAVORITE;
Cursor c = sqLiteDatabase.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (c.moveToFirst()) {
do {
Log.e(LOG, selectQuery);
Favorite fav = new Favorite();
fav.setFav(c.getInt(1));
fav.setFavDesc(c.getString(c.getColumnIndex(FAV_DESC)));
fav.setDate(c.getString(c.getColumnIndex(FAV_TIME)));
fav.setImage(c.getString(c.getColumnIndex(FAV_IMAGE)));
fav.setFavTitle(c.getString(c.getColumnIndex(FAV_TITLE)));
// adding to tags list
favoriteItems.add(fav);
} while (c.moveToNext());
}
return favoriteItems;
}
