private static List<String> getClasses() { fixUpTable(); final ArrayList<String> results = new ArrayList<>(); final String query = new Select("distinct otype as otypes").from(UploaderQueue.class).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query, null); while (resultCursor.moveToNext()) { results.add(resultCursor.getString(0)); } resultCursor.close(); return results; }
private static List<String> getClasses() { fixUpTable(); final ArrayList<String> results = new ArrayList<>(); final String query = new Select("distinct otype as otypes").from(UploaderQueue.class).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query, null); while (resultCursor.moveToNext()) { results.add(resultCursor.getString(0)); } resultCursor.close(); return results; }
private static int getCount(String where) { try { final String query = new Select("COUNT(*) as total").from(UploaderQueue.class).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query + where, null); if (resultCursor.moveToNext()) { final int total = resultCursor.getInt(0); resultCursor.close(); return total; } else { return 0; } } catch (Exception e) { Log.d(TAG, "Got exception getting count: " + e); return 0; } }
private static int getCount(String where) { try { final String query = new Select("COUNT(*) as total").from(UploaderQueue.class).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query + where, null); if (resultCursor.moveToNext()) { final int total = resultCursor.getInt(0); resultCursor.close(); return total; } else { return 0; } } catch (Exception e) { Log.d(TAG, "Got exception getting count: " + e); return 0; } }
private static int getLegacyCount(Class which, Boolean rest, Boolean mongo, Boolean and) { try { String where = ""; if (rest != null) where += " success = " + (rest ? "1 " : "0 "); if (and != null) where += (and ? " and " : " or "); if (mongo != null) where += " mongo_success = " + (mongo ? "1 " : "0 "); final String query = new Select("COUNT(*) as total").from(which).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query + ((where.length() > 0) ? " where " + where : ""), null); if (resultCursor.moveToNext()) { final int total = resultCursor.getInt(0); resultCursor.close(); return total; } else { return 0; } } catch (Exception e) { Log.d(TAG, "Got exception getting count: " + e); return -1; } }
private static int getLegacyCount(Class which, Boolean rest, Boolean mongo, Boolean and) { try { String where = ""; if (rest != null) where += " success = " + (rest ? "1 " : "0 "); if (and != null) where += (and ? " and " : " or "); if (mongo != null) where += " mongo_success = " + (mongo ? "1 " : "0 "); final String query = new Select("COUNT(*) as total").from(which).toSql(); final Cursor resultCursor = Cache.openDatabase().rawQuery(query + ((where.length() > 0) ? " where " + where : ""), null); if (resultCursor.moveToNext()) { final int total = resultCursor.getInt(0); resultCursor.close(); return total; } else { return 0; } } catch (Exception e) { Log.d(TAG, "Got exception getting count: " + e); return -1; } }
public <T extends Model> List<T> execute() { if (mQueryBase instanceof Select) { return SQLiteUtils.rawQuery(mType, toSql(), getArguments()); } else { SQLiteUtils.execSql(toSql(), getArguments()); Cache.getContext().getContentResolver().notifyChange(ContentProvider.createUri(mType, null), null); return null; } }
public <T extends Model> List<T> execute() { if (mQueryBase instanceof Select) { return SQLiteUtils.rawQuery(mType, toSql(), getArguments()); } else { SQLiteUtils.execSql(toSql(), getArguments()); Cache.getContext().getContentResolver().notifyChange(ContentProvider.createUri(mType, null), null); return null; } }
public <T extends Model> List<T> execute() { if (mQueryBase instanceof Select) { return SQLiteUtils.rawQuery(mType, toSql(), getArguments()); } else { SQLiteUtils.execSql(toSql(), getArguments()); Cache.getContext().getContentResolver().notifyChange(ContentProvider.createUri(mType, null), null); return null; } }