Migrate to SQLAlchemy 2.0

This needs very few changes:
 - Use declarative_base from sqlalchemy.orm instead of ext [1]
 - Enable the future flag on both engine and session

[1] https://docs.sqlalchemy.org/en/20/errors.html#error-b8d9

1 files changed, 2 insertions, 2 deletions

diff --git a/quarg/main.py b/quarg/main.py
index 7deb900..a182578 100644
--- a/quarg/main.py
+++ b/quarg/main.py
@@ -126,8 +126,8 @@ def main():
     if not config.has_option('Database', 'url'):
         errx('No database URL set in config file.')
 
-    engine = create_engine(config.get('Database', 'url'), echo=args.debug)
-    session = Session(bind=engine)
+    engine = create_engine(config.get('Database', 'url'), echo=args.debug, future=True)
+    session = Session(bind=engine, future=True)
 
     predicates = list(collect_predicates(args))