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 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)