def insert_dosage_db(unit, value_id, range_id): connector = DatabaseConnector() if value_id: query = """INSERT INTO dosage (unit,simple_value_id) VALUES (%s,%s) """ params = (unit, value_id) return connector.query_insert(query, params) if range_id: query = """INSERT INTO dosage (unit,range_id) VALUES (%s,%s) """ params = (unit, range_id) return connector.query_insert(query, params) query = """INSERT INTO dosage (unit) VALUES (%s) """ params = (unit, ) return connector.query_insert(query, params)
def insert_drug_composition_non_effective(drug_id, composition_id, value, unit): connector = DatabaseConnector() query = """INSERT INTO drug_composition_non_effective (drug_id,composition_id,unit,value) VALUES (%s,%s,%s,%s) """ if value != "": params = (drug_id, composition_id, unit, float(value)) else: query = """INSERT INTO drug_composition_non_effective (drug_id,composition_id,unit) VALUES (%s,%s,%s) """ params = (drug_id, composition_id, unit) return connector.query_insert(query, params)
def insert_drug_posology_db(drug_id, posology_id): connector = DatabaseConnector() query = """INSERT INTO drug_posology (drug_id,posology_id) VALUES (%s,%s) """ params = (drug_id, posology_id) return connector.query_insert(query, params)
def insert_posology_db(relation_id, dur_id, freq_id, stop_id, dosage_id): connector = DatabaseConnector() query = """INSERT INTO posology (relation_id,duration_id,frequency_id,stop_id,dosage_id) VALUES (%s,%s,%s,%s,%s) """ params = (relation_id, dur_id, freq_id, stop_id, dosage_id) return connector.query_insert(query, params)
def insert_interction_db(interaction_name, name_en, type): connector = DatabaseConnector() query = """INSERT INTO interaction (name, name_en, inter_type) VALUES (%s,%s,%s) """ params = (interaction_name, name_en, type) return connector.query_insert(query, params)
def insert_composition_for_db(composition_for): connector = DatabaseConnector() query = """INSERT INTO composition_for (name) VALUES (%s) """ params = (composition_for, ) return connector.query_insert(query, params)
def insert_side_effect_for_drug(drug_id, synonym_id): connector = DatabaseConnector() query = """INSERT INTO drug_side_effect_synonym (drug_id, synonym_id) values (%s,%s)""" params = (drug_id, synonym_id) return connector.query_insert(query, params)
def insert_side_effect(side_effect, umls_code=None): connector = DatabaseConnector() query = """INSERT INTO side_effect (name,umls_code) VALUES (%s,%s) """ params = (side_effect, umls_code or "") return connector.query_insert(query, params)
def insert_target_being_db(description): connector = DatabaseConnector() query = """INSERT INTO target_being (description) VALUES (%s) """ params = (description, ) return connector.query_insert(query, params)
def insert_drug(drug_name, normalized, name_en): connector = DatabaseConnector() query = """INSERT INTO drug (name,normalized,name_en) VALUES (%s,%s,%s) """ params = (drug_name, normalized, name_en) return connector.query_insert(query, params)
def insert_frequency_db(value, period): connector = DatabaseConnector() query = """INSERT INTO dosage_frequency (value,period) VALUES (%s,%s) """ params = (value, period) return connector.query_insert(query, params)
def insert_therapeutic_db(therapeutic_name, therapeutic_en_name): connector = DatabaseConnector() query = """INSERT INTO therapeutic (name,name_en) VALUES (%s,%s) """ params = (therapeutic_name, therapeutic_en_name) return connector.query_insert(query, params)
def insert_drug_therapeutic_db(drug_id, therapeutic_id): connector = DatabaseConnector() query = """INSERT INTO drug_therapeutic (drug_id,therapeutic_id) VALUES (%s,%s) """ params = (drug_id, therapeutic_id) return connector.query_insert(query, params)
def insert_file_db(file_name, drug_id): connector = DatabaseConnector() query = """INSERT INTO drug_file_name (file_name,drug_id) VALUES (%s,%s) """ params = (file_name, drug_id) return connector.query_insert(query, params)
def insert_drug_interaction_db(drug_id, interaction_id): connector = DatabaseConnector() query = """INSERT INTO drug_interaction (drug_id,interaction_id) VALUES (%s,%s) """ params = (drug_id, interaction_id) return connector.query_insert(query, params)
def insert_drug_comapny_db(drug_id, comp_id): connector = DatabaseConnector() query = """INSERT INTO drug_company (drug_id,company_id) VALUES (%s,%s) """ params = (drug_id, comp_id) return connector.query_insert(query, params)
def insert_company_db(comapny): connector = DatabaseConnector() query = """INSERT INTO company (name) VALUES (%s) """ params = (comapny, ) return connector.query_insert(query, params)
def insert_posology_target_being_db(posology_id, target_id): connector = DatabaseConnector() query = """INSERT INTO posology_target_being (posology_id,target_being_id) VALUES (%s,%s) """ print(posology_id, target_id) params = (posology_id, target_id) return connector.query_insert(query, params)
def insert_side_effect_synonym(side_effect_id, synonym): connector = DatabaseConnector() query = """INSERT INTO side_effect_synonym (side_effect_id, name) values (%s,%s);""" params = (side_effect_id, synonym) return connector.query_insert(query, params)
def insert_posology_case_db(posology_id, case_id): connector = DatabaseConnector() query = """INSERT INTO posology_target_case (posology_id,target_case_id) VALUES (%s,%s) """ params = (posology_id, case_id) return connector.query_insert(query, params)
def insert_composition_db(composition, translation, umls_code): connector = DatabaseConnector() query = """INSERT INTO composition (name,name_en,umls_code) VALUES (%s,%s,%s) """ params = (composition, translation, umls_code) return connector.query_insert(query, params)
def insert_dosage_value_db(value): connector = DatabaseConnector() query = """INSERT INTO dosage_value (value) VALUES (%s) """ params = (value, ) return connector.query_insert(query, params)
def insert_drug_composition_for_db(drug_composition_id, composition_for_id): connector = DatabaseConnector() query = """INSERT INTO drug_composition_for (drug_composition_id,composition_for_id) VALUES (%s,%s) """ params = (drug_composition_id, composition_for_id) return connector.query_insert(query, params)
def insert_dosage_range_db(min, max): connector = DatabaseConnector() query = """INSERT INTO dosage_range (min_value, max_value) VALUES (%s,%s) """ params = (min, max) return connector.query_insert(query, params)