示例#1
0
 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()
示例#2
0
 def hint(self, expr):
     return factory.get(self).TableJoin(self).hint(expr)
示例#3
0
 def natural(self):
     return factory.get(self).TableJoin(self).natural()
示例#4
0
 def cross_join(self, right):
     return factory.get(self).TableJoin(self).cross_join(right)
示例#5
0
 def on(self, cond):
     return factory.get(self).TableJoin(self).on(cond)
示例#6
0
 def as_(self, alias):
     return factory.get(self).TableAlias(self, alias)
示例#7
0
 def right_join(self, right):
     return factory.get(self).TableJoin(self).right_join(right)
示例#8
0
 def difference(self, *others):
     return self._op(factory.get(self).Except, *others)
示例#9
0
 def as_(self, alias):
     return factory.get(self).TableAlias(self, alias)
示例#10
0
 def union(self, *others):
     return self._op(factory.get(self).Union, *others)
示例#11
0
 def intersection(self, *others):
     return self._op(factory.get(self).Intersect, *others)
示例#12
0
 def raw(self, sql, params=()):
     return factory.get(self).Raw(sql, params, result=self.result)
示例#13
0
 def as_set(self, all=False):
     return factory.get(self).Set(self, all=all, result=self.result)
示例#14
0
 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()
示例#15
0
 def natural(self):
     return factory.get(self).TableJoin(self).natural()
示例#16
0
 def inner_join(self, right):
     return factory.get(self).TableJoin(self).inner_join(right)
示例#17
0
 def using(self, *fields):
     return factory.get(self).TableJoin(self).using(*fields)
示例#18
0
 def right_join(self, right):
     return factory.get(self).TableJoin(self).right_join(right)
示例#19
0
 def inner_join(self, right):
     return factory.get(self).TableJoin(self).inner_join(right)
示例#20
0
 def full_join(self, right):
     return factory.get(self).TableJoin(self).full_join(right)
示例#21
0
 def full_join(self, right):
     return factory.get(self).TableJoin(self).full_join(right)
示例#22
0
 def cross_join(self, right):
     return factory.get(self).TableJoin(self).cross_join(right)
示例#23
0
 def join(self, join_type, obj):
     return factory.get(self).TableJoin(self).join(join_type, obj)
示例#24
0
 def join(self, join_type, obj):
     return factory.get(self).TableJoin(self).join(join_type, obj)
示例#25
0
 def hint(self, expr):
     return factory.get(self).TableJoin(self).hint(expr)
示例#26
0
 def on(self, cond):
     return factory.get(self).TableJoin(self).on(cond)
示例#27
0
 def using(self, *fields):
     return factory.get(self).TableJoin(self).using(*fields)
示例#28
0
 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()