public static List<Treatments> latestForGraph(int number, double startTime, double endTime) { fixUpTable(); DecimalFormat df = new DecimalFormat("#"); df.setMaximumFractionDigits(1); // are there decimal points in the database?? return new Select() .from(Treatments.class) .where("timestamp >= ? and timestamp <= ?", df.format(startTime), df.format(endTime)) .orderBy("timestamp asc") .limit(number) .execute(); }
public static List<Treatments> latestForGraph(int number, double startTime, double endTime) { fixUpTable(); DecimalFormat df = new DecimalFormat("#"); df.setMaximumFractionDigits(1); // are there decimal points in the database?? return new Select() .from(Treatments.class) .where("timestamp >= ? and timestamp <= ?", df.format(startTime), df.format(endTime)) .orderBy("timestamp desc") .limit(number) .execute(); } public static long getTimeStampWithOffset(double offset) {
public static List<BloodTest> latest(int number) { try { return new Select() .from(BloodTest.class) .orderBy("timestamp desc") .limit(number) .execute(); } catch (android.database.sqlite.SQLiteException e) { fixUpTable(); return new ArrayList<>(); } }
@Deprecated public static List<BgSendQueue> mongoQueue() { return new Select() .from(BgSendQueue.class) .where("mongo_success = ?", false) .where("operation_type = ?", "create") .orderBy("_ID desc") .limit(30) .execute(); }
@Deprecated public static List<BgSendQueue> mongoQueue() { return new Select() .from(BgSendQueue.class) .where("mongo_success = ?", false) .where("operation_type = ?", "create") .orderBy("_ID desc") .limit(30) .execute(); }
public static SensorSendQueue nextSensorJob() { SensorSendQueue job = new Select() .from(SensorSendQueue.class) .where("success =", false) .orderBy("_ID desc") .limit(1) .executeSingle(); return job; }
public static List<Treatments> last(int num) { try { return new Select() .from(Treatments.class) .orderBy("timestamp desc") .limit(num) .execute(); } catch (android.database.sqlite.SQLiteException e) { fixUpTable(); return null; } }
public static List<CalibrationSendQueue> mongoQueue() { return new Select() .from(CalibrationSendQueue.class) .where("mongo_success = ?", false) .orderBy("_ID desc") .limit(20) .execute(); }
public static List<BloodTest> last(int num) { try { return new Select() .from(BloodTest.class) .orderBy("timestamp desc") .limit(num) .execute(); } catch (android.database.sqlite.SQLiteException e) { fixUpTable(); return null; } }
public static List<Treatments> latest(int num) { try { return new Select() .from(Treatments.class) .orderBy("timestamp desc") .limit(num) .execute(); } catch (android.database.sqlite.SQLiteException e) { fixUpTable(); return null; } }
public static SensorSendQueue nextSensorJob() { SensorSendQueue job = new Select() .from(SensorSendQueue.class) .where("success =", false) .orderBy("_ID desc") .limit(1) .executeSingle(); return job; }
public static List<Calibration> getCalibrationsForSensor(Sensor sensor, int limit) { return new Select() .from(Calibration.class) .where("sensor_uuid = ? ", sensor.uuid) .orderBy("timestamp desc") .limit(limit) .execute(); }
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 List<BgReading> latestForGraph(int number, long startTime, long endTime) { 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 desc") .limit(number) .execute(); }
public static List<BgReading> latestForGraph(int number, long startTime, long endTime) { 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 desc") .limit(number) .execute(); }
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 List<Calibration> latest(int number) { Sensor sensor = Sensor.currentSensor(); if (sensor == null) { return null; } return new Select() .from(Calibration.class) .where("Sensor = ? ", sensor.getId()) .orderBy("timestamp desc") .limit(number) .execute(); }
public static List<BgReading> latest_by_size(int number) { final Sensor sensor = Sensor.currentSensor(); if (sensor == null) return null; return new Select() .from(BgReading.class) .where("Sensor = ? ", sensor.getId()) .where("raw_data != 0") .orderBy("timestamp desc") .limit(number) .execute(); }
public static List<BgReading> latestUnCalculated(int number) { Sensor sensor = Sensor.currentSensor(); if (sensor == null) { return null; } return new Select() .from(BgReading.class) .where("Sensor = ? ", sensor.getId()) .where("raw_data != 0") .orderBy("timestamp desc") .limit(number) .execute(); }
public static List<BgReading> latest_by_size(int number) { final Sensor sensor = Sensor.currentSensor(); if (sensor == null) return null; return new Select() .from(BgReading.class) .where("Sensor = ? ", sensor.getId()) .where("raw_data != 0") .orderBy("timestamp desc") .limit(number) .execute(); }