[Git][qa/jenkins.debian.net][master] reproducible debian: initial sqla 2.0 support

[Mattia Rizzolo (@mattia)]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
c0491a10 by Mattia Rizzolo at 2025-08-11T15:34:17+02:00
reproducible debian: initial sqla 2.0 support

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


2 changed files:

- bin/rblib/__init__.py
- bin/rblib/const.py


Changes:

=====================================
bin/rblib/__init__.py
=====================================
@@ -39,6 +39,10 @@ def query_db(query, *args, **kwargs):
         insert:
             None
     """
+    if isinstance(query, str):
+        # across the code there are plenty of calls with plain strings
+        # be lazy (and probably a bit unsafe) and make them into ClauseElement
+        query = text(query)
     try:
         result = conn_db.execute(query, *args, **kwargs)
     except OperationalError as ex:


=====================================
bin/rblib/const.py
=====================================
@@ -84,7 +84,8 @@ PGDATABASE = 'reproducibledb'
 # init the database data and connection
 if not args.skip_database_connection:
     DB_ENGINE = create_engine("postgresql:///%s" % PGDATABASE)
-    DB_METADATA = MetaData(DB_ENGINE)  # Get all table definitions
+    DB_METADATA = MetaData()
+    DB_METADATA.reflect(DB_ENGINE)     # Get all table definitions
     conn_db = DB_ENGINE.connect()      # the local postgres reproducible db
 
 for key, value in conf_distro.items():



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/c0491a106fa6c35330a31145d11b984945eee65c

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/c0491a106fa6c35330a31145d11b984945eee65c
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20250811/1b378b9c/attachment-0001.htm>