CODEWITHSUNDEEP
elixirphoenix-frameworkecto
code.cycling
code.cycling

Reputation: 1274

Getting Ecto.Query.CastError when querying in phoenix

So I copied a query where it will preload a user associated in it.

The problem is that its throwing an ecto.query.cast error and I can't seem to find the solution.

query

def get_avatar!(id) do
IO.inspect(id)

query =
  from(
    p in AssocApp.Accounts.Avatar,
    where: p.user_id == ^id,
    select: p,
    preload: [:user]
  )

Repo.get!(Avatar, query)
end

user schema

schema "users" do
field(:password, :string)
field(:username, :string)
has_one(:avatar, AssocApp.Accounts.Avatar)

timestamps()end

avatar schema

schema "avatars" do
field(:firstname, :string)
field(:lastname, :string)
field(:pic_url, :string)
belongs_to(:user, AssocApp.Accounts.User)

timestamps()end

@doc false def changeset(avatar, attrs) do avatar |> cast(attrs, [:firstname, :lastname, :pic_url, :user_id]) # |> validate_required([:firstname, :lastname, :pic_url])end

avatar controller

def show(conn, %{"id" => id}) do
avatar = Accounts.get_avatar!(id)
render(conn, "show.json", avatar: avatar)end

Screenshot:

enter image description here

Upvotes: 0

Views: 1294

Answers (1)

Dogbert
Dogbert

Reputation: 222040

Repo.get!/2 fetches a record by its primary key but you're passing a query to it. You need to use Repo.one!/1:

Repo.one!(query)

Upvotes: 1

Related Questions