def add_reply(it_id, content, u_id, re_time):
if re_time == None :
re_time = time.strftime( '%Y-%m-%d %X', time.localtime() ) #set current time as default
try :
query = Reply.get(Reply.item_id == it_id)
except:
reply = Reply.create(item_id = it_id,r_content = content,user_id = u_id,r_time = re_time)
def del_project(name):
# firstly del project
p_id = Project.get(Project.p_name == name).p_id
query = Project.delete().where(Project.p_name == name)
query.execute()
# secondly del p_id in admin_pro
users = User.select()
for user in users:
admin_pro = user.admin_pro
u_id = user.u_id
if admin_pro:
if admin_pro == str(p_id):
admin_pro = None
else:
pids = admin_pro.split(',')
if str(p_id) in pids:
pids.remove(str(p_id))
splits = ','
admin_pro = splits.join(pids)
query = User.update(admin_pro = admin_pro).where(User.u_id == u_id)
query.execute()
# thirdly del item if p_id in item
items = Item.select()
items_id = []
for item in items:
if item.project_id == p_id:
items_id.append(item.it_id)
query = Item.delete().where(Item.project_id == p_id)
query.execute()
# fourly del reply if it_id in items_id
for item_id in items_id:
query = Reply.delete().where(Reply.item_id == item_id)
query.execute()
def del_item(it_id_list):
# firstly del item
for it_id_1 in it_id_list:
query = Item.delete().where(Item.it_id == int(it_id_1))
query.execute()
# secondly del reply if it_id in Reply.item_id
# 一个条目只对应一条回复信息
for it_id_2 in it_id_list:
query = Reply.delete().where(Reply.item_id == int(it_id_2))
query.execute()
