def initializeDB():
#project_root = '/projects/oev/quizApp_Project/'
project_root = os.path.dirname(os.path.realpath('quizApp_Project/'))
DATABASE = os.path.join(project_root, 'quizDB.db')
engine = create_engine('sqlite:///{0}?check_same_thread=False'.format(DATABASE), echo=True)
conn = engine.connect()
metadata.create_all(engine)
return engine, conn
import os
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy import Column, Date, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql import text, func, select, and_, or_, not_, desc, bindparam
from db_tables import metadata, Questions, Answers, Results, Students, StudentsTest, Graphs
# project_root = os.path.dirname(os.path.realpath('quizApp_Project/'))
# DATABASE = os.path.join(project_root, 'quizDB.db')
engine = create_engine('sqlite:///quizDB.db?check_same_thread=False', echo=True)
conn = engine.connect()
metadata.create_all(engine)
ids = [x[0] for x in conn.execute(select([Students.c.student_id])).fetchall()]
print (ids)
for sid in ids:
r = conn.execute(Students.update().\
where(Students.c.student_id == sid).\
values(progress='post_test'))
def initializeDB(user,pwd,server,dbname):
engine = create_engine('mysql://%s:%s@%s/%s?charset=utf8' % (user,pwd,server,dbname),
pool_recycle=3600)
conn = engine.connect()
metadata.create_all(engine)
return conn
