def search(self,params): params["pageNo"]=(params["pageNo"]-1)*self.pageSize sql="select * from sos_timetable where 1=1 " rowSql="select count(ID) from sos_timetable where 1=1" val = params.get("subjectName",None) if( DataValidator.isNotNull(val)): sql+=" and subjectName = '"+val+"' " rowSql+=" and subjectName = '"+val+"' " val = params.get("semester",None) if( DataValidator.isNotNull(val)): sql+=" and semester = '"+val+"' " rowSql+=" and semester = '"+val+"' " sql+=" LIMIT %s,%s" rowSql+=" LIMIT %s,%s" cursor = connection.cursor() cursor.execute(sql,[params["pageNo"],self.pageSize]) result=cursor.fetchall() test_tup1=("id","examTime","examDate","subjectName","courseName","semester") res={ "data":[], "count":[] } count=0 for x in result: res["data"].append({test_tup1[i] : x[i] for i, _ in enumerate(x)}) return res return q
def input_validation(self): super().input_validation() inputError = self.form["inputError"] if (DataValidator.isNull(self.form["firstName"])): inputError["firstName"] = "Name can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["lastName"])): inputError["lastName"] = "Last Name can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["login_id"])): inputError["login_id"] = "Login can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["password"])): inputError["password"] = "******" self.form["error"] = True if (DataValidator.isNull(self.form["confirmpassword"])): inputError["confirmpassword"] = "******" self.form["error"] = True if (DataValidator.isNotNull(self.form["confirmpassword"])): if (self.form["password"] != self.form["confirmpassword"]): inputError[ "confirmpassword"] = "******" self.form["error"] = True if (DataValidator.isNull(self.form["dob"])): inputError["dob"] = "dob can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["address"])): inputError["address"] = "address can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["mobilenumber"])): inputError["mobilenumber"] = "mobileNumber can not be null" self.form["error"] = True return self.form["error"]
def input_validation(self): super().input_validation() inputError = self.form["inputError"] if (DataValidator.isNull(self.form["firstName"])): inputError["firstName"] = "Name can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["lastName"])): inputError["lastName"] = "Last Name can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["login"])): inputError["login"] = "******" self.form["error"] = True if (DataValidator.isNull(self.form["password"])): inputError["password"] = "******" self.form["error"] = True if (DataValidator.isNull(self.form["dob"])): inputError["dob"] = "dob can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["mobileNumber"])): inputError["mobileNumber"] = "mobileNumber can not be null" self.form["error"] = True return self.form["error"]
def get_login_id(self, login): q = self.get_model().objects.filter() if (DataValidator.isNotNull(login)): q = q.filter(login_id=login) return q
def search(self, params): q = self.get_model().objects.filter() val = params.get("firstName", None) if (DataValidator.isNotNull(val)): q = q.filter(firstName=val) val = params.get("lastName", None) if (DataValidator.isNotNull(val)): q = q.filter(lastName=val) val = params.get("email", None) if (DataValidator.isNotNull(val)): q = q.filter(email=val) val = params.get("password", None) if (DataValidator.isNotNull(val)): q = q.filter(password=val) val = params.get("mobileNumber", None) if (DataValidator.isNotNull(val)): q = q.filter(mobileNumber=val) val = params.get("address", None) if (DataValidator.isNotNull(val)): q = q.filter(address=val) val = params.get("gender", None) if (DataValidator.isNotNull(val)): q = q.filter(gender=val) val = params.get("dob", None) if (DataValidator.isNotNull(val)): q = q.filter(dob=val) val = params.get("college_ID", None) if (DataValidator.isNotNull(val)): q = q.filter(college_ID=val) val = params.get("collegeName", None) if (DataValidator.isNotNull(val)): q = q.filter(collegeName=val) val = params.get("subject_ID", None) if (DataValidator.isNotNull(val)): q = q.filter(subject_ID=val) val = params.get("subjectName", None) if (DataValidator.isNotNull(val)): q = q.filter(subjectName=val) val = params.get("course_ID", None) if (DataValidator.isNotNull(val)): q = q.filter(course_ID=val) val = params.get("courseName", None) if (DataValidator.isNotNull(val)): q = q.filter(courseName=val) return q
def input_validation(self): super().input_validation() inputError = self.form["inputError"] if (DataValidator.isNull(self.form["firstName"])): inputError["firstName"] = "Name can not be null" self.form["error"] = True else: if DataValidator.isaplhacheck(self.form['firstName']): inputError['firstName'] = "First Name contains only alphabets" self.form['error'] = True if (DataValidator.isNull(self.form["lastName"])): inputError["lastName"] = "Last Name can not be null" self.form["error"] = True else: if DataValidator.isaplhacheck(self.form['lastName']): inputError['lastName'] = "Last Name contains only alphabet" self.form["error"] = True if (DataValidator.isNull(self.form["login"])): inputError["login"] = "******" self.form["error"] = True else: if DataValidator.isemail(self.form['login']): inputError['login'] = "******" self.form['error'] = True if (DataValidator.isNull(self.form["password"])): inputError["password"] = "******" self.form["error"] = True if (DataValidator.isNull(self.form["dob"])): inputError["dob"] = "DOB can not be null" self.form["error"] = True if (DataValidator.isNull(self.form["mobileNumber"])): inputError["mobileNumber"] = "Mobile Number can not be null" self.form["error"] = True else: if DataValidator.ismobilecheck(self.form['mobileNumber']): inputError['mobileNumber'] = "Invalid Mobile Number" self.form['error'] = True if (DataValidator.isNull(self.form["gender"])): inputError['gender'] = "Please Select Gender" self.form['error'] = True return self.form["error"]