def setUp(self): sys.path.insert(0, "../../src") from models import Student self.genghis = Student(1, "Genghis", "Khan", "*****@*****.**", "Shinai") self.dropping = Student(2, "Dropping", "Soon", "*****@*****.**", "Goodby3")
def setUp(self): print('\r') # drop all tables in the database db.session.remove() db.drop_all() # crete all tables in the database db.create_all() # adding users user_1 = User('*****@*****.**', encrypt('password'), 'student_1') student_1 = Student(user_1, 'U00000000A') db.session.add(student_1) user_2 = User('*****@*****.**', encrypt('password'), 'student_2') student_2 = Student(user_2, 'U00000000B') db.session.add(student_2) user_3 = User('*****@*****.**', encrypt('password'), 'teacher_1') staff_1 = Staff(user_3) db.session.add(staff_1) # adding topics topic = Topic(name='seng') db.session.add(topic) # adding lessons lesson = Lesson(1, 1, 'lesson_1', 'content') db.session.add(lesson) # adding quizzes quiz = Quiz(3, 'quiz_1', True, '2020-03-30', '2020-03-31') db.session.add(quiz) db.session.commit()
def test_student(): from models import Student Student(first_name='John', last_name='Doe', email='*****@*****.**', password='******', gender='M').save() Student(first_name='James', last_name='Bond', email='*****@*****.**', password='******', gender='M', aka='007').save() Student(first_name='Jane', last_name='Doe', email='*****@*****.**', password='******', gender='F', req_for_courses=[]).save() # TODO add a nonempty `req_for_courses` test case pass assert Student.objects(req_for_courses__size=0).count() == 3 # missing gender with pytest.raises(ValidationError): Student(first_name='John2', last_name='Doe2', email='*****@*****.**', password='******').save() clean_up()
def create_data1(self): obj = Course(title='英语') obj.student_list = [ Student(name='小杰'), Student(name='小工'), ] session.add(obj) session.commit()
def setUp(self): # set up the test DB self.db = tested_db self.db.create_all() self.db.session.add(Student(id=1, username="******")) self.db.session.add(Student(id=2, username="******")) self.db.session.commit() self.app = tested_app.test_client()
def temrunadd(): s1 = Student(sno='17240130', sid='44058319990123042X', sname='王钰婷', ssex='女', sbirth='1999-01-23', sdept='人工智能学院', sspecial='计算机信息管理', sclass='4班', saddr='广东省汕头市澄海区') s2 = Student(sno='17240224', sid='440111199803073156', sname='曾禹祥', ssex='男', sbirth='1998-03-07', sdept='人工智能学院', sspecial='计算机信息管理', sclass='2班', saddr='广东省广州市白云区') s3 = Student(sno='17140143', sid='440304199810266877', sname='陈逸轩', ssex='男', sbirth='1998-10-26', sdept='电子与通信工程学院', sspecial='电子信息工程技术', sclass='1班', saddr='广东省深圳市福田区') s4 = Student(sno='17340111', sid='444522419981111607', sname='李晓璇', ssex='女', sbirth='1998-11-11', sdept='建筑与环境工程学院', sspecial='房地产经营与管理', sclass='3班', saddr='广东省揭阳市惠来县') s5 = Student(sno='17440134', sid='440306199902024130', sname='许奕涵', ssex='男', sbirth='1999-02-02', sdept='机电工程学院', sspecial='建筑智能化工程技术', sclass='2班', saddr='广东省深圳市宝安区') db.session.add_all([s1, s2, s3, s4, s5]) db.session.commit() c1 = Card(sid=s1.sid, cardstate='可用', cardmoney=340.00, sno=s1.sno) c2 = Card(sid=s2.sid, cardstate='可用', cardmoney=200.00, sno=s2.sno) c3 = Card(sid=s3.sid, cardstate='可用', cardmoney=0.00, sno=s3.sno) c4 = Card(sid=s4.sid, cardstate='可用', cardmoney=20.00, sno=s4.sno) c5 = Card(sid=s5.sid, cardstate='可用', cardmoney=18.00, sno=s5.sno) db.session.add_all([c1, c2, c3, c4, c5]) db.session.commit() print("添加成功")
def addUsers(): """Currently adds whole user data scraped from swd site along with scores of the course. However, the intended purpose is to add a single user when the user signs up along with his scores and other data to the database :returns does not return anything""" from bs4 import BeautifulSoup data = open("html_doc.html", 'r').read() soup = BeautifulSoup(data, "lxml") gender = 'Male' errors = 0 # Populate the DB with Data scraped from SWD site for i in soup.find_all('tr'): t = [j.string for j in i.find_all('td')] if len(t) > 2: id = t[0].lstrip('\n').strip(" ") name = t[1].strip(" ").strip(" .").strip("\n") try: db_session.add(Student(id=id, name=name, gender=gender)) db_session.commit() id = id_format(id) print "------------------Added------------------- " print "ID :", id print "Name :", name print "Scores:", generateMarkList(id) print "------------------------------------------ " except IntegrityError: print "Unique Constraint failed!" errors += 1 print "Errors found: ", errors db_session.rollback() except InvalidRequestError: print "Invalid Request at", id, name errors += 1 print "Errors found: ", errors marks_data.reset_index() # Update the DB with scores from the uploaded csv file # If user is not present then then add the user for i in range(len(marks_data)): name = marks_data.loc[i]['Name'] id = marks_data.loc[i]['ID Number'] student_id = id_format(id) try: print "User present" resultCheck = db_session.query(Student).filter_by(id=student_id).first() resultCheck.scores = generateMarkList(i) db_session.commit() except: print "User not present" print student_id student = Student(id=student_id, name=name, gender=gender, scores=generateMarkList(i)) db_session.add(student) db_session.commit() print "Added ", id, " ", name
async def process(self, payload, data): self.sdk.log( "State Menu processor fired with payload {}".format(payload)) text = payload["text"] if text in self.response_phrases["EGE_calc"]: student = Student(self.sdk, payload, chat=payload['chat']) scores = student.scores # Show programs for user by scores return await self.controller.goto(payload, "calc", scores) elif text in self.response_phrases["ratings"]: return await self.controller.goto(payload, "ratings") # elif text in self.response_phrases["notifications"]: # return await self.controller.goto(payload, "settings") elif text in self.response_phrases["logout"]: # Remove student data from database Student(self.sdk, payload, chat=payload["chat"]).remove() # Remove checking for User's positions in ratings self.sdk.log("Scheduler for chat {} was removed".format( payload['chat'])) self.sdk.scheduler.remove(payload) # Send message message = "Если понадоблюсь, выполни команду /itmo_start." await self.sdk.send_text_to_chat(payload["chat"], message, remove_keyboard=True, bot=payload.get('bot', None)) # Go to start state return await self.controller.goto(payload, "start") # Response to undefined user reply message = "Не понимаю" await self.sdk.send_text_to_chat(payload["chat"], message, remove_keyboard=True, bot=payload.get('bot', None)) return await self.controller.goto(payload, "menu")
def index(): from models import Student post_form_class = model_form(Student, base_class=FlaskForm, db_session=db.session) if request.method == 'POST': form = post_form_class(request.form) if form.validate(): try: post = Student(**form.data) db.session.add(post) db.session.commit() flash('Student created!') except IntegrityError: db.session.rollback() flash("User {} is already exists".format(post.studentID)) else: flash('Form is not valid! Student was not created.') else: form = post_form_class() posts = Student.query.all() q = Student.query.filter( or_(and_(Student.sex == 'male', Student.age > 21), (and_(Student.sex == 'female', Student.faculty == 'Philology')))).order_by(Student.age) return render_template('index.html', form=form, posts=posts, q=q)
def render_booking_done(): form = userForm() name = form.name.data phone = form.phone.data day = form.day.data time = form.time.data teacher_id = form.teacher_id.data teacher_name = form.teacher_name.data timetable_id = form.timetable_id.data print(50 * '*') print(form.timetable_id.data) student = Student.query.filter(Student.phone == phone).first() if not student: student = Student(name=name, phone=phone) db.session.add(student) db.session.commit() booking = Booking(student_id=student.id, teacher_id=teacher_id, timetable_id=timetable_id) db.session.add(booking) db.session.commit() return render_template('booking_done.html', name=name, phone=phone, time=time, day=day)
def create_student(): classes_list = Classes.get_obj_list() for k, obj in enumerate(classes_list): print( k, '\033[33;1m班级名:[%s] 学校:[%s] 地址:[%s] 课程:[%s] 讲师:[%s]\033[0m ' % (obj.name, obj.school_id.get_obj_uuid().name, obj.school_id.get_obj_uuid().addr, obj.course_teacher_id.get_obj_uuid(). course_id.get_obj_uuid().name, obj.course_teacher_id.get_obj_uuid( ).teacher_id.get_obj_uuid().name)) choose = input('选择班级 >> ').strip() if choose.isdigit(): choose = int(choose) if choose < len(Classes.get_obj_list()): choose_classes = classes_list[choose] name = input('输入学生名字 >> ').strip() pas = input('输入学生密码 >> ').strip() age = input('输入学生年龄 >> ').strip() student_list = [obj.name for obj in Student.get_obj_list()] if name in student_list: print('\033[31;学生 [%s] 已存在,不可重复创建0m\033[0m' % name) else: student = Student(name, pas, age, choose_classes.nid) # 需要存一个nid student.save() print('\033[32;1m学生 [%s] 创建成功\033[0m' % name) else: print('\033[31;1m 没有此班级,请重新选择\033[0m')
def users(): if request.method == 'POST': data = request.get_json() userid = data.get('userid') username = data.get('username') number = data.get('number') re_number = data.get('re-number') if not (userid and username and number and re_number): return jsonify({'error': 'No arguments'}), 400 if number != re_number: return jsonify({'error': 'Wrong password'}), 400 student = Student() student.userid = userid student.username = username student.number = number db.session.add(student) db.session.commit() return jsonify(), 201 users = Student.query.all() app = Flask(__name__) app.config['JSON_AS_ASCII'] = False return jsonify([user.serialize for user in users])
def setUp(self): self.school = School(name='Minnesota') db.session.add(self.school) db.session.commit() self.tch = Teacher(first_name='Jess', last_name='Christensen', title='K4-2nd Sped', school_id=self.school.id, username='******', password='******') db.session.add(self.tch) db.session.commit() self.stu = Student(first_name='Fake', last_name='Kid', dob=date(2012, 1, 24), grade=1, teacher_id=self.tch.id, dis_area='OHI') db.session.add(self.stu) db.session.commit() self.iep = IEP(student_id=self.stu.id, teacher_id=self.tch.id) db.session.add(self.iep) db.session.commit()
def signup(): if request.method == 'POST': if request.form['UserType'] == 'Landlord': FirstName = request.form['FirstName'] LastName = request.form['LastName'] PhoneNum = request.form['PhoneNum'] Email = request.form['NewEmail'] Password = request.form['Password'] user = Landlord(FirstName, LastName, Email, Password, PhoneNum, True, datetime.now(), datetime.now()) db.session.add(user) elif request.form['UserType'] == 'Student': FirstName = request.form['FirstName'] LastName = request.form['LastName'] PhoneNum = request.form['PhoneNum'] Email = request.form['NewEmail'] Password = request.form['Password'] user = Student(FirstName, LastName, Email, Password, PhoneNum, True, datetime.now(), datetime.now()) db.session.add(user) #Handling SQLalchemy errors when a user added has the same email address (already exists) # http://docs.sqlalchemy.org/en/latest/core/exceptions.html try: db.session.commit() except exc.IntegrityError: db.session.rollback() return jsonify([{ 'status': 400, 'message': 'A user with this email already exists.' }]) return jsonify([{'status': 201}]) else: return render_template('signup.html')
def post(self): """ 新增数据 """ parser = reqparse.RequestParser() parser.add_argument('sid', type=int) parser.add_argument('sname', type=str) parser.add_argument('sex', type=str) parser.add_argument('birthplace', type=str) parser.add_argument('birthdate', type=str) parser.add_argument('department', type=str) parser.add_argument('sclass', type=str) args = parser.parse_args() #判断输入完整性 for key,value in args.iteritems(): if value is None: return {'error': "Please input field: %s" % key }, 400 stu = Student(**args) try: insert_row = stu.insert() #判断是否插入成功 if insert_row == 1: return stu, 201 except IntegrityError ,e: #insert duplicate primary_key entry if e[0] == 1062: return {'primary error': e[1]}, 400
def test_student_has_name_attribute(): """ Student must have a name atribute """ with pytest.raises(TypeError): Student()
def __init__(self, student_base_info: dict): self.student_list = [ Student( base_info[0], base_info[1], ) for base_info in student_base_info ]
def studentRegistration(): if(session['logged_in'] == True): #if user login if(request.method == 'GET'): return render_template('studentRegistration.html') elif(request.method == 'POST'): try: userId = request.json['user_id'] name = request.json['name'] grade = request.json['grade'] student = Student(userId, name, grade) newUser = Login(userId, userId,"student") #Create new user DataPipelineObj.insert_data(newUser) #Add details to the database (Into login table) DataPipelineObj.insert_data(student)#Add details to the database(Into Student table return jsonify({'status':"Student successfully registered"}) except: return jsonify({'status':"Fill the required details"}) else: abort(405) else: #if user not login return render_template('showSignIn.html')
def setUp(self): print('\r') # drop all tables in the database db.session.remove() db.drop_all() # crete all tables in the database db.create_all() # adding courses course = Course(index='cz3003') db.session.add(course) # adding users user = User( email='*****@*****.**', encrypted_password=encrypt('password'), name='std' ) std = Student(user,"U1722") db.session.add(std) # adding RsStudentCourseEnrol rs = initializeRsStudentCourseEnrol(1,'cz3003') db.session.add(rs) db.session.commit()
def dict_to_student(d): """ Convert dictionary to Student object :param d: dictionary :return: Student object """ st_obj = Student() st_obj.username = d[ 'username'] if 'username' in d else '' # each student has a unique username st_obj.first_name = d['first_name'] if 'first_name' in d else '' st_obj.last_name = d['last_name'] if 'last_name' in d else '' st_obj.email = d['email'] st_obj.password = d['password'] st_obj.linkedin_token = d['linkedin_token'] if 'linkedin_token' in d else '' st_obj.github_token = d['github_token'] if 'github_token' in d else '' st_obj.skills = d['skills'] if 'skills' in d else [] # list of strings st_obj.need_visa = d[ 'need_visa'] if 'need_visa' in d else 'no' # boolean STRING st_obj.location = d['location'] if 'location' in d else 'New York' # string st_obj.looking_for = d['looking_for'] if 'looking_for' in d else [ 'Internship', 'Full-Time', 'Co-op' ] # list st_obj.job_matches = d['job_matches'] if 'job_matches' in d else [] # list st_obj.favorited_jobs = d['favorited_jobs'] if 'favorited_jobs' in d else [ ] # list st_obj.declined_jobs = d['declined_jobs'] if 'declined_jobs' in d else [ ] # list return st_obj
def setUp(self): print('\r') # drop all tables in the database db.session.remove() db.drop_all() # crete all tables in the database db.create_all() # adding users user = User( email='*****@*****.**', encrypted_password=encrypt('password'), name='john_doe' ) student = Student(user, 'U1722') db.session.add(student) # adding topics topic = Topic(name='seng') db.session.add(topic) # adding lessons lesson = Lesson(topic_id=1, id=1, name='se', content='test') db.session.add(lesson) # adding questions qn_1 = Question(1, 1,'easy') db.session.add(qn_1) qn_2 = Question(1, 1,'medium') db.session.add(qn_2) db.session.commit()
def get(student_ID): query = "SELECT * FROM dbo.[STUDENTS] WHERE ID = ?" cursor.execute(query, student_ID) raw = cursor.fetchall() student = Student.Student(raw[0]) students = [student] return json.dumps([student.__dict__ for student in students])
def create_list(filename): cols_dict = dict(numara="A", ad="C") cols_lesson_dict = dict() wb = load_workbook(filename=filename) ws = wb[wb.sheetnames[0]] for harf in string.ascii_uppercase[5:]: if bool(ws[f"{harf}1"].value) == 0: break cols_lesson_dict[ws[f"{harf}1"].value.lower()] = harf students = list() for row in range(3, ws.max_row + 1): data = dict() data["satir"] = row for col_name, col_id in cols_lesson_dict.items(): data[col_name] = ws[f"{col_id}{row}"].value for col_name, col_id in cols_dict.items(): data[col_name] = ws[f"{col_id}{row}"].value students.append(Student(data, cols_lesson_dict)) students = sorted(students, key=lambda i: i.numara) olustur_set = set() for student in students: for lesson_name, lesson_class in student: if lesson_class: olustur_set.add(lesson_name + lesson_class) return dict(lists=sorted(list(olustur_set)), students=students)
def load_objects(): with open('processed_data/student_objects.json', 'r', encoding='utf-8') as student_objects_file: data = json.load(student_objects_file) [Student(datum) for datum in data] with open('processed_data/course_objects.json', 'r', encoding='utf-8') as course_objects_file: data = json.load(course_objects_file) [Course(datum) for datum in data]
def student(): if request.method == 'POST': student_name = request.form.get('student_name') student_id = request.form.get('student_id') student_section = request.form.get('student_section') student_photo = request.files['file'] try: filepath = os.path.join(app.config['students'], secure_filename(student_photo.filename)) student_photo.save(filepath) picture_of_student = face_recognition.load_image_file(filepath) face_encoding = face_recognition.face_encodings( picture_of_student)[0] face_encoding = face_encoding.tolist() face_encoding = str(face_encoding) new_student = Student( student_name=student_name, student_photo=student_photo.filename, student_id=student_id, student_section=student_section, encodings=face_encoding) #based on init function db.session.add(new_student) db.session.commit() return jsonify('{} was created'.format(new_student)) except Exception as e: return (str(e)) if request.method == 'GET': return render_template('student_reg.html')
def upload_courses(prid, filename): book = xlrd.open_workbook(filename) coursesNum = book.nsheets coursesNames = book.sheet_names() for i in range(coursesNum): thisSheet = book.sheet_by_index(i) #print thisSheet.col_values(0) cs = thisSheet.col_values(0) course_name = coursesNames[i] course = Course(name=course_name) course.save() pr = Project.objects.get(id=prid) print pr.name course.project = pr course.save() for st in cs: st = Student(stdnom=str(int(st))) st.save() course.students.add(st) course.save() return projects(request)
def save(self, role=1): user = Account(**self.data) user.role = role user.save() stuusr = Student(stuid=user.username, grade="20" + user.username[0:2]) stuusr.save() return user
def create_student(ano_para): if request.json["type"] == "3.2as": #待修改 student = Student() snounique = 1 snolist = db.session.execute('SELECT sno FROM StudentInfo;').fetchall() for sno in snolist: if request.json['sno'] == sno[0]: snounique = 0 if snounique == 1: student.sno = request.json['sno'] student.sname = request.json['sname'] student.sex = request.json['sex'] student.age = request.json['age'] student.classno = request.json['classno'] db.session.add(student) db.session.commit() return jsonify({ #待修改 'type': '3.2ar', 'success': 'true' }) else: return jsonify({ #待修改 'type': '3.2ar', 'success': 'false' })
def register(): form = RegistrationForm() if form.validate_on_submit(): student = Student( index=form.index.data, name=form.name.data, surname=form.surname.data, faculty=form.faculty.data, major=form.major.data, year=form.year.data, group=form.group.data, ) user = User(username=form.username.data, email=form.email.data, password=form.password.data, confirmed=False, admin=False) db.session.add(user) db.session.add(student) db.session.commit() token = generate_confirmation_token(user.email) confirm_url = url_for('confirm_email', token=token, _external=True) html = render_template('user/activate.html', confirm_url=confirm_url) subject = "Please confirm your email" send_email(user.email, subject, html) login_user(user) flash('A confirmation email has been sent via email.', 'success') return redirect('/unconfirmed') return render_template('user/register.html', form=form)
def submit(): rf = request.form if not rf.get("stid").isdigit: flash("The student ID is incorrect") return redirect("/") haspaid = None if rf.get("paid") == "Yes": haspaid=True if rf.get("paid") == "No": haspaid=False if haspaid is None: flash("Please choose yes or no!") return redirect("/") formvs = (int(rf.get("stid")), rf.get("fname"), rf.get("lname"), rf.get("cname"), rf.get("teacher"), haspaid) if not formsvalidated(*formvs): return redirect("/") if Student.query.get(formvs[0]): flash("Somebody already registered with that ID") return redirect("/") add_student = Student(*formvs) db.session.add(add_student) db.session.commit() return render_template("success.html", info=formvs)