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:30]
jlsolano [Last measurement at EUBREWNET]
codes:dbaccess [2024/06/21 10:27] (current)
jlsolano [Common Inputs]
Line 48: Line 48:
 ^ Parameter ^ Description ^ Example ^ ^ Parameter ^ Description ^ Example ^
 ^ brewerid | Brewer identification number | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​format=text|Get function with brewerid input parameter]] | ^ brewerid | Brewer identification number | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​format=text|Get function with brewerid input parameter]] |
-^ date | Date in YYYY-MM-DD format | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​format=text|Get function with date input parameter]] | +^ date | Date in YYYY-MM-DD ​or JJJYY format | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​format=text|Get function with date input parameter]] | 
-^ enddate | Date in YYYY-MM-DD format. If provided, the function will return the query in a date range | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​enddate=2015-01-05&​format=text|Get function with enddate input parameter]] |+^ enddate | Date in YYYY-MM-DD ​or JJJYY format. If provided, the function will return the query in a date range | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2015-01-01&​enddate=2015-01-05&​format=text|Get function with enddate input parameter]] |
 ^ fields | Comma separated list of fields to write in the output. You can use ''​myfields*''​ to select all fields starting with ''​myfields''​ | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1_5?​brewerid=157&​date=2015-01-01&​format=text&​fields=gmt,​o3| O3L1_5 output with just the ''​gmt''​ and ''​o3''​ fields]] | ^ fields | Comma separated list of fields to write in the output. You can use ''​myfields*''​ to select all fields starting with ''​myfields''​ | [[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1_5?​brewerid=157&​date=2015-01-01&​format=text&​fields=gmt,​o3| O3L1_5 output with just the ''​gmt''​ and ''​o3''​ fields]] |
  
Line 935: Line 935:
   * 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 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   * 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 present at a station, 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'', ​     - ''​brewerid'', ​
     - ''​last command''​@''​time when the last command was run'', ​     - ''​last command''​@''​time when the last command was run'', ​
     - dss:''​ozone value''​@''​time of the Direct Sun summary''​     - dss:''​ozone value''​@''​time of the Direct Sun summary''​
- +  * Output example:
-Output example: +
 <​code>​ <​code>​
 157, hk@14:​49:​54,​ dss:​289.1@14:​46:​22 157, hk@14:​49:​54,​ dss:​289.1@14:​46:​22
codes/dbaccess.1707924639.txt.gz · Last modified: 2024/02/14 15:30 by jlsolano