def CatStudent(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Teacher, "rb") as f:
if os.path.getsize(self.__DB_Teacher) == 0:
read = {}
else:
read = pickle.loads(f.read())
with open(self.__DB_Course, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
Coursereads = {}
else:
Coursereads = pickle.loads(f.read())
with open(self.__DB_Order, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
reads = {}
else:
reads = pickle.loads(f.read())
count = True
for i in read:
for a in reads:
for b in Coursereads:
if reads[a]["course"] == b and Coursereads[b][
"class"] == read[i]["stuclass"]:
count = False
print("姓名：" + reads[a]["name"],
"班级：" + read[i]["stuclass"])
if count:
print("没有任何学生")
def doRegister(self):
user=Users(badgeid=self.badgeid, email=self.email, password=self.password, keyword=[], doc=[], active=True,name=self.name)
try:
user.save()
return "Register successfully!"
except:
return "Unable to register."
def post(self):
registerForm = forms.SignupForm(request.form)
templateData = {
'form' : registerForm
}
current_app.logger.info(request.form)
if registerForm.validate() == False:
current_app.logger.info(registerForm.errors)
return "uhoh registration error"
else:
email = request.form['email']
name = request.form['name']
badgeid = request.form['badgeid']
pwd = request.form['password']
pwd=md5(pwd).hexdigest()
# prepare User
user=Users(badgeid=badgeid, email=email, password=pwd, keyword=[], doc=[], active=True, name=name)
user.save()
#try:
if login_user(user, remember="no"):
flash("Logged in!")
return redirect('/list')
else:
flash("unable to log you in")
#except:
# flash("unable to register with that email address")
# current_app.logger.error("Error on registration - possible duplicate emails")
return render_template("posts/register.html", **templateData)
def PurchaseCourse(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Order, "rb") as f:
if os.path.getsize(self.__DB_Order) == 0:
read = {}
else:
read = pickle.loads(f.read())
self.getCourse()
with open(self.__DB_Course, "rb") as f:
if os.path.getsize(self.__DB_Course) == 0:
reads = {}
else:
reads = pickle.loads(f.read())
course = input("Course Name>>>").strip()
if course in reads:
price = reads[course]["price"]
else:
print("课程不存在")
return False
data = {
"name": Users().CookieSession("sessionid"),
"course": course,
"price": price,
"createTime": time.time()
}
read[Common().Jam_hash(
str(time.time()) +
str(random.randint(10000, 99999)))] = data
with open(self.__DB_Order, "wb") as f:
pickle.dump(read, f)
print("购买成功！")
return True
def doLogin(self):
email = self.email
userObj = Users()
user = userObj.get_by_email_w_password(email)
if user and self.password == user.password and user.is_active():
return "Login successfully"
return "Login failed"
def doLogin(self): email=self.email userObj=Users() user = userObj.get_by_email_w_password(email) if user and self.password==user.password and user.is_active(): return "Login successfully" return "Login failed"
def load_user(id):
if id is None:
redirect('/login')
user = Users()
user.get_by_id(id)
if user.is_active():
return user
else:
return None
def load_user(id):
if id is None:
redirect('/login')
user = Users()
user.get_by_id(id)
if user.is_active():
return user
else:
return None
def getMoney(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Student, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
return False
else:
read = pickle.loads(f.read())
return read[Users().CookieSession(
"sessionid")]["money"]
def post(self):
email = request.form["email"]
userObj = Users()
user = userObj.get_by_email_w_password(email)
if user and md5(request.form["password"]).hexdigest()==user.password and user.is_active():
remember = request.form.get("remember", "no") == "yes"
if login_user(user, remember=remember):
return redirect('/list')
return render_template("posts/login.html")
def setBuyCourse(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Order, "rb") as f:
if os.path.abspath(self.__DB_Order) == 0:
read = {}
else:
read = pickle.loads(f.read())
for i in read:
if read[i]["name"] == Users().CookieSession("sessionid"):
print("课程名称：" + read[i]["course"])
def post(self):
email = request.form["email"]
userObj = Users()
user = userObj.get_by_email_w_password(email)
if user and md5(request.form["password"]).hexdigest(
) == user.password and user.is_active():
remember = request.form.get("remember", "no") == "yes"
if login_user(user, remember=remember):
return redirect('/list')
return render_template("posts/login.html")
def userindex2():
user = None
userlist = []
for i in range(1, 11):
user = Users(i, "bianli" + str(i))
userlist.append(user)
return render_template("user_list.html", user=userlist)
def userindex1(user_id):
user = None
if int(user_id) == 1:
user = Users(1, "xjl==1")
return render_template("userindex.html", user=user)
else:
return abort(404)
def getRole(self):
role = Users().getRole()
if role == "root" or role == "Teacher":
return True
else:
print("无权操作")
return False
def setTeacher(self):
user = Users().getUser()
counts = True
for i in user:
if user[i]["role"] == "Teacher":
counts = False
print("Name:" + i)
if counts:
print("没有合适的老师")
return False
name = input("Teacher Name:")
for i in School().ReadSchool():
print("ID:" + i, "：" + School().ReadSchool()[i]["name"])
school = input("School ID:").strip()
schools = StuClass().ReadStuClass()
count = True
for i in schools:
if schools[i]["school"] == school:
count = False
print(i)
if count:
print("该校区还没符合条件的班级！")
return False
stuclass = input("StuClass:").strip()
if self.FormatTeacher(name, school, stuclass):
return True
else:
return False
def main():
while True:
if Users().JudgeLogin():
role = Users().getRole()
if role == "root":
comtent = input(
"1、创建校区,2、创建班级，3、创建课程，4、查看校区，5、查看班级，6、查看课程 >>> ")
if comtent == "1":
School().CreateSchool()
elif comtent == "2":
StuClass().setClass()
elif comtent == "3":
Course().setCourse()
elif comtent == "4":
StuClass().getReadStuClass()
elif comtent == "5":
StuClass().getReadStuClass()
elif comtent == "6":
Course().getCourseName(Course().getCourse())
else:
print("输入错误，请重新输入")
elif role == "Teacher":
comtent = input("1、查看班级学员列表,2、查看课程，3、添加成绩，4、修改成绩 >>> ")
if comtent == "1":
Teachers().CatStudent()
elif comtent == "2":
Teachers().CatCourse()
elif comtent == "3":
Teachers().setAchievement()
elif comtent == "4":
Teachers().midifyAchievement()
else:
print("输入错误，请重新输入")
elif role == "Student":
comtent = input("1、购买课程,2、课程查询，3、查看已购买课程, 4、查看成绩 >>> ")
if comtent == "1":
Students().PurchaseCourse()
elif comtent == "2":
Course().getCourseName(Course().getCourse())
elif comtent == "3":
Students().setBuyCourse()
elif comtent == "4":
Students().LookAchievement()
else:
print("输入错误，请重新输入")
def getCourse(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Course, "rb") as f:
if os.path.getsize(self.__DB_Course) == 0:
read = {}
else:
read = pickle.loads(f.read())
with open(self.__DB_School, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
reads = {}
else:
reads = eval(pickle.loads(f.read()))
for i in read:
for a in reads:
if reads[a]["id"] == read[i]["school"]:
print("课程名称：" + i, "价格：" + read[i]["price"],
"校区：" + reads[a]["name"],
"开学日期：" + read[i]["DateofSchool"])
def setAchievement(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Achievement, "rb") as f:
if os.path.getsize(self.__DB_Achievement) == 0:
read = {}
else:
read = pickle.loads(f.read())
student = input("Student Name>>>:").strip()
with open(self.__DB_Student, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
reads = {}
else:
reads = pickle.loads(f.read())
if student in reads:
achievement = input("Achievement>>>:").strip()
with open(self.__DB_Teacher, "rb") as f:
if os.path.getsize(self.__DB_Teacher) == 0:
treads = {}
else:
treads = pickle.loads(f.read())
with open(self.__DB_Course, "rb") as f:
if os.path.getsize(self.__DB_Course) == 0:
creads = {}
else:
creads = pickle.loads(f.read())
# print(treads)
# print(creads)
course = ""
for a in creads:
if treads[Users().CookieSession("sessionid")][
"stuclass"] == creads[a]["class"]:
course = a
data = {"achievement": achievement, "course": course}
read[student] = data
with open(self.__DB_Achievement, "wb") as f:
pickle.dump(read, f)
print("添加成功", student, "成绩：", achievement)
return True
else:
print("学生不存在！")
return False
def LookAchievement(self):
if Users().JudgeLogin():
student = Users().CookieSession("sessionid")
with open(self.__DB_Student, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
read = {}
else:
read = pickle.loads(f.read())
if student in read:
with open(self.__DB_Achievement, "rb") as f:
if os.path.getsize(self.__DB_Achievement) == 0:
aread = {}
else:
aread = pickle.loads(f.read())
for i in aread:
if i == student:
print("目前" + aread[i]["course"] + "学科成绩：",
aread[i]["achievement"])
# Students().setBuyCourse()
# Students().LookAchievement()
def CatCourse(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
with open(self.__DB_Teacher, "rb") as f:
if os.path.getsize(self.__DB_Teacher) == 0:
read = {}
print("目前没有创建任何课程")
return False
else:
read = pickle.loads(f.read())
with open(self.__DB_StuClass, "rb") as f:
readClass = pickle.loads(f.read())
# print(readClass)
with open(self.__DB_Course, "rb") as f:
if os.path.getsize(self.__DB_Course) == 0:
reads = {}
else:
reads = pickle.loads(f.read())
with open(self.__DB_School, "rb") as f:
if os.path.getsize(self.__DB_School) == 0:
readschool = {}
else:
readschool = eval(pickle.loads(f.read()))
count = True
for b in reads:
for i in read:
for a in readClass:
if read[i]["stuclass"] == a and reads[b][
"class"] == a:
for c in readschool:
if readschool[c]["id"] == reads[b][
"school"]:
count = False
print(
"班级：" + readClass[a]["name"],
"校区：" + readschool[c]["name"],
"开学日期：" + reads[b]["DateofSchool"])
if count:
print("没有创建任何课程")
def post(self):
registerForm = forms.SignupForm(request.form)
templateData = {'form': registerForm}
current_app.logger.info(request.form)
if registerForm.validate() == False:
current_app.logger.info(registerForm.errors)
return "uhoh registration error"
else:
email = request.form['email']
name = request.form['name']
badgeid = request.form['badgeid']
pwd = request.form['password']
pwd = md5(pwd).hexdigest()
# prepare User
user = Users(badgeid=badgeid,
email=email,
password=pwd,
keyword=[],
doc=[],
active=True,
name=name)
user.save()
#try:
if login_user(user, remember="no"):
flash("Logged in!")
return redirect('/list')
else:
flash("unable to log you in")
#except:
# flash("unable to register with that email address")
# current_app.logger.error("Error on registration - possible duplicate emails")
return render_template("posts/register.html", **templateData)
def midifyAchievement(self):
if Users().JudgeLogin():
if self.getUser(Users().CookieSession("sessionid")):
student = input("Student Name>>>:").strip()
with open(self.__DB_Student, "rb") as f:
if os.path.getsize(self.__DB_Student) == 0:
read = {}
else:
read = pickle.loads(f.read())
if student in read:
with open(self.__DB_Achievement, "rb") as f:
if os.path.getsize(self.__DB_Achievement) == 0:
aread = {}
else:
aread = pickle.loads(f.read())
for i in aread:
if i == student:
print("目前" + aread[i]["course"] + "学科成绩：",
aread[i]["achievement"])
course = input("Revised Course>>>:").strip()
aread[i]["achievement"] = course
break
with open(self.__DB_Achievement, "wb") as f:
pickle.dump(aread, f)
print("修改成功")
return True
else:
print("学生分数信息不存在")
return False
# print(Teachers().setTeacher())
# Teachers().CatStudent()
# Teachers().CatCourse()
# Teachers().midifyAchievement()
# Teachers().LookAchievement()
def user():
ob = Users()
Exit = 0
while (Exit != -1):
print("Choose an Available Operation listed below:")
print("1.viewFlights")
print("2.bookFlight")
print("3.viewAndCancelTickets")
print("4.Exit")
try:
option = int(input())
print("You have selected option %d " % option)
if (option == 1):
ob.viewFlights()
elif (option == 2):
ob.bookFlight()
elif (option == 3):
ob.viewAndCancelTickets()
elif (option == 4):
Exit = -1
else:
print("Please Enter one of above listed options!!!")
except:
print("Enter a valid Number!")
class Room(colander.MappingSchema):
users = Users()
uid = colander.SchemaNode(colander.String())
class UserList(colander.MappingSchema): kind = colander.SchemaNode(colander.String(), validator=colander.OneOf(['USERS'])) model = Users()
users = []
for i, result in enumerate(data['results']):
dob = datetime.strptime(result['dob']['date'], '%Y-%m-%dT%H:%M:%S.%fZ')
row = {
'UserId': i,
'Gender': result['gender'],
'Title': result['name']['title'],
'FirstName': result['name']['first'],
'LastName': result['name']['last'],
'City': result['location']['city'],
'Username': result['login']['username'],
'Email': result['email'],
'DOB': dob.date(),
'Age': result['dob']['age'],
'RDTB': Users.calculatenextbirthday(dob),
'Cell': ''.join([i for i in result['cell'] if i.isdigit()]),
'Phone': ''.join([i for i in result['phone'] if i.isdigit()]),
'Password': result['login']['password']
}
users.append(row)
for user in users:
row = Users(**user)
conn.session.add(row)
conn.session.commit()
elif args.percentage_sex:
all = conn.session.query(func.count('*')).select_from(Users).scalar()
male = conn.session.query(Users).filter(
Users.Gender.like('male')).count() / all * 100
female = conn.session.query(Users).filter(
