cymple.builder.LimitAvailable
- class cymple.builder.LimitAvailable(query)
Bases:
QueryStartAvailable
,Unwind
,Where
,CaseWhen
,Return
,Set
,Skip
,Union
A class decorator declares a Limit is available in the current query.
- __init__(query)
Initialize the query object.
Methods
__init__
(query)Initialize the query object.
call
()Concatenate the "CALL" clause.
case_when
(filters, on_true, on_false, ref_name)Concatenate a CASE WHEN clause to the query, created from a list of given property filters.
create
()Concatenate the "CREATE" clause.
cypher
(cypher_query_str)Concatenate a cypher query string
get
()Get the final query string .
match
()Concatenate the "MATCH" clause.
Concatenate the "MATCH" clause.
merge
()Concatenate the "MERGE" clause.
return_literal
(literal)Concatenate a literal RETURN statement.
return_mapping
(mappings)Concatenate a RETURN statement for multiple objects.
set
(properties[, escape_values])Concatenate a SET clause, using the given properties map.
skip
(skip_count)Concatenate a skip statement.
union
()Combines the results of two or more queries.
Combines the results of two or more queries including duplicates.
unwind
(variables)Concatenate an UNWIND clause, keeping one or more variables given in 'variables' arg.
where
(name, comparison_operator, value, **kwargs)Concatenate a WHERE clause to the query, created as {name} {comparison_operator} {value}.
where_literal
(statement, **kwargs)Concatenate a literal WHERE clause to the query.
where_multiple
(filters[, ...])Concatenate a WHERE clause to the query, created from a list of given property filters.
with_
(variables)Concatenate a WITH clause, keeping one or more variables given in 'variables' arg.
- call()
Concatenate the “CALL” clause.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- case_when(filters: dict, on_true: str, on_false: str, ref_name: str, comparison_operator: str = '=', boolean_operator: str = 'AND', **kwargs)
Concatenate a CASE WHEN clause to the query, created from a list of given property filters.
- Parameters:
filters (dict) – A dict representing the set of properties to be filtered
on_true (str) – The query to run when the predicate is true
on_false (str) – The query to run when the predicate is false
ref_name (str) – The name which is used to refer to the newly filtered object
comparison_operator (str) – A string operator, according to which the comparison between property values is done, e.g. for “=”, we get: property.name = property.value, defaults to “=”
boolean_operator (str) – The boolean operator to apply between predicates, defaults to “AND”
**kwargs –
kwargs
:type **kwargs
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- create()
Concatenate the “CREATE” clause.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- cypher(cypher_query_str)
Concatenate a cypher query string
- get()
Get the final query string .
- match()
Concatenate the “MATCH” clause.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- match_optional()
Concatenate the “MATCH” clause.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- merge()
Concatenate the “MERGE” clause.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- return_literal(literal: str)
Concatenate a literal RETURN statement.
- Parameters:
literal (str) – A Cypher string describing the objects to be returned, referencing name/names which were defined earlier in the query
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- return_mapping(mappings: List[Mapping])
Concatenate a RETURN statement for multiple objects.
- Parameters:
mappings (List[Mapping]) – The mapping (or a list of mappings) of db property names to code names, to be returned
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- set(properties: dict, escape_values: bool = True)
Concatenate a SET clause, using the given properties map.
- Parameters:
properties (dict) – A dict to be used to set the variables with their corresponding values
escape_values (bool) – Determines whether the properties values should be escaped or not, defaults to True
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- skip(skip_count: int | str)
Concatenate a skip statement.
- Parameters:
skip_count (Union[int, str]) – A non-negative integer or a string of cypher expression that evaluates to a non-negative integer (as long as it is not referring to any external variables)
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- union()
Combines the results of two or more queries. Duplicates are removed.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- union_all()
Combines the results of two or more queries including duplicates.
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- unwind(variables: str)
Concatenate an UNWIND clause, keeping one or more variables given in ‘variables’ arg.
- Parameters:
variables (str) – A string refering to previously obtained variables, comma seperated
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- where(name: str, comparison_operator: str, value: str, **kwargs)
Concatenate a WHERE clause to the query, created as {name} {comparison_operator} {value}. E.g. x = ‘abc’.
- Parameters:
name (str) – The name of the object which is to be used in the comparison
comparison_operator (str) – A string operator, according to which the comparison between compared object and the {value} is done, e.g. for “=”, we get: {name} = {value}
value (str) – The value which is compared against
**kwargs –
kwargs
:type **kwargs
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- where_literal(statement: str, **kwargs)
Concatenate a literal WHERE clause to the query.
- Parameters:
statement (str) – A literal string of the required filter
**kwargs –
kwargs
:type **kwargs
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- where_multiple(filters: dict, comparison_operator: str = '=', boolean_operator: str = ' AND ', **kwargs)
Concatenate a WHERE clause to the query, created from a list of given property filters.
- Parameters:
filters (dict) – A dict representing the set of properties to be filtered
comparison_operator (str) – A string operator, according to which the comparison between property values is done, e.g. for “=”, we get: property.name = property.value, defaults to “=”
boolean_operator (str) – The boolean operator to apply between predicates, defaults to ‘ AND ‘
**kwargs –
kwargs
:type **kwargs
- Returns:
A Query object with a query that contains the new clause.
- Return type:
- with_(variables: str)
Concatenate a WITH clause, keeping one or more variables given in ‘variables’ arg.
- Parameters:
variables (str) – A string refering to previously obtained variables, comma seperated
- Returns:
A Query object with a query that contains the new clause.
- Return type: