sbrl-github
/
Air-Quality-Web
mirror of https://github.com/ConnectedHumber/Air-Quality-Web
1
0
Fork 0
Code Issues Releases Wiki Activity
482 Commits 12 Branches 0 Tags 2 MiB
Commit Graph

81 Commits

Author SHA1 Message Date
Starbeamrainbowlabs 3dc7b58e6e
api/device-info: drastically optimise by removing a redundant JOIN 
....why we didn't remove it before, I have no idea.
 2021-01-30 21:33:28 +00:00
Starbeamrainbowlabs 8ccc578e7b
api/list-reading-types: optimise 
This uses the new sensor_reading_value_types table that was recently 
added, and also REMOVES the "count" property on returned objects from 
this API action.
 2021-01-30 18:26:50 +00:00
Starbeamrainbowlabs 712e0602ed
api/index: update URL 2020-12-12 13:58:54 +00:00
Starbeamrainbowlabs 552a640600
Bugfix: Correct SQL. Fixes #63 2020-05-15 18:27:02 +01:00
Starbeamrainbowlabs cdb656b4b3
Bugfix: Fix duplicated items in list-devices-near. 
Fixes #61.
 2020-05-01 23:41:31 +01:00
Starbeamrainbowlabs 0b19464678
Don't show devices that have visible set to 0 2020-05-01 23:34:34 +01:00
Starbeamrainbowlabs 4c61f662cc
Bugfix: Fix error in list-devices-near error 2020-03-05 18:52:53 +00:00
Starbeamrainbowlabs 35c65f4b81
Improve device last seen time performance via new DB column. 
Fixes #58
 2019-11-12 22:03:35 +00:00
Starbeamrainbowlabs e52c136406
Fix bugs in performance improvement 2019-11-07 19:04:05 +00:00
Starbeamrainbowlabs 7398260a57
Improve SQL statements for getting device reading types 2019-11-07 18:43:28 +00:00
Starbeamrainbowlabs 209fcd7926
Add short-term caching header to list-devices and list-devices-near. 2019-10-10 21:25:40 +01:00
Starbeamrainbowlabs a678a89b95
Add last_seen to list_devices_near 2019-08-14 13:00:30 +01:00
Starbeamrainbowlabs 7a489706bd
Bugfix new device sensor list 2019-07-18 22:18:30 +01:00
Starbeamrainbowlabs a325940322
Implement new ISensorRepository. 
This is thanks to @BNNorman's recent DB changes :D
 2019-07-18 21:19:16 +01:00
Starbeamrainbowlabs d5df81eed1
Add last_seen to device-info. For 36 2019-06-30 17:33:44 +01:00
Starbeamrainbowlabs 5efaab3f67
Add last-seen to list-devices. 
For #36.
 2019-06-30 17:27:57 +01:00
Starbeamrainbowlabs 74b1b212fe
Log SQL warnings to the error log, but only in development 2019-06-30 17:24:02 +01:00
Starbeamrainbowlabs e86b0b4f97
Upgrade ST_DISTANCE() to ST_DISTANCE_SPHERE(), but there's a permissions issue. 2019-06-26 21:02:17 +01:00
Starbeamrainbowlabs 2d07af950a
Use new column name 2019-06-23 14:42:47 +01:00
Starbeamrainbowlabs 030d0cb9be
Revert "Don't use the new datetime computed column until the issues are worked out" 
This reverts commit 97e234b920.
 2019-06-23 14:39:24 +01:00
Starbeamrainbowlabs 97e234b920
Don't use the new datetime computed column until the issues are worked out 2019-06-23 13:54:18 +01:00
Starbeamrainbowlabs 336b7624fa
Fully comment database class 2019-06-23 13:13:28 +01:00
Starbeamrainbowlabs 913786ec0b
Drastically optimise the queries behind fetch-data and device-data. 2019-06-22 21:08:12 +01:00
Starbeamrainbowlabs b4ae0b457b
Optimise some queries using the new datetime computed column, but there's more work to do. 
The fetch-data query in particular is using the wrong index.
 2019-06-22 11:50:23 +01:00
Starbeamrainbowlabs 51c76ccd58
Add list-devices-near action with appropriate API documentation 2019-06-21 22:05:13 +01:00
Starbeamrainbowlabs 0006c2a921
Add performance counter system. 2019-06-21 00:02:26 +01:00
Starbeamrainbowlabs 87c0eb90ba
Optimise the fetch-data query 2019-06-20 22:12:33 +01:00
Starbeamrainbowlabs 009e2e4b72
Bugfix new device-recent-data action 2019-06-13 22:10:14 +01:00
Starbeamrainbowlabs dba984340d
Implement new device-data-recent, but it's not working right. 2019-06-13 22:02:04 +01:00
Starbeamrainbowlabs 7710331f1e
Add is_min & is_max to validator 2019-06-13 21:53:26 +01:00
Starbeamrainbowlabs bbf3d02b5d
Document the Validator class to make Serenata happy 2019-06-13 21:46:30 +01:00
Starbeamrainbowlabs 58ae39a731
Bugfix: Correct name of index action class 2019-06-13 20:58:36 +01:00
Starbeamrainbowlabs 233d780123
Add link to production api.php in API docs, and change default action to a helpful message 
Also bump version
 2019-05-16 17:31:35 +01:00
Starbeamrainbowlabs 530876ab5f
[server/fetch-data] Omit send device location information 2019-04-16 17:40:32 +01:00
Starbeamrainbowlabs 8ebb6539bc
[server/list-reading-types] Don't return an error if a device hasn't submitted any data yet 2019-04-16 17:15:11 +01:00
Starbeamrainbowlabs dcdec686a4
Add device_type_id output as type_id 2019-03-14 12:50:43 +00:00
Starbeamrainbowlabs ac4ecd1751
API: Return altitude information 2019-03-14 12:42:17 +00:00
Starbeamrainbowlabs 527738fa00
Add version action. 2019-03-01 17:46:12 +00:00
Starbeamrainbowlabs aa3abc39eb
API/fetch-data: Don't send a cache-control header with datetime=now 2019-02-24 18:07:11 +00:00
Starbeamrainbowlabs 6ec021de36
Only log sql qierues in development mode 2019-02-24 17:18:36 +00:00
Starbeamrainbowlabs 47bc5874cc
API: Add format parameter to fetch-data action. 2019-02-24 17:17:11 +00:00
Starbeamrainbowlabs e29f7f4569
API: Add format parameter to list-devices action 2019-02-24 17:11:36 +00:00
Starbeamrainbowlabs 09ab6f38d5
API: Add format parameter to list-reading-types action 2019-02-24 17:07:09 +00:00
Starbeamrainbowlabs 263658d735
API: Add csv format to device-data action 2019-02-24 16:55:33 +00:00
Starbeamrainbowlabs 0d3f55fc6a
Enhance error device data no data error message. 
Fixes #13.
 2019-02-23 20:28:45 +00:00
Starbeamrainbowlabs 519e85b66a
[server] Bugfix: Updatee device-data action t use DB structure 2019-02-20 17:39:45 +00:00
Starbeamrainbowlabs 3c2605dcb9
Port the data repeository over to the new structure 2019-02-18 20:44:37 +00:00
Starbeamrainbowlabs 828e7ad999
Bugfix: Update a significant portion of the backend to the new database structure 2019-02-18 20:39:35 +00:00
Starbeamrainbowlabs 3a2b2571f6
[API] Add device-id GET parameter to list-reading-types action.. 2019-02-07 19:15:38 +00:00
Starbeamrainbowlabs dc7427c18b
[server] Add changelog action 2019-01-26 21:46:33 +00:00