Hi Girls and Guys,
I've written a small DataLogger plugin for the DCERouter. It is way not finished and only stores the value of co2 level change events for now:
mysql> select PK_Datapoints,EK_Device,Description,timestamp,Datapoint,Unit from Datapoints,Unit where FK_Unit=PK_Unit order by timestamp desc limit 5;
+---------------+-----------+-------------+---------------------+-----------+------+
| PK_Datapoints | EK_Device | Description | timestamp | Datapoint | Unit |
+---------------+-----------+-------------+---------------------+-----------+------+
| 106 | 101 | CO2 level | 2009-02-09 01:07:42 | 410 | ppm |
| 105 | 101 | CO2 level | 2009-02-09 01:06:42 | 416 | ppm |
| 104 | 101 | CO2 level | 2009-02-09 01:05:42 | 417 | ppm |
| 103 | 101 | CO2 level | 2009-02-09 01:04:42 | 419 | ppm |
| 102 | 101 | CO2 level | 2009-02-09 01:03:42 | 411 | ppm |
+---------------+-----------+-------------+---------------------+-----------+------+
5 rows in set (0.00 sec)
DT is on schema, the code is in the 0810 branch, src/DataLogger_Plugin and src/lmce_datalog.
best regards,
Hari