class MakeData():
def __init__(self):
self.student = SStudents()
self.teacher = STeachers()
self.personal = SPersonal()
self.competition = SCompetitions()
self.user = SUsers()
self.team = STeams()
self.infor = SInfor()
def make_id(self):
user_ids = []
student_ids = []
teacher_ids = []
competition_ids = []
team_ids = []
i = 0
while i < 22:
user_ids.append(uuid.uuid4())
student_ids.append(uuid.uuid4())
teacher_ids.append(uuid.uuid4())
competition_ids.append(uuid.uuid4())
team_ids.append(uuid.uuid4())
i = i + 1
return user_ids, student_ids, teacher_ids, competition_ids, team_ids
def add_users(self, user_ids):
i = 0
name = "test"
pwd = "123"
utype = 100
while i < 22:
self.user.add_user(user_ids[i], name + str(i), pwd, utype)
i = i + 1
if i > 10:
utype = 101
def add_students(self, user_ids, student_ids):
i = 0
name = "student"
no = "130323"
university = "杭州电子科技大学"
school = "管理学院"
tel = "135880460"
grade = 2018
sex = 201
while i < 11:
self.personal.add_student_abo_by_uid(student_ids[i], user_ids[i],
name + str(i), no + str(i),
university, school,
tel + str(i), grade, sex)
i = i + 1
if i > 5:
sex = 202
def add_teachers(self, user_ids, teacher_ids):
i = 0
name = "teacher"
no = "7403"
university = "杭州电子科技大学"
school = "管理学院"
tel = "177064411"
while i < 11:
self.personal.add_teacher_abo_by_uid(user_ids[i + 11],
teacher_ids[i], name + str(i),
no, tel + str(i) + str(i),
university, school, i + 1)
i = i + 1
def add_competitions(self, competition_ids):
i = 0
name = "test_competition"
level = 1
start = "2018-01-22"
end = "2019-01-22"
min = 3
max = 5
own = "浙江团省委"
abo = "测试数据"
while i < 22:
self.competition.add_competitions(competition_ids[i],
name + str(i), i, level, start,
end, min, max, own, abo)
i = i + 1
def add_team(self, team_ids, competition_ids):
i = 0
name = "test_team"
while i < 22:
self.team.add_team(team_ids[i], name + str(i), competition_ids[i],
701, 5)
i = i + 1
def add_tsstudent(self, team_ids, student_ids):
i = 0
while i < 6:
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i], 1000, 1101)
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i + 1], 1001, 1101)
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i + 2], 1001, 1101)
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i + 3], 1002, 1101)
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i + 4], 1002, 1101)
self.team.add_student_in_team(uuid.uuid4(), team_ids[i],
student_ids[i + 5], 1002, 1102)
i = i + 1
def add_tsteacher(self, team_ids, teacher_ids):
i = 0
while i < 6:
self.team.add_teacher_in_team(uuid.uuid4(), team_ids[i],
teacher_ids[i], 1)
i = i + 1
def add_stech(self, student_ids):
i = 0
name = "test_tech"
while i < 11:
self.personal.add_student_tech_by_sid(uuid.uuid4(), student_ids[i],
name + str(i), i % 5 + 1)
self.personal.add_student_tech_by_sid(uuid.uuid4(), student_ids[i],
name + str(i + 1), i % 5 + 1)
i = i + 1
def add_scuse(self, student_ids):
i = 0
name = "测试竞赛简历"
no = "一等奖"
while i < 11:
self.personal.add_student_use_by_sid(uuid.uuid4(), student_ids[i],
name + "1", no)
self.personal.add_student_use_by_sid(uuid.uuid4(), student_ids[i],
name + "2", no)
i = i + 1
def add_tcuse(self, teacher_ids):
i = 0
name = "测试竞赛简历"
no = "一等奖"
while i < 11:
self.personal.add_teacher_use_by_tid(uuid.uuid4(), teacher_ids[i],
name + "1", no, i)
i = i + 1
class CUsers():
def __init__(self):
self.judgeData = JudgeData() #全局实例化
self.susers = SUsers()
#实现登录的数据处理
def login(self):
form = request.data #获取前端发送的body体
print str(form)
#判断body体不为空
if str(form) == "" or str(form) == "[]":
return param_miss
form = json.loads(form)
#判断必要存在的参数
if not self.judgeData.inData(
"Uname", form) or not self.judgeData.inData("Upwd", form):
return param_miss
list_uname = self.susers.get_all_user_name() #获取数据库中存在的uname
#判断uname存在
if form["Uname"] not in list_uname:
return
Upwd = self.susers.get_upwd_by_uname(form["Uname"]) #根据用户名获取数据库的密码
#判断session是否异常
if Upwd == False:
return system_error
#判断用户名与密码匹配
if Upwd != form["Upwd"]:
return error_upwd
Uid = self.susers.get_uid_by_uname(form["Uname"]) #根据用户名获取数据库的id
Utype = self.susers.get_utype_by_uid(Uid)
login_ok["messages"]["Uid"] = Uid #将获取到的内容放置到body中
login_ok["messages"]["Utype"] = Utype
return login_ok
#实现注册的数据处理
def register(self):
form = request.data #获取前端发送的body体
print request.values
#print str(form)
#判断body体不为空
if str(form) == "" or str(form) == "[]":
return param_miss
print form
form = json.loads(form)
#判断必要参数存在
if not self.judgeData.inData("Uname",form) or not self.judgeData.inData("Upwd",form) \
or not self.judgeData.inData("Utype", form):
return param_miss
list_uname = self.susers.get_all_user_name() #获取数据库中存在的uname
#判断session是否异常
if list_uname == False:
return system_error
#判断uname唯一
if form["Uname"] in list_uname:
return repeated_name
is_register = self.susers.add_user(uuid.uuid4(), form["Uname"],
form["Upwd"], form["Utype"]) #写入数据库
#判断写入数据库的响应
if is_register:
return register_ok
else:
return system_error