mirror of
https://github.com/PretendoNetwork/friends.git
synced 2025-04-02 11:01:46 -04:00
27 lines
660 B
Go
27 lines
660 B
Go
package database_3ds
|
|
|
|
import (
|
|
"github.com/PretendoNetwork/friends/database"
|
|
)
|
|
|
|
// RemoveFriendship removes a user's friend relationship
|
|
func RemoveFriendship(user1_pid uint32, user2_pid uint32) error {
|
|
result, err := database.Manager.Exec(`
|
|
DELETE FROM "3ds".friendships WHERE user1_pid=$1 AND user2_pid=$2`, user1_pid, user2_pid)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
|
|
rowsAffected, _ := result.RowsAffected()
|
|
if rowsAffected == 0 {
|
|
return database.ErrFriendshipNotFound
|
|
}
|
|
|
|
_, err = database.Manager.Exec(`
|
|
UPDATE "3ds".friendships SET type=0 WHERE user1_pid=$1 AND user2_pid=$2`, user2_pid, user1_pid)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
|
|
return nil
|
|
}
|