diff options
| -rw-r--r-- | sources/db/show_selection_stats.sql | 5 | ||||
| -rwxr-xr-x | sources/db/update.sh | 2 | ||||
| -rwxr-xr-x | sources/master/update.sh | 3 |
3 files changed, 10 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." diff --git a/sources/master/update.sh b/sources/master/update.sh index 8d49af9..85c3ee7 100755 --- a/sources/master/update.sh +++ b/sources/master/update.sh @@ -47,6 +47,9 @@ m4 --prefix-builtins \ -D __MIN_COUNT_RELATIONS_PER_TYPE__=$min_count_relations_per_type \ selection.sql | sqlite3 $SELECTION_DB +echo "Selection database contents:" +sqlite3 $SELECTION_DB < ../db/show_selection_stats.sql + echo "`$DATECMD` Update history database..." if [ ! -e $HISTORY_DB ]; then |