[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[dak/master] silence another SQLAlchemy warning about textual SQL expressions



---
 dak/clean_suites.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/dak/clean_suites.py b/dak/clean_suites.py
index 314c6121..20e942f9 100755
--- a/dak/clean_suites.py
+++ b/dak/clean_suites.py
@@ -36,6 +36,7 @@
 
 import errno
 import os
+import sqlalchemy.sql as sql
 import stat
 import sys
 import time
@@ -269,7 +270,7 @@ def clean(now_date, archives, max_delete, session):
         session.commit()
 
     # Delete files from the pool
-    old_files = session.query(ArchiveFile).filter('files_archive_map.last_used <= (SELECT delete_date FROM archive_delete_date ad WHERE ad.archive_id = files_archive_map.archive_id)').join(Archive)
+    old_files = session.query(ArchiveFile).filter(sql.text('files_archive_map.last_used <= (SELECT delete_date FROM archive_delete_date ad WHERE ad.archive_id = files_archive_map.archive_id)')).join(Archive)
     if max_delete is not None:
         old_files = old_files.limit(max_delete)
         Logger.log(["Limiting removals to %d" % max_delete])
-- 
2.11.0


Reply to: