search

robmarkcole / HASS-data-detective

Explore and analyse your Home Assistant data
https://data.home-assistant.io/
MIT License
184 stars 36 forks source link

Updates to sqlalchemy and queries #154

Closed robmarkcole closed 1 year ago

robmarkcole commented 1 year ago

Closes:

timoei commented 1 year ago

Hello @robmarkcole ,

the combination of the schema update and the sqlalchemy upgrade leads to the problem that neither version 2.6 and 3.0 aren't working for me. Running version 3.0 misses table _statesmeta and version 2.6 doesn't work with SQLAlchemy > 2.0 (which was upgraded by home assistant itself).

Could you maybe fix version 2.6 also to make it work with SQLAlchemy 2.0? Otherwise it would be nice to have 3.0 also working with older instances of hassio? Actually my Home Assistance instance is up to date, but maybe the database schema wasn't upgraded along with the hassio updates?

robmarkcole commented 1 year ago

@timoei to use 2.6 you should isolate your python environment (you should always to this actually)

3.0 will work with the HA release tomorrow, so you can wait for that

timoei commented 1 year ago

hey @robmarkcole thanks for your fast reply and the greate work you guys do! So I will wait for the HA update! :-)