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)
