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'