diff options
| author | Jochen Topf <jochen@topf.org> | 2014-06-01 14:19:47 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2014-06-01 14:19:47 +0200 |
| commit | b07f46f1016928ee07e53b66573407c9f49d9552 (patch) | |
| tree | 1e92239ef433b38f16aed4000524407fd6ae8159 /sources/db | |
| parent | cf27449b90bc9207ad00a34167d3d48c200ebdfe (diff) | |
| download | taginfo-b07f46f1016928ee07e53b66573407c9f49d9552.tar taginfo-b07f46f1016928ee07e53b66573407c9f49d9552.tar.gz | |
Output some counts from selection.db into update log.
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." |