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()
