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 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 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 remove(self):
getDb().delete(self.__table__,where="id="+self.id)
print 'remove'
