def update_assignment(task_id, type, target, charge_id, charge_name, deadline): """ 政府人员更新任务信息,包含 任务名,目标,负责人,截至日期等 """ sql = "update assignment set type=?, task_target=?, charger_id=?, charger_name=?, deadline=? where task_id=?" return db.update(sql, type, target, charge_id, charge_name, deadline, task_id)
def check_news(news_id): """ 进行已读操作 """ sql = "update station_news set news_status = 1 where news_id = %s".format( news_id) result = db.update(sql, news_id) return result
def update_history_time(search_text): """ 更新该搜索文本所在行的时间 :param search_text: :return: """ sql = """ update search_history set gmt_create = now() where search_text = ? """ return db.update(sql, search_text, bind='data_mining')
def update_record_status(record_id, status): """ 更新记录状态 """ sql = "update submit_record set audit_status=? where record_id=?" return db.update(sql, status, record_id)
def update_year_target(id, numbers): """ 用户更新年度目标 """ sql = "update target set numbers=? where id=?" return db.update(sql, numbers, id)
def update_assignment_progress(task_id, progress): """ 服务商修改完成度 """ sql = "update assignment set progress=progress + ? where task_id=?" return db.update(sql, progress, task_id)
def update_assignment_status(task_id, status): """ 修改任务的状态 """ sql = "update assignment set status=? where task_id=?" return db.update(sql, status, task_id)