diff options
| author | Abyss777 <abyss@fox5.ru> | 2017-05-10 13:27:49 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2017-05-12 17:55:01 +0500 |
| commit | 6c17f85d04b224ff2a09265918765c9f4fc8cf94 (patch) | |
| tree | 5bbebd7f66b5af547267751fdb4de21283489716 /setup | |
| parent | 4ce5dd893d3b95fc759fd1d0e0dbf09d0d559936 (diff) | |
| download | trackermap-server-6c17f85d04b224ff2a09265918765c9f4fc8cf94.tar.gz trackermap-server-6c17f85d04b224ff2a09265918765c9f4fc8cf94.tar.bz2 trackermap-server-6c17f85d04b224ff2a09265918765c9f4fc8cf94.zip | |
Implement computed attributes
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/setup/default.xml b/setup/default.xml index 82f2798dd..0e43b210f 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -18,6 +18,7 @@ <entry key='logger.file'>./logs/tracker-server.log</entry> <entry key='event.enable'>true</entry> + <entry key='processing.computedAttributes.enable'>true</entry> <!-- DATABASE CONFIG --> @@ -364,6 +365,65 @@ DELETE FROM user_user WHERE userId = :userId AND managedUserId = :managedUserId </entry> + <entry key='database.selectAttributes'> + SELECT * FROM attributes + </entry> + + <entry key='database.insertAttribute'> + INSERT INTO attributes (description, type, attribute, expression) + VALUES (:description, :type, :attribute, :expression) + </entry> + + <entry key='database.updateAttribute'> + UPDATE attributes SET + description = :description, + type = :type, + attribute = :attribute, + expression = :expression + WHERE id = :id + </entry> + + <entry key='database.deleteAttribute'> + DELETE FROM attributes WHERE id = :id + </entry> + + <entry key='database.selectAttributePermissions'> + SELECT userId, attributeId FROM user_attribute + </entry> + + <entry key='database.linkAttribute'> + INSERT INTO user_attribute (userId, attributeId) VALUES (:userId, :attributeId) + </entry> + + <entry key='database.unlinkAttribute'> + DELETE FROM user_attribute WHERE userId = :userId AND attributeId = :attributeId + </entry> + + <entry key='database.selectGroupAttributes'> + SELECT groupId, attributeId FROM group_attribute + </entry> + + <entry key='database.linkGroupAttribute'> + INSERT INTO group_attribute (groupId, attributeId) VALUES (:groupId, :attributeId) + </entry> + + <entry key='database.unlinkGroupAttribute'> + DELETE FROM group_attribute WHERE groupId = :groupId AND attributeId = :attributeId + </entry> + + <entry key='database.selectDeviceAttributes'> + SELECT deviceId, attributeId FROM device_attribute + </entry> + + <entry key='database.linkDeviceAttribute'> + INSERT INTO device_attribute (deviceId, attributeId) VALUES (:deviceId, :attributeId) + </entry> + + <entry key='database.unlinkDeviceAttribute'> + DELETE FROM device_attribute WHERE deviceId = :deviceId AND attributeId = :attributeId + </entry> + + <!-- PROTOCOL CONFIG --> <entry key='gps103.port'>5001</entry> |