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