From ba9551ce3e4a3aade38d5f3b2ac7dee9d022a466 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Mon, 27 Apr 2015 15:15:01 +1200
Subject: Implement permissions manager

---
 src/org/traccar/database/DataManager.java | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

(limited to 'src/org/traccar/database/DataManager.java')

diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index d53ec7838..f60fd4cb3 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -364,23 +364,23 @@ public class DataManager {
             connection.close();
         }
     }
-    
-    public List<Long> getDeviceList(long userId) throws SQLException {
+
+    public Collection<Map.Entry<Long, Long>> getPermissions() throws SQLException {
 
         Connection connection = dataSource.getConnection();
         try {
             PreparedStatement statement = connection.prepareStatement(
-                    "SELECT id FROM device WHERE id IN (" +
-                    "SELECT device_id FROM user_device WHERE user_id = ?);");
+                    "SELECT user_id, device_id FROM user_device;");
             try {
-                statement.setLong(1, userId);
-
-                ResultSet resultSet = statement.executeQuery();
+                statement.execute();
+                ResultSet resultSet = statement.getResultSet();
                 
-                List<Long> result = new LinkedList<Long>();
+                List<Map.Entry<Long, Long>> result = new LinkedList<Map.Entry<Long, Long>>();
                 while (resultSet.next()) {
-                    result.add(resultSet.getLong(1));
+                    result.add(new AbstractMap.SimpleEntry<Long, Long>(
+                            resultSet.getLong(1), resultSet.getLong(2)));
                 }
+                
                 return result;
             } finally {
                 statement.close();
@@ -389,7 +389,7 @@ public class DataManager {
             connection.close();
         }
     }
-    
+
     public JsonArray getDevices(long userId) throws SQLException {
 
         Connection connection = dataSource.getConnection();
-- 
cgit v1.2.3