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


Ignore:
Timestamp:
Mar 20, 2014, 12:14:03 PM (10 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #529, comment 8

    v10 v11  
    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. ||
    3434|| `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)`. ||
     35
     36Lab environment servlet and JSP files:
     37
     38|| '''File''' || '''Description''' ||
     39|| `labenv/src/net/sf/basedb/labenv/servlet/LabEnvironmentServlet.java` || Java servlet class for obtaining information from lab sensors and the lab environment database. Initially three Ajax commands are implemented: `GetLabSensorConfigList`, `LabEnvironmentSensorQuery`, and `LabEnvironmentDatabaseQuery`. ||
     40|| `labenv/resources/reports/labsensorinfo.jsp` || JSP file for obtaining data from selected lab sensor(s). ||
     41|| `labenv/resources/reports/labenvironmentdatabaseexport.jsp` || JSP file for obtaining data from the lab environment database, for selected sensor(s) and time period. The obtained data is made available in table format with tab-separated columns, for preview or export to an external file. ||