def test_get_table_column_names():
with app.app_context():
column_names = get_table_column_names(
app=app,
table='entries',
)
assert column_names == ['id', 'text', 'available', 'concert_date']
def test_db_creation():
if os.path.isfile(database_):
os.unlink(database_)
assert not os.path.isfile(database_)
with app.app_context():
init_db(app)
assert os.path.isfile(database_)
def test_read_from_app_db_empty_read_all():
with app.app_context():
entries = read_from_app_db(
app=app,
properties=['*'],
table='entries',
)
assert entries == []
def test_insert_into_app_db():
with app.app_context():
insert_into_app_db(app=app,
properties=['user', 'password'],
table='logins',
values=['user_test', 'password_test'])
logins = read_from_app_db(app=app, properties=['*'], table='logins')
assert logins[0]['user'] == 'user_test'
assert logins[0]['password'] == 'password_test'
def test_update_app_db():
with app.app_context():
update_app_db(app=app,
table='logins',
property='user',
value='"user_test2"',
where='user = "******"')
found = entry_in_app_db(app=app,
table='logins',
target={'user': '******'})
assert found
import os
from BigCalendar.utility.db_pre_post_processing import *
from BigCalendar.utility.db_control import *
from BigCalendar.big_calendar import app
app.config['DATABASE'] = 'test.db'
database_ = app.config['DATABASE']
with app.app_context():
if os.path.isfile(database_):
os.unlink(database_)
init_db(app)
insert_into_app_db(app=app,
properties=['mic', 'bass', 'drums', 'guitar', 'keys'],
table='availabilities',
values=[0, 1, 2, 1, 0])
def test_who_is_unavailable():
who = who_is_unavailable()
assert who == 'mic, keys'
def test_entry_in_app_db():
with app.app_context():
found = entry_in_app_db(app=app,
table='logins',
target={'user': '******'})
assert found