def create_booking_events(start_time=None, end_time=None, reference=None, doctor_id=None, submission_id=None): cur.execute(query, [start_time, end_time, reference, doctor_id, submission_id]) CONNECTION.commit()
def update_submissions(description=None, age=None, gender=None, client_email=None): cur.execute(query, [ description, age, gender, client_email ]) CONNECTION.commit()
def create_doctors(name=None, license_code=None, license_expiry_date=None, qualification=None, qualification_level=None): cur.execute(query, [ name, license_code, license_expiry_date, qualification, qualification_level ]) CONNECTION.commit()
def create_redirects(ip_addr=None, url_reference=None, dest_url=None, referrer=None, referrer_type=None, referrer_id=None, access_time=None, set_cookie=None, browser_used=None, browser_used_version=None, os=None, os_version=None, langs_used=None): cur.execute(query, [ ip_addr, url_reference, dest_url, referrer, referrer_type, referrer_id, access_time, set_cookie, browser_used, browser_used_version, os, os_version, langs_used ]) CONNECTION.commit()
def create_logs(ip_addr=None, action=None, target_value=None, html_dom_elem=None, html_attr=None, curr_url=None, dest_url=None, referrer=None, referrer_type=None, referrer_id=None, access_time=None, set_cookie=None, browser_used=None, browser_used_version=None, os=None, os_version=None, langs_used=None): cur.execute(query, [ ip_addr, action, target_value, html_dom_elem, html_attr, curr_url, dest_url, referrer, referrer_type, referrer_id, access_time, set_cookie, browser_used, browser_used_version, os, os_version, langs_used ]) CONNECTION.commit()
def update_doctor_id(doctor_id, booking_event_id): cur.execute(query, [doctor_id, booking_event_id]) CONNECTION.commit()
def update_browser_used_version(browser_used_version, log_id): cur.execute(query, [browser_used_version, log_id]) CONNECTION.commit()
def update_dest_url(dest_url, redirect_id): cur.execute(query, [dest_url, redirect_id]) CONNECTION.commit()
def delete_logs(log_id): cur.execute(query, [log_id]) CONNECTION.commit() # cur.close()
def delete_tags(tag_id): cur.execute(query, [tag_id]) CONNECTION.commit() # cur.close()
def update_tag_id(tag_id, symptom_tag_relation_id): cur.execute(query, [tag_id, symptom_tag_relation_id]) CONNECTION.commit()
def update_languages_used(languages_used, log_id): cur.execute(query, [languages_used, log_id]) CONNECTION.commit()
def delete_symptom_tag_relations(symptom_tag_relation_id): cur.execute(query, [symptom_tag_relation_id]) CONNECTION.commit() # cur.close()
def update_qualification_level(qualification_level, doctor_id): cur.execute(query, [qualification_level, doctor_id]) CONNECTION.commit()
def update_html_dom_elem(html_dom_elem, log_id): cur.execute(query, [html_dom_elem, log_id]) CONNECTION.commit()
def update_url_reference(url_reference, redirect_id): cur.execute(query, [url_reference, redirect_id]) CONNECTION.commit()
def delete_doctor_tag_relations(doctor_tag_relation_id): cur.execute(query, [doctor_tag_relation_id]) CONNECTION.commit() # cur.close()
def update_description(description, symptom_id): cur.execute(query, [description, symptom_id]) CONNECTION.commit()
def update_access_time(access_time, log_id): cur.execute(query, [access_time, log_id]) CONNECTION.commit()
def update_html_attr(html_attr, log_id): cur.execute(query, [html_attr, log_id]) CONNECTION.commit()
def update_referrer_id(referrer_id, log_id): cur.execute(query, [referrer_id, log_id]) CONNECTION.commit()
from main_files.db.connect_db import CONNECTION cur = CONNECTION.cursor() query = """ UPDATE symptom_tag_relations SET symptom_id = %s, tag_id = %s WHERE symptom_tag_relation_id = %s """ def update_symptom_tag_relations(symptom_id=None, tag_id=None): cur.execute(query, [symptom_id, tag_id]) CONNECTION.commit() # cur.close()
def update_os_version(os_version, redirect_id): cur.execute(query, [os_version, redirect_id]) CONNECTION.commit()
def update_action(action, log_id): cur.execute(query, [action, log_id]) CONNECTION.commit()
def update_doctor_id(doctor_id, doctor_tag_relation_id): cur.execute(query, [doctor_id, doctor_tag_relation_id]) CONNECTION.commit()
def update_doctor_tag_relations(doctor_id=None, tag_id=None): cur.execute(query, [doctor_id, tag_id]) CONNECTION.commit()
def update_set_cookie(set_cookie, redirect_id): cur.execute(query, [set_cookie, redirect_id]) CONNECTION.commit()
def update_reference(reference, booking_event_id): cur.execute(query, [reference, booking_event_id]) CONNECTION.commit()
def update_symptom_tag_relations(symptom_id=None, tag_id=None): cur.execute(query, [symptom_id, tag_id]) CONNECTION.commit()
def delete_doctors(doctor_id): cur.execute(query, [doctor_id]) CONNECTION.commit() # cur.close()