Comments (4)
beerlington
commented on August 16, 2024
It looks like you might be preloading the users into the account relationship. The user id and account id are the same in the response, which seems suspicious.
Does it work if you change the account preload in your query? Change preload to preload: [account: a]
def get_user!(id) do
from(u in User,join: a in assoc(u, :account),
where: u.id == ^id,
preload: [account: a], join: l in assoc(u, :linked_users),
where: u.id == l.parent_id , preload: [linked_users: u],
where: l.active == true) |> Repo.one
endfrom ja_serializer.
JamesAndresCM
commented on August 16, 2024
It looks like you might be preloading the users into the account relationship. The user id and account id are the same in the response, which seems suspicious.
Does it work if you change the account preload in your query? Change preload to
preload: [account: a]def get_user!(id) do from(u in User,join: a in assoc(u, :account), where: u.id == ^id, preload: [account: a], join: l in assoc(u, :linked_users), where: u.id == l.parent_id , preload: [linked_users: u], where: l.active == true) |> Repo.one end
Thanks for your fast reply
This is the output query:
us = from u in User,join: a in assoc(u, :account), where: u.id == 1327, join: l in assoc(u, :linked_users), where: u.id == l.parent_id , where: l.active == true, preload: [account: u, linked_users: u]
#Ecto.Query<from u0 in AccountService.Accounts.User,
join: a1 in assoc(u0, :account), join: l2 in assoc(u0, :linked_users),
where: u0.id == 1327, where: u0.id == l2.parent_id, where: l2.active == true,
preload: [linked_users: u0, account: u0]>
iex(84)> Repo.all(us)
[debug] QUERY OK source="users" db=5.1ms idle=9121.0ms
SELECT u0.`id`, u0.`account_id`, u0.`username`, u0.`email`, u0.`old_encrypted_password`, u0.`salt`, u0.`reset_token`, u0.`activation_token`, u0.`active`, u0.`created_at`, u0.`updated_at`, u0.`type`, u0.`role`, u0.`name`, u0.`lastname`, u0.`holding_id`, u0.`can_create_users`, u0.`binary_authorization`, u0.`can_modify`, u0.`profile_picture`, u0.`last_seen`, u0.`new_layout`, u0.`reset_password_token`, u0.`remember_created_at`, u0.`sign_in_count`, u0.`current_sign_in_at`, u0.`last_sign_in_at`, u0.`current_sign_in_ip`, u0.`last_sign_in_ip`, u0.`failed_attempts`, u0.`locked_at`, u0.`password_changed_at`, u0.`change_password`, u0.`level`, u0.`can_modify_data`, u0.`confirmation_token`, u0.`confirmed_at`, u0.`support`, u0.`show_chat`, u0.`theme`, u0.`phone`, u0.`enable_summary_report`, u0.`binary_permissions`, u0.`encrypted_password`, u0.`id`, u0.`account_id`, u0.`username`, u0.`email`, u0.`old_encrypted_password`, u0.`salt`, u0.`reset_token`, u0.`activation_token`, u0.`active`, u0.`created_at`, u0.`updated_at`, u0.`type`, u0.`role`, u0.`name`, u0.`lastname`, u0.`holding_id`, u0.`can_create_users`, u0.`binary_authorization`, u0.`can_modify`, u0.`profile_picture`, u0.`last_seen`, u0.`new_layout`, u0.`reset_password_token`, u0.`remember_created_at`, u0.`sign_in_count`, u0.`current_sign_in_at`, u0.`last_sign_in_at`, u0.`current_sign_in_ip`, u0.`last_sign_in_ip`, u0.`failed_attempts`, u0.`locked_at`, u0.`password_changed_at`, u0.`change_password`, u0.`level`, u0.`can_modify_data`, u0.`confirmation_token`, u0.`confirmed_at`, u0.`support`, u0.`show_chat`, u0.`theme`, u0.`phone`, u0.`enable_summary_report`, u0.`binary_permissions`, u0.`encrypted_password`, u0.`id`, u0.`account_id`, u0.`username`, u0.`email`, u0.`old_encrypted_password`, u0.`salt`, u0.`reset_token`, u0.`activation_token`, u0.`active`, u0.`created_at`, u0.`updated_at`, u0.`type`, u0.`role`, u0.`name`, u0.`lastname`, u0.`holding_id`, u0.`can_create_users`, u0.`binary_authorization`, u0.`can_modify`, u0.`profile_picture`, u0.`last_seen`, u0.`new_layout`, u0.`reset_password_token`, u0.`remember_created_at`, u0.`sign_in_count`, u0.`current_sign_in_at`, u0.`last_sign_in_at`, u0.`current_sign_in_ip`, u0.`last_sign_in_ip`, u0.`failed_attempts`, u0.`locked_at`, u0.`password_changed_at`, u0.`change_password`, u0.`level`, u0.`can_modify_data`, u0.`confirmation_token`, u0.`confirmed_at`, u0.`support`, u0.`show_chat`, u0.`theme`, u0.`phone`, u0.`enable_summary_report`, u0.`binary_permissions`, u0.`encrypted_password` FROM `users` AS u0 INNER JOIN `accounts` AS a1 ON a1.`id` = u0.`account_id` INNER JOIN `linked_users` AS l2 ON l2.`parent_id` = u0.`id` WHERE (u0.`id` = 1327) AND (u0.`id` = l2.`parent_id`) AND (l2.`active` = TRUE) []
[
%AccountService.Accounts.User{
profile_picture: nil,
confirmation_token: nil,
users: #Ecto.Association.NotLoaded<association :users is not loaded>,
current_sign_in_ip: "::1",
updated_at: ~U[2020-03-31 20:01:50Z],
type: nil,
reset_password_token: nil,
current_sign_in_at: ~U[2020-03-18 20:34:19Z],
can_modify_data: true,
activation_token: nil,
holding_id: nil,
active: true,
password_changed_at: ~U[2019-08-19 14:56:52Z],
account_id: 1,
reset_token: nil,
name: "Andres",
can_create_users: true,
created_at: ~U[2015-07-09 17:09:48Z],
__meta__: #Ecto.Schema.Metadata<:loaded, "users">,
phone: "+56978197220",
lastname: "Grass",
account: %AccountService.Accounts.User{
profile_picture: nil,
confirmation_token: nil,
users: #Ecto.Association.NotLoaded<association :users is not loaded>,
current_sign_in_ip: "::1",
updated_at: ~U[2020-03-31 20:01:50Z],
type: nil,
reset_password_token: nil,
current_sign_in_at: ~U[2020-03-18 20:34:19Z],
can_modify_data: true,
activation_token: nil,
holding_id: nil,
active: true,
password_changed_at: ~U[2019-08-19 14:56:52Z],
account_id: 1,
reset_token: nil,
name: "Andres",
can_create_users: true,
created_at: ~U[2015-07-09 17:09:48Z],
__meta__: #Ecto.Schema.Metadata<:loaded, "users">,
phone: "+56978197220",
lastname: "Grass",
account: #Ecto.Association.NotLoaded<association :account is not loaded>,
email: "[email protected]",
enable_summary_report: false,
encrypted_password: "$2a$10$jkSngSCBYowAgYSTsmBAseOVmYGMDWIN2uPpk69tC4WKIs8291YQK",
id: 1327,
confirmed_at: ~U[2016-12-01 19:48:47Z],
...
},
email: "[email protected]",
enable_summary_report: false,
encrypted_password: "$2a$10$jkSngSCBYowAgYSTsmBAseOVmYGMDWIN2uPpk69tC4WKIs8291YQK",
id: 1327,
confirmed_at: ~U[2016-12-01 19:48:47Z],
binary_permissions: 255,
change_password: false,
linked_users: [
%AccountService.Accounts.User{
profile_picture: nil,
confirmation_token: nil,
users: #Ecto.Association.NotLoaded<association :users is not loaded>,
current_sign_in_ip: "::1",
updated_at: ~U[2020-03-31 20:01:50Z],
type: nil,
reset_password_token: nil,
current_sign_in_at: ~U[2020-03-18 20:34:19Z],
can_modify_data: true,
activation_token: nil,
holding_id: nil,
active: true,
password_changed_at: ~U[2019-08-19 14:56:52Z],
account_id: 1,
reset_token: nil,
name: "Andres",
can_create_users: true,
created_at: ~U[2015-07-09 17:09:48Z],
...
}
],
remember_created_at: nil,
new_layout: true,
binary_authorization: 255,
theme: 0,
locked_at: nil,
last_seen: ~U[2020-03-31 20:01:50Z],
last_sign_in_at: ~U[2020-03-18 20:31:54Z],
username: "test",
can_modify: true,
last_sign_in_ip: "::1",
role: "admin",
old_encrypted_password: nil,
failed_attempts: 0,
level: 262141,
support: 0,
show_chat: true,
sign_in_count: 583,
salt: nil
}
]
And this works me
def get_user!(id) do
user = Repo.get(User, id)
user |> Repo.preload(account: from(u in Account))
|> Repo.preload(linked_users: from(l in LinkedUser, where: ^id == l.parent_id and l.active == true))
end
But why query not serialize relationships?
Regards
from ja_serializer.
beerlington
commented on August 16, 2024
account: %AccountService.Accounts.User{
That does not look right. I would expect the account relationship to use a different schema from the User.
from ja_serializer.
JamesAndresCM
commented on August 16, 2024
account: %AccountService.Accounts.User{
That does not look right. I would expect the account relationship to use a different schema from the User.
Thanks, now this work, i change preload, but another question, why type relationships is null?
type: null
has_one :account,
serializer: AccountServiceWeb.AccountView,
include: true,
type: :account,
identifiers: :when_included
from ja_serializer.
Related Issues (20)
- Considering migrating to Jason? HOT 4
- How to get a custom attribute value formatter to work properly. HOT 4
- Remove Poison dependency
- Can not start app without poison
- Association links instead of data HOT 2
- phoenix 1.4.4 app errors due to Poison being required despite trying to use Jason HOT 3
- Omitting prev/next links when higher than total page number
- Offer camelCase keys
- Links won't use the page_base_url HOT 7
- Optional json-api version member ? HOT 4
- cannot use relationship named `location` HOT 1
- Using JaSerializer.PhoenixView results in no function clause matching in Plug.Conn.resp/3 HOT 2
- EctoErrorSerializer doesn't render errors from relationships and embedded objects HOT 4
- deep_format_keys implementation & mix release duplication error HOT 3
- Missing documentation for testing Phoenix controller responses HOT 2
- Sparse field param for function based attribute breaks HOT 3
- Should links be output for an empty relationship? HOT 3
- Type ignored on relationship definition HOT 5
- Is it possible to use ja_serializer with a newly generated Phoenix 1.7.7 app? HOT 12
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ja_serializer.