def update_sample_record(data):
"""
Update a vardb record
Data should be an object of class SampleView
"""
session = controller.connect_to_database()
record = session.query(Sample).filter_by(id=data["id"]).one()
record = Sample()
record.sample = data["sample"]
record.panel = data["panel"]
record.sample_taken = data["sample_taken"]
record.genotyping = data["genotyping"]
record.variant_calling = data["variant_calling"]
record.qc_status = data["qc_status"]
record.qc_report = data["qc_report"]
record.coverage = data["coverage"]
session.commit()
session.close()
def add_sample_record(data, export=False):
"""
Data should be an object of class SamplView
"""
sample = Sample()
sample.sample = data["sample"]
sample.panel = data["panel"]
sample.sample_taken = data["sample_taken"]
sample.genotyping = data["genotyping"]
sample.variant_calling = data["variant_calling"]
sample.qc_status = data["qc_status"]
sample.qc_report = data["qc_report"]
sample.coverage = data["coverage"]
if export:
session = controller.connect_to_export_file()
else:
session = controller.connect_to_database()
session.add(sample)
session.commit()
session.close()
