diff options
Diffstat (limited to 'gentoobrowse-api/service')
| -rw-r--r-- | gentoobrowse-api/service/maintenancePackageTree.cpp | 6 | ||||
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/fileListCreate.sql | 1 |
2 files changed, 5 insertions, 2 deletions
diff --git a/gentoobrowse-api/service/maintenancePackageTree.cpp b/gentoobrowse-api/service/maintenancePackageTree.cpp index 5e3d4f4..f5a06de 100644 --- a/gentoobrowse-api/service/maintenancePackageTree.cpp +++ b/gentoobrowse-api/service/maintenancePackageTree.cpp @@ -175,7 +175,11 @@ namespace Gentoo { tp.beforeDelete = boost::bind(&Maintenance::fileDeleted, this, dbc, &fps, tmp, _1); tp.beforeUpdate = boost::bind(&Maintenance::fileChanged, this, dbc, &fps, tmp, _1); tp.beforeInsert = boost::bind(&Maintenance::fileCreated, this, dbc, &fps, tmp, _1); - DB::StaticSqlWriter obpo("processOrder NULLS LAST"); + DB::StaticSqlWriter obpo("CASE \ + WHEN b.fileTypeId = 1 THEN 1 \ + WHEN b.fileTypeId = 10 THEN 2 \ + WHEN b.fileTypeId = 4 THEN 3 \ + END NULLS LAST"); tp.order = &obpo; dbc->patchTable(&tp); for (const auto & fp : fps) { diff --git a/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql index d8d627c..76d5536 100644 --- a/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql +++ b/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql @@ -3,7 +3,6 @@ SELECT r.repoid, fl.filename, ft.filetypeid, - ft.processOrder, (STRING_TO_ARRAY(fl.filename, '/'))[2:100] pathparts, fl.filesize, fl.filemtime moddate |