Prisma•13mo ago•

7 replies

how to prevent duplicate rows in my friends table

i am working on adding friends feature in my application i am using mysql database , with prisma orm i have a friends table and a users table as the name implies the user table stores the users , friends stores friend records the schema of both tables are as follows

model Users {
  id       
  username    
  email       
  uuid             
  status      
  friends     Friends[]
}
model Friends {
  id             
  username       
  friendId       
  email          
  friend_name    
  friend_request_enum
  Users  Users? @relation(fields: [userId], references: [id])
  userId Int?
}

model Users {
  id       
  username    
  email       
  uuid             
  status      
  friends     Friends[]
}
model Friends {
  id             
  username       
  friendId       
  email          
  friend_name    
  friend_request_enum
  Users  Users? @relation(fields: [userId], references: [id])
  userId Int?
}

when a friend request is sent a record is created in the friends table the here is what happens in my database as an example we have two users

 userA:john

 userA:john

userB:sara

userB:sara

, john sends a friend request to sara a row is created as following :

username :john
  friendId:sara's uuid 
  email: john email 
  friend_name:sara  
friend_request:"SENT"

username :john
  friendId:sara's uuid 
  email: john email 
  friend_name:sara  
friend_request:"SENT"

if sara accepts the friend request is set to

ACCEPTED

ACCEPTED

when i fetch the user Data i am including the friends relation in the query let's say that i fetch the userData of the

userB : sara

userB : sara

that accepted the friend request the problem is friends field returned from the query is empty after some digging i discovered that's because the row created was created by the sender

 userA:john

 userA:john

therefore when i query the user Data that accepted the friend request

userB : sara

userB : sara

i am getting an empty friends field , if i query

userA:john

userA:john

i get friend list with one row that shows sara as the friend , i attempted to insert a another row in the friends table where the sender in this case is sara and the reciever is

john

john

problem is i am gonna have two rows for each friendship which means more space in my database i wanna have only one row for each friendship is there any way to achieve that + is there anything wrong with having two rows for each friendShip ?

how to prevent duplicate rows in my friends table

model Users {
  id       
  username    
  email       
  uuid             
  status      
  friends     Friends[]
}
model Friends {
  id             
  username       
  friendId       
  email          
  friend_name    
  friend_request_enum
  Users  Users? @relation(fields: [userId], references: [id])
  userId Int?
}

model Users {
  id       
  username    
  email       
  uuid             
  status      
  friends     Friends[]
}
model Friends {
  id             
  username       
  friendId       
  email          
  friend_name    
  friend_request_enum
  Users  Users? @relation(fields: [userId], references: [id])
  userId Int?
}

when a friend request is sent a record is created in the friends table the here is what happens in my database as an example we have two users

 userA:john

 userA:john

userB:sara

userB:sara

, john sends a friend request to sara a row is created as following :

username :john
  friendId:sara's uuid 
  email: john email 
  friend_name:sara  
friend_request:"SENT"

username :john
  friendId:sara's uuid 
  email: john email 
  friend_name:sara  
friend_request:"SENT"

if sara accepts the friend request is set to

ACCEPTED

ACCEPTED

when i fetch the user Data i am including the friends relation in the query let's say that i fetch the userData of the

userB : sara

userB : sara

that accepted the friend request the problem is friends field returned from the query is empty after some digging i discovered that's because the row created was created by the sender

 userA:john

 userA:john

therefore when i query the user Data that accepted the friend request

userB : sara

userB : sara

i am getting an empty friends field , if i query

userA:john

userA:john

i get friend list with one row that shows sara as the friend , i attempted to insert a another row in the friends table where the sender in this case is sara and the reciever is

john

john

how to prevent duplicate rows in my friends table

how to prevent duplicate rows in my friends table

Similar Threads

Similar Threads

Similar Threads