FlexMeasures / flexmeasures / 7915205712

78%

push

github

Chore/modernize type annotations (#972)

* 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 specific columns from User table

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

* fix deleting account query

Signed-off-by: Ahmad Wahid <ahmedwahid16101@... (continued)

3270 of 4921 branches covered (66.45%)

Branch coverage included in aggregate %.

6927 of 9689 relevant lines covered (71.49%)

0.71 hits per line