diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2022-02-13 23:34:25 -0800 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2022-02-13 23:34:25 -0800 |
| commit | 1c73bae2e23242673e0a07cdbc2493700f134ceb (patch) | |
| tree | d1105368628b5f64fabb657682df58f1641e4d54 /setup | |
| parent | de110b28ce8adb6ba875d88ede6e8f86dae4dd48 (diff) | |
| download | trackermap-server-1c73bae2e23242673e0a07cdbc2493700f134ceb.tar.gz trackermap-server-1c73bae2e23242673e0a07cdbc2493700f134ceb.tar.bz2 trackermap-server-1c73bae2e23242673e0a07cdbc2493700f134ceb.zip | |
New storage implementation
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 30 |
1 files changed, 0 insertions, 30 deletions
diff --git a/setup/default.xml b/setup/default.xml index 0d8133627..a1ba5ca33 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -41,37 +41,7 @@ <entry key='commands.queueing'>true</entry> <entry key='database.ignoreUnknown'>true</entry> - <entry key='database.generateQueries'>true</entry> <entry key='database.changelog'>./schema/changelog-master.xml</entry> - - <entry key='database.loginUser'> - SELECT * FROM tc_users - WHERE email = :email OR login = :email - </entry> - - <entry key='database.selectPositions'> - SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime - </entry> - - <entry key='database.selectPrecedingPosition'> - SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime <= :time ORDER BY fixTime DESC LIMIT 1 - </entry> - - <entry key='database.selectLatestPositions'> - SELECT tc_positions.* FROM tc_positions INNER JOIN tc_devices ON tc_positions.id = tc_devices.positionid; - </entry> - - <entry key='database.updateLatestPosition'> - UPDATE tc_devices SET positionId = :id WHERE id = :deviceId - </entry> - - <entry key='database.selectEvents'> - SELECT * FROM tc_events WHERE deviceId = :deviceId AND eventTime BETWEEN :from AND :to ORDER BY eventTime - </entry> - - <entry key='database.selectStatistics'> - SELECT * FROM tc_statistics WHERE captureTime BETWEEN :from AND :to ORDER BY captureTime - </entry> <entry key='gps103.port'>5001</entry> <entry key='tk103.port'>5002</entry> |