gcb

gcb

Phx.gen missing primary keys and bad types in references

i’m not getting primary keys for phx.gen.html/json.

mix phx.gen.html Content Community communities name:string:unique description:string user_id:references:users

resulted in

  def change do
  │ create table(:communities) do
  │ │ add :name, :string
  │ │ add :description, :string
  │ │ add :user_id, references(:users, on_delete: :nothing)

  │ │ timestamps()
  │ end

    create unique_index(:communities, [:name])                                                                                                                                
  │ create index(:communities, [:user_id])
  end
end

without any primary keys entirely, …and the references ignores the uuid type that is on the referenced users table. For users table I used --binary-id and got add :id, :binary_id, primary_key: true

am I expected to always use either --no-binary-id or --binary-id to get primary keys?

trying to run this, i get

ERROR 42804 (datatype_mismatch) foreign key constraint “communities_user_id_fkey” cannot be implemented

Key columns “user_id” and “id” are of incompatible types: bigint and uuid.

and it is not clear how i can even force :uuid types in a reference…

Marked As Solved

gcb

gcb

missing from docs but easy to find on source. the fix for the wrong reference type is to add type: parameter.

add :user_id, references(:users, on_delete: :nothing, type: :binary_id) 

but still clueless about the lack of primary keys

Also Liked

gcb

gcb

heh. the simple id is hidden on the create tables. i guess it is all good then.

Where Next?

Popular in Questions Top

srinivasu
How to handle excepions in elixir? Suppose i have A, B, C ,D, E modules. and each module has get() function. A.get() method will call th...
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
fireproofsocks
I’m working on defining a simple Ecto schema for a table (in PostGres), but I don’t see where I can define a column as NOT NULL. Conside...
New
rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list....
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
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
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
Codball
Mix format works fine if run from the cmd. I’ve followed this to facilitate the implementation into VSC which involves downloading an ext...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers' Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
lucidguppy
I have a super simple question about elixir - how would I take a file like this foo bar baz and output a new file that enumerates th...
New

Other popular topics Top

Qqwy
Update: How to use the Blogs & Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3268 119930 1237
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New
aalberti333
As the title describes, I’m trying to run Enum.map() over a list of key/value pairs, where the value is a map. My data looks like this: ...
New
polypush135
As many of you may have realized by now (sorry for all the posts here) I’ve been working on a db problem where I’m trying to aggregate a ...
New
danschultzer
None of the current solutions worked well for me, so I went ahead and built a user management system from scratch. This project took far...
548 27727 240
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
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
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
AstonJ
We’ve put together this wiki for Phoenix LiveView - please feel free to add any info you feel is worth including. What is Phoenix LiveV...
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

We're in Beta

About us Mission Statement