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 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<Treatments> latestForGraphSystime(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("systimestamp >= ? and systimestamp <= ?", df.format(startTime), df.format(endTime)) .orderBy("systimestamp asc") .limit(number) .execute(); }
public static synchronized Treatments create(final double carbs, final double insulin, final String notes, long timestamp, double position, String suggested_uuid) { fixUpTable(); Log.d(TAG, "Creating treatment: Insulin: " + Double.toString(insulin) + " / Carbs: " + Double.toString(carbs));
public static Treatments lastCarbsOrInsulin() { fixUpTable(); //.where("carbs > 0 OR insulin > 0 OR (notes IS NOT NULL AND notes != '' AND notes NOT LIKE '%watchkeypad%'") List<Treatments> treatl = new Select() .from(Treatments.class) .where("carbs > 0 OR insulin > 0 OR notes IS NOT NULL") .orderBy("timestamp desc") .execute(); if ((treatl != null) && (treatl.size() > 0)) { return treatl.get(0); } else { return null; } }
public static Treatments last() { fixUpTable(); return new Select() .from(Treatments.class) .orderBy("_ID desc") .executeSingle(); }
public static Treatments lastSystime() { fixUpTable(); return new Select() .from(Treatments.class) .orderBy("systimestamp desc") .executeSingle(); } /*public static Treatments last() {
public static Treatments last() { fixUpTable(); return new Select() .from(Treatments.class) .orderBy("_ID desc") .executeSingle(); }
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; } }
fixUpTable(); dupe_treatment.save(); Log.d(TAG,"Saved updated treatement notes"); fixUpTable(); long x = mytreatment.save(); Log.d(TAG, "Saving treatment result: " + x);
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<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 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; } }
fixUpTable(); dupe_treatment.save(); Log.d(TAG,"Saved updated treatement notes"); fixUpTable(); long x = mytreatment.save(); Log.d(TAG, "Saving treatment result: " + x);
fixUpTable(); dupe_treatment.save(); Log.d(TAG,"Saved updated treatement notes"); fixUpTable(); long x = mytreatment.save(); Log.d(TAG, "Saving treatment result: " + x);