! AlexNotTheLion Comments - Answer Overflow

! AlexNotTheLion

Explore posts from servers

AAE📼 Addie’s Analog Emporium 🌐TTCTheo's Typesafe Cult DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by ! AlexNotTheLion on 4/2/2024 in #help

friendship query that returns the other user object

updated! thank you kindly 🙂

8 replies

DTDrizzle Team

•Created by ! AlexNotTheLion on 4/2/2024 in #help

friendship query that returns the other user object

const user = data.user;

const queryResult = await db
    .select({
        id: friendships.id,
        status: friendships.status,
        incoming: sql<boolean>`friendship.receiving_user = ${user.id}`,
        profile: {
            id: profiles.id,
            username: profiles.username,
            avatarUrl: profiles.avatarUrl
        }
    }).from(friendships).innerJoin(profiles, sql`(
        friendship.sending_user != ${user.id}
        AND friendship.sending_user = profile.id
        ) OR (
        friendship.receiving_user != ${user.id}
        AND friendship.receiving_user = profile.id
        )`)
    .where(sql`friendship.sending_user = ${user.id} OR friendship.receiving_user = ${user.id}`);

const user = data.user;

const queryResult = await db
    .select({
        id: friendships.id,
        status: friendships.status,
        incoming: sql<boolean>`friendship.receiving_user = ${user.id}`,
        profile: {
            id: profiles.id,
            username: profiles.username,
            avatarUrl: profiles.avatarUrl
        }
    }).from(friendships).innerJoin(profiles, sql`(
        friendship.sending_user != ${user.id}
        AND friendship.sending_user = profile.id
        ) OR (
        friendship.receiving_user != ${user.id}
        AND friendship.receiving_user = profile.id
        )`)
    .where(sql`friendship.sending_user = ${user.id} OR friendship.receiving_user = ${user.id}`);