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
Last revision Both sides next revision
codes:dbaccess [2024/02/14 15:25]
jlsolano [Last measurement at EUBREWNET]
codes:dbaccess [2024/02/14 15:34]
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. See also [[codes:​dbaccess#​common_inputs|Brewerid in common inputs]]
   * 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.txt · Last modified: 2024/02/14 15:35 by jlsolano