예제 #1
0
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() 
예제 #2
0
def  add_item(it_type,user_id,project_id,deal,content,it_time,picture):
    if it_type == None:
        it_type = 1 # use advice as default
    if user_id == None:
        user_id = 1 # 若无法获得userid,则默认为管理员admin提出的意见,即匿名意见
    if project_id ==None:
        project_id = 1 # user 1 as default project id
    if deal == None :
        deal = 0 # set no deal as default
    if it_time == None :
        it_time = time.strftime( '%Y-%m-%d %X', time.localtime() ) #set current time as default
    Item.create(it_type= it_type ,user_id=user_id,project_id = project_id,deal= deal,it_content = content,it_time = it_time,picture= picture )
    newItem = Item.get(Item.it_type == it_type ,Item.user_id == user_id, Item.project_id == project_id, Item.deal == deal, Item.it_content == content, Item.it_time == it_time, Item.picture == picture)
    return newItem
예제 #3
0
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() 
예제 #4
0
def set_multiitem_dealed(it_id_list):
    for it_id in it_id_list:
        query = Item.update(deal = 1).where(Item.it_id == it_id)
        query.execute()
예제 #5
0
def set_item_dealed(it_id):
    query = Item.update(deal = 1).where(Item.it_id == it_id)
    query.execute()