diff options
| -rw-r--r-- | debug.xml | 10 | ||||
| -rw-r--r-- | setup/traccar.xml | 10 | ||||
| -rw-r--r-- | src/org/traccar/database/DataManager.java | 12 |
3 files changed, 0 insertions, 32 deletions
@@ -119,11 +119,6 @@ WHERE email = :email; </entry> - <entry key='database.selectUser'> - SELECT * FROM users - WHERE id = :id; - </entry> - <entry key='database.selectUsersAll'> SELECT * FROM users; </entry> @@ -247,11 +242,6 @@ SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND serverTime BETWEEN :from AND :to ORDER BY serverTime DESC; </entry> - <entry key='database.selectGeofence'> - SELECT * FROM geofences - WHERE id = :id; - </entry> - <entry key='database.selectGeofencesAll'> SELECT * FROM geofences; </entry> diff --git a/setup/traccar.xml b/setup/traccar.xml index ccdc5b745..c13abb3e2 100644 --- a/setup/traccar.xml +++ b/setup/traccar.xml @@ -62,11 +62,6 @@ WHERE email = :email; </entry> - <entry key='database.selectUser'> - SELECT * FROM users - WHERE id = :id; - </entry> - <entry key='database.selectUsersAll'> SELECT * FROM users; </entry> @@ -190,11 +185,6 @@ SELECT * FROM events WHERE deviceId = :deviceId AND type LIKE :type AND serverTime BETWEEN :from AND :to ORDER BY serverTime DESC; </entry> - <entry key='database.selectGeofence'> - SELECT * FROM geofences - WHERE id = :id; - </entry> - <entry key='database.selectGeofencesAll'> SELECT * FROM geofences; </entry> diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java index c58fe40a5..6718bda83 100644 --- a/src/org/traccar/database/DataManager.java +++ b/src/org/traccar/database/DataManager.java @@ -160,12 +160,6 @@ public class DataManager { .executeQuery(User.class); } - public User getUser(long userId) throws SQLException { - return QueryBuilder.create(dataSource, getQuery("database.selectUser")) - .setLong("id", userId) - .executeQuerySingle(User.class); - } - public void addUser(User user) throws SQLException { user.setId(QueryBuilder.create(dataSource, getQuery("database.insertUser"), true) .setObject(user) @@ -359,12 +353,6 @@ public class DataManager { .executeQuery(Geofence.class); } - public Geofence getGeofence(long geofenceId) throws SQLException { - return QueryBuilder.create(dataSource, getQuery("database.selectGeofences")) - .setLong("id", geofenceId) - .executeQuerySingle(Geofence.class); - } - public void addGeofence(Geofence geofence) throws SQLException { geofence.setId(QueryBuilder.create(dataSource, getQuery("database.insertGeofence"), true) .setObject(geofence) |