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): 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()