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)