def _in(self, operator, right):
from vulkn.types.integer import UInt8
from vulkn.datatable import VulknDataTable
in_arg = None
if hasattr(right, 'show_sql'):
in_arg = right.show_sql()[0:-1]
elif isinstance(right, list):
if isinstance(right[0], str):
in_arg = "'{}'".format("','".join(map(str, right)))
else:
in_arg = ','.join(map(str, right))
else:
in_arg = str(right)
return UInt8(Literal('{} {} ({})'.format(self._value, operator, in_arg)))
def JSONExtractBool(self, *indices_or_keys):
return UInt8(func('JSONExtractBool', self._value, *indices_or_keys))
def JSONHas(self, *indices_or_keys):
return UInt8(func('JSONHas', self._value, *indices_or_keys))
def visitParamExtractBool(self, name):
return UInt8(func('visitParamExtractBool', self._value, name))
def visitParamHas(self, name):
return UInt8(func('visitParamHas', self._value, name))
def like(self, pattern: str):
return UInt8(func('like', self._value, pattern))
def __xor__(self, right) -> any:
from vulkn.types.integer import UInt8
return UInt8(func('xor', self._value, right))
def __invert__(self) -> any:
from vulkn.types.integer import UInt8
return UInt8(func('bitNot', self._value))
def not_(self) -> any:
from vulkn.types.integer import UInt8
return UInt8(func('not', self._value))
def __and__(self, right) -> any:
from vulkn.types.integer import UInt8
return UInt8(func('bitAnd', self._value, right))
def __le__(self, right) -> any:
from vulkn.types.integer import UInt8
return UInt8(func('lessOrEquals', self._value, right))
def notBetween(self, start, end):
from vulkn.types.integer import UInt8
return UInt8(Literal('{} NOT BETWEEN {} AND {}'.format(self._value, start, end)))
def isNotNull(self):
from vulkn.types.integer import UInt8
return UInt8(func('isNotNull', self._value))