@Test(expected = SQLiteDoneException.class) public void simpleQueryForStringThrowsSQLiteDoneExceptionTest() throws Exception { //throw SQLiteDOneException if no rows returned. SQLiteStatement stmt = database.compileStatement("SELECT * FROM `countme` where `name`= 'cessationoftime'"); assertThat(stmt.simpleQueryForString()).isEqualTo("0"); }
@Test public void simpleQueryTest() throws Exception { SQLiteStatement stmt = database.compileStatement("SELECT count(*) FROM `countme`"); assertThat(stmt.simpleQueryForLong()).isEqualTo(0L); assertThat(stmt.simpleQueryForString()).isEqualTo("0"); SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `countme` (`name` ,`lastUsed` ) VALUES (?,?)"); insertStatement.bindString(1, "Leg Press"); insertStatement.bindLong(2, 0); insertStatement.executeInsert(); assertThat(stmt.simpleQueryForLong()).isEqualTo(1L); assertThat(stmt.simpleQueryForString()).isEqualTo("1"); insertStatement.bindString(1, "Bench Press"); insertStatement.bindLong(2, 1); insertStatement.executeInsert(); assertThat(stmt.simpleQueryForLong()).isEqualTo(2L); assertThat(stmt.simpleQueryForString()).isEqualTo("2"); }
@Override public String simpleQueryForString() { return statement.simpleQueryForString(); } }
@Override public String simpleQueryForString(String sql, Object[] bindArgs) { SQLiteStatement statement = null; try { statement = db.compileStatement(sql); SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs); return statement.simpleQueryForString(); } finally { if (statement != null) { statement.close(); } } }
@Override public String simpleQueryForString() { return mDelegate.simpleQueryForString(); }
public String simpleQueryForString() { return statement.simpleQueryForString(); }
@Nullable @Override public String simpleQueryForString() { return statement.simpleQueryForString(); }
SQLiteStatement stmt = db.compileStatement("SELECT X FROM Y WHERE Z = ?"); ... stmt.bindString(1, "foo"); String x = stmt.simpleQueryForString();
@Override synchronized public String getValue(String group, String name) { myGetValueStatement.bindString(1, group); myGetValueStatement.bindString(2, name); try { return myGetValueStatement.simpleQueryForString(); } catch (SQLException e) { return null; } }
@Override synchronized public String getValue(String group, String name) { myGetValueStatement.bindString(1, group); myGetValueStatement.bindString(2, name); try { return myGetValueStatement.simpleQueryForString(); } catch (SQLException e) { return null; } }
@Override synchronized public String getValue(String group, String name) { myGetValueStatement.bindString(1, group); myGetValueStatement.bindString(2, name); try { return myGetValueStatement.simpleQueryForString(); } catch (SQLException e) { return null; } }
private String getFirstMessageId(UUID server, String channel) { synchronized (mDatabaseLock) { waitForDatabase(); mGetFirstMessageIdStatement.bindString(1, server.toString()); mGetFirstMessageIdStatement.bindString(2, channel); String ret; try { ret = mGetFirstMessageIdStatement.simpleQueryForString(); } catch (SQLiteDoneException ignored) { ret = null; } mGetFirstMessageIdStatement.clearBindings(); return ret; } }
@Override protected String getHash(long bookId, long lastModified) throws NotAvailable { try { final SQLiteStatement statement = get( "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?" ); synchronized (statement) { statement.bindLong(1, bookId); statement.bindLong(2, lastModified); try { return statement.simpleQueryForString(); } catch (SQLiteDoneException e) { return null; } } } catch (Throwable t) { throw new NotAvailable(); } }
@Override protected String getHash(long bookId, long lastModified) throws NotAvailable { try { final SQLiteStatement statement = get( "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?" ); synchronized (statement) { statement.bindLong(1, bookId); statement.bindLong(2, lastModified); try { return statement.simpleQueryForString(); } catch (SQLiteDoneException e) { return null; } } } catch (Throwable t) { throw new NotAvailable(); } }
@Override protected String getHash(long bookId, long lastModified) throws NotAvailable { try { final SQLiteStatement statement = get( "SELECT hash FROM BookHash WHERE book_id=? AND timestamp>?" ); synchronized (statement) { statement.bindLong(1, bookId); statement.bindLong(2, lastModified); try { return statement.simpleQueryForString(); } catch (SQLiteDoneException e) { return null; } } } catch (Throwable t) { throw new NotAvailable(); } }
username = prog.simpleQueryForString(); } catch (SQLiteDoneException e) { MyLog.ignored(TAG, e);
@NonNull public static String conditionToStringColumnValue(SQLiteDatabase dbIn, String tableName, String columnName, String condition) { String method = "cond2str"; SQLiteDatabase db = dbIn == null ? MyContextHolder.get().getDatabase() : dbIn; if (db == null) { MyLog.v(TAG, () -> method + "; Database is null"); return ""; } String sql = "SELECT " + columnName + " FROM " + tableName + " WHERE " + condition; String columnValue = ""; if (StringUtils.isEmpty(tableName) || StringUtils.isEmpty(columnName)) { throw new IllegalArgumentException(method + " tableName or columnName are empty"); } else if (StringUtils.isEmpty(columnName)) { throw new IllegalArgumentException("columnName is empty: " + sql); } else { try (SQLiteStatement prog = db.compileStatement(sql)) { columnValue = prog.simpleQueryForString(); } catch (SQLiteDoneException e) { MyLog.ignored(TAG, e); } catch (Exception e) { MyLog.e(TAG, method + " table='" + tableName + "', column='" + columnName + "'", e); return ""; } if (MyLog.isVerboseEnabled()) { MyLog.v(TAG, method + "; '" + sql + "' -> " + columnValue ); } } return StringUtils.isEmpty(columnValue) ? "" : columnValue; }
oid = prog.simpleQueryForString();