diff options
| author | ubq323 <ubq323> | 2021-06-26 01:23:58 +0000 |
|---|---|---|
| committer | ubq323 <ubq323> | 2021-06-26 01:23:58 +0000 |
| commit | cd8b3aa2c5abd414068c8f9f5edbebab807153eb (patch) | |
| tree | 94030d3e8d85981f9495cebca962bfe9398e2acd /apioforum/db.py | |
| parent | a1660cad33f03828e2c74d8f083ad6490ea0da7f (diff) | |
display vote counts (badly)
Diffstat (limited to 'apioforum/db.py')
| -rw-r--r-- | apioforum/db.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/apioforum/db.py b/apioforum/db.py index 1faa167..67989df 100644 --- a/apioforum/db.py +++ b/apioforum/db.py @@ -109,7 +109,10 @@ CREATE TABLE votes ( ); ALTER TABLE posts ADD COLUMN vote INTEGER REFERENCES votes(id); """, - +""" +CREATE VIEW vote_counts AS + SELECT poll, option_idx, count(*) AS num FROM votes WHERE current GROUP BY option_idx,poll; +""", ] |