diff options
| author | Jochen Topf <jochen@topf.org> | 2010-11-04 20:31:01 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2010-11-04 20:31:01 +0100 |
| commit | 0bf8b3ea8c9524a4a8666e5dcb5276c9729d45f6 (patch) | |
| tree | fe7514fc74432857e905ddcc2b6de9290ad6ea3e /sources/db/post.sql | |
| parent | 94748c28692398b953a385a3316162a3b141f5d8 (diff) | |
| download | taginfo-0bf8b3ea8c9524a4a8666e5dcb5276c9729d45f6.tar taginfo-0bf8b3ea8c9524a4a8666e5dcb5276c9729d45f6.tar.gz | |
New report: characters in keys
Diffstat (limited to 'sources/db/post.sql')
| -rw-r--r-- | sources/db/post.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index 2316657..8f0b2fb 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -38,6 +38,13 @@ INSERT INTO stats (key, value) SELECT 'num_keypairs_on_nodes', count(*) FROM INSERT INTO stats (key, value) SELECT 'num_keypairs_on_ways', count(*) FROM keypairs WHERE count_ways > 0; INSERT INTO stats (key, value) SELECT 'num_keypairs_on_relations', count(*) FROM keypairs WHERE count_relations > 0; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_plain', count(*) FROM keys WHERE characters='plain'; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_colon', count(*) FROM keys WHERE characters='colon'; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_letters', count(*) FROM keys WHERE characters='letters'; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_space', count(*) FROM keys WHERE characters='space'; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_problem', count(*) FROM keys WHERE characters='problem'; +INSERT INTO stats (key, value) SELECT 'characters_in_keys_rest', count(*) FROM keys WHERE characters='rest'; + UPDATE keys SET prevalent_values=( SELECT group_concat(value, '|') FROM ( SELECT value FROM tags t |