aboutsummaryrefslogtreecommitdiff
path: root/src/org/traccar/database
diff options
context:
space:
mode:
Diffstat (limited to 'src/org/traccar/database')
-rw-r--r--src/org/traccar/database/DataManager.java10
1 files changed, 8 insertions, 2 deletions
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<Alert> 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