def update_plan(ptype,CourseId,Yardid,Coach_id,BeginDate,EndDate,WorkTime,OffTime,WeekSchedule_list_or_str,updater):
session = database.get_session()
updatedict = {'BeginDate':BeginDate,'EndDate':EndDate,'Modifier':updater,'LastUpdateDate':datetime.now()}
if CourseId:
c = Course()
c.CourseId = CourseId
updatedict.update({'Course':[c]})
if Yardid:
y = Yard()
y.Yardid = Yardid
updatedict.update({'Yard':[y]})
if Coach_id:
m = Member()
m.UserId = Coach_id
updatedict.update({'Coach':[m]})
if WorkTime:
updatedict.update({'WorkTime':WorkTime})
if OffTime:
updatedict.update({'OffTime':OffTime})
if WeekSchedule_list_or_str:
if ptype=='a':
s = ''
for e in WeekSchedule_list_or_str:
s+= '&'.join(e)+'^'
updatedict.update({'WeekSchedule':s.strip('^')})
elif ptype=='b':
updatedict.update({'WeekSchedule':WeekSchedule_list_or_str})
else:
pass
session.query(Course).filter(Course.CourseId == CourseId).update(updatedict)
session.commit()
session.close()
def update_course(CourseId,Name,Duration,Amount,Coach_id,HourFee,Comment,Description,updater):
session = database.get_session()
updatedict = {'Name':Name.strip(),'Duration':int(Duration),'Amount':int(Amount),'HourFee':int(HourFee),
'Comment':Comment.strip(),'Description':Description.strip(),'Modifier':updater,
'LastUpdateDate':datetime.now()}
if Coach_id:
m = Member()
m.UserId = Coach_id
updatedict.update({'Coach':[m]})
session.query(Course).filter(Course.CourseId == CourseId).update(updatedict)
session.commit()
session.close()
def create_course(CourseType,Name,Duration,Amount,HourFee,Comment,Description,creator,Coach_id=None):
session = database.get_session()
p = Course()
p.CType = CourseType.strip()
p.Name = Name.strip()
p.Duration = int(Duration)
p.Amount = int(Amount)
if Coach_id:
m = Member()
m.UserId = Coach_id
p.Coach.append(m)
p.HourFee = int(HourFee)
p.Comment = Comment.strip()
p.Description = Description.strip()
p.Creator = creator
p.CreateDate = datetime.now()
session.add(p)
session.commit()
session.close()
