diff options
| author | ubq323 <ubq323> | 2021-07-11 02:42:34 +0000 |
|---|---|---|
| committer | ubq323 <ubq323> | 2021-07-11 02:42:34 +0000 |
| commit | 94e93dffbc2f23823cfb6949828861063a3f3e23 (patch) | |
| tree | bf6d2dce4753cb60afefe40d7be25775b2bb4ff2 | |
| parent | 3aa8279af5247ce34cfab8842afeb404f3864845 (diff) | |
fix indexing issue with displaying of votes
| -rw-r--r-- | apioforum/thread.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/apioforum/thread.py b/apioforum/thread.py index ec98d89..20b02ca 100644 --- a/apioforum/thread.py +++ b/apioforum/thread.py @@ -39,7 +39,8 @@ def view_thread(thread_id): FROM poll_options LEFT OUTER JOIN vote_counts ON poll_options.poll = vote_counts.poll AND poll_options.option_idx = vote_counts.option_idx - WHERE poll_options.poll = ?; + WHERE poll_options.poll = ? + ORDER BY option_idx asc; """,(poll_row['id'],)).fetchall() poll = {} poll.update(poll_row) @@ -126,7 +127,7 @@ def create_poll(thread_id): cur.execute("UPDATE threads SET poll = ? WHERE threads.id = ?",(pollid,thread_id)) cur.executemany( "INSERT INTO poll_options (poll,option_idx,text) VALUES (?,?,?)", - zip(itertools.repeat(pollid),range(len(polloptions)),polloptions) + zip(itertools.repeat(pollid),range(1,len(polloptions)+1),polloptions) ) db.commit() flash("poll created successfully") |