2019-05-26 09:28:03.534 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: item is Powermessurement_EG_Kuelschrank
2019-05-26 09:28:03.534 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getHistItemFilterQuery filter=‘true’ numberDecimalcount=‘3’ table=‘item0041’ item=‘Powermessurement_EG_Kuelschrank (Type=NumberItem, State=0.0)’ itemName=‘Powermessurement_EG_Kuelschrank’
2019-05-26 09:28:03.534 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::getHistItemFilterQueryProvider filter = org.openhab.core.persistence.FilterCriteria@196069d5, numberDecimalcount = 3, table = item0041, simpleName = Powermessurement_EG_Kuelschrank
2019-05-26 09:28:03.535 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::query queryString = SELECT time, value FROM item0041 WHERE TIME>‘2019-05-26 08:28:03’ ORDER BY time ASC
2019-05-26 09:28:03.535 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doGetHistItemFilterQuery sql=SELECT time, value FROM item0041 WHERE TIME>‘2019-05-26 08:28:03’ ORDER BY time ASC
2019-05-26 09:28:03.536 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘0.0’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.536 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘0.0’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.536 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘14.399999618530273’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.537 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘0.0’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.593 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘139.8000030517578’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.593 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘139.8000030517578’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.593 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘139.8000030517578’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.593 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘125.80000305175781’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.594 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘125.80000305175781’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.594 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘125.80000305175781’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.595 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = ‘0.0’, getClass = ‘class java.lang.Double’, clazz = ‘Double’
2019-05-26 09:28:03.595 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: query for Powermessurement_EG_Kuelschrank returned 11 rows in 61 ms
2019-05-26 09:28:03.596 [INFO ] [.smarthome.model.script.Betrieb.rule] - Verbrauch Kühlschrank Durchschnitt: -73.19130978547278
mysql> select avg(value) from item0041 where time >= ‘2019-05-26 08:30:00’ and time <= ‘2019-05-26 09:25:00’;
±------------------+
| avg(value) |
±------------------+
| 73.74545617537065 |
±------------------+
1 row in set (0.07 sec)
| 2019-05-26 08:30:05 | 0 |
| 2019-05-26 08:40:04 | 0 |
| 2019-05-26 08:45:34 | 14.399999618530273 |
| 2019-05-26 08:46:03 | 0 |
| 2019-05-26 08:49:08 | 139.8000030517578 |
| 2019-05-26 08:50:05 | 139.8000030517578 |
| 2019-05-26 09:00:05 | 139.8000030517578 |
| 2019-05-26 09:02:59 | 125.80000305175781 |
| 2019-05-26 09:10:04 | 125.80000305175781 |
| 2019-05-26 09:20:05 | 125.80000305175781 |
| 2019-05-26 09:23:29 | 0 |