aboutsummaryrefslogtreecommitdiff
path: root/src/hydrilla/proxy/tables.sql
diff options
context:
space:
mode:
authorWojtek Kosior <koszko@koszko.org>2022-08-25 12:43:29 +0200
committerWojtek Kosior <koszko@koszko.org>2022-09-28 12:54:53 +0200
commit503e546b2b0c9dba505a4e7940f257d41ad95f67 (patch)
treec17f245f8a826d4d385923557681ad372fb58b03 /src/hydrilla/proxy/tables.sql
parent4dbbb2aec204a5cccc713e2e2098d6e0a47f8cf6 (diff)
downloadhaketilo-hydrilla-503e546b2b0c9dba505a4e7940f257d41ad95f67.tar.gz
haketilo-hydrilla-503e546b2b0c9dba505a4e7940f257d41ad95f67.zip
[proxy] properly flag failed package installations in sqlite db
Diffstat (limited to 'src/hydrilla/proxy/tables.sql')
-rw-r--r--src/hydrilla/proxy/tables.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/hydrilla/proxy/tables.sql b/src/hydrilla/proxy/tables.sql
index 54fe3ee..2483c96 100644
--- a/src/hydrilla/proxy/tables.sql
+++ b/src/hydrilla/proxy/tables.sql
@@ -245,8 +245,8 @@ SELECT
iv.repo_iteration_id,
iv.definition,
iv.active,
- r.name AS repo,
- ri.iteration AS repo_iteration,
+ r.repo_id, r.name AS repo,
+ ri.repo_iteration_id, ri.iteration AS repo_iteration,
COALESCE(r.active_iteration_id, -1) != ri.repo_iteration_id AND r.repo_id != 1
AS is_orphan,
r.repo_id = 1 AS is_local