Issue in relationship

[wasiqaftab]

HI sorry a wired bug in relationship or may be its me i am scratching my head from last 2 days but didnt get around it. please see the code
return [ 'contactsUser' => HasMany::make('userfriends', UserRepository::class), ];

but the result which i get from index function just one record relationship recorded. can you please tell me what i am doing wrong i see the repo keys etc all are okay. userfriends has a relation in contact model @binaryk can you please check it

[arthurkirkosa]

I'd recommend you use the same key in the Repository as the name of the function in your User model.

return [ 'userfriends' => HasMany::make('userfriends', UserRepository::class)]; if you relation in User is public function userfriends(): HasMany

[wasiqaftab]

@arthurkirkosa i am doing same please see the snippets

Table structure is

users have user id as uuid
contacts table have
user_id as uuid and friend_id as uuid

1. User Model

public function userfriends(): HasMany { return $this->hasMany(Contact::class,'friend_id', 'id'); }

2. ContactsRepository Relation

Key on contacts repository is public static string $uriKey = 'contacts';

public static function related(): array { return [ 'userfriends' => HasMany::make('userfriends', UserRepository::class), ]; }

3. Contact Model

public function userfriends(): BelongsTo { return $this->belongsTo(User::class, 'friend_id'); }

API call if is like that

{{host}}/api/restify/contacts?related=userfriends

Result i am expecting is all friend_ids with relation but now i am getting error of un defined function maps

"message": "Call to undefined method App\\Models\\User::map()",

Please guide am i doing something wrong

[wasiqaftab]

Also if i use belongsTo relation like that
return [ 'userRelationship' => BelongsTo::make('userfriends', UserRepository::class), ];

it will only return first record as relation output something like that

Please guide as it just show relation for first record

[arthurkirkosa]

Yes, as Contact has a BelongTo with User, that's the relation you have to use in your ContactRepository as well.

Because a Contact Belongs To a User, it's normal for you to have just one item of User loaded with that Contact

If you what the full list of contacts start from the User repo
GET /api/restify/users?related=userfriends

For clarity I would rename the methods in each model to the corresponding entity

// User

public function contacts(): HasMany {}
// or
public function friends(): HasMany {}

// Contact

public function user(): BelongsTo {}
// or
public function friend(): BelongsTo {}

Naming them in singular and plural would outline how many object I should receive when using the relation in the code

[arthurkirkosa]

@wasiqaftab I moved this issue to a Discussion.

[wasiqaftab]

@arthurkirkosa i have same issue

[arthurkirkosa]

As I can see, you have defined friend as a BelongsTo in the model and a HasMany in the repository... the type must match in both

'contactusers' => BelongsTo::make('friend', UserRepository::class),

[wasiqaftab]

Thanks it worked. but problem is that i just need the user which is in my contact tables. like user have many contacts so i just need friend id relation or user detail can you guide me how i can acheive that. because my understanding is that i need to use the contact repository for it so i can only get the loginin user contacts with their details i mean user details

[wasiqaftab]

I think so its a other way around. as contacts table have a composite primary key one is the auth key which tells me that get that users and second is its friends key which tells me okay these are the friends of that login user. now i need get the user info for that user friends like their name etc

[arthurkirkosa]

Lets back up.

What are you trying to achieve?

What are the HTTP calls you are making?

[wasiqaftab]

i am doing this call
{{host}}/api/restify/users?related=contactusers

but logically i want to do this call

{{host}}/api/restify/contacts?related=contactusers

What i am trying to do is to get all the contacts with their relation with users like users have contacts and when i login i need to make api for contacts which will give me all friend ids for that user and friend id is logically another user id so i need to get the data for that friend id which is present in user table

[arthurkirkosa]

{{host}}/api/restify/contacts?related=contactusers should give you only one user back... which is correct, because a Contact has ONLY one User related (it belongs to that User)

When you log in with the current user... it has many contacts, which have a single relation to another User... and you need to see the currently logged in user's friends (Contact->User)

The architecture that you want is a User has many friends (User) and each User can befriend other users.

If so, you need a ManyToMany relationship between users and don't need that Contact model.

[wasiqaftab]

I think so i figure it out. now it works my bad i am using the contact repository i need to use the user repository

[wasiqaftab]

Only last thing i have about 3 different scenarios which uses the different Pivot tables like block users and profile views. so i am declaring it like that in user repository
return [ 'users' => BelongsToMany::make('liked', UserRepository::class)->withPivot( field('is_mutual_like') ), 'usersviews' => BelongsToMany::make('viewed', UserRepository::class)->withPivot( field('count') ), ];

but when i fetch it like

{{host}}/api/restify/users/dfb6ec7e-e37b-4cd1-bdf9-ffd3727820f8?related=usersviews

it gives me both relations if i need to get only one relation at a time how can i do that. and also how i can i include paging in it.

[wasiqaftab]

also i try to do the pagination like
{{host}}/api/restify/users/dfb6ec7e-e37b-4cd1-bdf9-ffd3727820f8?related=usersviews&relatablePerPage=2
it will only show 2 records ? as i have 10 records in db

[arthurkirkosa]

First, I'd name both the key of the related and the name of the relationship the same; this way you're sure to not load things by mistake or confuse Restify.

'liked' => BelongsToMany::make('liked', UserRepository::class)->withPivot( field('is_mutual_like'),

if liked is the name of the BelongsToMany relationship in the model

[wasiqaftab]

Ok thanks it worked. What about paging issue