diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance')
4 files changed, 18 insertions, 1 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql b/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql new file mode 100644 index 0000000..5234f51 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql @@ -0,0 +1,4 @@ +SELECT phase +FROM filelist +GROUP BY phase +ORDER BY phase diff --git a/gentoobrowse-api/service/sql/maintenance/gitListChangesInPhase.sql b/gentoobrowse-api/service/sql/maintenance/gitListChangesInPhase.sql new file mode 100644 index 0000000..17dfdb3 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/gitListChangesInPhase.sql @@ -0,0 +1,5 @@ +SELECT repoId, fileTypeId, pathParts, status +FROM filelist +WHERE phase = ? +AND status IS NOT NULL +ORDER BY POSITION(status IN 'DMA'), updateOrder NULLS LAST diff --git a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql b/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql index df9f947..20ca804 100644 --- a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql +++ b/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql @@ -2,7 +2,6 @@ CREATE TEMPORARY TABLE filelist AS SELECT fl.repoid, fl.status, - fl.filename, ft.filetypeid, ft.updateOrder, ft.phase, diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql b/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql new file mode 100644 index 0000000..68cdbee --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql @@ -0,0 +1,9 @@ +UPDATE filelist SET + status = CASE WHEN status = 'A' THEN 'M' END +WHERE pathparts IN ( + SELECT pathparts + FROM filelist + WHERE filetypeid = 1 + AND status IN ('A', 'D') + GROUP BY pathparts + HAVING COUNT(*) = 2) |