def retrieve_experiment_status(ae_id):
sql_stmt = """SELECT status FROM experiments where accession = '%s' """ % ae_id
result = execute_select(sql_stmt, db)
if result and result[0]:
return result[0]['status']
return None
def retrieve_checker_score(accession):
sql_stmt = """SELECT checker_score FROM experiments where accession = '%s' """ % accession
result = execute_select(sql_stmt, db)
if result and result[0]:
return result[0]['checker_score']
return None
def retrieve_experiment_id_by_accession(accession):
sql = """SELECT id FROM experiments WHERE accession = '%s'""" % accession
res = execute_select(sql, db)
if res and res[0]:
return res[0]['id']
return None
def retrieve_data_files_by_owned_by(submission_id):
sql = '''SELECT fileName, digest from data_files where ownedBy = %s''' % str(
submission_id)
print sql
return execute_select(sql, db)
def retrieve_submission_by_accession(acc):
sql = """select * from submissions where accession = '%s' """ % acc
return execute_select(sql, db)