def get_composition_en(drug_id):
connector = DatabaseConnector()
query = """select composition_id from drug_composition_effective where drug_id = %s"""
params = (drug_id, )
comps = []
comp_ids = connector.query(query, params)
for comp in comp_ids:
query = """select name_en from composition where id = %s"""
params = (comp[0], )
comp_en = connector.query(query, params)
comps.append(comp_en[0])
return comps
def get_composition(composition_name):
connector = DatabaseConnector()
query = """select id from composition where name = %s"""
params = (composition_name, )
return connector.query(query, params)
def get_synonym_id(synonym):
connector = DatabaseConnector()
query = """SElECT id from side_effect_synonym where name = %s ;"""
params = (synonym, )
return connector.query(query, params)
def get_side_effect_from_code(code):
connector = DatabaseConnector()
query = """select id from side_effect where umls_code = %s"""
params = (code, )
return connector.query(query, params)
def get_company_db(name):
connector = DatabaseConnector()
query = """select id from company where name = %s"""
params = (name, )
return connector.query(query, params)
def get_dosage_range_db(min, max):
connector = DatabaseConnector()
query = """select id from dosage_range where min_value = %s and max_value = %s"""
params = (min, max)
return connector.query(query, params)
def get_dosage_value_db(value):
connector = DatabaseConnector()
query = """select id from dosage_value where value = %s"""
params = (value, )
return connector.query(query, params)
def get_case_db(description):
connector = DatabaseConnector()
query = """select id from target_case where description = %s"""
params = (description, )
print(query)
return connector.query(query, params)
def get_drug(drug_name):
connector = DatabaseConnector()
query = """select id from side_effect where name = %s"""
params = (drug_name, )
return connector.query(query, params)
def get_target_being_db(description):
connector = DatabaseConnector()
query = """select id from target_being where description = %s"""
params = (description, )
return connector.query(query, params)
def get_therapeutic_arabic_name(name_en):
print("inside???")
connector = DatabaseConnector()
query = """select name from therapeutic where name_en = %s"""
params = (name_en, )
return connector.query(query, params)
def get_therapeutic_from_names(therapeutic_name, name_en):
connector = DatabaseConnector()
query = """select id from therapeutic where name = %s or name_en = %s"""
params = (therapeutic_name, name_en)
return connector.query(query, params)
def get_therapeutic(therapeutic_name):
connector = DatabaseConnector()
query = """select id from therapeutic where name = %s"""
params = (therapeutic_name, )
return connector.query(query, params)
def get_all_files_db():
connector = DatabaseConnector()
query = """select file_name, drug_id from drug_file_name"""
params = ()
return connector.query(query, params)
def get_interaction(interaction_name):
connector = DatabaseConnector()
query = """select id from interaction where name = %s"""
params = (interaction_name, )
return connector.query(query, params)
