diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance')
7 files changed, 0 insertions, 39 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql b/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql deleted file mode 100644 index 5234f51..0000000 --- a/gentoobrowse-api/service/sql/maintenance/filelistPhases.sql +++ /dev/null @@ -1,4 +0,0 @@ -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 deleted file mode 100644 index 17dfdb3..0000000 --- a/gentoobrowse-api/service/sql/maintenance/gitListChangesInPhase.sql +++ /dev/null @@ -1,5 +0,0 @@ -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 deleted file mode 100644 index 20ca804..0000000 --- a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TEMPORARY TABLE filelist AS -SELECT - fl.repoid, - fl.status, - ft.filetypeid, - ft.updateOrder, - ft.phase, - (STRING_TO_ARRAY(fl.filename, '/')) pathparts -FROM filelistraw fl, gentoobrowse.filetypes ft -WHERE (STRING_TO_ARRAY(fl.filename, '/')) ~ ft.spec diff --git a/gentoobrowse-api/service/sql/maintenance/gitListCreateIdx.sql b/gentoobrowse-api/service/sql/maintenance/gitListCreateIdx.sql deleted file mode 100644 index 1b3a6ca..0000000 --- a/gentoobrowse-api/service/sql/maintenance/gitListCreateIdx.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX idx_filelist_mode ON filelist(phase, status) diff --git a/gentoobrowse-api/service/sql/maintenance/gitListCreateRaw.sql b/gentoobrowse-api/service/sql/maintenance/gitListCreateRaw.sql deleted file mode 100644 index 3007cd8..0000000 --- a/gentoobrowse-api/service/sql/maintenance/gitListCreateRaw.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE TEMPORARY TABLE filelistraw ( - repoid INT NOT NULL, - filename TEXT NOT NULL, - status CHARACTER(1) NOT NULL) diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql b/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql deleted file mode 100644 index 68cdbee..0000000 --- a/gentoobrowse-api/service/sql/maintenance/updatesMergeFilelistEntries.sql +++ /dev/null @@ -1,9 +0,0 @@ -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) diff --git a/gentoobrowse-api/service/sql/maintenance/updatesMoveFilelist.sql b/gentoobrowse-api/service/sql/maintenance/updatesMoveFilelist.sql deleted file mode 100644 index 0a34c82..0000000 --- a/gentoobrowse-api/service/sql/maintenance/updatesMoveFilelist.sql +++ /dev/null @@ -1,6 +0,0 @@ -UPDATE filelist 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 |