def get_clinics_by_type(type):
cursor = conn.cursor()
type = '%' + type + '%'
cursor.executemany("SELECT * from clinictype_tbl where type_en like %s ",
type)
result = cursor.fetchall()
search = []
for r in result:
search.append(str(r[0]))
cursor.executemany("SELECT * from clinic_tbl where clinic_id in (%s)",
search)
result = cursor.fetchall()
print(result)
payload = []
for r in result:
payload.append({
'clinic_id': r[0],
'clinic_name': r[1],
'address': r[2],
'contact_no': str(r[3]),
'description': r[4],
'latitude': float(r[5]),
'longitude': float(r[6]),
'clinic_count': r[7],
'open_time': str(r[8]),
'close_time': str(r[9]),
'photo_url': r[10]
})
return jsonify(clinic=payload)
def get_users():
# data = request.get_json()
cursor = conn.cursor()
cursor.execute("SELECT * from user_tbl")
result = cursor.fetchall()
print(result)
payload = []
for r in result:
payload.append({
'user_id': r[0],
'age_range': r[1],
'gender': r[2],
'myself': r[3]
})
return jsonify(user=payload)
def get_events():
# data = request.get_json()
cursor = conn.cursor()
cursor.execute("SELECT * from event_tbl")
result = cursor.fetchall()
print(result)
payload = []
for r in result:
payload.append({
'event_id': r[0],
'event_name': r[1],
'event_desc': r[2],
'event_url': r[3],
'event_photo_url': r[4],
})
return jsonify(event=payload)
def get_clinic_by_id(id):
cursor = conn.cursor()
cursor.execute("SELECT * from clinic_tbl where clinic_id=%s", id)
r = cursor.fetchone()
print(r)
payload = [{
'clinic_id': r[0],
'clinic_name': r[1],
'address': r[2],
'contact_no': str(r[3]),
'description': r[4],
'latitude': float(r[5]),
'longitude': float(r[6]),
'clinic_count': r[7],
'open_time': str(r[8]),
'close_time': str(r[9]),
'photo_url': r[10]
}]
return jsonify(clinic=payload)
def get_clinics_by_address(address):
cursor = conn.cursor()
address = '%' + address + '%'
cursor.execute("SELECT * from clinic_tbl where address like %s", address)
result = cursor.fetchall()
print(result)
payload = []
for r in result:
payload.append({
'clinic_id': r[0],
'clinic_name': r[1],
'address': r[2],
'contact_no': str(r[3]),
'description': r[4],
'latitude': float(r[5]),
'longitude': float(r[6]),
'clinic_count': r[7],
'open_time': str(r[8]),
'close_time': str(r[9]),
'photo_url': r[10]
})
return jsonify(clinic=payload)
def get_clinics():
# data = request.get_json()
cursor = conn.cursor()
cursor.execute("SELECT * from clinic_tbl")
result = cursor.fetchall()
print(result)
payload = []
for r in result:
payload.append({
'clinic_id': r[0],
'clinic_name': r[1],
'address': r[2],
'contact_no': str(r[3]),
'description': r[4],
'latitude': float(r[5]),
'longitude': float(r[6]),
'clinic_count': r[7],
'open_time': str(r[8]),
'close_time': str(r[9]),
'photo_url': r[10]
})
return jsonify(clinic=payload)