Arsenalist

Arsenalist

I’m using the Paginator library and right before calling Repo.paginate(), I print the query which is:

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

This makes sense to me, but when I call paginate, it executes:

SELECT ... 
FROM "contest_entries" AS c0 
WHERE (c0."contest_id" = $1) AND (NOT (c0."prize_id" IS NULL)) AND (c0."inserted_at" < $2) 
ORDER BY c0."inserted_at" LIMIT $3 [2, ~U[2024-09-26 19:10:25Z], 4]

Notice that the executed ORDER BY does not have the DESC associated with it.

Could this be because I am passing before to paginator and it defaults to an ASC sort in that case when I really want a DESC sort? If so, how does Paginator handle traversing through a list sorted in reverse?

Showing Posts 1 to 4

arcyfelix

arcyfelix

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

Arsenalist

Arsenalist OP

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.

Schultzer

Schultzer

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

Arsenalist

Arsenalist OP

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

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
ryanwinchester
apply_graft/2 doesn’t rewrite an add_many sub-workflow’s deps on an add step. Grafted jobs cancel with “upstream job was deleted” Version...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge &amp; Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews