@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(post.id, current_user.id))}
end)
It removes all my post data.
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”: “Google”, “inserted_at”: “2017-07-21T22:08:11”, “id”: 4, “comments”: [ { “updated_at”: “2017-08-05T10:56:28”, “post_id”: 4, “inserted_at”: “2017-08-05T10:51:33”, “id”: 1, “body”: “test23333”, “author”: “equse” } ] } ]
The same data in terminal output:
[%Microscope.Post{meta: #Ecto.Schema.Metadata<:loaded, “posts”>,
comments: [%Microscope.Comment{meta: #Ecto.Schema.Metadata<:loaded, “comments”>,
author: “equse”, body: “test23333”, id: 1,
inserted_at: #Ecto.DateTime<2017-08-05 10:51:33>,
post: #Ecto.Association.NotLoaded,
post_id: 4, updated_at: #Ecto.DateTime<2017-08-05 10:56:28>}], id: 4,
inserted_at: #Ecto.DateTime<2017-07-21 22:08:11>,
notifications: #Ecto.Association.NotLoaded,
posts_favourites: #Ecto.Association.NotLoaded,
title: “Google”, updated_at: #Ecto.DateTime<2017-07-21 22:08:11>,
url: “http://google.pl”,
user: %Microscope.User{meta: #Ecto.Schema.Metadata<:loaded, “users”>,
encrypted_password: “$2b$12$oWoyU3mUiVbnfqBwPPUycun3V9oHnn3kSCBoMWcW1mjcUS5C3Difa”,
id: 1, inserted_at: #Ecto.DateTime<2017-07-17 19:57:44>,
notifications: #Ecto.Association.NotLoaded,
password: nil,
posts: #Ecto.Association.NotLoaded,
shares: #Ecto.Association.NotLoaded,
updated_at: #Ecto.DateTime<2017-07-17 19:57:44>, username: “equse”},
user_id: 1,
votes: [%Microscope.Vote{meta: #Ecto.Schema.Metadata<:loaded, “votes”>,
author: “equse”, id: 22, inserted_at: #Ecto.DateTime<2017-08-06 12:22:14>,
post: #Ecto.Association.NotLoaded,
post_id: 4, updated_at: #Ecto.DateTime<2017-08-06 12:22:14>}]}
And it should look like:
“posts”: [ { “favourite”: [ { “user_id”: 1, “post_id”: 2 } ] , “votes”: [ { “post_id”: 4, “id”: 22, “author”: “equse” } ], “user_id”: 1, “user”: { “username”: “equse”, “id”: 1 }, “url”: “http://google.pl”, “title”: “Google”, “inserted_at”: “2017-07-21T22:08:11”, “id”: 4, “comments”: [ { “updated_at”: “2017-08-05T10:56:28”, “post_id”: 4, “inserted_at”: “2017-08-05T10:51:33”, “id”: 1, “body”: “test23333”, “author”: “equse” } ] } ]
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 fields.
Is this JSON or elixir? doesn’t matter, its invalid in both cases.
This may sound hard, but it seems as if fundamentals of elixir are missing, you should pick up a book and learn about them before continuing.
Also an important advice! Try to leave behind everything you learned in PHP! OOP vs FP (and related) aren’t the only differences, but if I start now it will end with rage-bashing PHP 
I’m just trying to implement “add to favourites” function. It can’t be so hard as it seems to be 
Now my output looks like:
%{:__meta__ => #Ecto.Schema.Metadata<:loaded, "posts">,
:__struct__ => Microscope.Post, :comments => [], :id => 2,
:inserted_at => #Ecto.DateTime<2017-07-18 19:26:48>,
:notifications => #Ecto.Association.NotLoaded<association :notifications is not loaded>,
:posts_favourites => #Ecto.Association.NotLoaded<association :posts_favourites is not loaded>,
:title => "Wykop", :updated_at => #Ecto.DateTime<2017-07-18 19:26:48>,
:url => "http://wykop.pl",
:user => %Microscope.User{__meta__: #Ecto.Schema.Metadata<:loaded, "users">,
encrypted_password: "$2b$12$oWoyU3mUiVbnfqBwPPUycun3V9oHnn3kSCBoMWcW1mjcUS5C3Difa",
id: 1, inserted_at: #Ecto.DateTime<2017-07-17 19:57:44>,
notifications: #Ecto.Association.NotLoaded<association :notifications is not loaded>,
password: nil,
posts: #Ecto.Association.NotLoaded<association :posts is not loaded>,
shares: #Ecto.Association.NotLoaded<association :shares is not loaded>,
updated_at: #Ecto.DateTime<2017-07-17 19:57:44>, username: "equse"},
:user_id => 1,
:votes => [%Microscope.Vote{__meta__: #Ecto.Schema.Metadata<:loaded, "votes">,
author: "equsek", id: 10, inserted_at: #Ecto.DateTime<2017-07-23 20:32:52>,
post: #Ecto.Association.NotLoaded<association :post is not loaded>,
post_id: 2, updated_at: #Ecto.DateTime<2017-07-23 20:32:52>},
%Microscope.Vote{__meta__: #Ecto.Schema.Metadata<:loaded, "votes">,
author: "equse", id: 23, inserted_at: #Ecto.DateTime<2017-08-06 19:47:24>,
post: #Ecto.Association.NotLoaded<association :post is not loaded>,
post_id: 2, updated_at: #Ecto.DateTime<2017-08-06 19:47:24>}],
"favourite" => [%{post_id: 2, user_id: 1}]}]
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!
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 query.
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 fundamentals.
If you want to have a key in there, that is :favourites you need to add it to your defstruct or schema-definition (maybe virtual).
Also I still do not know what you mean by “outsoutside the brackets”. It would help both of us if you were using proper terms.
PS: Proper terms means as well to not talk about arrays, but lists, but I will excuse this for now.
I’m really confused at what you want. You want a true/false indicator in a list of posts you already have? Then either be really inefficient and keep what you have and just set to true if the count of results from get_favourites is 1, else false. Or else run a 2nd query to find all the user’s favourites and set a key on each matching post via an Enum.map
