From 5dc81b6197b9a1387adffdc2628c24ca483d2376 Mon Sep 17 00:00:00 2001 From: Irving Gonzalez Date: Wed, 10 Jun 2015 20:06:30 -0600 Subject: Begin implementing alerts --- src/org/traccar/database/DataManager.java | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'src/org/traccar/database') diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java index 9633ada58..35e9cff95 100644 --- a/src/org/traccar/database/DataManager.java +++ b/src/org/traccar/database/DataManager.java @@ -46,6 +46,7 @@ import org.traccar.model.Permission; import org.traccar.model.Position; import org.traccar.model.Server; import org.traccar.model.User; +import org.traccar.model.Alert; import com.mchange.v2.c3p0.ComboPooledDataSource; @@ -322,5 +323,10 @@ public class DataManager { .setObject(server) .executeUpdate(); } - -} + + public Collection getAlertsByDevice(Long deviceId) throws SQLException { + return QueryBuilder.create(dataSource, properties.getProperty("database.getAlertsByDevice")) + .setLong("deviceId", deviceId) + .executeQuery(new Alert()); + } +} \ No newline at end of file -- cgit v1.2.3