bee.condition

class Condition(abc.ABC):

Condition: used to construct complex WHERE, UPDATE statements and so on.

@abstractmethod
def op( self, field: str, op: bee.bee_enum.Op, value: Any) -> Condition:
@abstractmethod
def opWithField( self, field: str, op: bee.bee_enum.Op, field2: str) -> Condition:
@abstractmethod
def and_(self) -> Condition:
@abstractmethod
def or_(self) -> Condition:
@abstractmethod
def not_(self) -> Condition:
@abstractmethod
def l_parentheses(self) -> Condition:
@abstractmethod
def r_parentheses(self) -> Condition:
@abstractmethod
def between(self, field: str, low: Any, high: Any) -> Condition:
@abstractmethod
def groupBy(self, field: str) -> Condition:
@abstractmethod
def having( self, functionType: bee.bee_enum.FunctionType, field: str, op: bee.bee_enum.Op, value: Any) -> Condition:
@abstractmethod
def orderBy(self, field: str) -> Condition:
@abstractmethod
def orderBy2( self, field: str, orderType: bee.bee_enum.OrderType) -> Condition:
@abstractmethod
def orderBy3( self, functionType: bee.bee_enum.FunctionType, field: str, orderType: bee.bee_enum.OrderType) -> Condition:

eg: orderBy3(FunctionType.MAX, "total", OrderType.DESC)-->order by max(total) desc

@abstractmethod
def selectField(self, *field: str) -> Condition:
@abstractmethod
def start(self, start: int) -> Condition:
@abstractmethod
def forUpdate(self) -> Condition:
@abstractmethod
def size(self, size: int) -> Condition:
@abstractmethod
def suidType(self, suidType: bee.bee_enum.SuidType) -> Condition:
@abstractmethod
def getSuidType(self) -> Condition:
@abstractmethod
def setAdd(self, field: str, value: int) -> Condition:
@abstractmethod
def setMultiply(self, field: str, value: int) -> Condition:
@abstractmethod
def setAdd2(self, field1: str, field2: str) -> Condition:
@abstractmethod
def setMultiply2(self, field1: str, field2: str) -> Condition:
@abstractmethod
def set(self, field: str, value: Any) -> Condition:
@abstractmethod
def setWithField(self, field1: str, field2: str) -> Condition:
@abstractmethod
def setNull(self, field: str) -> Condition: