banzaay
(banzaay)
May 2, 2018, 3:29pm
1
Hi all,
I have configured the persistence for the group of temperatures in all my rooms.
This is the configuration:
Group:Number:AVG gTemperature "Temperatura" <temperature> (Home)
gTemperature : strategy = everyChange
I’m using sqlite for the persistence and in the database I see, for example:
sqlite> select * from item0010;
2018-04-30 11:19:27.545|21.4
2018-04-30 11:29:50.019|21.5
2018-04-30 11:36:05.963|21.6
2018-04-30 11:38:24.623|21.7
2018-04-30 11:55:14.957|21.8
2018-04-30 12:17:09.487|21.9
2018-04-30 12:18:09.174|21.8
2018-04-30 12:18:11.697|21.9
2018-04-30 12:21:07.396|22.0
2018-04-30 12:29:05.625|22.1
2018-04-30 12:47:10.575|22.3
2018-04-30 13:42:50.971|22.4
2018-04-30 13:45:31.296|22.5
2018-04-30 13:48:46.334|22.7
2018-04-30 13:57:21.060|22.5
sqlite>
I expected to have both the temperature and the indication of associated item.
How can I have this ?
Thanks
vzorglub
(Vincent Regaud)
May 2, 2018, 3:36pm
2
One of the tables in your sqlite database will have the link between the item name and the related table name. This persistence service just works like that
banzaay
(banzaay)
May 2, 2018, 3:58pm
3
This is clear when I have a single Item, but in this case I have a group of Items.
If I need to thrack the temparature of all the room I havo to persist the single Items, in this case I’ll have as much tables as nte number of items.
Is this the correct way ?
I can use this sintax:
Temperature1,Temperature2,Temperature3,Temperature4 : strategy = everyChange
Is correct ?
rlkoshak
(Rich Koshak)
May 2, 2018, 4:02pm
4
Actually you are only persisting the Group Item’s state. If you want to persist the state of gTemperature and all the members of gTemperature you need to use:
gTemperature,gTemperature* : strategy = everyChange
gTemperature* means “all members of gTemperature”.