Changes between Version 9 and Version 10 of Ticket #529, comment 8


Ignore:
Timestamp:
Mar 20, 2014, 11:49:30 AM (10 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #529, comment 8

    v9 v10  
    3232|| '''File''' || '''Description''' ||
    3333|| `labenv/src/net/sf/basedb/labenv/util/LabSensorUtil.java` || Class with public methods for obtaining values from a lab sensor: `String fetchLabSensorName(String sensorUrl)`, `LabEnvironmentData createLabEnvironmentData(String sensorUrl)`, and `LabEnvironmentData createLabEnvironmentData(String sensorUrl, String sensorName)`. Private method `String fetchDataFromUrl(String url)` is used to obtain the raw sensor output from a sensor at a specified URL. ||
    34 || `labenv/src/net/sf/basedb/labenv/util/LabEnvironmentStorageUtil.java` || Class for storing and retrieving data in/from the lab environment database. ||
     34|| `labenv/src/net/sf/basedb/labenv/util/LabEnvironmentStorageUtil.java` || Class for storing and retrieving data in/from the lab environment database. The lab environment database table is created if not existing. The table contains columns for: `id INTEGER PRIMARY KEY`, `sensorNumber numeric`, `unixTime numeric`, `temperature numeric`, and `humidity numeric`. Note that sensor measurements are stored by sensor number, not sensor URL or name. The class has public methods `ResultSet executeQuery(String instruction)`, `void executeUpdate(String instruction)`, `void updateLabEnvDb(int sensorNumber, LabEnvironmentData envData)`, `void updateLabEnvDb(int sensorNumber, long unixTime, LabEnvironmentData envData)`, `void updateLabEnvDb(int sensorNumber, long unixTime, double temperature, double humidity)`, and `List<LabEnvironmentData> queryLabEnvDb(Integer sensorNumber, Date startTime, Date endTime)`. ||