fuelen

fuelen

Hey
I want to introduce you a small utility that may help in writing dynamic queries :slight_smile:

In a few words, this code:

blank_string? = fn string -> String.trim(string) == "" end
query = some_complex_query()

query =
  if not is_binary(params[:some_field1]) or blank_string?.(params[:some_field1]) do
    query
  else
    query |> where(some_field1: ^params[:some_field1])
  end

query =
  if is_nil(params[:some_field2]) do
    query
  else
    query |> where(some_field2: ^params[:some_field2])
  end

query |> Repo.all()

can be reorganzied to this:

blank_string? = fn string -> String.trim(string) == "" end

some_complex_query()
|> Composite.new(params)
|> Composite.param(:somefield1, &where(&1, some_field1: ^&2),
  ignore?: &(not is_binary(&1) or blank_string?.(&1))
)
|> Composite.param(:some_field2, &where(&1, some_field2: ^&2))
|> Repo.all()

However, library can be used not only with Ecto.
For more complex example with joins check test file.

Currently, it is not published to hex and available only on Github
https://github.com/fuelen/composite
Any feedback is welcome! :slight_smile:

Showing Posts 1 to 5

thojanssens1

thojanssens1

Aren’t Changesets used for parameter validations?

fuelen

fuelen OP

For validation - yes, but this library is about optional application.

fuelen

fuelen OP

One and a half years have passed, the library has version 0.4 and has better docs with examples.
Check it out here composite v0.6.0 — Documentation

fuelen

fuelen OP

Published an article about the library

fuelen

fuelen OP

Composite v0.7.0 is out :tada:

It adds apply_tagged/1,3 for detecting unchanged queries and fixes dependency ordering and strict nested params.

— All posts loaded —

Where Next? Top

Trending in Announcing Top

wojtekmach
Hey everyone! Req is an HTTP client for Elixir that I’ve been working on for quite some time. There is already a lot of HTTP clients out...
New
handnot2
Samly can be used to enable SAML 2.0 Single Sign On in a Plug/Phoenix application. This library uses Erlang esaml to provide plug enabl...
New
woylie
Flop is an Elixir library that applies filtering, ordering and pagination parameters to your Ecto queries. offset-based pagination with...
New
MRdotB
I needed to reuse React components from my Chrome extension in my Phoenix/LiveView backend. I noticed that for Svelte/Vue, there are live...
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
fuelen
Hi all! I want to present a small library which provides a mix task for generating an Entity-Relationship Diagram for Ecto schemas. You...
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
AstonJ
This showed up on my feed.. anyone heard of it? Just hype? Ox Alpha is a reasoning model designed for coding, sustained ag...
New
sergio
It’s not that it’s vocabulary is too advanced. It’s something worse. I get lost trying to follow even a paragraph written by Claude. It’...
New
sorenone
Today we’re releasing Oban for Python. Not an Oban client in Python. Not a pythonx wrapper embedded in Elixir. Nope, it’s a fully operati...
New
akoutmos
@hugobarauna, Dr. Dimitrios Koutmos (my brother) and I (Alex Koutmos) have been hard at work on writing a book on how you can use Elixir ...
New
pferriby
Introductory paragraph I’ll be looking for a keen junior or someone that has a couple of years experience in the real world (so you’ve be...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews