queries

Graph/Cypher queries used in Adapt.

Functions

_get_last_spend_date(delta)

get_continuous_moves_query(company_ids, ...[, ...])

get_round_trips_query(company_ids, incl_record_types, ...)

get_shorty_moves_query(company_ids, incl_record_types, ...)

get_triangular_circuits_query(company_ids, ...[, ...])

Module Contents

queries._get_last_spend_date(delta)
queries.get_continuous_moves_query(company_ids: list[list[int]], incl_record_types: list[str], internal_company_ids: list[int], run_type: str, equipment_class: str | list[str] = 'DRY', last_spend_date_delta_months: int = 12, min_miles: int | list[int] = 200, max_miles: int | list[int] = 2550, min_loads: int | list[int] = 100, max_loads: int | list[int] = 100000, total_miles: int = 2550, max_dead_pct: float = 0.05, limit: int = 50000)
Parameters:
queries.get_round_trips_query(company_ids: list[list[int]], incl_record_types: list[str], internal_company_ids: list[int], run_type: str, equipment_class: str | list[str] = 'DRY', last_spend_date_delta_months: int = 12, min_miles: int | list[int] = 100, max_miles: int | list[int] = 2550, min_loads: int | list[int] = 100, max_loads: int | list[int] = 100000, total_miles: int = 2550, max_dead_pct: float = 0.1, limit: int = 50000)
Parameters:
queries.get_shorty_moves_query(company_ids: list[list[int]], incl_record_types: list[str], internal_company_ids: list[int], run_type: str, equipment_class: str | list[str] = 'DRY', last_spend_date_delta_months: int = 12, min_miles: int | list[int] = 100, max_miles: int | list[int] = 2550, min_loads: int | list[int] = 10, max_loads: int | list[int] = 100000, total_miles: int = 2550, max_dead_pct: float = 0.05, shorty_min_miles: int = 75, shorty_max_miles: int = 200, limit: int = 50000)
Parameters:
queries.get_triangular_circuits_query(company_ids: list[list[int]], incl_record_types: list[str], internal_company_ids: list[int], run_type: str, equipment_class: str | list[str] = 'DRY', last_spend_date_delta_months: int = 12, min_miles: int | list[int] = 100, max_miles: int | list[int] = 2550, min_loads: int | list[int] = 100, max_loads: int | list[int] = 100000, total_miles: int = 2550, max_dead_pct: float = 0.1, deadheads: list[str] = [':SHORT_DEADHEADS_TO|:LONG_DEADHEADS_TO', ':SHORT_DEADHEADS_TO|:LONG_DEADHEADS_TO'], limit: int = 50000)
Parameters: