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
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 | |
Popular in Questions
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
i’m a new one to elixir
which editor can i use
vs code? or atom?
Thanks! :smiley:
New
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
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
The Elixir Typespec docs show the following syntax for keyword lists in typespecs:
# ...
| [key: type] # keyword lis...
New
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
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
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
Original source of discussion: This topic on the Pragmatic Programmers' Functional Web Development with Elixir, OTP, and Phoenix forum.
...
New
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
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
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
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
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...
New
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
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
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible.
total = 10
while total != 0
...
New
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
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
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








