def update(self, key_values=None, **kw): kw.setdefault('table', self._tables) kw.setdefault('fields', self._fields) kw.setdefault('where', self._where) kw.setdefault('order_by', self._order_by) kw.setdefault('limit', self._limit) return self.result(factory.get(self).Update(mapping=key_values, **kw)).update()
def hint(self, expr): return factory.get(self).TableJoin(self).hint(expr)
def natural(self): return factory.get(self).TableJoin(self).natural()
def cross_join(self, right): return factory.get(self).TableJoin(self).cross_join(right)
def on(self, cond): return factory.get(self).TableJoin(self).on(cond)
def as_(self, alias): return factory.get(self).TableAlias(self, alias)
def right_join(self, right): return factory.get(self).TableJoin(self).right_join(right)
def difference(self, *others): return self._op(factory.get(self).Except, *others)
def union(self, *others): return self._op(factory.get(self).Union, *others)
def intersection(self, *others): return self._op(factory.get(self).Intersect, *others)
def raw(self, sql, params=()): return factory.get(self).Raw(sql, params, result=self.result)
def as_set(self, all=False): return factory.get(self).Set(self, all=all, result=self.result)
def delete(self, **kw): kw.setdefault('table', self._tables) kw.setdefault('where', self._where) kw.setdefault('order_by', self._order_by) kw.setdefault('limit', self._limit) return self.result(factory.get(self).Delete(**kw)).delete()
def inner_join(self, right): return factory.get(self).TableJoin(self).inner_join(right)
def using(self, *fields): return factory.get(self).TableJoin(self).using(*fields)
def full_join(self, right): return factory.get(self).TableJoin(self).full_join(right)
def join(self, join_type, obj): return factory.get(self).TableJoin(self).join(join_type, obj)
def insert(self, key_values=None, **kw): kw.setdefault('table', self._tables) kw.setdefault('fields', self._fields) return self.result(factory.get(self).Insert(mapping=key_values, **kw)).insert()