예제 #1
0
 def between(self, start, end) -> 'CriteriaInterface':
     return criteria('{} BETWEEN {} AND {}', self._statement, start, end)
예제 #2
0
 def lte(self, value) -> 'CriteriaInterface':
     return criteria('{} <= {}', self._statement, value)
예제 #3
0
 def is_not_null(self) -> 'CriteriaInterface':
     return criteria('{} IS NOT NULL', self._statement)
예제 #4
0
 def gt(self, value) -> 'CriteriaInterface':
     return criteria('{} > {}', self._statement, value)
예제 #5
0
 def not_eq(self, value) -> 'CriteriaInterface':
     return criteria('{} != {}', self._statement, value)
예제 #6
0
 def not_in(self, *args) -> 'CriteriaInterface':
     return criteria('{} NOT IN ({})', self._statement, listing(args))
예제 #7
0
 def in_(self, *args) -> 'CriteriaInterface':
     return criteria('{} IN ({})', self._statement, listing(args))
예제 #8
0
 def __not_like(self, value: 'StatementInterface') -> 'CriteriaInterface':
     return criteria('{} NOT LIKE {}', self._statement, value)