public void markAsBookmark(int point_id) { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(POINT_ID, point_id); if (!pointExists(point_id)) { db.insert(SCHOOL_BOOKMARK_TABLE, POINT_ID, values); } }
public void saveNavigationListItem(NavigationListItem item) { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(TYPE, item.type); values.put(POINT_ID, item.point_id); if (!isNavigationListItemExists(item.point_id)) { db.insert(NAVIGATION_TYPE_TABLE, POINT_ID, values); } else { db.update( NAVIGATION_TYPE_TABLE, values, POINT_ID_WHERE, new String[] {String.valueOf(item.point_id)}); } }
public boolean saveNavigationItem(NavigationItem item) { boolean bFlags = false; SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(NAME, item.name); values.put(TYPE, item.type); values.put(POINT_ID, item.point_id); values.put(PARENT_ID, item.parent_id); values.put(SCHOOL_KEY, item.key); values.put(TITLEURL, item.titleurl); values.put(STATUS, item.status); if (schoolDistrictExist(item.point_id)) { db.update( SCHOOL_DISTRICT_TABLE, values, POINT_ID_WHERE, new String[] {String.valueOf(item.point_id)}); } else { bFlags = true; db.insert(SCHOOL_DISTRICT_TABLE, POINT_ID, values); } return bFlags; }
public void endTransaction() { mNavigationDBHelper.getWritableDatabase().setTransactionSuccessful(); mNavigationDBHelper.getWritableDatabase().endTransaction(); }
public void startTransaction() { mNavigationDBHelper.getWritableDatabase().beginTransaction(); }
private NavigationDB(Context context) { mNavigationDBHelper = NavigationDatabaseHelper.getInstance(context); SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); createTable(db); db.close(); }
public void deleteBookmarkFlag(int point_id) { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); if (pointExists(point_id)) { db.delete(SCHOOL_BOOKMARK_TABLE, POINT_ID_WHERE, new String[] {String.valueOf(point_id)}); } }
public void clearAllNavigationList() { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); db.delete(NAVIGATION_TYPE_TABLE, null, null); }
public void clearChildBySearchKey(String searchkey) { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); db.delete(SCHOOL_DISTRICT_TABLE, NAME + " LIKE '%" + searchkey + "%'", null); }
public void clearChildID(String parentid) { SQLiteDatabase db = mNavigationDBHelper.getWritableDatabase(); db.delete(SCHOOL_DISTRICT_TABLE, PARENT_ID + "=?", new String[] {parentid}); }