From b07f46f1016928ee07e53b66573407c9f49d9552 Mon Sep 17 00:00:00 2001
From: Jochen Topf <jochen@topf.org>
Date: Sun, 1 Jun 2014 14:19:47 +0200
Subject: Output some counts from selection.db into update log.

---
 sources/db/show_selection_stats.sql | 5 +++++
 sources/db/update.sh                | 2 ++
 2 files changed, 7 insertions(+)
 create mode 100644 sources/db/show_selection_stats.sql

(limited to 'sources/db')

diff --git a/sources/db/show_selection_stats.sql b/sources/db/show_selection_stats.sql
new file mode 100644
index 0000000..d6cc0c7
--- /dev/null
+++ b/sources/db/show_selection_stats.sql
@@ -0,0 +1,5 @@
+
+SELECT '  interesting_tags count ......... ', count(*) FROM interesting_tags;
+SELECT '  frequent_tags count ............ ', count(*) FROM frequent_tags;
+SELECT '  interesting_relation_types count ', count(*) FROM interesting_relation_types;
+
diff --git a/sources/db/update.sh b/sources/db/update.sh
index a189c96..f003426 100755
--- a/sources/db/update.sh
+++ b/sources/db/update.sh
@@ -51,6 +51,8 @@ TAGSTATS=`../../bin/taginfo-config.rb sources.db.tagstats ../../tagstats/tagstat
 if [ -f $SELECTION_DB ]; then
     OPEN_SELECTION_DB="--selection-db=$SELECTION_DB"
     echo "Reading selection database '$SELECTION_DB'"
+    echo "Selection database contents:"
+    sqlite3 $SELECTION_DB < show_selection_stats.sql
 else
     OPEN_SELECTION_DB=""
     echo "Selection database '$SELECTION_DB' not found. Not creating some statistics."
-- 
cgit v1.2.3