From 368f71cb16139abf72d1c351b1fe64c5470365cf Mon Sep 17 00:00:00 2001 From: Ansgar Burchardt Date: Sun, 4 Nov 2012 15:52:14 +0100 Subject: [PATCH] dak/dakdb/update75.py: handle "/" in component names. --- dak/dakdb/update75.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/dak/dakdb/update75.py b/dak/dakdb/update75.py index e6684337..d152d649 100644 --- a/dak/dakdb/update75.py +++ b/dak/dakdb/update75.py @@ -54,7 +54,7 @@ def _track_files_per_archive(cnf, c): FROM files f JOIN location l ON f.location = l.id""", (archive_id,)) - c.execute("""UPDATE files f SET filename = substring(f.filename FROM '/(.*)') + c.execute("""UPDATE files f SET filename = substring(f.filename FROM c.name || '/(.*)') FROM location l, component c WHERE f.location = l.id AND l.component = c.id AND f.filename LIKE c.name || '/%'""") -- 2.39.5