public static void GetTasksFromDB() {
try {
// zrobic zeby zwrocil to albo dodal do listy bezposrednio i oznaczyl ze odczytane. moze
// usunac bezposrednio zeby nie wadzily?
// System.out.println("# Bufor pusty. Odpytywanie bazy danych...");
String selectedBy = Konfiguracja.getDeviceComPort();
// markowanie zadan w bazie. onzacza ze zadania beda wykonywane przez dana instancje
// programu(urzadzenie)
String updateQuery =
"update sms.tasks set selected_by = '"
+ selectedBy
+ "' where id_task in (select id_task from(select id_task, send_time FROM sms.tasks where (selected_by is null OR selected_by = '') AND send_time <= now() order by send_time asc limit 5)as t);";
dba.updateDataBase(updateQuery);
// String selectQuery = "SELECT id_task, phone_number, message, send_time FROM sms.tasks where
// selected_by = '"+selectedBy+"' order by send_time";
String selectQuery =
"SELECT id_task, phone_number, message, send_time, selected_by FROM sms.tasks where selected_by = '"
+ selectedBy
+ "' AND send_time <= now() order by send_time";
// dba.readDataBase("SELECT phone_number, message, sender, send_time FROM sms.tasks order by
// send_time asc limit 5");
dba.readDataBase(selectQuery);
} catch (Exception ex) {
Logger.getLogger(BuforZadan.class.getName()).log(Level.SEVERE, null, ex);
}
}
