diff options
Diffstat (limited to 'gentoobrowse-api/service/sql')
3 files changed, 18 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMD5CacheFiles.sql b/gentoobrowse-api/service/sql/maintenance/updatesMD5CacheFiles.sql new file mode 100644 index 0000000..1fcbb7e --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/updatesMD5CacheFiles.sql @@ -0,0 +1,6 @@ +UPDATE gentoobrowse.files SET + pathparts[3] = ?, + pathparts[4] = REGEXP_REPLACE(pathparts[4], CONCAT('^', REPLACE(?, '+', '\+'), '(-[0-9])'), CONCAT(?::text, '\1')) +WHERE pathparts[3] = ? +AND pathparts[4] ~ CONCAT('^', replace(?, '+', '\+'), '-[0-9]') +AND filetypeId = 1 diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql b/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql new file mode 100644 index 0000000..1dfe419 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/updatesMovePackages.sql @@ -0,0 +1,8 @@ +UPDATE gentoobrowse.packages p SET + name = ?, + categoryid = cn.categoryid +FROM gentoobrowse.categories co, gentoobrowse.categories cn +WHERE p.name = ? +AND p.categoryid = co.categoryid +AND co.name = ? +AND cn.name = ? diff --git a/gentoobrowse-api/service/sql/maintenance/updatesPackageDirFiles.sql b/gentoobrowse-api/service/sql/maintenance/updatesPackageDirFiles.sql new file mode 100644 index 0000000..307484a --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/updatesPackageDirFiles.sql @@ -0,0 +1,4 @@ +UPDATE gentoobrowse.files SET + pathparts[1:2] = ARRAY[?, ?] +WHERE pathparts[1:2] = ARRAY[?, ?] +AND filetypeId IN (4, 8) |