def add_clinic(clinic): update_language_string(clinic.name) with get_connection() as conn: with conn.cursor() as cur: cur.execute( 'INSERT INTO clinics (id, name, edited_at) VALUES (%s, %s, %s)', [clinic.id, to_id(clinic.name), clinic.edited_at])
def add_user(user): update_language_string(user.name) with get_connection() as conn: with conn.cursor() as cur: query = ''' INSERT INTO users (id, name, role, email, hashed_password, edited_at) VALUES (%s, %s, %s, %s, %s, %s); ''' cur.execute(query, [ user.id, user.name.id, user.role, user.email, user.hashed_password, datetime.now() ])
def add_patient(patient: Patient): update_language_string(patient.given_name) update_language_string(patient.surname) update_language_string(patient.country) update_language_string(patient.hometown) with get_connection() as conn: with conn.cursor() as cur: cur.execute( 'INSERT INTO patients (id, given_name, surname, date_of_birth, sex, country, hometown, phone, edited_at) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)', [ patient.id, to_id(patient.given_name), to_id(patient.surname), patient.date_of_birth, patient.sex, to_id(patient.country), to_id(patient.hometown), patient.phone, patient.edited_at ])