@spec state_for(Lightning.Run.t()) :: Ecto.Query.t()

Query to calculate the current state of a workorder.

It takes a run, as the state is updated after each run is changed.

The logic is as follows:

• All other Runs that are not in a finished state are considered first.
• The current Run is unioned onto the unfinished runs with a null ordinality.
• The runs are ordered by state in the following order started > claimed > available > null
• The run states are then mapped to the workorder state enum: available is mapped to pending (the only run state Lightning can still cancel atomically), while claimed and started are both mapped to running.

The null ordinality ensures that the current run is always last in the ordering.