Paginator ignores sort direction

I’m not using limit/offset. I want to use cursor based paging.

If you’re just doing offset/limit or keyset why not just write it yourself?

Thank you. I switched to Flop and am getting similar behaviour:

Query before being executed:

#Ecto.Query<from c0 in Amplify.Models.ContestEntry,
 where: c0.contest_id == ^"2", where: not is_nil(c0.prize_id)>

Flop parameters:

%{
  "after" => nil,
  "before" => nil,
  "first" => 3,
  "order_by" => ["inserted_at"],
  "order_direction" => ["desc"]
}

How I’m calling it:

Flop.validate_and_run(query, params)

Actual query that’s run:

SELECT ... 
FROM "contest_entries" AS c0 WHERE (c0."contest_id" = $1) AND (NOT (c0."prize_id" IS NULL)) 
ORDER BY c0."inserted_at" LIMIT $2 [2, 4]

I expect it to execute ORDER BY c0."inserted_at" DESC but it’s not adding the DESC part.

I believe Paginator has been abandoned, and it is generally recommended that you migrate your code to Flop.