def createTeam():
if session.get("id") is None:
return redirect("/user/login")
name = session.get("name")
if request.method == "GET":
return render_template('student_templates/createTeam.html', name=name)
else:
name = request.form.get("name")
userId = session.get("id")
course = CourseAndStudent.query.filter(
CourseAndStudent.studentId == userId).first()
with db.auto_commit():
team = Team()
team.courseId = course.CourseId
team.TeamName = name
team.isFinish = 0
db.session.add(team)
team = Team.query.filter(
Team.courseId == course.CourseId).order_by(
Team.TeamNumber.desc()).first()
member = Member()
member.studentId = userId
member.teamId = team.TeamNumber
member.votenum = 0
db.session.add(member)
return redirect('/student/display')
def get_team_image():
teams = rackhd_config.Teams
repo = rackhd_config.repos
team_name = request.form['TeamName'] or 'Maglev Team'
startDate = request.form['StartDate'] or '2015-10-01'
endDate = request.form['EndDate'] or datetime.now()
image_name = request.form['image_name']
if type(startDate) == type(""):
startDate = datetime.strptime(startDate, "%Y-%m-%d")
if type(endDate) == type(""):
endDate = datetime.strptime(endDate, "%Y-%m-%d")
team_members = teams[team_name]
#print("startDate %s, endDate: %s" % (startDate,endDate) )
t = Team(team_name, team_members)
operator = {
'image1': t.draw_team_pr_count_monthly(startDate, endDate),
'image2': t.draw_team_comments_count_monthly(startDate, endDate),
'image3': t.draw_team_avg_duration_monthly(startDate, endDate),
'image4': t.draw_pr_count_member(startDate, endDate),
'image5': t.draw_comments_count_member(startDate, endDate),
'image6': t.draw_avg_duration_member(startDate, endDate)
}
image_output = operator[image_name]
image = base64.b64encode(image_output).decode('UTF-8')
return make_response(image)
def create_team(team_name: str, owner: str):
"""Create new team."""
new_team = Team(name=team_name,
owner=owner,
team_members=[],
draft_position=0)
new_team.save()
return new_team
def get_team():
with db.auto_commit():
team = Team()
team.TeamName = 'g1'
team.TeamNumber = 0
# 数据库的insert操作
db.session.add(team)
return 'hello team'
def post(self):
# create
league_name = self.get_body_argument("league_name")
manager_team_name = self.get_body_argument("manager_team_name")
league = League(name=league_name)
team = Team(name=manager_team_name, league=league)
league.manager = team
self.session.add_all([league, team])
self.session.commit()
def create_team():
jsonData = request.get_json()
with db.auto_commit():
team = Team()
team.team_name = jsonData['team_name']
team.team_logo = jsonData['team_logo']
team.team_type = jsonData['team_type']
team.team_captain = jsonData['team_captain']
team.team_slogan = jsonData['team_slogan']
team.team_comment = jsonData['team_comment']
team.school_id = jsonData['school_id']
team.category_id = jsonData['category_id']
db.session.add(team)
return Success(msg='新增成功')
def post_team(req):
"""
"""
# Get data from request
req.get_data()
league_id = req.json.get('league_id')
user_id = req.json.get('user_id')
name = req.json.get('name')
# Create instance of GoalScored and add to database
new_team = Team(user_id=user_id, league_id=league_id, name=name)
db.session.add(new_team)
# Commit data to database - if exception is caught, return the error message
try:
db.session.commit()
except IntegrityError as e:
db.session.rollback()
return jsonify(status='fail', error=str(e.orig))
# Return success message
return jsonify(status='success', data={'Team': new_team.to_dict()})
def byStudent():
if session.get("id") is None:
return redirect("/user/login")
name=session.get("name")
courseId=request.args.get("courseId")
studentList=CourseAndStudent.query.filter_by(CourseId=courseId).all()
list=[]
for i in studentList:
student=Student.query.filter_by(id=i.studentId).first()
if student is not None:
list.append(student)
#每组的人数
totalNum=Course.query.filter_by(CourseId=courseId).first().numofmember
#组的数量
# teamNum=len(list)/totalNum+1
# print(teamNum)
#
# if teamNum==1:
# list2=[]
# list2.append(list)
# pass
# else:
from random import shuffle
shuffle(list) # 重排序
list2 = []
for i in range(0, len(list), totalNum):
list2.append(list[i:i + totalNum])
result=[]
for i in list2:
dict1 = dict()
nameTeam=random.randint(100,1000)
dict1["name"]=str(nameTeam)
dict1["value"]=i
print(i)
result.append(dict1)
with db.auto_commit():
team = Team()
team.TeamName=str(nameTeam)
team.courseId=courseId
# 数据库的insert操作
db.session.add(team)
team=Team.query.filter(Team.courseId==courseId).filter(Team.TeamName==nameTeam).first()
with db.auto_commit():
for x in i:
member=Member()
member.teamId=team.TeamNumber
member.studentId=x.id
db.session.add(member)
Course.query.filter(Course.CourseId == courseId).update({"teamType": 2})
db.session.commit()
return render_template("teacher_templates/displaygroup.html",name=name,courseId=courseId,result=result)
def __init__(self):
self.rackhd = Team("rackhd", [])
self.no_rackhd = Team("no_rackhd", [])
self.db = SQLiteDB()
self.set_rackhd()
self.set_no_rackhd()
