From 721b53d22fbd326eff3067ef99b9f377c8f6b55a Mon Sep 17 00:00:00 2001
From: Chris Fulljames <christianfulljames@gmail.com>
Date: Sun, 1 Feb 2026 14:37:03 -0500
Subject: [PATCH] Show import queue count

---
 src/littlesongplace/dreams_importer.py             | 5 ++++-
 src/littlesongplace/templates/dreams-importer.html | 2 ++
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/src/littlesongplace/dreams_importer.py b/src/littlesongplace/dreams_importer.py
index 66bc87e..923b396 100644
--- a/src/littlesongplace/dreams_importer.py
+++ b/src/littlesongplace/dreams_importer.py
@@ -11,7 +11,10 @@ bp = Blueprint("dreams-importer", __name__, url_prefix="/dreams-importer")
 @bp.get("")
 @bp.get("/")
 def dreams_importer():
-    return render_template("dreams-importer.html")
+    queue_count = db.query(
+            "SELECT COUNT(*) FROM import_queue WHERE status = 0", one=True)
+    queue_count = queue_count["COUNT(*)"]
+    return render_template("dreams-importer.html", queue_count=queue_count)
 
 @bp.get("/next-in-queue")
 @auth.admin_only
diff --git a/src/littlesongplace/templates/dreams-importer.html b/src/littlesongplace/templates/dreams-importer.html
index c6274ff..d1b71f1 100644
--- a/src/littlesongplace/templates/dreams-importer.html
+++ b/src/littlesongplace/templates/dreams-importer.html
@@ -23,6 +23,8 @@ email at
 <a href="mailto:littlesongplace@gmail.com">littlesongplace@gmail.com</a>.
 </p>
 
+<p><b>Status:</b> Songs currently waiting for import: {{ queue_count }}</p>
+
 <h2>tips for imports</h2>
 For best results:
 <ul>
-- 
2.39.5