phunsukh1

phunsukh1

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

Showing Posts 1 to 2

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)
— 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
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
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
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
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

Other Trending Topics Top

JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
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
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
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
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

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews