phunsukh1

phunsukh1

Search for text pattern in a list

Hello All,
I am building a small website using Elixir/Phoenix and Mnesia as the backend database. The site is simple so mnesia works for us. I added ecto3_mnesia to use some of the Ecto’s functionality. Everything works great. We ran into a small issue when trying to search for a text. sort of like Postgresql’s like functionality.

Is there anyway to use like with mnesia?. If that is not an option, how can i search for a pattern using Enum? i.e., if i have a list of maps, I want to search for a text within some fields in the map.

Appreciate your help.
Regards,
Phunsukh

Most Liked

ericgray

ericgray

It would help if you could show us an example of what you’re trying to accomplish. A sample list of maps and what kind of text are you trying to find. Also what have you tried so far.

APB9785

APB9785

Creator of ECSx

I’m sure Mnesia provides a proper way to do it, but just to answer your second question about Enum, you can easily search through maps with something like:

Enum.filter(
  list_of_maps,
  &Enum.find(&1, fn {_key, value} ->
    String.contains?(value, search_query)
  end)
)

This will return all maps where search_query was found in the values. If you only want to return the first map where search_query was found, just replace Enum.filter with Enum.find. In this naive example it will search all fields because key is ignored, but you could search specific fields with a variety of simple methods, such as pattern matching, adding a guard, or simply Kernel.and/2. And if it’s just a single field you can remove Enum.find entirely:

Enum.filter(list_of_maps, fn m ->
  String.contains?(m[search_field], search_query)
end)

Where Next?

Popular in Questions Top

joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 records...
New
Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
komlanvi
Hi everyone, I was playing with phoenix liveView but I run into an issue. I have a form and want to validate each input text when the te...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New
svb
Hi! Currently I want to submit a form by pressing the Enter key. However, since my input field is of type “textarea” this is just adds a...
New

Other popular topics Top

electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
nobody
Hi! In PHP: $_SERVER[‘SERVER_ADDR’] - in Elixir? Searched the docs for ip address and the web, no good results. Thanks!
New
JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
gausby
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
1207 40165 209
New
bsollish-terakeet
Credo is smart enough to check for (something like) this: assert length(the_list) == 0 with this response: Checking if an enum is empt...
New

We're in Beta

About us Mission Statement