def stockcrossgenotype():
"""join various tables in the database
"""
return joined_table_template(
['subjects.fly_genotype', 'subjects.fly_stock', 'subjects.fly_cross'],
'Stock + Cross + Genotype Table',
'#',
)
def subjectgenotype():
"""join various tables in the database
"""
delete_url = url_for('delete',
schema='subjects',
table='FlySubject',
subtable=None)
return joined_table_template(
['subjects.fly_genotype', 'subjects.fly_subject'],
'Subject + Genotype Table',
'entersubject',
edit_url=url_for('entersubject'),
delete_url=delete_url)
def crossgenotype():
"""join various tables in the database
"""
delete_url = url_for('delete',
schema='subjects',
table='FlyCross',
subtable=None)
return joined_table_template(
['subjects.fly_genotype', 'subjects.fly_cross'],
'Cross + Genotype Table',
'cross',
edit_url=url_for('cross'),
load_url=url_for('crossload'),
delete_url=delete_url)
def registeredusers():
"""registeredusers
"""
delete_url = url_for('delete',
schema=config['user_schema'],
table=config['user_table'],
subtable=None)
return joined_table_template([config.user_table],
'Registered Users',
edit_url=url_for('table',
schema=config['user_schema'],
table=config['user_table'],
subtable=None),
delete_url=delete_url)
def emergencycontacts():
"""emergencycontacts
"""
if not hasattr(config.user_table, 'EmergencyContact'):
return redirect(url_for('registeredusers'))
delete_url = url_for('delete',
schema=config['user_schema'],
table=config['user_table'],
subtable=None)
return joined_table_template([config.user_table.EmergencyContact],
'Emergency Contacts',
edit_url=url_for('table',
schema=config['user_schema'],
table=config['user_table'],
subtable=None),
delete_url=delete_url)