From ae935e1c38c7ffe662fa3381b0a5bd8b91c72b49 Mon Sep 17 00:00:00 2001 From: Teddy Date: Tue, 27 Aug 2013 08:46:44 +0800 Subject: use mysql for higher performance --- server/piztor/import.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'server/piztor/import.py') diff --git a/server/piztor/import.py b/server/piztor/import.py index 84c990f..c91aae9 100644 --- a/server/piztor/import.py +++ b/server/piztor/import.py @@ -2,7 +2,7 @@ from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from model import * -path = "piztor.sqlite" +path = "root:helloworld@localhost/piztor" class UserData: def __init__(self, username, password, gid, sex): @@ -12,12 +12,12 @@ class UserData: self.sex = sex def create_database(): - engine = create_engine('sqlite:///' + path, echo = True) + engine = create_engine('mysql://' + path, echo = True) Base.metadata.drop_all(engine) Base.metadata.create_all(engine) def import_user_data(data): - engine = create_engine('sqlite:///' + path, echo = True) + engine = create_engine('mysql://' + path, echo = True) Session = sessionmaker(bind = engine) session = Session() for user in data: -- cgit v1.2.3