User Tools

Site Tools


codes:dbaccess

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
codes:dbaccess [2024/02/14 15:25]
jlsolano [Last measurement at EUBREWNET]
codes:dbaccess [2024/02/14 15:35] (current)
jlsolano [Last measurement at EUBREWNET]
Line 934: Line 934:
   * Function: ''​last_measurement''​   * Function: ''​last_measurement''​
   * Example: http://​rbcce.aemet.es/​eubrewnet/​stats/​last_measurement?​gaw_id=izo   * Example: http://​rbcce.aemet.es/​eubrewnet/​stats/​last_measurement?​gaw_id=izo
-  * Description:​ by returning the type and time of the last command run at the Brewer, and the value of the last Direct Sun summary, this function provides a quick way to check the status of a Brewer connected to EUBREWNET'​s database +  * Description:​ by returning the type and time of the most recent ​command run at the Brewer ​on the present day, and the value of the most recent ​Direct Sun summary, this function provides a quick way to check the status of a Brewer connected to EUBREWNET'​s database 
-  * Input: ''​brewerid''​ or ''​gaw_id'',​ to return the data of a specific Brewer or of all the Brewers at a stations, respectively. See also [[codes:​dbaccess#​common_inputs|Brewerid in common inputs]]+  * Input: ''​brewerid''​ or ''​gaw_id'',​ to return the data of a specific Brewer or of all the Brewers ​present ​at a station, respectively
   * Output: one line for each Brewer, with three fields separated by commas:   * Output: one line for each Brewer, with three fields separated by commas:
 +    - ''​brewerid'', ​
 +    - ''​last command''​@''​time when the last command was run'', ​
 +    - dss:''​ozone value''​@''​time of the Direct Sun summary''​
 +  * Output example:
 <​code>​ <​code>​
-breweridlast command@time when the last command was run, dss:ozone value@time of the Direct Sun summary ​ +157hk@14:49:54, dss:289.1@14:46:22 
-</​code> ​  +183, co@14:​40:​40,​ dss:​286.8@12:​06:​03 
- +185, co@14:​24:​57,​ dss:​283.9@10:​45:​09 
- +257, hk@14:​50:​02,​ dss:​289.1@14:​48:​14 
 +258, hk@14:​48:​17,​ dss:​283.3@14:​42:​50 
 +</​code>​
codes/dbaccess.1707924304.txt.gz · Last modified: 2024/02/14 15:25 by jlsolano