Definition of the access functions that are developed in Eubrewnet There is Table with a summary of the available functions and their links as example.

For security purposes user authentication has been added to this tools. Examples of connections in matlab and python are provided for understanding.

• Function: getETC
• Inputs:
  1. brewerid: Id of Brewer
• Outputs: A list of (brewerid, date('YYYY-MM-DD'), etc) that comes from the ICF that are stored in the Eubrewnet Database.

• Function: getDS
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the DS measures with some extra fields as temperature or number of summary for a day.

• Function: getDSinterval
• Inputs:
  1. brewerid: Id of Brewer
  2. date: start date('YYYY-MM-DD') of the range of measures
  3. enddate: end date('YYYY-MM-DD') of the range of measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the DS measures with some extra fields as temperature or number of summary for the whole range of dates.

• Function: getZS
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A dictionary with the ZS measures that for a brewer and a day. The key is the datetime('YYYY-MM-DD HH:MM:SS') and the value is a dictionary formed by pairs of <value name, value>.

• Function: getSL
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A dictionary with the SL measures that for a brewer and a day. The key is the datetime('YYYY-MM-DD HH:MM:SS') and the value is a dictionary formed by pairs of <value name, value>.

• Function: getConfigbyDate
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the available configuration
• Outputs: A dictionary with the available Configuration for a brewer and a day formed by pairs of <constant name, constant value>. The available configuration is the last configuration stored or the information of the header of the bfile for that day.

• Function: getDSS
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the DS summaries for a day.

• Function: getZSS
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the ZS summaries for a day.

• Function: getSLS
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the SL summaries for a day.

• Function: getHG
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the mercury lamp test for a day.

• Function: getFileStatus
• Inputs:
  1. file: Name of the file for status check
  2. brewerid: Id of Brewer
  3. date: date('YYYY-MM-DD') or start date if end date is provided
  4. enddate: end date('YYYY-MM-DD') of the date range
• Outputs: A list where the first element is a list with the fields and the rest are the status of a file with full information if file is provided or a short information with file name, process time and status for all the files between dates.

• Function: getUmkehr
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Outputs: A list where the first element is the list of measure fields and the rest of them are the umkehr measures for a day from the B files.

• Function: getBfileAvailable
• Inputs:
  1. brewerid: Id of Brewer
  2. year: date('YYYY')
• Outputs: A list whit the dates of the received B files in Eubrewnet.

• Function: getHGInterval
• Inputs:
  1. brewerid: Id of Brewer
  2. date: start date('YYYY-MM-DD') of the period of tests
  3. date: end date('YYYY-MM-DD') of the period of tests
• Outputs: A list where first element is a list with the field names of the HG tests and the rest are the different measures between date and enddate.

• Function: getUV
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
  3. scantype: measures will be filtered by a specific scan type
• Outputs: A list where each element is a list. The different lists come in a row and can be grouped by fives. By this way, the information contained in the lists is related bellow:
  1. Header information (scan, brewerid, integration time, dead time, number of cycles, location, latitude, longitude, temperature, pressure, darkcount and minutes for first measure) as related in Brewer Operator Manual
  2. Minutes since 00:00 AM
  3. Wavelengths
  4. Micrometer steps
  5. Raw counts

• Function: getUVAvailableScanTypes
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the measures
• Output: A list with the different types of scans for the given brewer and date.

• Function: getUVR
• Inputs:
  1. brewerid: Id of Brewer
  2. date: date('YYYY-MM-DD') of the available responsivity file
• Output: A list with three lists, where the first list contains the brewerid and the date of the UVR file. The second and third lists contain pairs of wavelength and responsivity.

• Function: getAVG
• Inputs:
  1. avg: Average name (apnavg, apoavg…)
  2. brewerid: Id of Brewer
  3. date: start date('YYYY-MM-DD') of the measures
  4. date: end date('YYYY-MM-DD') of the measures
• Outputs: A list where first element is a list with the field names of the AVG file and the rest are the different measures between date and enddate if both are defined, only from date if enddate is not defined.

The list of available AVGS access functions is:

• Function: getComment
• Inputs:
  1. brewerid: Id of Brewer
  2. date: start date('YYYY-MM-DD') of the measures
  3. date: end date('YYYY-MM-DD') of the measures
• Outputs: A list where first element is a list with the field names of the Parsed Comments file and the rest are the comments of the B files between date and enddate if both are defined, only from date if enddate is not defined.

• Function: getLastComments
• Inputs:
  1. brewerid: Id of Brewer
  2. limit: Limit of the results
• Outputs: A list where first element is a list with the field names of the Parsed Comments file and the rest are the last comments of the B files. They are limited by default to five comments.

• Function: getL1
• Inputs:
  1. brewerid: Id of Brewer
  2. date: start date('YYYY-MM-DD') of the range of measures
  3. enddate: end date('YYYY-MM-DD') of the range of measures
• Outputs: A list where the first element is the list of parameters and the rest of them are the L1 calculated measures (see Eubrewnet Products Generation) for the whole range of dates.

A matlab function is available for users for understanding the Authentication method.

|t get_dss_auth.m

extern> http://rbcce.aemet.es/svn/matlab/get_dss_auth.m

A python script is available for users for understanding the Authentication method.

|t connect_example.py

extern> http://rbcce.aemet.es/svn/python/connect_example.py