From b720d31d0d76557b92763b23fa659212eb10d4bc Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Mon, 29 Jul 2024 22:14:22 +0200
Subject: [PATCH] Continued: - added view for recently updated instances -
 renamed 'recently' to 'added' for not confusing it

---
 daemon.py                  | 9 ++++++++-
 templates/views/index.html | 5 +++--
 templates/views/list.html  | 7 +++++--
 3 files changed, 16 insertions(+), 5 deletions(-)

diff --git a/daemon.py b/daemon.py
index 9c76df9..d0b146f 100755
--- a/daemon.py
+++ b/daemon.py
@@ -127,11 +127,18 @@ WHERE {mode} = ? \
 ORDER BY domain \
 LIMIT ?", [value, amount]
         )
-    elif mode == "recently":
+    elif mode == "added":
         database.cursor.execute(
             f"SELECT * \
 FROM instances \
 ORDER BY first_seen DESC \
+LIMIT ?", [amount]
+        )
+    elif mode == "updated":
+        database.cursor.execute(
+            f"SELECT * \
+FROM instances \
+ORDER BY last_updated DESC \
 LIMIT ?", [amount]
         )
     else:
diff --git a/templates/views/index.html b/templates/views/index.html
index 0b607dc..3286a4e 100644
--- a/templates/views/index.html
+++ b/templates/views/index.html
@@ -70,9 +70,10 @@
         <li><a href="scoreboard?mode=block_level&amp;amount=20">Block level statistics</a></li>
     </ul>
 
-    <h2>Recently added:</h2>
+    <h2>Recently ...:</h2>
     <ul class="nav">
-        <li><a href="list?mode=recently&amp;value=1&amp;amount=50">50 instances</a></li>
+        <li><a href="list?mode=added&amp;value=1&amp;amount=50">50 added instances</a></li>
+        <li><a href="list?mode=updated&amp;value=1&amp;amount=50">50 updated instances</a></li>
     </ul>
 {% endblock %}
 {% block footer %}
diff --git a/templates/views/list.html b/templates/views/list.html
index 8c55257..5a6b86c 100644
--- a/templates/views/list.html
+++ b/templates/views/list.html
@@ -5,7 +5,8 @@
     {% elif mode == 'original_software' %} Original software {{value}}
     {% elif mode == 'software' %} Used software {{value}}
     {% elif mode == 'command' %} Command {{value}}
-    {% elif mode == 'recently' %} {{amount}} recently added instances
+    {% elif mode == 'added' %} {{amount}} recently added instances
+    {% elif mode == 'updated' %} {{amount}} recently updated instances
     {% endif %}
 {% endblock %}
 
@@ -20,8 +21,10 @@
         <h1>Instances found by command {{value}}</h1>
     {% elif mode == 'origin' %}
         <h1>Instances originated from {{value}}</h1>
-    {% elif mode == 'recently' %}
+    {% elif mode == 'added' %}
         <h1>{{amount}} recently added instances</h1>
+    {% elif mode == 'updated' %}
+        <h1>{{amount}} recently updated instances</h1>
     {% else %}
         <h1 style="color: red">mode={{mode}} not supported</h1>
     {% endif %}
-- 
2.39.5