l.s.d.stormexpr : module documentation

Part of lp.services.database

No module docstring
Class BulkUpdate Undocumented
Function compile_bulkupdate Undocumented
Class Values Undocumented
Function compile_values Undocumented
Class ColumnSelect Undocumented
Function compile_columnselect Undocumented
Class Greatest Undocumented
Class CountDistinct Undocumented
Function compile_countdistinct Undocumented
Class Concatenate Storm operator for string concatenation.
Class NullCount Undocumented
Class Array Undocumented
Class TryAdvisoryLock Undocumented
Class AdvisoryUnlock Undocumented
Function compile_array Undocumented
Class ArrayAgg Aggregate values (within a GROUP BY) into an array.
Class Unnest Expand an array to a set of rows.
Class ArrayContains True iff the left side is a superset of the right side.
Class ArrayIntersects True iff the arrays have at least one element in common.
Class IsDistinctFrom True iff the left side is distinct from the right side.
Class NullsFirst Order null values before non-null values.
Class NullsLast Order null values after non-null values.
Class RegexpMatch Undocumented
Function get_where_for_reference Generate a column comparison expression for a reference property.
Function determine_table_and_fragment Undocumented
Function fti_search An expression ensuring that table rows match the specified text.
Function rank_by_fti Undocumented
Function _remote_variables A helper function to extract the foreign key values of an object.
Function _get_where_for_local_many Generate an OR or IN expression used to find others.
@compile.when(BulkUpdate)
def compile_bulkupdate(compile, update, state):
Undocumented
@compile.when(Values)
def compile_values(compile, expr, state):
Undocumented
@compile.when(ColumnSelect)
def compile_columnselect(compile, expr, state):
Undocumented
@compile.when(CountDistinct)
def compile_countdistinct(compile, countselect, state):
Undocumented
@compile.when(Array)
def compile_array(compile, array, state):
Undocumented
def get_where_for_reference(reference, other):
Generate a column comparison expression for a reference property.

The returned expression may be used to find referenced objects referring to C{other}.

If the right hand side is a collection of values, then an OR in IN expression is returned - if the relation uses composite keys, then an OR expression is used; single key references produce an IN expression which is more efficient for large collections of values.

def _remote_variables(relation, obj):
A helper function to extract the foreign key values of an object.
def _get_where_for_local_many(relation, others):
Generate an OR or IN expression used to find others.

If the relation uses composite keys, then an OR expression is used; single key references produce an IN expression which is more efficient for large collections of values.

def determine_table_and_fragment(table, ftq):
Undocumented
def fti_search(table, text, ftq=True):
An expression ensuring that table rows match the specified text.
def rank_by_fti(table, text, ftq=True):
Undocumented
API Documentation for Launchpad, generated by pydoctor at 2022-06-16 00:00:12.