From 48ec673198857d221265e2fe9dbedcb92c3ef236 Mon Sep 17 00:00:00 2001
From: Thierry Parmentelat <thierry.parmentelat@inria.fr>
Date: Thu, 24 Apr 2025 14:48:35 +0200
Subject: [PATCH] when retrieving slices attached to a site, exclude the
 expired ones

---
 planetlab5.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/planetlab5.sql b/planetlab5.sql
index 54788364..4c20ce80 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -768,7 +768,7 @@ CREATE OR REPLACE VIEW site_slices AS
 SELECT site_id,
 array_accum(slice_id) AS slice_ids
 FROM slices
-WHERE is_deleted is false
+WHERE is_deleted is false and expires > CURRENT_TIMESTAMP
 GROUP BY site_id;
 
 -- Slice membership
-- 
2.47.0