ven Comments - Answer Overflow

ven

Explore posts from servers

NNuxt DDeno PPrisma DTDrizzle Team

Posts Comments

PPrisma

•Created by ven on 7/26/2024 in #help-and-questions

Using Prisma with Supabase and NuxtJS/Nitro

thank you ted

4 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

hang on. let me figure out this call stuff

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

because the example only give many

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i missed the one part

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

new to discord

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i dont know know how to start a call 🙂

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i can jump on a call. are you free now?

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

finally threw in the towel

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i tried all kinds of stuff to get db.query work

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i ended up with a left join

        const data = await db
            .select()
            .from(chatRooms)
            .leftJoin(
                chatRoomParticipants,
                eq(chatRooms.id, chatRoomParticipants.chatRoomId)
            )
            .leftJoin(
                profile,
                eq(profile.userUid, chatRoomParticipants.userUid)
            )
            .where(eq(chatRooms.ownerUid, userId));

        const data = await db
            .select()
            .from(chatRooms)
            .leftJoin(
                chatRoomParticipants,
                eq(chatRooms.id, chatRoomParticipants.chatRoomId)
            )
            .leftJoin(
                profile,
                eq(profile.userUid, chatRoomParticipants.userUid)
            )
            .where(eq(chatRooms.ownerUid, userId));

@mast1999

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

29 replies

DTDrizzle Team

•Created by ven on 7/18/2023 in #help

How to Chain multiple selects

i decided to use joins because i couldnt figure out how to setup the relationships post introspection. i wish the documentation was a bit more clear.

29 replies

Gaming

Programming