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

  • Making http post requests using okhttp
  • onRequestPermissionsResult (Fragment)
  • notifyDataSetChanged (ArrayAdapter)
  • addToBackStack (FragmentTransaction)
  • URL (java.net)
    A Uniform Resource Locator that identifies the location of an Internet resource as specified by RFC
  • Enumeration (java.util)
    A legacy iteration interface.New code should use Iterator instead. Iterator replaces the enumeration
  • TreeMap (java.util)
    Walk the nodes of the tree left-to-right or right-to-left. Note that in descending iterations, next
  • Cipher (javax.crypto)
    This class provides access to implementations of cryptographic ciphers for encryption and decryption
  • Notification (javax.management)
  • Option (scala)
  • Top plugins for WebStorm
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

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