{{extend 'db_layout.html'}} {{('message' in globals())}} {{if 'message' in globals():}} {{ count = db.patient.id.count() query = db( (auth.accessible_query('read', db.patient) | auth.accessible_query('admin', db.patient) ) & (db.patient.id == db.sequence_file.patient_id) ).select( db.patient.ALL, count, groupby=db.patient.id ) }}

{{=message}}

{{for row in query :}} {{pass}}
name birth info files
{{=row.patient.last_name + " " + row.patient.first_name }} {{=row.patient.birth }} {{=row.patient.info }} {{=row[count]}} p e X
add patient
{{elif 'content' in globals():}} {{=content}} {{else:}} {{=BEAUTIFY(response._vars)}} {{pass}}