Perny Comments - Answer Overflow

Perny

•Created by Perny on 5/18/2024 in #help

many-to-one transaction with select API and Postgres

The documentation mentions an .all() method but that does not appear to exist. The snippet is also quite cursed mentioning variables that don't exist and not containing all imports.

3 replies

DTDrizzle Team

•Created by Perny on 5/18/2024 in #help

many-to-one transaction with select API and Postgres

Here is my query:

const result = await db
    .select()
    .from(game)
    .where(eq(game.id, "g_123"))
    .leftJoin(goal,
        eq(game.id, goal.game_id)
    )

const result = await db
    .select()
    .from(game)
    .where(eq(game.id, "g_123"))
    .leftJoin(goal,
        eq(game.id, goal.game_id)
    )

But it only returns it as one-to-one

3 replies

DTDrizzle Team

•Created by Perny on 3/12/2024 in #help

How can I get nested data to be inside the parent object

This is so basic though, you'd think the they would've thought about it

6 replies

DTDrizzle Team

•Created by Perny on 3/12/2024 in #help

How can I get nested data to be inside the parent object

Probably will have to use SQL stings.

6 replies

DTDrizzle Team

•Created by Perny on 3/12/2024 in #help

How can I get nested data to be inside the parent object

Three queries.. idk...

6 replies

Gaming

Programming