codes:dbaccess
Differences
This shows you the differences between two versions of the page.
| 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 3.0 Unported
