add new parameter to threads: last_author

1 files changed, 9 insertions, 0 deletions

diff --git a/dbupdate.py b/dbupdate.py
new file mode 100644
index 0000000..717feb1
--- /dev/null
+++ b/dbupdate.py
@@ -0,0 +1,9 @@
+import sqlite3
+
+with sqlite3.connect("data.sqlite") as _con:
+    _con.execute('ALTER TABLE threads ADD COLUMN last_author text DEFAULT ""')
+    _con.commit()
+    for tid in _con.execute("SELECT thread_id FROM threads"):
+        author = _con.execute("SELECT author FROM messages WHERE thread_id = ? ORDER BY post_id", tid).fetchall()[-1]
+        _con.execute("UPDATE threads SET last_author = ? WHERE thread_id = ?", author + tid)
+    _con.commit()