I have my mysql.persist
// persistence strategies have a name and a definition and are referred to in the “Items” section
Strategies {
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
everyNight : “0 59 23 * * ?”
// if no strategy is specified for an item entry below, the default list will be used
default = everyChange
}
/*
- Each line in this section defines for which item(s) which strategy(ies) should be applied.
- You can list single items, use “" for all items or "groupitem” for all members of a group
- item (excl. the group item itself).
*/
Items {
// persist all items once a day and on every change and restore them from the db at startup - : strategy = everyChange, everyDay, restoreOnStartup
// additionally, persist all temperature and weather values every hour
// Temperature*, Weather* : strategy = everyHour
Temperature : strategy = everyHour
Precip_Total_Inches : strategy = everyNight
Precip_Total_Inches_History : strategy = everyChange
}
Looking at Precip_Total_Inches
mysql> select * from Item6;
+---------------------+-------+
| Time | Value |
+---------------------+-------+
| 2016-03-27 22:10:10 | 0 |
| 2016-03-27 23:59:00 | 0 |
| 2016-03-28 00:00:02 | 0 |
| 2016-03-28 00:10:05 | 0 |
| 2016-03-28 23:59:00 | 0 |
| 2016-03-29 00:00:02 | 0 |
| 2016-03-29 00:10:05 | 0 |
| 2016-03-29 21:38:04 | 0.31 |
| 2016-03-29 21:45:59 | 0.31 |
| 2016-03-29 23:59:00 | 0.31 |
| 2016-03-30 00:00:02 | 0.31 |
| 2016-03-30 00:05:59 | 0 |
| 2016-03-30 19:55:55 | 0 |
| 2016-03-30 23:59:00 | 0 |
| 2016-03-31 00:00:01 | 0 |
+---------------------+-------+
15 rows in set (0.00 sec)
And I see more entries than I expect.
I thought I would get JUST the 23:59:00 entries… why the extra ones?
Tom