public static List<BgReading> latestForGraphAsc(int number, long startTime, long endTime) {//KS return new Select() .from(BgReading.class) .where("timestamp >= " + Math.max(startTime, 0)) .where("timestamp <= " + endTime) .where("calculated_value != 0") .where("raw_data != 0") .orderBy("timestamp asc") .limit(number) .execute(); }
public static BgReading readingNearTimeStamp(double startTime) { final double margin = (4 * 60 * 1000); final DecimalFormat df = new DecimalFormat("#"); df.setMaximumFractionDigits(1); return new Select() .from(BgReading.class) .where("timestamp >= " + df.format(startTime - margin)) .where("timestamp <= " + df.format(startTime + margin)) .where("calculated_value != 0") .where("raw_data != 0") .executeSingle(); }
public <T extends Model> T executeSingle() { if (mQueryBase instanceof Select) { limit(1); return (T) SQLiteUtils.rawQuerySingle(mType, toSql(), getArguments()); } else { limit(1); SQLiteUtils.rawQuerySingle(mType, toSql(), getArguments()).delete(); return null; } }
public From where(String clause, Object... args) { where(clause).addArguments(args); return this; }
public From or(String clause, Object... args) { or(clause).addArguments(args); return this; }
public static Sensor currentSensor() { Sensor sensor = new Select() .from(Sensor.class) .where("started_at != 0") .where("stopped_at = 0") .orderBy("_ID desc") .limit(1) .executeSingle(); return sensor; }
public static void deleteAll() { new Delete() .from(DesertSync.class) .execute(); }
public static synchronized ActiveBluetoothDevice first() { return new Select() .from(ActiveBluetoothDevice.class) .orderBy("_ID asc") .executeSingle(); }
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; } }
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; }
public From from(Class<? extends Model> table) { return new From(table, this); }
public From on(String on, Object... args) { mOn = on; mFrom.addArguments(args); return mFrom; }
public static SensorSendQueue nextSensorJob() { SensorSendQueue job = new Select() .from(SensorSendQueue.class) .where("success =", false) .orderBy("_ID desc") .limit(1) .executeSingle(); return job; }