From 984db9a8283ae83d4898c62431698b1c85462d4d Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Wed, 2 Mar 2016 16:26:33 +0100 Subject: [PATCH] Oops, store based on id not messageid --- loader/tools/edit_raw.py | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/loader/tools/edit_raw.py b/loader/tools/edit_raw.py index b313414..4e3925e 100755 --- a/loader/tools/edit_raw.py +++ b/loader/tools/edit_raw.py @@ -76,11 +76,11 @@ if __name__ == "__main__": while True: a = raw_input('Save this to db?').lower() if a == 'y' or a == 'yes': - curs.execute("INSERT INTO messages_edited SELECT * FROM messages WHERE messageid=%(msgid)s", { - 'msgid': opt.msgid, + curs.execute("INSERT INTO messages_edited SELECT * FROM messages WHERE id=%(id)s", { + 'id': id, }) - curs.execute("UPDATE messages SET rawtxt=%(raw)s WHERE messageid=%(msgid)s", { - 'msgid': opt.msgid, + curs.execute("UPDATE messages SET rawtxt=%(raw)s WHERE id=%(id)s", { + 'id': id, 'raw': bytearray(s2), }) conn.commit() -- 2.39.5