diff options
author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-09-22 17:51:23 +1200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-09-22 17:51:23 +1200 |
commit | 05cb432d786e3e4248b54dc47d457ebf9e33ba62 (patch) | |
tree | 2534c50504dc2282417b5d14567155977d0c32fb /src/org/traccar/database/DataManager.java | |
parent | 55ee0b56cd1f668711b9ffc82e7d90961435b42f (diff) | |
parent | c8816bdd85d62fb767795b2dc4d31326fdad9cd5 (diff) | |
download | trackermap-server-05cb432d786e3e4248b54dc47d457ebf9e33ba62.tar.gz trackermap-server-05cb432d786e3e4248b54dc47d457ebf9e33ba62.tar.bz2 trackermap-server-05cb432d786e3e4248b54dc47d457ebf9e33ba62.zip |
Merge pull request #2354 from Abyss777/device_attribute_aliases
Add attributes aliases
Diffstat (limited to 'src/org/traccar/database/DataManager.java')
-rw-r--r-- | src/org/traccar/database/DataManager.java | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java index abc48f063..02adb0455 100644 --- a/src/org/traccar/database/DataManager.java +++ b/src/org/traccar/database/DataManager.java @@ -37,6 +37,7 @@ import liquibase.resource.ResourceAccessor; import org.traccar.Config; import org.traccar.helper.Log; +import org.traccar.model.AttributeAlias; import org.traccar.model.Device; import org.traccar.model.DevicePermission; import org.traccar.model.Event; @@ -460,4 +461,27 @@ public class DataManager { .setLong("id", notification.getId()) .executeUpdate(); } + + public Collection<AttributeAlias> getAttributeAliases() throws SQLException { + return QueryBuilder.create(dataSource, getQuery("database.selectAttributeAliases")) + .executeQuery(AttributeAlias.class); + } + + public void addAttributeAlias(AttributeAlias attributeAlias) throws SQLException { + attributeAlias.setId(QueryBuilder.create(dataSource, getQuery("database.insertAttributeAlias"), true) + .setObject(attributeAlias) + .executeUpdate()); + } + + public void updateAttributeAlias(AttributeAlias attributeAlias) throws SQLException { + QueryBuilder.create(dataSource, getQuery("database.updateAttributeAlias")) + .setObject(attributeAlias) + .executeUpdate(); + } + + public void removeAttributeAlias(long attributeAliasId) throws SQLException { + QueryBuilder.create(dataSource, getQuery("database.deleteAttributeAlias")) + .setLong("id", attributeAliasId) + .executeUpdate(); + } } |