def select_max(table):
query = f'select max({ID}) as {ID} from {table}'
r = select_query(query)
if r:
result = r.fetchall()
if result[0].get(ID):
return result[0].get(ID)
return 0
return None
def find_enrollment_of_role(role_id):
query = f"select * from {ENROLLMENT} where {ROLE_ID}={role_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
enrollment = None
for i in result:
enrollment = map_response(i, mapper)
return enrollment
return None
def find_shift_by_id(_id):
query = f"select * from {SHIFT} where {ID}={_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
shift = None
for i in result:
shift = map_response(i, mapper)
return shift
return None
def find_user_by_gender(gender_id):
query = f"select * from {USER} where {GENDER_ID}={gender_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
user = None
for i in result:
user = map_response(i, mapper)
return user
return None
def find_role_by_id(_id):
query = f"select * from {ROLE} where {ID}={_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
role = None
for i in result:
role = map_response(i, mapper)
return role
return None
def find_attendance_status_by_id(_id):
query = f"select * from {ATTENDANCE} where {ID}='{_id}'"
r = database.select_query(query)
if r:
result = r.fetchall()
status = None
for i in result:
status = map_response(i, mapper)
return status
return None
def find_all_enrollments():
query = f"select * from {ENROLLMENT}"
r = database.select_query(query)
if r:
result = r.fetchall()
enrollment = []
for i in result:
enrollment.append(map_response(i, mapper))
return enrollment
return None
def find_attendance_record_of_enrollment_at_date(enrollment_id, date):
query = f"select * from {ATTENDANCE_RECORD} where {ENROLLMENT_ID}={enrollment_id} and {ATTENDANCE_DATE} = {date}"
r = database.select_query(query)
if r:
result = r.fetchall()
attendance = None
for i in result:
attendance = map_response(i, mapper)
return attendance
return None
def find_attendance_status_id_by_name(name):
query = f"select {ID} from {ATTENDANCE} where {STATUS}='{name}'"
r = database.select_query(query)
if r:
result = r.fetchall()
status_id = None
for i in result:
status_id = map_response(i, mapper)
return status_id
return None
def find_gender_by_id(_id):
query = f"select * from {GENDER} where {ID}={_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
gender = None
for i in result:
gender = map_response(i, mapper)
return gender
return None
def find_course_by_id(_id):
query = f"select * from {COURSE} where {ID}={_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
course = None
for i in result:
course = map_response(i, mapper)
return course
return None
def find_madrassa_by_id(_id):
query = f"select * from {MADRASSA} where {ID}={_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
madrassa = None
for i in result:
madrassa = map_response(i, mapper)
return madrassa
return None
def find_madrassa_detail_by_madrassa_id(madrassa_id):
query = f"select * from {MADRASSA_DETAILS} where {MADRASSA_ID}={madrassa_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
madrassa_detail = None
for i in result:
madrassa_detail = map_response(i, mapper)
return madrassa_detail
return None
def get_all_genders():
query = f"select * from {GENDER}"
r = database.select_query(query)
if r:
result = r.fetchall()
genders = []
for i in result:
mapped_data = map_response(i, mapper)
genders.append(mapped_data)
return genders
return []
def get_all_courses():
query = f"select * from {COURSE}"
r = database.select_query(query)
if r:
result = r.fetchall()
courses = []
for i in result:
mapped_data = map_response(i, mapper)
courses.append(mapped_data)
return courses
return []
def get_all_madrassas():
query = f"select * from {MADRASSA}"
r = database.select_query(query)
if r:
result = r.fetchall()
madrassas = []
for i in result:
mapped_data = map_response(i, mapper)
madrassas.append(mapped_data)
return madrassas
return []
def get_all_roles():
query = f"select * from {ROLE}"
r = database.select_query(query)
if r:
result = r.fetchall()
roles = []
for i in result:
mapped_data = map_response(i, mapper)
roles.append(mapped_data)
return roles
return []
def get_all_shifts():
query = f"select * from {SHIFT}"
r = database.select_query(query)
if r:
result = r.fetchall()
shifts = []
for i in result:
mapped_data = map_response(i, mapper)
shifts.append(mapped_data)
return shifts
return []
def find_madrassa_detail_by_shift_course_madrassa(shift_id, course_id,
madrassa_id):
query = f"select * from {MADRASSA_DETAILS} where " \
f"{SHIFT_ID}={shift_id} and " \
f"{MADRASSA_ID}={madrassa_id} and " \
f"{COURSE_ID}={course_id}"
r = database.select_query(query)
if r:
result = r.fetchall()
madrassa_detail = None
for i in result:
madrassa_detail = map_response(i, mapper)
return madrassa_detail
return None
def user_already_enrolled(user, madrassa_detail, role):
query = f"select * from {ENROLLMENT} where " \
f"{USER_ID}={user[gc.ID]} and " \
f"{ROLE_ID}={role[gc.ID]} and " \
f"{MADRASSA_DETAIL_ID}={madrassa_detail[gc.ID]}"
print(query)
r = database.select_query(query)
if r:
result = r.fetchall()
print(result)
enrollment = None
for i in result:
enrollment = map_response(i, mapper)
return enrollment is not None, enrollment
return True, None
def find_user_by_cnic_or_contact(cnic, contact):
where_clause = ""
if cnic or contact:
where_clause = where_clause + "where"
if cnic:
where_clause = where_clause + f" {CNIC}='{cnic}' "
if contact:
where_clause = where_clause + "and"
if contact:
where_clause = where_clause + f" ({CONTACT}='{contact}' or {GUARDIAN_CONTACT}='{contact}')"
query = f"select * from {USER} " + where_clause
print(query)
r = database.select_query(query)
if r:
result = r.fetchall()
data = []
for i in result:
data.append(map_response(i, mapper))
return data
return None
def wrap(*args, **kwargs):
token = None
headers = request_header()
if X_ACCESS_TOKEN in headers:
token = headers[X_ACCESS_TOKEN]
if not token:
response = make_general_response(MISSING_TOKEN, 'token is missing')
return response, UNAUTHORIZED
# try:
algorithm = gc.SHA256
data = decode(token,
current_app.config[SECRET_KEY],
algorithms=[algorithm])
query = f"Select {PASSWORD} from {ADMIN} where {USERNAME} = '{data.get(gc.USERNAME)}'"
r = select_query(query)
if r:
result = r.fetchall()
password = result[0][PASSWORD]
hashed_password = sha256(password.encode(gc.ASCII)).hexdigest()
if hashed_password == data.get(gc.PASSWORD):
return f(*args, **kwargs)
response = make_general_response(FAIL, 'FAIL')
return response, BAD_REQUEST
