From 961b362ab35f5900cd3b3ab90a9a4082fbfdcb3c Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Sun, 30 Dec 2018 11:49:29 -0500 Subject: script to update authdb --- script.py | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 script.py (limited to 'script.py') diff --git a/script.py b/script.py new file mode 100644 index 0000000..fd60a3c --- /dev/null +++ b/script.py @@ -0,0 +1,16 @@ +import sqlite3 +import psycopg2 + +conn = sqlite3.connect("/home/http/famille/famille.db", + detect_types=sqlite3.PARSE_DECLTYPES) +conn.row_factory = sqlite3.Row +conn.execute("PRAGMA foreign_keys=ON") +cur = conn.execute("SELECT id, user_name, password from users") + +authdb = psycopg2.connect("postgres://auth_master@localhost/authdb") +sql_str = "INSERT INTO users(id, name, password) VALUES(%s, %s, %s)" +with authdb.cursor() as c: + for id, name, password in cur: + c.execute(sql_str, (id, name, password)) +authdb.commit() +authdb.close() -- cgit v1.2.3-70-g09d2