congrats Icon
New! Announcing our next generation AI code completions
Read here
Tabnine Logo
SQLiteStatement.simpleQueryForString
Code IndexAdd Tabnine to your IDE (free)

How to use
simpleQueryForString
method
in
android.database.sqlite.SQLiteStatement

Best Java code snippets using android.database.sqlite.SQLiteStatement.simpleQueryForString (Showing top 18 results out of 315)

origin: robolectric/robolectric

@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");
}
origin: robolectric/robolectric

@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");
}
origin: yahoo/squidb

  @Override
  public String simpleQueryForString() {
    return statement.simpleQueryForString();
  }
}
origin: yahoo/squidb

@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();
    }
  }
}
origin: daolq3012/AssetSQLiteOpenHelper

@Override
public String simpleQueryForString() {
  return mDelegate.simpleQueryForString();
}
origin: jeffdcamp/dbtools-android

public String simpleQueryForString() {
  return statement.simpleQueryForString();
}
origin: firelotus/Meteorite

@Nullable
@Override
public String simpleQueryForString() {
  return statement.simpleQueryForString();
}
origin: stackoverflow.com

 SQLiteStatement stmt = db.compileStatement("SELECT X FROM Y WHERE Z = ?");
...
stmt.bindString(1, "foo");
String x = stmt.simpleQueryForString();
origin: adolfAn/FBReader_AS

@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;
  }
}
origin: Jiangzqts/EpubRead

@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;
  }
}
origin: ydcx/KooReader

@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;
  }
}
origin: MCMrARM/revolution-irc

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;
  }
}
origin: adolfAn/FBReader_AS

@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();
  }
}
origin: ydcx/KooReader

@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();
  }
}
origin: Jiangzqts/EpubRead

@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();
  }
}
origin: andstatus/andstatus

  username = prog.simpleQueryForString();
} catch (SQLiteDoneException e) {
  MyLog.ignored(TAG, e);
origin: andstatus/andstatus

@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;
}
origin: andstatus/andstatus

oid = prog.simpleQueryForString();
android.database.sqliteSQLiteStatementsimpleQueryForString

Popular methods of SQLiteStatement

  • bindLong
  • bindString
  • clearBindings
  • executeInsert
  • close
  • execute
  • bindDouble
  • bindBlob
  • executeUpdateDelete
  • simpleQueryForLong
  • bindNull
  • bindAllArgsAsStrings
  • bindNull,
  • bindAllArgsAsStrings,
  • bindDate,
  • bindInt,
  • bindInteger,
  • bindValue,
  • simpleQueryForBlobFileDescriptor,
  • toString

Popular in Java

  • Updating database using SQL prepared statement
  • getSystemService (Context)
  • getContentResolver (Context)
  • getResourceAsStream (ClassLoader)
  • FlowLayout (java.awt)
    A flow layout arranges components in a left-to-right flow, much like lines of text in a paragraph. F
  • GridBagLayout (java.awt)
    The GridBagLayout class is a flexible layout manager that aligns components vertically and horizonta
  • BufferedWriter (java.io)
    Wraps an existing Writer and buffers the output. Expensive interaction with the underlying reader is
  • DateFormat (java.text)
    Formats or parses dates and times.This class provides factories for obtaining instances configured f
  • JFileChooser (javax.swing)
  • Option (scala)
  • Top 12 Jupyter Notebook Extensions
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyStudentsTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now