sqlalchemy.sql.operators

module documentation

Defines operators used in SQL expressions.
Class ​Column​Operators Defines boolean, comparison, and other operators for _expression.ColumnElement expressions.
Class ​Operators Base of comparison and logical operators.
Function ​_escaped​_like​_impl Undocumented
Function all​_op Undocumented
Function any​_op Undocumented
Function as​_ Undocumented
Function asc​_op Undocumented
Function between​_op Undocumented
Function collate Undocumented
Function comma​_op Undocumented
Function commutative​_op Undocumented
Function comparison​_op Undocumented
Function concat​_op Undocumented
Function contains​_op Undocumented
Function desc​_op Undocumented
Function distinct​_op Undocumented
Function endswith​_op Undocumented
Function exists Undocumented
Function filter​_op Undocumented
Function from​_ Undocumented
Function function​_as​_comparison​_op Undocumented
Function ilike​_op Undocumented
Function in​_op Undocumented
Function is​_ Undocumented
Function is​_associative Undocumented
Function is​_boolean Undocumented
Function is​_commutative Undocumented
Function is​_comparison Undocumented
Function is​_distinct​_from Undocumented
Function is​_false Undocumented
Function is​_natural​_self​_precedent Undocumented
Function is​_not Undocumented
Function is​_not​_distinct​_from Undocumented
Function is​_ordering​_modifier Undocumented
Function is​_precedent Undocumented
Function is​_true Undocumented
Function json​_getitem​_op Undocumented
Function json​_path​_getitem​_op Undocumented
Function like​_op Undocumented
Function match​_op Undocumented
Function mirror rotate a comparison operator 180 degrees.
Function not​_between​_op Undocumented
Function not​_contains​_op Undocumented
Function not​_endswith​_op Undocumented
Function not​_ilike​_op Undocumented
Function not​_in​_op Undocumented
Function not​_like​_op Undocumented
Function not​_match​_op Undocumented
Function not​_regexp​_match​_op Undocumented
Function not​_startswith​_op Undocumented
Function nulls​_first​_op Undocumented
Function nulls​_last​_op Undocumented
Function op Undocumented
Function regexp​_match​_op Undocumented
Function regexp​_replace​_op Undocumented
Function startswith​_op Undocumented
Constant ​_PRECEDENCE Undocumented
Variable ​_asbool Undocumented
Variable ​_associative Undocumented
Variable ​_booleans Undocumented
Variable ​_commutative Undocumented
Variable ​_comparison Undocumented
Variable ​_largest Undocumented
Variable ​_mirror Undocumented
Variable ​_natural​_self​_precedent Operators where if we have (a op b) op c, we don't want to parenthesize (a op b).
Variable ​_smallest Undocumented
def _escaped_like_impl(fn, other, escape, autoescape):

Undocumented

def all_op(a):

Undocumented

def any_op(a):

Undocumented

def as_():

Undocumented

def asc_op(a):

Undocumented

@comparison_op
def between_op(a, b, c, symmetric=False):

Undocumented

def collate(a, b):

Undocumented

def comma_op(a, b):

Undocumented

def commutative_op(fn):

Undocumented

def comparison_op(fn):

Undocumented

def concat_op(a, b):

Undocumented

@comparison_op
def contains_op(a, b, escape=None, autoescape=False):

Undocumented

def desc_op(a):

Undocumented

def distinct_op(a):

Undocumented

@comparison_op
def endswith_op(a, b, escape=None, autoescape=False):

Undocumented

def exists():

Undocumented

def filter_op(a, b):

Undocumented

def from_():

Undocumented

@comparison_op
def function_as_comparison_op():

Undocumented

@comparison_op
def ilike_op(a, b, escape=None):

Undocumented

@comparison_op
def in_op(a, b):

Undocumented

@comparison_op
def is_(a, b):

Undocumented

def is_associative(op):

Undocumented

def is_boolean(op):

Undocumented

def is_commutative(op):

Undocumented

def is_comparison(op):

Undocumented

@comparison_op
def is_distinct_from(a, b):

Undocumented

def is_false(a):

Undocumented

def is_natural_self_precedent(op):

Undocumented

@comparison_op
def is_not(a, b):

Undocumented

@comparison_op
def is_not_distinct_from(a, b):

Undocumented

def is_ordering_modifier(op):

Undocumented

def is_precedent(operator, against):

Undocumented

def is_true(a):

Undocumented

def json_getitem_op(a, b):

Undocumented

def json_path_getitem_op(a, b):

Undocumented

@comparison_op
def like_op(a, b, escape=None):

Undocumented

@comparison_op
def match_op(a, b, **kw):

Undocumented

def mirror(op):

rotate a comparison operator 180 degrees.

Note this is not the same as negation.

@comparison_op
def not_between_op(a, b, c, symmetric=False):

Undocumented

@comparison_op
def not_contains_op(a, b, escape=None, autoescape=False):

Undocumented

@comparison_op
def not_endswith_op(a, b, escape=None, autoescape=False):

Undocumented

@comparison_op
def not_ilike_op(a, b, escape=None):

Undocumented

@comparison_op
def not_in_op(a, b):

Undocumented

@comparison_op
def not_like_op(a, b, escape=None):

Undocumented

@comparison_op
def not_match_op(a, b, **kw):

Undocumented

@comparison_op
def not_regexp_match_op(a, b, flags=None):

Undocumented

@comparison_op
def not_startswith_op(a, b, escape=None, autoescape=False):

Undocumented

def nulls_first_op(a):

Undocumented

def nulls_last_op(a):

Undocumented

def op(a, opstring, b):

Undocumented

@comparison_op
def regexp_match_op(a, b, flags=None):

Undocumented

def regexp_replace_op(a, b, replacement, flags=None):

Undocumented

@comparison_op
def startswith_op(a, b, escape=None, autoescape=False):

Undocumented

_PRECEDENCE =

Undocumented

Value
{from_: 15,
 function_as_comparison_op: 15,
 any_op: 15,
 all_op: 15,
 getitem: 15,
 json_getitem_op: 15,
 json_path_getitem_op: 15,
...
_asbool =

Undocumented

_associative =

Undocumented

_booleans =

Undocumented

_commutative =

Undocumented

_comparison =

Undocumented

_largest =

Undocumented

_mirror =

Undocumented

_natural_self_precedent =
Operators where if we have (a op b) op c, we don't want to parenthesize (a op b).
_smallest =

Undocumented