diff options
author | Jochen Topf <jochen@topf.org> | 2014-09-18 12:31:17 +0200 |
---|---|---|
committer | Jochen Topf <jochen@topf.org> | 2014-09-18 12:31:17 +0200 |
commit | 076414f518a298e4f98bc1e69a9008b199e08884 (patch) | |
tree | dbeedf538bd88f39c85da9bdbef305046ab364cc /sources/projects | |
parent | 0ce037322548f6b2d3112c0d8ef89dc946777177 (diff) | |
download | taginfo-076414f518a298e4f98bc1e69a9008b199e08884.tar taginfo-076414f518a298e4f98bc1e69a9008b199e08884.tar.gz |
Prepare for putting project stats in db.keys and db.values.
Diffstat (limited to 'sources/projects')
-rw-r--r-- | sources/projects/post.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sources/projects/post.sql b/sources/projects/post.sql index 5fa2b5a..5a6f73c 100644 --- a/sources/projects/post.sql +++ b/sources/projects/post.sql @@ -11,6 +11,15 @@ INSERT INTO stats (key, value) SELECT 'projects_ok', count(*) FROM projects WHER INSERT INTO stats (key, value) SELECT 'project_keys', count(*) FROM project_tags WHERE value IS NULL; INSERT INTO stats (key, value) SELECT 'project_tags', count(*) FROM project_tags WHERE value IS NOT NULL; +CREATE TABLE project_counts ( + key TEXT NOT NULL, + value TEXT, + num INTEGER +); + +INSERT INTO project_counts (key, value, num) SELECT key, NULL, count(*) FROM (SELECT DISTINCT project_id, key FROM project_tags) GROUP BY key; +INSERT INTO project_counts (key, value, num) SELECT key, value, count(*) FROM (SELECT DISTINCT project_id, key, value FROM project_tags WHERE value IS NOT NULL) GROUP BY key, value; + ANALYZE; UPDATE source SET update_end=datetime('now'); |