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