FlexMeasures / flexmeasures / 7914759358

78%

Build Type

push

github

Committed by web-flow

Commit Message

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)

Run Details

3872 of 6484 branches covered (59.72%)

Branch coverage included in aggregate %.

147 of 230 new or added lines in 50 files covered. (63.91%)

15 existing lines in 12 files now uncovered.

6930 of 9693 relevant lines covered (71.49%)

2.86 hits per line