CODEWITHSUNDEEP
postgresqlelixirphoenix-frameworkecto
Philip Claren
Philip Claren

Reputation: 2896

How to get PostgreSQL hashes in Phoenix's Ecto models?

I want to define a PostgreSQL-Hash type field in my Ecto model but I'm not sure how to do it. I haven't found an explicit guide on this topic and I'm assuming it's somewhere hidden in here: http://hexdocs.pm/ecto/Ecto.Schema.html

Has anyone the definite guide to do PostgreSQL-Hash fields in Ecto?

Upvotes: 8

Views: 522

Answers (1)

Philip Claren
Philip Claren

Reputation: 2896

As JustMichael stated, the answer is the :map type.

The table definition:

CREATE TABLE public.authors (
  id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('authors_id_seq'::regclass),
  settings HSTORE,
  updated_at TIMESTAMP WITHOUT TIME ZONE,
  inserted_at TIMESTAMP WITHOUT TIME ZONE
);

The Ecto model:

defmodule Nexus.Author do
  use Nexus.Web, :model

  schema "authors" do
    field :settings, :map
    timestamps
  end
end

Now I can get access the settings Nexus.Repo.get(Author, some_id).settings and get a map in return.

Upvotes: 4

Related Questions