def update(self, where, **kwargs): fields, params = self._get_update_params(**kwargs) if where: where = " AND %s" % where sql = "UPDATE %s SET %s WHERE 1=1 %s" % (self.table, fields, where) print(sql) return dbhelper.execute_with_params(sql,params)
def delete(self, **kwargs): sql = "DELETE FROM %s %s" % (self.table, self._get_where(**kwargs)) params = kwargs return dbhelper.execute_with_params(sql,params)