def init_db(request):
patch_session(Session, request)
register_session_listeners()
with Session() as session:
session.add(
Attendee(placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=VOLUNTEER_RIBBON,
staffing=True))
session.add(
Attendee(placeholder=True,
first_name='Regular',
last_name='Attendee'))
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
session.add(
Attendee(placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=STAFF_BADGE))
session.add(
Attendee(placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=SUPPORTER_BADGE))
session.commit()
def init_db(request):
patch_session(Session, request)
register_session_listeners()
with Session() as session:
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=VOLUNTEER_RIBBON,
staffing=True
))
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Attendee'
))
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=STAFF_BADGE
))
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=SUPPORTER_BADGE
))
session.commit()
def init_db(request):
class db: pass
patch_session(Session, request)
db.turner = create('User', name='Turner')
db.hooch = create('User', name='Hooch')
create('Tag', user_id=db.turner['id'], name='Male')
create('Tag', user_id=db.hooch['id'], name='Male')
db.ninja = create('Tag', user_id=db.turner['id'], name='Ninja')
db.pirate = create('Tag', user_id=db.hooch['id'], name='Pirate')
db.boss = create('Boss', name='Howard Hyde')
db.turner_account = create('Account', username='******', password='******', user_id=db.turner['id'], boss_id=db.boss['id'])
db.hooch_account = create('Account', username='******', password='******', user_id=db.hooch['id'])
return db
def init_db(request):
for module in modules:
setattr(module, 'PRE_CON', True)
setattr(module, 'AT_THE_CON', False)
setattr(module, 'AT_OR_POST_CON', False)
setattr(module, 'CUSTOM_BADGES_REALLY_ORDERED', False)
patch_session(Session, request)
register_session_listeners()
with Session() as session:
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=VOLUNTEER_RIBBON,
staffing=True
))
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Attendee'
))
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=STAFF_BADGE
))
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=NEED_NOT_PAY,
badge_type=SUPPORTER_BADGE
))
session.commit()
def init_db(request):
patch_session(Session, request)
initialize_db()
def init_db(request):
if os.path.exists(TEST_DB_FILE):
os.remove(TEST_DB_FILE)
patch_session(Session, request)
initialize_db(modify_tables=True)
register_session_listeners()
with Session() as session:
session.add(
Attendee(placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=c.VOLUNTEER_RIBBON,
staffing=True))
session.add(
Attendee(placeholder=True,
first_name='Regular',
last_name='Attendee'))
d_arcade_trusted_dept_role = DeptRole(name='Trusted',
description='Trusted in Arcade')
d_arcade = Department(name='Arcade',
description='Arcade',
dept_roles=[d_arcade_trusted_dept_role])
d_console_trusted_dept_role = DeptRole(
name='Trusted', description='Trusted in Console')
d_console = Department(name='Console',
description='Console',
dept_roles=[d_console_trusted_dept_role])
session.add_all([
d_arcade, d_arcade_trusted_dept_role, d_console,
d_console_trusted_dept_role
])
assigned_depts = {
'One': [d_arcade],
'Two': [d_console],
'Three': [d_arcade, d_console],
'Four': [d_arcade, d_console],
'Five': []
}
trusted_depts = {
'One': [],
'Two': [],
'Three': [],
'Four': [d_arcade, d_console],
'Five': []
}
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
dept_memberships = []
for dept in assigned_depts[name]:
is_trusted = dept in trusted_depts[name]
dept_memberships.append(
DeptMembership(
department_id=dept.id,
dept_roles=(dept.dept_roles if is_trusted else [])))
session.add_all(dept_memberships)
session.add(
Attendee(placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.STAFF_BADGE,
dept_memberships=dept_memberships))
session.add(
Attendee(placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.SUPPORTER_BADGE))
session.commit()
session.add(
WatchList(first_names='Banned, Alias, Nickname',
last_name='Attendee',
email='*****@*****.**',
birthdate=date(1980, 7, 10),
action='Action',
reason='Reason'))
session.add(
Job(name='Job One',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
department=d_arcade,
extra15=True))
session.add(
Job(name='Job Two',
start_time=c.EPOCH + timedelta(hours=1),
slots=1,
weight=1,
duration=2,
department=d_arcade))
session.add(
Job(name='Job Three',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
department=d_arcade))
session.add(
Job(name='Job Four',
start_time=c.EPOCH,
slots=2,
weight=1,
duration=2,
department=d_console,
extra15=True))
session.add(
Job(name='Job Five',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
department=d_console))
session.add(
Job(name='Job Six',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
department=d_console,
required_roles=[d_console_trusted_dept_role]))
session.add(
PromoCode(code='ten percent off',
discount=10,
discount_type=PromoCode._PERCENT_DISCOUNT))
session.add(
PromoCode(code='ten dollars off',
discount=10,
discount_type=PromoCode._FIXED_DISCOUNT))
session.add(
PromoCode(code='ten dollar badge',
discount=10,
discount_type=PromoCode._FIXED_PRICE))
session.add(PromoCode(code='free badge', discount=0, uses_allowed=100))
session.commit()
def init_db(request, sensible_defaults):
if os.path.exists(TEST_DB_FILE):
os.remove(TEST_DB_FILE)
patch_session(Session, request)
initialize_db()
register_session_listeners()
with Session() as session:
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=c.VOLUNTEER_RIBBON,
staffing=True
))
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Attendee'
))
d_arcade = str(c.ARCADE)
d_console = str(c.CONSOLE)
d_arcade_and_console = '{},{}'.format(c.ARCADE, c.CONSOLE)
assigned_depts = {
'One': d_arcade,
'Two': d_console,
'Three': d_arcade_and_console,
'Four': d_arcade_and_console,
'Five': ''
}
trusted_depts = {
'One': '',
'Two': '',
'Three': '',
'Four': d_arcade_and_console,
'Five': ''
}
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.STAFF_BADGE,
assigned_depts=assigned_depts[name],
trusted_depts=trusted_depts[name]
))
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.SUPPORTER_BADGE
))
session.commit()
session.add(WatchList(
first_names='Banned, Alias, Nickname',
last_name='Attendee',
email='*****@*****.**',
birthdate=date(1980, 7, 10),
action='Action', reason='Reason'
))
session.add(Job(
name='Job One',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
location=c.ARCADE,
extra15=True
))
session.add(Job(
name='Job Two',
start_time=c.EPOCH + timedelta(hours=1),
slots=1,
weight=1,
duration=2,
location=c.ARCADE
))
session.add(Job(
name='Job Three',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
location=c.ARCADE
))
session.add(Job(
name='Job Four',
start_time=c.EPOCH,
slots=2,
weight=1,
duration=2,
location=c.CONSOLE,
extra15=True
))
session.add(Job(
name='Job Five',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
location=c.CONSOLE
))
session.add(Job(
name='Job Six',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
location=c.CONSOLE,
restricted=True
))
session.commit()
def init_db(request):
patch_session(sa.Session, request)
def db_setup(request):
patch_session(Session, request)
initialize_db()
def init_db(request, sensible_defaults):
if os.path.exists(TEST_DB_FILE):
os.remove(TEST_DB_FILE)
patch_session(Session, request)
initialize_db()
register_session_listeners()
with Session() as session:
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=c.VOLUNTEER_RIBBON,
staffing=True
))
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Attendee'
))
d_arcade = str(c.ARCADE)
d_console = str(c.CONSOLE)
d_arcade_and_console = '{},{}'.format(c.ARCADE, c.CONSOLE)
assigned_depts = {
'One': d_arcade,
'Two': d_console,
'Three': d_arcade_and_console,
'Four': d_arcade_and_console,
'Five': ''
}
trusted_depts = {
'One': '',
'Two': '',
'Three': '',
'Four': d_arcade_and_console,
'Five': ''
}
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.STAFF_BADGE,
assigned_depts=assigned_depts[name],
trusted_depts=trusted_depts[name]
))
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.SUPPORTER_BADGE
))
session.commit()
session.add(WatchList(
first_names='Banned, Alias, Nickname',
last_name='Attendee',
email='*****@*****.**',
birthdate=date(1980, 7, 10),
action='Action', reason='Reason'
))
session.add(Job(
name='Job One',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
location=c.ARCADE,
extra15=True
))
session.add(Job(
name='Job Two',
start_time=c.EPOCH + timedelta(hours=1),
slots=1,
weight=1,
duration=2,
location=c.ARCADE
))
session.add(Job(
name='Job Three',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
location=c.ARCADE
))
session.add(Job(
name='Job Four',
start_time=c.EPOCH,
slots=2,
weight=1,
duration=2,
location=c.CONSOLE,
extra15=True
))
session.add(Job(
name='Job Five',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
location=c.CONSOLE
))
session.add(Job(
name='Job Six',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
location=c.CONSOLE,
restricted=True
))
session.commit()
def init_db(request):
if os.path.exists(TEST_DB_FILE):
os.remove(TEST_DB_FILE)
patch_session(Session, request)
initialize_db(modify_tables=True)
register_session_listeners()
with Session() as session:
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Volunteer',
ribbon=c.VOLUNTEER_RIBBON,
staffing=True
))
session.add(Attendee(
placeholder=True,
first_name='Regular',
last_name='Attendee'
))
d_arcade_trusted_dept_role = DeptRole(name='Trusted', description='Trusted in Arcade')
d_arcade = Department(name='Arcade', description='Arcade', dept_roles=[d_arcade_trusted_dept_role])
d_console_trusted_dept_role = DeptRole(name='Trusted', description='Trusted in Console')
d_console = Department(name='Console', description='Console', dept_roles=[d_console_trusted_dept_role])
session.add_all([d_arcade, d_arcade_trusted_dept_role, d_console, d_console_trusted_dept_role])
assigned_depts = {
'One': [d_arcade],
'Two': [d_console],
'Three': [d_arcade, d_console],
'Four': [d_arcade, d_console],
'Five': []
}
trusted_depts = {
'One': [],
'Two': [],
'Three': [],
'Four': [d_arcade, d_console],
'Five': []
}
for name in ['One', 'Two', 'Three', 'Four', 'Five']:
dept_memberships = []
for dept in assigned_depts[name]:
is_trusted = dept in trusted_depts[name]
dept_memberships.append(DeptMembership(
department_id=dept.id,
dept_roles=(dept.dept_roles if is_trusted else [])
))
session.add_all(dept_memberships)
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.STAFF_BADGE,
dept_memberships=dept_memberships
))
session.add(Attendee(
placeholder=True,
first_name=name,
last_name=name,
paid=c.NEED_NOT_PAY,
badge_type=c.SUPPORTER_BADGE
))
session.commit()
session.add(WatchList(
first_names='Banned, Alias, Nickname',
last_name='Attendee',
email='*****@*****.**',
birthdate=date(1980, 7, 10),
action='Action', reason='Reason'
))
session.add(Job(
name='Job One',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
department=d_arcade,
extra15=True
))
session.add(Job(
name='Job Two',
start_time=c.EPOCH + timedelta(hours=1),
slots=1,
weight=1,
duration=2,
department=d_arcade
))
session.add(Job(
name='Job Three',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
department=d_arcade
))
session.add(Job(
name='Job Four',
start_time=c.EPOCH,
slots=2,
weight=1,
duration=2,
department=d_console,
extra15=True
))
session.add(Job(
name='Job Five',
start_time=c.EPOCH + timedelta(hours=2),
slots=1,
weight=1,
duration=2,
department=d_console
))
session.add(Job(
name='Job Six',
start_time=c.EPOCH,
slots=1,
weight=1,
duration=2,
department=d_console,
required_roles=[d_console_trusted_dept_role]
))
session.add(PromoCode(code='ten percent off', discount=10,
discount_type=PromoCode._PERCENT_DISCOUNT))
session.add(PromoCode(code='ten dollars off', discount=10,
discount_type=PromoCode._FIXED_DISCOUNT))
session.add(PromoCode(code='ten dollar badge', discount=10,
discount_type=PromoCode._FIXED_PRICE))
session.add(PromoCode(code='free badge', discount=0, uses_allowed=100))
session.commit()
def db_setup(request):
patch_session(Session, request)
initialize_db()
