def POST(self):
d = web.input()
name = d.name
if name == "":
return "name is null"
from mysql import getDb
rst = getDb().query("select count(*) CT from py_addrbook where name = $name", vars=locals())
if rst[0].CT > 0:
getDb().update(
"py_addrbook",
name=d.name,
mobile=d.mobile,
addr=d.addr,
qq=d.qq,
wechat=d.wechat,
other=d.other,
where="name=$name",
vars=locals(),
)
return "Update Success!Thanks!"
getDb().insert(
"py_addrbook", name=d.name, mobile=d.mobile, addr=d.addr, qq=d.qq, wechat=d.wechat, other=d.other
)
return "Success!Thanks!"
def POST(self):
d = web.input()
name = d.name
if name == "":
return "name is null"
from mysql import getDb
rst = getDb().query(
"select count(*) CT from py_addrbook where name = $name",
vars=locals())
if rst[0].CT > 0:
getDb().update('py_addrbook',
name=d.name,
mobile=d.mobile,
addr=d.addr,
qq=d.qq,
wechat=d.wechat,
other=d.other,
where="name=$name",
vars=locals())
return "Update Success!Thanks!"
getDb().insert('py_addrbook',
name=d.name,
mobile=d.mobile,
addr=d.addr,
qq=d.qq,
wechat=d.wechat,
other=d.other)
return 'Success!Thanks!'
def modify(self,**kwargs): params = copy(self) try: params['where'] = kwargs['where'] params['vars'] = kwargs['vars'] except: params['where']='id='+str(self.id) getDb().update(self.__table__,**params)
def modify(self, **kwargs):
params = copy(self)
try:
params['where'] = kwargs['where']
params['vars'] = kwargs['vars']
except:
params['where'] = 'id=' + str(self.id)
getDb().update(self.__table__, **params)
def GET(self):
d = web.input()
name = d.name
if name == "":
return ""
from mysql import getDb
import json
rst = getDb().query("select * from py_addrbook where name=$name",
vars=locals())
return json.dumps(package(rst))
def GET(self):
d = web.input()
name = d.name
if name == "":
return ""
from mysql import getDb
import json
rst = getDb().query("select * from py_addrbook where name=$name", vars=locals())
return json.dumps(package(rst))
def execute(cls,sql,**kwargs): rs = getDb().query(sql,**kwargs) ''' if(isinstance(rs, long)): return rs else: for rcd in rs: rcd = dict(rcd) lst.append(rcd) return lst ''' return rs
def execute(cls, sql, **kwargs):
rs = getDb().query(sql, **kwargs)
'''
if(isinstance(rs, long)):
return rs
else:
for rcd in rs:
rcd = dict(rcd)
lst.append(rcd)
return lst
'''
return rs
def GET(self):
from mysql import getDb
rst = getDb().query("select * from py_addrbook ", vars=locals())
addTxt = u'姓名,手机,现住址,QQ,微信,其他\n'
for rcd in rst:
addTxt += rcd.name + "," + rcd.mobile + "," + rcd.addr + "," + rcd.qq + "," + rcd.wechat + "," + rcd.other + "\n"
import StringIO, codecs
s = StringIO.StringIO()
s.write(unicode(codecs.BOM_UTF8, "utf-8"))
s.write(addTxt)
s.seek(0)
web.header("Content-Type",
"text/csv;charset=utf-8") #content-type需要根据实际的文件类型来指定
web.header("Content-Disposition", "attachment;filename=0411.csv")
while True:
c = s.read(2048)
if c:
yield c
else:
break
def GET(self):
from mysql import getDb
rst = getDb().query("select * from py_addrbook ", vars=locals())
addTxt = u"姓名,手机,现住址,QQ,微信,其他\n"
for rcd in rst:
addTxt += (
rcd.name + "," + rcd.mobile + "," + rcd.addr + "," + rcd.qq + "," + rcd.wechat + "," + rcd.other + "\n"
)
import StringIO, codecs
s = StringIO.StringIO()
s.write(unicode(codecs.BOM_UTF8, "utf-8"))
s.write(addTxt)
s.seek(0)
web.header("Content-Type", "text/csv;charset=utf-8") # content-type需要根据实际的文件类型来指定
web.header("Content-Disposition", "attachment;filename=0411.csv")
while True:
c = s.read(2048)
if c:
yield c
else:
break
def GET(self):
from mysql import getDb
rst = getDb().query("select * from py_addrbook ", vars=locals())
render = web.template.render('templates')
return render.ab(rst)
def find(cls,**kwargs): rs = getDb().select(cls.__table__,**kwargs) return rs
def save(self): it = getDb().insert(self.__table__,**self) setattr(self, 'id', it) return it
def find(cls, **kwargs):
rs = getDb().select(cls.__table__, **kwargs)
return rs
def save(self):
it = getDb().insert(self.__table__, **self)
setattr(self, 'id', it)
return it
def GET(self):
from mysql import getDb
rst = getDb().query("select * from py_addrbook ", vars=locals())
render = web.template.render("templates")
return render.ab(rst)
