if I use this, it shows me user password I need to select fields I want not all of them
shahryarjb
benwilson512
Author of Craft GraphQL APIs in Elixir with Absinthe
When you say the user password, do you mean the user password hash or the user’s actual password? The user’s actual password should never, EVER be stored in the database.
0
shahryarjb
I mean the user hash password and shows the user status, I want to show my user the query selected.
if I call the u: u in my select this problem will be solved like this
query = from u in UserSchema,
where: u.id == ^id,
left_join: c in assoc(u, :subscribers),
preload: [subscribers: c],
select: %{
u: u,
user_info: %{
id: u.id,
name: u.name,
mobile: u.mobile,
last_name: u.last_name,
mobile: u.mobile,
inserted_at: u.inserted_at,
updated_at: u.updated_at,
}
}
Repo.one(query)
but it shows me Users all fields again
0
benwilson512
Author of Craft GraphQL APIs in Elixir with Absinthe
query = from u in UserSchema,
where: u.id == ^id,
left_join: c in assoc(u, :subscribers),
preload: [subscribers: c],
select: struct(u, [
:id,
:name,
:mobile,
:last_name,
:mobile,
:status,
:role,
:inserted_at,
:updated_at,
])
2
shahryarjb
** (Ecto.QueryError) the binding used in `from` must be selected in `select` when using `preload` in query:
from u0 in BankError.ClientApi.Auth.UserSchema,
left_join: s1 in BankError.ClientApi.Factor.SubscriberSchema,
on: s1.user_id == u0.id,
where: u0.id == ^...,
select: struct(s1, [:id, :name, :mobile, :last_name, :mobile, :status, :role, :inserted_at, :updated_at, :subscribers]),
preload: [subscribers: s1]
(ecto) lib/ecto/repo/queryable.ex:132: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
(ecto) lib/ecto/repo/queryable.ex:66: Ecto.Repo.Queryable.one/3
0
benwilson512
Author of Craft GraphQL APIs in Elixir with Absinthe
shahryarjb
I have this error,
** (Postgrex.Error) ERROR 42703 (undefined_column) column u0.subscribers does not exist
query: SELECT u0."id", u0."name", u0."mobile", u0."last_name", u0."mobile", u0."status", u0."role", u0."inserted_at", u0."updated_at", u0."subscribers", s1."id", s1."expire_time", s1."status", s1."user_id", s1."inserted_at", s1."updated_at" FROM "users" AS u0 LEFT OUTER JOIN "subscribers" AS s1 ON s1."user_id" = u0."id" WHERE (u0."id" = $1)
(ecto_sql) lib/ecto/adapters/sql.ex:605: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql) lib/ecto/adapters/sql.ex:538: Ecto.Adapters.SQL.execute/5
(ecto) lib/ecto/repo/queryable.ex:147: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
(ecto) lib/ecto/repo/queryable.ex:66: Ecto.Repo.Queryable.one/3
it should be noted I fixed my problem with long way but if it works I think my code will be Shorter
0
benwilson512
Author of Craft GraphQL APIs in Elixir with Absinthe