def delete(self): """ 通过db对象的updata接口 执行sql sql:delete from `user` where `id` = %s,ARGS:(10190,) """ self.pre_delete and self.pre_delete() pk = self.__primary_key__.name args = (getattr(self, pk), ) db.updata('delete from `%s` where `%s`=?' % (self.__table__, pk), *args) return self
def updata(): if not session: return redirect("/login/") if request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} result = db.updata('user', data) return json.dumps(result)
def updata(self): self.pre_updata and self.pre_updata() L = [] args = [] for k, v in self.__mappings__.iteritems(): if v.updatable: if hasattr(self, k): arg = getattr(self, k) else: arg = v.default setattr(self, k, arg) L = append('`%s`=?' % k) args.append(arg) pk = self.__primary_key__.name args.append(getattr(self, pk)) db.updata( 'updata `%s` set %s where %s = ?' % (self.__table__, ','.join(L), pk), *args) return self
def jobbupdate(): if not session.get('username', None): return redirect("/login/") if request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} data['status'] = 2 data['deal_person'] = session['username'] data['deal_time'] = time.strftime("%Y-%m-%d %H:%M") result = db.updata("ops_jobs", data) return json.dumps(result) else: id = request.args.get('id') data = { 'id': id, 'status': 1, "deal_person": session["username"], 'deal_time': time.strftime("%Y-%m-%d %H:%M") } result = db.updata("ops_jobs", data) return json.dumps(result)
def cabinetupdate(): if not session: return redirect("/login/") if request.method == "GET": idc = db.getlist('idc', idc_field) idc = idc["msg"] data = {k: v[0] for k, v in dict(request.args).items()} result = db.getone('cabinet', cabinet_field, data) result = result["msg"] return render_template("cabinetupdate.html", result=result, idc=idc) elif request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} print data result = db.updata('cabinet', data) return json.dumps(result)
def chpwdoneself(): if not session: return redirect("/login/") if request.method == "POST": data = {k: v[0] for k, v in dict(request.form).items()} user = {} user["id"] = data["id"] result = db.getone('user', field, user) result = result['msg'] if data['oldpasswd'] == result['password']: user["password"] = data["newpasswd"] result = db.updata('user', user) return json.dumps(result) else: result = {'errmsg': "原密码错误"} return json.dumps(result)