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 as_(self, alias):
return factory.get(self).TableAlias(self, alias)
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 natural(self):
return factory.get(self).TableJoin(self).natural()
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 right_join(self, right):
return factory.get(self).TableJoin(self).right_join(right)
def inner_join(self, right):
return factory.get(self).TableJoin(self).inner_join(right)
def full_join(self, right):
return factory.get(self).TableJoin(self).full_join(right)
def full_join(self, right):
return factory.get(self).TableJoin(self).full_join(right)
def cross_join(self, right):
return factory.get(self).TableJoin(self).cross_join(right)
def join(self, join_type, obj):
return factory.get(self).TableJoin(self).join(join_type, obj)
def join(self, join_type, obj):
return factory.get(self).TableJoin(self).join(join_type, obj)
def hint(self, expr):
return factory.get(self).TableJoin(self).hint(expr)
def on(self, cond):
return factory.get(self).TableJoin(self).on(cond)
def using(self, *fields):
return factory.get(self).TableJoin(self).using(*fields)
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()