def GET(self):
finalschedules = FinalScheduleTable.select(0, 'all')
finalusers = FinalUserTable.select(0, 'all')
schedules = ScheduleTable.select(0, 0, 'all')
users = UserTable.select(0, 0, 'all')
for finalschedule in finalschedules:
FinalScheduleTable.delete()
for finaluser in finalusers:
name = finaluser.s_name
FinalUserTable.delete(name)
for schedule in schedules:
if schedule.keep:
FinalScheduleTable.insert(schedule.s_name, schedule.s_time)
else:
sid=schedule.id
ScheduleTable.delete(sid, 0, 'id')
for user in users:
if user.s_type == 0:
FinalUserTable.insert(user.s_name, user.time_duty)
raise web.seeother('/schedule/data')
def launch():
finalschedules = FinalScheduleTable.select(0, 'all')
finalusers = FinalUserTable.select(0, 'all')
schedules = ScheduleTable.select(0, 0, 'all')
users = UserTable.select(0, 0, 'all')
FinalScheduleTable.delete()
for finaluser in finalusers:
name = finaluser.s_name
FinalUserTable.delete(name)
for schedule in schedules:
if schedule.keep:
FinalScheduleTable.insert(schedule.s_name, schedule.s_time)
else:
sid=schedule.id
ScheduleTable.delete(sid, 0, 'id')
for user in users:
if user.s_type == 0:
FinalUserTable.insert(user.s_name, user.time_duty)
def userDelete(sid):
user = UserTable.select(sid, 0, 'id')
name = user[0].s_name
UserTable.delete(sid)
ScheduleTable.delete(0, name, 'name')