Changes between Version 15 and Version 16 of Ticket #529, comment 8


Ignore:
Timestamp:
Mar 27, 2014, 11:22:47 AM (11 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #529, comment 8

    v15 v16  
    3636|| `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. ||
    3737|| `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)`. ||
     38|| `labenv/src/net/sf/basedb/labenv/util/ReportTableUtil.java` || Class with utility methods for creating statistics for different time intervals. For future use. ||
    3839
    3940Lab environment servlet and JSP files: