aswinmohanme

aswinmohanme

Phx.gen.auth Where to add extra user information?

I have generated an auth system with phx.gen.auth . I need to add mroe information to the user such as stripe connect id and such. Should I add directly to the user schema or create a profile schema and attach it one to one to the user schema. If going through the profile route how can I make sure all my users have an associated profile with it.

Any pointers would be really helpful.

Marked As Solved

soup

soup

I think the general advice has become to separate “log in methods/credentials” from “user accounts”, because you can more easily manage user data and login data.

So you may end up with

user: id, name, email
web_login: user_id, hash, last_used, last_host, recovery_code
totp_login:  user_id, secret, last_used, last_host
oauth_login: user_id, token, ...
...

etc. Instead of ending up with really fat user tables.

It maybe depends on your desired complexity, but you don’t really lose much by normalising the database.

If you do stick them all in the single table, I would recommend creating different schemas for each login method so your modules are better focused. (You can define multiple schemas that point to one table and have each only include the pertinent fields.)

You can ensure your data has integrity with database constraints (see ecto constraint validation).

E: Sorry I may have been a bit unclear to your actual question, you can put stripe_connect_id in the users table, it really depends on how much you think you will end up stuffing in there and how much you want to normalise your dataset.

I personally structure my accounts like this:

users: id, email, hashed_password
users_roles: user_id, role_id
roles: id, type
profiles: user_id, name, avatar, ...

If I wanted to store a users stripe data (unfamiliar with the specifics of the API) I personally would put it in another table:

user_stripes: user_id, connect_id, account_name?, public_key?, ...

This means you can more easily expand to have a user own multiple stripe accounts, etc.

Also Liked

APB9785

APB9785

Creator of ECSx

phx.gen.auth already generates separate tables for users and user_tokens. OP should add the columns to the users table.

Where Next?

Popular in Questions Top

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
Kurisu
For example for a current url like http://localhost:4000/cosmetic/products?_utf8=✓&query=perfume&page=2, I would like to get: ...
New
qwerescape
Is there a way to get the call stack or stack trace at any point in the code? Not from exceptions, but an expression that returns how the...
New
jononomo
I am trying to figure out how Mix knows whether the environment is test, dev, or prod – where is this set? Thanks.
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
beno
I will often find my self writing things similar to: case some_value do nil -> something() "" -> something() _ -> somethi...
New
pmjoe
I have a relationship of love and hate with Elixir. Lots of things are just absolutely right, but there are some things that are kind of ...
New
vonH
When I run the Plug and I recompile I wind up having to use Ctrl C to quit iex and start again. Witht the help of rlwrap I can use the cu...
New
sergio_101
I am VERY much an elixir newbie. I have taken one elixir course and one phoenix course on Udemy. During that course, I saw the instructor...
New
chensan
I have a User schema with a :from_id field set to type :string: defmodule TweetBot.Repo.Migrations.CreateUsers do use Ecto.Migration ...
New

Other popular topics Top

sen
Hi All, I set a environment variables in dev.exs , like below code. when i start server, how can i set the ${enable} value? thanks. d...
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
shahryarjb
Hello, I have map which I want to convert it to string like this: the map: %{last_name: "tavakkoli", name: "shahryar"} the string I ne...
New
chrismccord
This release brings a number of exciting features, including integration with the new Phoenix LiveDashboard and Phoenix LiveView. There h...
New
dokuzbir
I want to highlight html closing tags when i click a html tag. That works in .html files but doesnt work for html.eex templates. How can...
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
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
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
bsollish-terakeet
Credo is smart enough to check for (something like) this: assert length(the_list) == 0 with this response: Checking if an enum is empt...
New
jason.o
In the code below, if the create action is not set to accept “extra_key” as an input, it errors out with a message shown above. Is there ...
New

We're in Beta

About us Mission Statement