1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| #!/usr/bin/env python -B
# -*- coding: utf-8 -*-
from . import create_engine
from . import declarative_base
from . import scoped_session, sessionmaker
from . import LoginManager
import os
import sys
dbPath = os.path.abspath('{}/../../../db/'.format(os.path.realpath(__file__)))
engine = create_engine('sqlite:///{}/database.sqlite3'.format(dbPath), convert_unicode=True, echo=False)
db_session = scoped_session(sessionmaker(autocommit=False,
autoflush=False,
bind=engine))
Base = declarative_base()
Base.query = db_session.query_property()
login_manager = LoginManager()
login_manager.session_protection = 'strong'
login_manager.login_view = 'auth.login'
def init_db():
print 'init_db'
#Base.metadata.drop_all(bind=engine)
from model.user import User
#Base.metadata.drop_all(bind=engine)
Base.metadata.create_all(bind=engine)
# Create the fixtures
user = User(username='Quentin2', password='Toto')
db_session.add(user)
db_session.commit()
for user in db_session.query(User).all():
print "ID : {0} , USER : {1}, PASSWORD : {2}".format(user.id, user.username, user.password) |
Partager