public List<String> getAllProvince() { List<String> list = new ArrayList<String>(); Cursor c = db.rawQuery("SELECT distinct province from " + CITY_TABLE_NAME, null); while (c.moveToNext()) { String province = c.getString(c.getColumnIndex("province")); list.add(province); } return list; }
mcursor.moveToFirst(); public void count(){ SQLiteDatabase db = table.getWritableDatabase(); String count = "SELECT count(*) FROM table"; Cursor mcursor = db.rawQuery(count, null); mcursor.moveToFirst(); int icount = mcursor.getInt(0); System.out.println("NUMBER IN DB: " + icount); }
public int getTaskCount(long tasklist_Id) { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor= db.rawQuery("SELECT COUNT (*) FROM " + TABLE_TODOTASK + " WHERE " + KEY_TASK_TASKLISTID + "=?", new String[] { String.valueOf(tasklist_Id) }); int count = 0; if(null != cursor) if(cursor.getCount() > 0){ cursor.moveToFirst(); count = c.getInt(0); } cursor.close(); } db.close(); return count;
private boolean contains(String host) { Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_HOSTS + " WHERE " + COLUMN_HOST + " = ?;", new String[] {host}); try { return cursor.moveToNext(); } finally { cursor.close(); } }
@Test public void testInsertAndRawQuery() throws Exception { String stringColumnValue = "column_value"; byte[] byteColumnValue = new byte[]{1, 2, 3}; ContentValues values = new ContentValues(); values.put("first_column", stringColumnValue); values.put("second_column", byteColumnValue); database.insert("table_name", null, values); Cursor cursor = database.rawQuery("select second_column, first_column from table_name", null); assertThat(cursor.moveToFirst()).isTrue(); byte[] byteValueFromDatabase = cursor.getBlob(0); String stringValueFromDatabase = cursor.getString(1); assertThat(stringValueFromDatabase).isEqualTo(stringColumnValue); assertThat(byteValueFromDatabase).isEqualTo(byteColumnValue); }
public static boolean isFieldExists(SQLiteDatabase db, String tableName, String fieldName) { if (tableName == null || db == null || fieldName == null || !db.isOpen()) return false; Cursor cursor = null; try { cursor = db.rawQuery("SELECT * FROM " + tableName + " LIMIT 0", null); return cursor != null && cursor.getColumnIndex(fieldName) != -1; } catch (Exception e) { OkLogger.printStackTrace(e); return false; } finally { if (cursor != null) { cursor.close(); } } } }
@Test public void testExecuteUpdateDelete() throws Exception { SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` (`name`) VALUES (?)"); insertStatement.bindString(1, "Hand Press"); long pkeyOne = insertStatement.executeInsert(); assertThat(pkeyOne).isEqualTo(1); SQLiteStatement updateStatement = database.compileStatement("UPDATE `routine` SET `name`=? WHERE `id`=?"); updateStatement.bindString(1, "Head Press"); updateStatement.bindLong(2, pkeyOne); assertThat(updateStatement.executeUpdateDelete()).isEqualTo(1); Cursor dataCursor = database.rawQuery("SELECT `name` FROM `routine`", null); assertThat(dataCursor.moveToNext()).isTrue(); assertThat(dataCursor.getString(0)).isEqualTo("Head Press"); }
@Test public void testFailureNestedTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(12345, 'Julie');"); database.endTransaction(); database.setTransactionSuccessful(); database.endTransaction(); Cursor cursor = database.rawQuery("SELECT COUNT(*) FROM table_name", null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(0); }
public List<String> getAllProvince() { List<String> list = new ArrayList<String>(); Cursor c = db.rawQuery("SELECT distinct province from " + CITY_TABLE_NAME, null); while (c.moveToNext()) { String province = c.getString(c.getColumnIndex("province")); list.add(province); } return list; }
@Override public AccountStats doDbWork(SQLiteDatabase db) throws WrappedException, MessagingException { Cursor cursor = db.rawQuery(sqlQuery, selectionArgs); try { AccountStats accountStats = new AccountStats(); if (cursor.moveToFirst()) { accountStats.unreadMessageCount = cursor.getInt(0); accountStats.flaggedMessageCount = cursor.getInt(1); } return accountStats; } finally { cursor.close(); } } });
@Override public FileDownloadModel find(final int id) { Cursor c = null; try { c = db.rawQuery(FileDownloadUtils.formatString("SELECT * FROM %s WHERE %s = ?", TABLE_NAME, FileDownloadModel.ID), new String[]{Integer.toString(id)}); if (c.moveToNext()) return createFromCursor(c); } finally { if (c != null) c.close(); } return null; }
SQLiteDatabase db = table.getWritableDatabase(); String count = "SELECT count(*) FROM table"; Cursor mcursor = db.rawQuery(count, null); mcursor.moveToFirst(); int icount = mcursor.getInt(0); if(icount>0) //leave else //populate table
@Test public void testInsertOrThrow() { String stringColumnValue = "column_value"; byte[] byteColumnValue = new byte[]{1, 2, 3}; ContentValues values = new ContentValues(); values.put("first_column", stringColumnValue); values.put("second_column", byteColumnValue); database.insertOrThrow("table_name", null, values); Cursor cursor = database.rawQuery("select second_column, first_column from table_name", null); assertThat(cursor.moveToFirst()).isTrue(); byte[] byteValueFromDatabase = cursor.getBlob(0); String stringValueFromDatabase = cursor.getString(1); assertThat(stringValueFromDatabase).isEqualTo(stringColumnValue); assertThat(byteValueFromDatabase).isEqualTo(byteColumnValue); }
public static boolean CheckIsDataAlreadyInDBorNot(String TableName, String dbfield, String fieldValue) { SQLiteDatabase sqldb = EGLifeStyleApplication.sqLiteDatabase; String Query = "Select * from " + TableName + " where " + dbfield + " = " + fieldValue; Cursor cursor = sqldb.rawQuery(Query, null); if(cursor.getCount() <= 0){ cursor.close(); return false; } cursor.close(); return true; }
@Test public void testSuccessTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); database.setTransactionSuccessful(); database.endTransaction(); Cursor cursor = database.rawQuery("SELECT COUNT(*) FROM table_name", null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(1); }
private static boolean columnExists(SQLiteDatabase db, String table, String columnName) { Cursor columnCursor = db.rawQuery("PRAGMA table_info(" + table + ")", null); boolean foundColumn = false; while (columnCursor.moveToNext()) { String currentColumnName = columnCursor.getString(1); if (currentColumnName.equals(columnName)) { foundColumn = true; break; } } columnCursor.close(); return foundColumn; }
/** * Check whether or not a message has child messages in the thread structure. * * @param db * {@link SQLiteDatabase} instance to access the database. * @param messageId * The database ID of the message to get the children for. * * @return {@code true} if the message has children. {@code false} otherwise. */ private boolean hasThreadChildren(SQLiteDatabase db, long messageId) { Cursor cursor = db.rawQuery( "SELECT COUNT(t2.id) " + "FROM threads t1 " + "JOIN threads t2 ON (t2.parent = t1.id) " + "WHERE t1.message_id = ?", new String[] { Long.toString(messageId) }); try { return (cursor.moveToFirst() && !cursor.isNull(0) && cursor.getLong(0) > 0L); } finally { cursor.close(); } }
@Test public void testFailureTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); final String select = "SELECT COUNT(*) FROM table_name"; Cursor cursor = database.rawQuery(select, null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(1); cursor.close(); database.endTransaction(); cursor = database.rawQuery(select, null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(0); }
public int count() { SQLiteDatabase db = getReadableDatabase(); Cursor cursor = db.rawQuery("select * from cars", null); if (cursor != null && cursor.getCount() > 0) { cursor.moveToFirst(); return cursor.getInt(0); } else { return 0; } } }