Hello there,
My first post here.
I am playing out with Elixir and the new Phoenix (1.3). Tried to create a Todo app following the code snippets here: Working with Ecto associations and embeds « Plataformatec Blog
Since it is Phoenix 1.3, I tried to put them into context. However, naming seems to be confusing.
I created the project as follows:
mix phx.gen.html Todo List lists title:string
mix phx.gen.schema Todo.Item items body:text list_id:references:lists
scheme are as follows:
schema "todo_lists" do
field :title, :string
has_many :todo_items, TodoApp.Todo.Item
timestamps()
end
…
schema "todo_items" do
field :body, :string
#field :todo_list_id, :id
belongs_to :todo_list, TodoApp.Todo.List
timestamps()
end
I receive this error:
Ecto.QueryError at GET /lists/4
deps/ecto/lib/ecto/association.ex:495: fieldTodoApp.Todo.Item.list_id
inwhere
does not exist in the schema in query:
from i in TodoApp.Todo.Item,
where: i.list_id == ^4,
order_by: [asc: i.list_id],
select: {i.list_id, i}
It is clear that alto it should be TodoApp.Todo.Item.todo_list_id
for in the DB there is no such field as list_id but todo_list_id.
How to fix this?