diff options
Diffstat (limited to 'sources/db')
| -rw-r--r-- | sources/db/show_selection_stats.sql | 5 | ||||
| -rwxr-xr-x | sources/db/update.sh | 2 |
2 files changed, 7 insertions, 0 deletions
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." |