aboutsummaryrefslogtreecommitdiffstats
path: root/import.py
diff options
context:
space:
mode:
Diffstat (limited to 'import.py')
-rw-r--r--import.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/import.py b/import.py
index 976dce4..3138e73 100644
--- a/import.py
+++ b/import.py
@@ -1,8 +1,9 @@
import sqlite3
import sys
+from datetime import datetime
def convert_date(date):
- return "T".join(date.split(" "))
+ return datetime.strptime(date, "%Y-%m-%d %H:%M:%S")
def import_users(old_conn, new_conn):
for row in old_conn.execute("select * from users"):
@@ -39,7 +40,7 @@ if __name__ == "__main__":
new = sys.argv[2]
old_conn = sqlite3.connect(old)
old_conn.row_factory = sqlite3.Row
- new_conn = sqlite3.connect(new)
+ new_conn = sqlite3.connect(new, detect_types=sqlite3.PARSE_DECLTYPES)
new_conn.row_factory = sqlite3.Row
import_users(old_conn, new_conn)
import_news(old_conn, new_conn)