FlexMeasures / flexmeasures / 7914759358 / 4

78%

main: 78%

push

github

Support SQLAlchemy 2.0.x (#938)

Update SQLAlchemy dependency from version 1.4 to 2.0, and with it timely-beliefs 2, which gains some speed improvements in querying time series data from the database.


* import declarative object from orm

* use db.session.get instead of query.get

* refactor users to use session.get()

* refactor assets and view_utils to use session.get and session.execute

* refactor generic_assets to use session.get and session.execute

* refactor data-show to use session.get and session.execute

* remove commented in code

* refactor account to use session.get()

* adopt sqlalchemy 2 features in data_add

* refactore cli scripts to support sqlalchemy 2.0

* update v3_0/assets

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update api to use sqlalchemy 2.0

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update models to support sqlalchemy 2.0

* update migration scripts

* update api

* update ui to use sqlalchemy 2.0

* update cli queries to sqlalchemy 2.0 version

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* migrate queries to sqlalchemy 2.0

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update requirements

* use session.execute instead of engine.execute

* first check for a table if exists then data

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* add zone to session before returning it

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update last value datatime query

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update data_gen.py queries

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* update api queries

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* remove commented lines

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* updated remaining queries to sqlalchemy 2.0 format

Signed-off-by: Ahmad Wahid <ahmedwahid16101@gmail.com>

* get speci... (continued)

1497 of 3114 branches covered (0.0%)

Branch coverage included in aggregate %.

6912 of 9675 relevant lines covered (71.44%)

0.71 hits per line