dorian-marchal

dorian-marchal

How to insert an empty list in a `jsonb` column?

With this Ecto migration:

defmodule Migrations.Foo do
  use Ecto.Migration

  def change do
    create table(:foo, primary_key: false) do
      add(:id, :uuid, primary_key: true)
      add(:bars, :map, null: false)
    end
  end
end

I can’t get empty lists to be saved in the database.

This doesn’t work:

%Foo{bars: []} |> Repo.insert

# produces:
# ** (Postgrex.Error) ERROR 23502 (not_null_violation) null value in column "bars" violates not-null constraint

But this does work:

%Foo{bars: [%{foo: "bar"}]} |> Repo.insert

I tried to change my migration type to {:array, :map} but it doesn’t work either.

I can get around this by allowing null values and setting a default, like that add(:bars, :map, default: "[]") but it doesn’t seem right.

What am I missing?

First Post!

vlad.grb

vlad.grb

Can you share with us how your schema looks like?

For me it is weird. I’ve just tried basing on your input with the latest Ecto 3.4.4

defmodule EmptyJson.Repo.Migrations.CreateUser do
  use Ecto.Migration

  def change do
    create table(:users) do
      add :jsonb_field, :jsonb, null: false
      add :json_field, :jsonb, null: false
      add :map_field, :map, null: false
    end
  end
end

The schema

defmodule EmptyJson.User do
  use Ecto.Schema

  schema "users" do
    field(:jsonb_field, {:array, :map})
    field(:json_field, {:array, :map})
    field(:map_field, {:array, :map})
  end
end

With the insert itself

%EmptyJson.User{id: 1, jsonb_field: [], json_field: [], map_field: []}
|> EmptyJson.Repo.insert()

And got the next log

INSERT INTO "users" ("id","json_field","jsonb_field","map_field") VALUES ($1,$2,$3,$4) [1, [], [], []]

If you print out the d\+ users in psql client then


                                                  Table "public.users"
   Column    |  Type  | Collation | Nullable |              Default              | Storage  | Stats target | Description 
-------------+--------+-----------+----------+-----------------------------------+----------+--------------+-------------
 id          | bigint |           | not null | nextval('users_id_seq'::regclass) | plain    |              | 
 jsonb_field | jsonb  |           | not null |                                   | extended |              | 
 json_field  | jsonb  |           | not null |                                   | extended |              | 
 map_field   | jsonb  |           | not null |                                   | extended |              | 

Where Next?

Popular in Questions Top

pgiesin
This should be a simple problem but I just can’t seem to figure it out. I have a standalone Elixir app that won’t find the database. Dep...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
stefanchrobot
What’s the safe way to decode a JSON string into a struct? I want to avoid calling String.to_atom. Jason.decode can give me a map with st...
New
myronmarston
The Elixir Typespec docs show the following syntax for keyword lists in typespecs: # ... | [key: type] # keyword lis...
New
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
New
kostonstyle
Hi all I want to have a unix time, from the current time plus 1 hour. DateTime.now + 1 hour How to get it in elixir? Thanks
New
chewm
Hi guys, nice to meet you to the whole forum, I’m new here, I’m trying to configure visual studio code for elixir, right now the intellis...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers' Functional Web Development with Elixir, OTP, and Phoenix forum. ...
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

Other popular topics Top

senggen
Erlang/OTP 25 [erts-13.2.2] [source] [64-bit] [smp:8:8] [ds:8:8:10] [async-threads:1] 15:22:35.803 [error] gen_event {lager_file_backend...
New
yawaramin
In the Dialyzer docs ( http://erlang.org/doc/man/dialyzer.html#requesting-or-suppressing-warnings-in-source-files ), there is a way to tu...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
axelson
This post is a wiki (feel free to hit the edit button near the bottom right of this post to add your own changes!) This post collects co...
239 45766 226
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
aadeshere1
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible. total = 10 while total != 0 ...
New
alice
Hey, Just curious what are the main benefits of Elixir compared to Clojure? When is Elixir more useful than Clojure and vice versa? Th...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
New

We're in Beta

About us Mission Statement