queries
=======

.. py:module:: queries

.. autoapi-nested-parse::

   Graph/Cypher queries used in Adapt.



Functions
---------

.. autoapisummary::

   queries._get_last_spend_date
   queries.get_continuous_moves_query
   queries.get_round_trips_query
   queries.get_shorty_moves_query
   queries.get_triangular_circuits_query


Module Contents
---------------

.. py:function:: _get_last_spend_date(delta)

.. py:function:: 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)

.. py:function:: 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)

.. py:function:: 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)

.. py:function:: 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)