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 create_student():
body = request.get_json()
std_fname = body.get('fname')
std_lname = body.get('lname')
std_email = body.get('email')
std_dob = body.get('dob')
std_gender = body.get('sex')
std_regno = int(body.get('regno'))
error = False
try:
# instantiate student object
std = Student(std_regno, std_fname, std_lname, std_email, std_dob,
std_gender)
std.insert()
students = Student.query.order_by(Student.std_id).all()
students_list = [student.format for student in students]
except Exception as e:
db.session.rollback()
error = True
print(sys.exc_info())
finally:
db.session.close()
if error:
abort(422)
else:
return redirect('/students')
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 zapisz_result(request):
if request.method == 'POST':
imie1 = request.POST.get("imie")
nazwisko1 = request.POST.get("nazwisko")
przedmiot = request.POST.get("przedmiot")
if imie1 == '' or nazwisko1 == '':
subjects = Wyklad.objects.all()
return render(request, 'zapisy/zapisz.html', {'subjects':subjects, 'error':True})
try:
student_1 = Student.objects.get(imie=imie1, nazwisko=nazwisko1)
text = '%s %s zostal znaleziony w bazie. ' % (student_1.imie, student_1.nazwisko)
except:
student_1 = Student(imie=imie1, nazwisko=nazwisko1)
student_1.save()
text = '%s %s nie zostal znaleziony. Dodano studenta do bazy. ' % (student_1.imie, student_1.nazwisko)
przedmiot_1 = Wyklad.objects.get(nazwa=przedmiot)
try:
student_2 = przedmiot_1.studenci.get(imie=imie1, nazwisko=nazwisko1)
print 'student ', student_2.imie, ' jest juz zapisany na ', przedmiot_1.nazwa
return render_to_response('zapisy/zapisz.html', {'odpowiedz':True, 'odpowiedz2':text+'Student jest juz zapisany za zajecia'})
except:
przedmiot_1.studenci.add(student_1)
return render_to_response('zapisy/zapisz.html', {'odpowiedz':True, 'odpowiedz2':text+'Student zostal zapisany na zajecia'})
else:
return render_to_response('zapisy/zapisz.html', {'error':True})
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():
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 test_create_student(self):
with test_database(TEST_DB, (Student,)):
self.create_students(),
self.assertEqual(Student.select().count(), 2)
self.assertNotEqual(
Student.select().get().password, 'password'
)
def check_in(student_id, class_id):
"""Checkin student to a class"""
try:
student = Student.get(Student.id == student_id)
except Exception:
cprint('Student Id Not Found', 'red')
return
try:
class_ = Class_.get(Class_.id == class_id)
except Exception:
cprint('Class Not Found', 'red')
return
if student.checked_in:
cprint("{} is already checked in".format(
student.student_name), 'red', 'on_grey')
elif not class_.session:
cprint("{} is not in session".format(
class_.class_name), 'red', 'on_grey')
else:
# Add a check in entry to check_ins table
check_in = Checkin.create(
student=student, class_=class_, status=1)
check_in.save()
# Set the student's check_in status to true
qry = Student.update(checked_in=1).where(Student.id == student_id)
qry.execute()
cprint("Checked in {} to {} class".format(
student.student_name, class_.class_name), 'green', 'on_grey')
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 add_student(request):
from uuid import uuid4
if request.method == 'POST':
name = escape(request.POST.get('name', None).strip())
username = escape(request.POST.get('username', None).strip())
password = escape(request.POST.get('password', None).strip())
rno = escape(request.POST.get('rno', None).strip())
dob = escape(request.POST.get('dob', None).strip())
course = escape(request.POST.get('course', None).strip())
year = escape(request.POST.get('year', None).strip())
semester = escape(request.POST.get('semester', None).strip())
image1 = request.FILES.get('image1')
image2 = request.FILES.get('image2')
image3 = request.FILES.get('image3')
image4 = request.FILES.get('image4')
image1.name = '{}{}'.format(uuid4().hex, image1.name[image1.name.rfind('.'):])
image2.name = '{}{}'.format(uuid4().hex, image2.name[image2.name.rfind('.'):])
image3.name = '{}{}'.format(uuid4().hex, image3.name[image3.name.rfind('.'):])
image4.name = '{}{}'.format(uuid4().hex, image4.name[image4.name.rfind('.'):])
student = Student(name=name, username=username, password=password, rollno=rno, dob=dob,
course=course, year=year, semester=semester, image1=image1, image2=image2,
image3=image3, image4=image4)
student.save()
return HttpResponseRedirect('/dashboard')
return HttpResponseRedirect('/forms')
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 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 insert_item(argv):
'''Takes the system arguments as parameter and then inserts the item.
Keyword arguments:
argv -- An array of command line arguments passed to the program.
'''
if argv[2] == "school":
school = School.create(name=argv[3])
print "New school: " + str(School.get(School.name == argv[3]))
elif argv[2] == "batch":
batch = Batch.create(school=argv[3], name=argv[4])
print "New batch: " + str(Batch.get(Batch.name == argv[4]))
elif argv[2] == "student":
print "New student:",
if len(argv) > 6:
student = Student.create(batch=argv[3],
age=argv[4],
last_name=argv[5],
first_name=argv[6])
print str(Student.get(Student.age == argv[4] and
Student.last_name == argv[5] and
Student.first_name == argv[6]))
else:
student = Student.create(batch=argv[3],
age=argv[4],
last_name=argv[5])
print str(Student.get(Student.age == argv[4] and
Student.last_name == argv[5]))
elif argv[2] == "exercise":
exercise = Exercise.create(student=argv[3],
subject=argv[4],
note=argv[5])
print "New Exercise: " + str(exercise)
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 create_instance_test():
t1 = Teacher.create(name='t1')
t2 = Teacher.create(name='t2')
s1 = Student.create(name = 's1', teacher=t1)
s2 = Student.create(name = 's2', teacher=t1)
s3 = Student.create(name = 's3', teacher=t2)
s4 = Student.create(name = 's4', teacher=t2)
def create_instance_test():
t1 = Teacher.create(name='t1')
t2 = Teacher.create(name='t2')
s1 = Student.create(name='s1', teacher=t1)
s2 = Student.create(name='s2', teacher=t1)
s3 = Student.create(name='s3', teacher=t2)
s4 = Student.create(name='s4', teacher=t2)
def upload(request):
'''
Upload a csv and store the students' imformation in the database.
'''
if request.method == "POST": # form submitted
try:
csv = request.FILES['csv']
if csv.size > 4096:
return render(request, 'error.html', {'str':'文件尺寸过大'})
else:
for line in csv:
line = line.strip('\r\n\xef\xbb\xbf') # delete the useless characters
words = line.split(',')
if len(words) == 0:
continue
paras = dict()
paras['num'] = int(words[0])
paras['tot'] = 0 # total score
for i in xrange(1,6):
paras[subjects[i]] = int(words[i+1]) # scores of the subjects
paras['tot'] += paras[subjects[i]]
paras['name']=words[1]
stu = Student(**paras)
try:
stu.clean_fields() # check the scores of the students
except:
return render(request, 'error.html', {'str':'学生信息错误'})
stu.save()
return render(request, 'notify.html', {"str":"导入csv文件成功"}) # upload succeeded
except:
return render(request, 'error.html', {'str':'您没有上传文件或文件格式错误，具体文件格式详见帮助'})
else:
return render(request, 'upload.html')
def modify1(request):
'''
Receive the form containing a student's information
and update the student's infromation in the database.
'''
try:
cmd = request.POST.get('cmd')
paras = dict()
paras['num'] = int(request.POST.get('num'))
if cmd == 'edit': # edit the student's infromation
paras['name'] = request.POST.get('name')
paras['tot'] = 0
for subject in subjects[1:]:
paras[subject] = int(request.POST.get(subject))
paras['tot'] += paras[subject]
stu=Student(**paras)
stu.clean_fields() # validate the fields of the students, if not, an error will be raised
stu.save()
return render(request, 'query.html', {"table":[[Student.objects.get(num=paras['num']), Student.objects.filter(tot__gt=paras['tot']).count()+1]]})
else: # delete the student from the database
Student.objects.filter(num=paras['num']).delete()
return render(request, 'notify.html', {"str":"学生信息成功删除"})
except:
return render(request, 'error.html', {"str":"学生信息错误，请正确填写"});
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 register():
data = dict(request.form.items())
if data.get('username', None):
Student.create(username=data.get('username', 'anonymous'),
name=data.get('name', 'Jane Doe'),
course=data.get('course', 'Python'),
age=data.get('age', 18))
return render_template("register_student.html")
def create_data1(self):
obj = Course(title='英语')
obj.student_list = [
Student(name='小杰'),
Student(name='小工'),
]
session.add(obj)
session.commit()
def change_notify_status(call):
user = call.from_user.id
Student.trigger_notify(user)
bot.edit_message_reply_markup(
user,
message_id=call.message.message_id,
reply_markup=create_notify_keyboard(user),
)
def add_student(request):
if request.method == "POST":
id_number = request.POST.get('id_number', '')
first_name = request.POST.get('first_name', '')
last_name = request.POST.get('last_name','')
student = Student(id_number=id_number, first_name=first_name, last_name=last_name)
student.save()
return HttpResponseRedirect('/')
def get(self):
stubStudents = [ "rush8192", "kshin" ]
for student in stubStudents:
matchingStudent = Student.query(Student.student_id == student).get()
if matchingStudent == None:
studentObj = Student(student_id=student,academic_plans=[])
studentObj.put()
print "populated db with student: " + student
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 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 find_by_name(self, name):
statement = f"SELECT id FROM {self.tablename} WHERE name=?"
self.cursor.execute(statement, (name, ))
result = self.cursor.fetchone()
if result:
new_obj = Student(*result)
new_obj.id = result
else:
raise RecordNotFoundException(f'record with name={name} not found')
def setUpClass(cls):
global o1_id
o1 = Student()
o1.url_number = 1
o1.public_profile.realname = '李小兵'
o1.save()
o1_id = o1.id
def get(self):
stubStudents = ["rush8192", "kshin"]
for student in stubStudents:
matchingStudent = Student.query(
Student.student_id == student).get()
if matchingStudent == None:
studentObj = Student(student_id=student, academic_plans=[])
studentObj.put()
print "populated db with student: " + student
def post(self):
user = users.get_current_user()
if not user:
self.redirect(users.create_login_url(self.request.uri))
return
next_active_assignemnt = None
if (self.request.get('type') == 'Student'):
rose_username = self.request.get('rose_username')
new_student = Student(parent=get_parent_key(user),
id=rose_username,
first_name=self.request.get('first_name'),
last_name=self.request.get('last_name'),
rose_username=rose_username,
team=self.request.get('team'))
new_student.put()
elif (self.request.get('type') == 'Assignment'):
active_assignment = Assignment(parent=get_parent_key(user),
name=self.request.get('assignment_name'))
if len(self.request.get('assignment_entity_key')) > 0:
assignment_key = ndb.Key(urlsafe=self.request.get('assignment_entity_key'))
if assignment_key:
assignment = assignment_key.get()
if assignment:
active_assignment = assignment
active_assignment.name = self.request.get('assignment_name')
active_assignment.put()
next_active_assignemnt = active_assignment.key.urlsafe()
elif (self.request.get('type') == 'SingleGradeEntry'):
assignment_key = ndb.Key(urlsafe=self.request.get('assignment_key'))
student_key = ndb.Key(urlsafe=self.request.get('student_key'))
student = student_key.get()
score = int(self.request.get('score'))
new_grade_entry = GradeEntry(parent=assignment_key,
id=student.rose_username,
assignment_key=assignment_key,
student_key=student_key,
score=score)
new_grade_entry.put()
next_active_assignemnt = assignment_key.urlsafe()
elif (self.request.get('type') == 'TeamGradeEntry'):
assignment_key = ndb.Key(urlsafe=self.request.get('assignment_key'))
score = int(self.request.get('score'))
team = self.request.get('team')
student_query = Student.query(Student.team==team, ancestor=get_parent_key(user))
for student in student_query:
new_grade_entry = GradeEntry(parent=assignment_key,
id=student.rose_username,
assignment_key=assignment_key,
student_key=student.key,
score=score)
new_grade_entry.put()
next_active_assignemnt = assignment_key.urlsafe()
if next_active_assignemnt:
self.redirect("/?active_assignemnt=" + next_active_assignemnt)
else:
self.redirect("/")
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
def create_student(name, drink_coffee, entrou, saiu):
entrou = list(map(int, entrou.split('/')))
entrou = datetime(entrou[2], entrou[1], entrou[0])
saiu = list(map(int, saiu.split('/')))
saiu = datetime(saiu[2], saiu[1], saiu[0])
Student.create(name=name,
drink_coffee=drink_coffee,
entrou=entrou,
saiu=saiu,
email='')
def register():
data = dict(request.form.items())
if data.get('id', None):
Student.create(
id=data.get('id',1),
title=data.get('title', 'python class was hard today'),
date=data.get('Date', 12/7/9),
)
return render_template("register_student.html")
def save(self,commit=True):
user = User.objects.create_user(self.cleaned_data['studentid'], '', '000000')
user.is_staff = True
user.save()
theclass = Class.objects.get(id = self.cleaned_data['studentclass'])
student = Student(user=user,realname=self.cleaned_data['studentname'],\
theclass=theclass,sex=self.cleaned_data['studentsex'])
if commit:
student.save()
return student
def reset_chair_status(call):
user = call.from_user.id
Student.reset_extended_flag(user)
bot.edit_message_text(
chat_id=user,
message_id=call.message.message_id,
text=get_chair_status_message(user),
parse_mode="html",
reply_markup=settings_buttons(),
)
def deploy():
from flask.ext.migrate import upgrade
# migrate database to latest revision
upgrade()
# create teaaher1
Teacher.add_teacher1()
# create stu1
Student.add_stu1()
def save(self,commit=True):
user = User.objects.create_user(self.cleaned_data['studentid'], '', '000000')
user.is_staff = True
user.save()
theclass = Class.objects.get(id = self.cleaned_data['studentclass'])
student = Student(user=user,realname=self.cleaned_data['username'],\
theclass=theclass,sex=self.cleaned_data['studentsex'])
if commit:
student.save()
return student
def all(self):
statement = f'SELECT * from {self.tablename}'
self.cursor.execute(statement)
result = []
for item in self.cursor.fetchall():
id, name = item
student = Student(name)
student.id = id
result.append(student)
return result
def create_student(name, last_name, year_birth, address_residence,
year_admission, group, average_score):
student = Student(name=name,
last_name=last_name,
year_birth=year_birth,
address_residence=address_residence,
year_admission=year_admission,
group=group,
average_score=average_score)
student.save()
def find_all(self):
command = f'SELECT * FROM {self.table_name}'
self.cursor.execute(command)
result = []
for item in self.cursor.fetchall():
id, name = item
student = Student(name)
student.id = id
result.append(student)
return result
def testStudent(self):
who = Student()
who.setStudentID(1)
who.setStudentName("Decebal")
who.setStudentGroup("Dacia")
assert who.getStudentID() == 1
assert who.getStudentName() == "Decebal"
assert who.getStudentGroup() == "Dacia"
def save(self):
user = Account(**self.data)
user.save()
if self.role.data == 1:
stuusr = Student(stuid=self.username.data)
stuusr.save()
if self.role.data == 3:
teausr = Teacher(teaid=self.username.data)
teausr.save()
return self.username.data, self.role.data
def saveDataFromRequest(self, req_body):
request_objs = req_body.splitlines()
students = json.loads(request_objs[0])
activities = json.loads(request_objs[1])
comments = json.loads(request_objs[2])
Student.get_from_json(students)
Comment.get_from_json(comments)
Activity.get_from_json(activities)
def register(request):
if request.POST:
post = request.POST
new_student = Student(
Username = post["username"],
Password= post["password"],
Institute = post["institute"],
Contact_way = post["contact_way"],
Email = post["email"])
new_student.save()
return render_to_response("gegister.html")
def add_enrollments(enrollments, group):
group.students = []
for i in range(len(enrollments)):
enrollment = enrollments[i].lower()
new_student = Student.query.filter_by(enrollment=enrollment).first()
if not new_student:
new_student = Student(email=enrollment + '@itesm.mx',
role='student', enrollment=enrollment)
new_student.hash_password(enrollment)
group.students.append(new_student)
return group
def save(self, commit=True):
user = User.objects.create_user(self.cleaned_data["studentid"], "", "000000")
user.is_staff = True
user.save()
theclass = Class.objects.get(id=self.cleaned_data["studentclass"])
student = Student(
user=user, realname=self.cleaned_data["studentname"], theclass=theclass, sex=self.cleaned_data["studentsex"]
)
if commit:
student.save()
return student
def generateStudent():
student = Student()
student.name = random.choice(NAMES)
student.gender = random.choice(GENDERS)
student.age = random.choice(AGES)
student.university = random.choice(UNIVERSITIES)
student.department = random.choice(DEPARTMENTS)
student.percent_sem1 = randomPercent()
student.percent_sem2 = randomPercent()
student.percent_sem3 = randomPercent()
student.percent_sem4 = randomPercent()
return student
def testStudent(self):
"""
Method tests the Student class.
"""
who = Student(666)
who.setStudentID(1)
who.setStudentName("Decebal")
who.setStudentGroup("Dacia")
assert who.getStudentID() == 1
assert who.getStudentName() == "Decebal"
assert who.getStudentGroup() == "Dacia"
def post(self):
'''This function is called when POST request is routed to this handler.
'''
#Get name and group from HTTP request
name = self.request.get('name')
group = self.request.get('group')
#Create new Student entity
student = Student(name=name, group=group)
#Save it
student.put()
#Redirect to home page
self.redirect('/')
def create_students(count=2):
for i in range(count):
Student.create_student(
username=STUDENT_LIST[i],
user_json=requests.get("https://teamtreehouse.com/{}.json".format(STUDENT_LIST[i])).json(),
email='test_{}@example.com'.format(i),
first_name='John',
last_name='Doe',
password='******',
github_username=STUDENT_LIST[i],
city='Portland',
state='OR',
country='USA'
)
def add_student_action(request):
username = request.REQUEST['username']
password = request.REQUEST['password']
exist_student_list = Student.objects.filter(username=username)
if len(exist_student_list) == 0:
new_student = Student(username=username)
new_student.set_password(password)
new_student.save()
new_student = authenticate(username=username, password=password)
login(request, new_student)
return redirect('/')
else:
return render_to_response('coursera/main.html', {'error': 'The username already exists'})
def student_register_view(request):
if request.method == "POST":
username = request.POST['username']
if not User.objects.filter(username = username).exists():
return render(request, 'reg/student_register.html', {'error':'Username or email already used, or passwords do not match'})
u = User.objects.get(username = username)
t = Student(user=u)
t.save()
return redirect('home')
else:
if Student.objects.filter(user=request.user).count() > 0 or Teacher.objects.filter(user=request.user).count() > 0 or Parent.objects.filter(user=request.user).count() > 0:
return redirect('home')
return render(request, 'reg/student_register.html')
def createClassAndStudents(self): c = Class() c.name = 'Test Class' self.class_key = c.put() c = self.class_key.get() self.timezone = c.timezone s = Student() s.first_name = 'Joe' s.last_name = 'Smith' self.student_key = s.put() c.enrolled.append(self.student_key) c.put() # TODO: fix this to use a known date, since could potentially have problems if run in different timezone to default self.today_as_ordinal = Attend.today_as_ordinal(self.timezone)
def post(self):
try: # try to create student from form values
student = Student()
student.studentid = int(self.request.get('studentid').strip())
student.first_name = self.request.get('first_name').strip().title()
student.last_name = self.request.get('last_name').strip().title()
student.ucinetid = self.request.get('ucinetid').strip().lower()
student.email = self.request.get('email').strip().lower()
student.lab = int(self.request.get('lab').strip())
student.quarter = int(self.request.get('quarter').strip())
student.year = int(self.request.get('year').strip())
student.active = True
except Exception, e:
return self.redirect('/admin?message=' + 'There was a problem adding that student: ' + str(e))
def post(self):
user = users.get_current_user()
uid = user.user_id()
newStudent = Student(userid=uid)
newStudent.name = self.request.get("name")
newStudent.email = user.email()
newStudent.rollno = self.request.get("rollno")
newStudent.cgpa = float(self.request.get("cgpa"))
newStudent.phno = self.request.get("phoneno")
newStudent.approved = False
newStudent.put()
self.redirect("/")
def top_batch(argv):
'''Print the student object that is the top of a given batch.
Keyword arguments:
argv -- An array of command line arguments passed to the program.
'''
top = {"score": 0.0, "student": Student}
for student in Student.select():
if str(student.batch.id) == str(argv[2]):
arr = handle_average(["", "", student.id], Student,
"Student", False)
for dict in arr:
dict["student"] = student
if len(argv) > 3:
for i in arr:
if i["subject"] == argv[3]:
if i["average"] > top["score"]:
top["score"] = i["average"]
top["student"] = i["student"]
else:
for i in arr:
if i["average"] > top["score"]:
top["score"] = i["average"]
top["student"] = i["student"]
print top["student"]
def post(self):
if bool(self.request.get('choice')):
ndb.delete_multi(Student.query().fetch(keys_only=True))
ndb.delete_multi(Assignment.query().fetch(keys_only=True))
ndb.delete_multi(Setting.query().fetch(keys_only=True))
self.redirect('/admin')
def post(self, pathname):
user = users.get_current_user();
uid = ""
if (user == None):
uid = self.request.get('uid')
else:
uid = user.user_id()
title = self.request.get('title')
print "creating new plan for: " + uid + " with title: " + title
# first we load the GER program sheet, and add it to a new plan
GER_SHEET_NAME = "GER-PRE-2015" #TODO: this needs to be changed to the correct value
matchingStudent = Student.query(Student.student_id == uid).get()
if matchingStudent == None:
self.response.write('Error: no matching student record for: ' + uid)
return
gerSheet = Program_Sheet.query(Program_Sheet.ps_name == GER_SHEET_NAME).get()
studentGerSheet = Student_Program_Sheet(program_sheet=gerSheet.key,
cand_courses=[], allow_double_count=True)
studentGerSheet.put()
studentPlan = Student_Plan(student_plan_name=title, student_course_list=[], program_sheets=[ studentGerSheet.key ])
studentPlan.put()
matchingStudent.academic_plans.append(studentPlan.key)
matchingStudent.put()
print "created new plan for student: " + uid + " with id: " + str(studentPlan.key.urlsafe())
self.response.set_status(201)
#return the created plan
self.response.write(studentPlan.to_dict())
