def select_one_where_email(email):
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM admin_apotek WHERE email = %s",
[str(email)])
admin = dict_fetch_one(cursor)
if admin is not None:
admin = Admin(admin['email'], admin['id_apotek'])
return admin
def select_one_where_email(email):
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM apoteker WHERE email = %s",
[str(email)])
apoteker = dict_fetch_one(cursor)
if apoteker is not None:
apoteker = Apoteker(apoteker['email'])
return apoteker
def select_one_where_email(email):
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM pengguna WHERE email = %s",
[str(email)])
list_pengguna_dict = dict_fetch_one(cursor)
for pengguna in list_pengguna_dict:
pengguna_obj = Pengguna(pengguna['email'],
pengguna['telepon'],
pengguna['password'],
pengguna['nama_lengkap'])
return pengguna_obj
def check_one_where_email_exist(email):
with connection.cursor() as cursor:
cursor.execute("SELECT 1 FROM pengguna WHERE email = %s",
[str(email)])
pengguna = dict_fetch_one(email)
return pengguna is not None
def check_one_where_email_exist(email):
with connection.cursor() as cursor:
cursor.execute("SELECT 1 WHERE email = %s", [str(email)])
admin = dict_fetch_one(cursor)
return admin is not None