Query all - Githubissues

dwyl / alog

🌲 alog (Append-only Log) is an easy way to start using the Lambda/Kappa architecture in your Elixir/Phoenix Apps while still using PostgreSQL (with Ecto).

GNU General Public License v2.0

15 stars 2 forks source link

Query all #54

Closed SimonLab closed 5 years ago

SimonLab commented 5 years ago

ref: #40

This PR is based on #50 (thanks @RobStallion , it's much easier to have a common base :+1: )

When Repo.all(query) is called we need to

[x] order the elements of the query by inserted_at value
[x] add "distinct on" the entry_id to make sure to get the latest version of the item
[x] Then with the two added points above, create a subquery and select only the element of these subquery which are not deleted

RobStallion commented 5 years ago

@SimonLab this is looking really good 👍