Hey, I’ve got problem with has many association. I would like to connect posts with posts_likes through “post_id” and “user_id” (which would be took from guardian Guardian.Plug.current_resource(conn)). How can I do this? It is easily possible in SQL, but how to translate it to elixir and ecto? In …

[image] maliawelli: this enum.map posted above doesn’t return expected data. It returns only: “posts”: [ { “favourite”: }, { “favourite”: [ { “user_id”: 1, “post_id”: 2 } ] } ] Which is as expected according how I understood you. This is why I asked for input and output as you expect it in …

@gregvaughn : I can’t use join, because I won’t get posts which are not liked by logged user. I want to have only information in each post if it is liked by user or not. I’ve got right data, but during this operation: Enum.map(page.entries, fn post → %{“favourite” => Repo.all(Post.getFavourites…

Since you still didn’t show what you expect, I have to guess (again)… Enum.map(page.entries, fn post -> post |> Map.put("favourite", repo.all... end

@NobbZ Ok. I’m posting json, because it is much easier to get info than from terminal output. I’ve got posts data like this: “posts”: [ { “votes”: [ { “post_id”: 4, “id”: 22, “author”: “equse” } ], “user_id”: 1, “user”: { “username”: “equse”, “id”: 1 }, “url”: “ http://google.pl ”, “title”: “Goog…

[image] maliawelli: I’ve got posts data like this: Which I do not know how it gets deserialized into elixir terms, therefore mostly useless, also it is invalid JSON, since it is neither a list nor a single object. %Microscope.Post{[…]} Oh… It is a struct. You can’t simply add or remove fi…

@NobbZ I’m just trying to implement “add to favourites” function. It can’t be so hard as it seems to be :slight_smile: Now my output looks like: %{:__meta__ => #Ecto.Schema.Metadata<:loaded, "posts">, :__struct__ => Microscope.Post, :comments => [], :id => 2, :inserted_at => #Ecto.DateTime<20…

@NobbZ I’m still learning elixir and sitting with book between my knees. But this operations should be as easy as in other languages :frowning: Also I’m trying to learn during some project.

[image] maliawelli: So my information about favourite is outside the brackets and my API doesn’t see that data. Of what brackets? Where do you want that information to be placed? The task itself is very simple, but only if one knows EXACTLY what you want to have!

@NobbZ As I wrote exactly few times. I would like to have information (if post is in favourites or not) inside each single post from posts array. The best option would be to do this with ecto schema, but I haven’t found any example in documentation, so I’m trying just to fetch this in additional q…

In the data you have shown us, you have shown a mangled struct, which was a Post, before you required to insert a String key. And since Post is/should be a struct, you are normaly not allowed to simply add new keys to it. Structs are fixed. This is what I meant by saying you are missing fundamental…

Has many through many fields

Questions & Help Questions

LostKobrakai August 8, 2017, 5:48am 25

Use left_join maybe?