diff options
| author | Abyss777 <abyss@fox5.ru> | 2016-11-30 09:58:48 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2016-11-30 09:58:48 +0500 |
| commit | d5ec75ecd3697e37782c9dd53998c889d5b9ef4d (patch) | |
| tree | 22096d3869db469ad556a0e7aeaecd17ad02c6b6 /setup | |
| parent | e24b3588647fc1597f31b9bcd26ed9b7378f9f5b (diff) | |
| download | trackermap-server-d5ec75ecd3697e37782c9dd53998c889d5b9ef4d.tar.gz trackermap-server-d5ec75ecd3697e37782c9dd53998c889d5b9ef4d.tar.bz2 trackermap-server-d5ec75ecd3697e37782c9dd53998c889d5b9ef4d.zip | |
Add API to get positions by Id
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/setup/default.xml b/setup/default.xml index 7df352c4d..5c6f8fe90 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -171,6 +171,10 @@ SELECT * FROM positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime </entry> + <entry key='database.selectPosition'> + SELECT * FROM positions WHERE id = :id + </entry> + <entry key='database.insertPosition'> INSERT INTO positions (deviceId, protocol, serverTime, deviceTime, fixTime, valid, latitude, longitude, altitude, speed, course, address, attributes) VALUES (:deviceId, :protocol, :now, :deviceTime, :fixTime, :valid, :latitude, :longitude, :altitude, :speed, :course, :address, :attributes) |