def setUp(self):
app.config['TESTING'] = True
app.config['WTF_CSRF_ENABLED'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + \
os.path.join(basedir, TEST_DB)
self.app = app.test_client()
db.create_all()
def setUp(self):
app.config['TESTING'] = True
app.config['WTF_CSRF_ENABLED'] = False
app.config['DEBUG'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + \
os.path.join(basedir, TEST_DB)
self.app = app.test_client()
db.create_all()
self.assertEquals(app.debug, False)
c.executemany("""INSERT INTO appointments (name, due_date, priority,
creation_date, user_id) VALUES (?, ?, ?, ?, ?)""", data)
# delete old_tasks table
c.execute("DROP TABLE old_appointments")'''
with sqlite3.connect(DATABASE_PATH) as connection:
# get a cursor object used to execute SQL commands
c = connection.cursor()
# temporarily change the name of users table
c.execute("""ALTER TABLE users RENAME TO old_users""")
# recreate a new users table with updated schema
db.create_all()
# retrieve data from old_users table
c.execute("""SELECT name, email, password
FROM old_users ORDER BY id ASC""")
# save all rows as a list of tuples; set role to 'user'
data = [(row[0], row[1], row[2],
'user') for row in c.fetchall()]
# insert data to users table
c.executemany("""INSERT INTO users (name, email, password,
role) VALUES (?, ?, ?, ?)""", data)
# delete old_users table
c.execute("DROP TABLE old_users")
# c.execute("""SELECT name,due_date,priority, status FROM old_tasks ORDER BY task_id ASC""")
#
# # save all rows as a list of tuples; set posted_date to now and user_id to 1
# data = [(row[0], row[1], row[2], row[3], datetime.now(), 1) for row in c.fetchall()]
#
# # insert data to tasks table
# c.executemany("""INSERT INTO tasks(name,due_date,priority,status,posted_date,user_id) VALUES (?,?,?,?,?,?)""", data)
#
# # delete old_tasks table
# c.execute("""DROP TABLE old_tasks""")
with sqlite3.connect(DATABASE_PATH) as connection:
c = connection.cursor()
# temporarily change the name of the users_table
c.execute("""ALTER TABLE users RENAME TO old_users""")
# recreate a new users table with updated schema
db.create_all()
# retrieve data from old_users_table
c.execute("""SELECT name,email,password FROM old_users ORDER BY id ASC""")
# save all rows as a list of tuples; set role to user
data = [(row[0], row[1], row[2],'user') for row in c.fetchall()]
# insert data to users table
c.executemany("""INSERT INTO users(name,email,password,role) VALUES (?,?,?,?)""", data)
# delete old_users table
c.execute("""DROP TABLE old_users""")