How to use com.activeandroid.query

public static Reminder byid(long id) {
  return new Select()
      .from(Reminder.class)
      .where("_ID = ?", id)
      .executeSingle();
}

public static List<UserError> all() {
  return new Select()
      .from(UserError.class)
      .orderBy("timestamp desc")
      .execute();
}

public static void deleteAll() {
  new Delete()
      .from(DesertSync.class)
      .execute();
}

public static LibreBlock getLatestForTrend(long start_time, long end_time) {
  return new Select()
      .from(LibreBlock.class)
      .where("bytestart == 0")
      .where("byteend >= 344")
      .where("timestamp >= ?", start_time)
      .where("timestamp <= ?", end_time)
      .orderBy("timestamp desc")
      .executeSingle();
}

public static List<LibreBlock> getForTrend(long start_time, long end_time) {
  return new Select()
      .from(LibreBlock.class)
      .where("bytestart == 0")
      .where("byteend >= 344")
      .where("timestamp >= ?", start_time)
      .where("timestamp <= ?", end_time)
      .orderBy("timestamp asc")
      .execute();
}

public static void deleteAll() {
  new Delete()
      .from(DesertSync.class)
      .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<AlertType> getAllActive() {
  List<AlertType> alerts  = new Select()
      .from(AlertType.class)
      .where("active = ?", true)
      .execute();
  return alerts;
}

public static void delete_all(boolean from_interactive) {
  if (from_interactive) {
    //GcmActivity.push_delete_all_treatments();
  }
  new Delete()
      .from(Treatments.class)
      .execute();
  // not synced with uploader queue - should we?
}

public static synchronized ActiveBluetoothDevice first() {
  return new Select()
      .from(ActiveBluetoothDevice.class)
      .orderBy("_ID asc")
      .executeSingle();
}

public static TransmitterData byid(long id) {
  return new Select()
      .from(TransmitterData.class)
      .where("_ID = ?", id)
      .executeSingle();
}

public static BgReading findByUuid(String uuid) {
  return new Select()
      .from(BgReading.class)
      .where("uuid = ?", uuid)
      .executeSingle();
}

public static BgReading byUUID(String uuid) {
  if (uuid == null) return null;
  return new Select()
      .from(BgReading.class)
      .where("uuid = ?", uuid)
      .executeSingle();
}

public static Sensor getByTimestamp(double started_at) {
  return new Select()
      .from(Sensor.class)
      .where("started_at = ?", started_at)
      .executeSingle();
}

public static Reminder byid(long id) {
  return new Select()
      .from(Reminder.class)
      .where("_ID = ?", id)
      .executeSingle();
}

public static Calibration findByUuid(String uuid) {
  return new Select()
      .from(Calibration.class)
      .where("uuid = ?", uuid)
      .executeSingle();
}

public static UserNotification lastBgAlert() {
  return new Select()
      .from(UserNotification.class)
      .where("bg_alert = ?", true)
      .orderBy("_ID desc")
      .executeSingle();
}
public static UserNotification lastCalibrationAlert() {

public static UserNotification lastExtraCalibrationAlert() {
  return new Select()
      .from(UserNotification.class)
      .where("extra_calibration_alert = ?", true)
      .orderBy("_ID desc")
      .executeSingle();
}

public static LibreBlock getLatestForTrend(long start_time, long end_time) {
  return new Select()
      .from(LibreBlock.class)
      .where("bytestart == 0")
      .where("byteend >= 344")
      .where("timestamp >= ?", start_time)
      .where("timestamp <= ?", end_time)
      .orderBy("timestamp desc")
      .executeSingle();
}

public static BgReading byUUID(String uuid) {
  if (uuid == null) return null;
  return new Select()
      .from(BgReading.class)
      .where("uuid = ?", uuid)
      .executeSingle();
}