diff options
Diffstat (limited to 'sources/projects/post.sql')
-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'); |