Mr.T 🐻⛓ Posts - Answer Overflow

Mr.T 🐻⛓

Explore posts from servers

•Created by Mr.T 🐻⛓ on 10/2/2023 in #help

Can't reference an array of enum in a table

I'm trying to define a column in a table such as: abilitiesRequired: abilities("abilitiesRequired").array(), but I get an error saying that abilities[] does not exist. How should i define that column so we can have one or multiple enums in ? Thank you

1 replies

DTDrizzle Team

•Created by Mr.T 🐻⛓ on 9/25/2023 in #help

Can't filter using 'query' when relation is one to one

Hello, I'm trying to use where filter on this query:

 const qb = db.query.event.findMany({
    with: {
      workoutSession: {
        where: eq(workoutSession.athleteId, userId),
        with: {
          workoutResult: {
            with: {
              workout: true,
            },
          },
        },
      },
    },
})

 const qb = db.query.event.findMany({
    with: {
      workoutSession: {
        where: eq(workoutSession.athleteId, userId),
        with: {
          workoutResult: {
            with: {
              workout: true,
            },
          },
        },
      },
    },
})

And for some reason, where just isn't an option when event <-> workoutSession are a one-to-one relationship if I create a one-to-many relationship in the schema, then I can safely use where here. I wonder if that is something normal 🤔 Thanks!

4 replies

DTDrizzle Team

•Created by Mr.T 🐻⛓ on 9/16/2023 in #help

Trying to get relations from one table to another, as one-to-many but get only one value

I have a one-to-many relation on a table, and I want to get all the workoutResults associated with a workoutSession. My query looks like this:

      const qb = db
        .select()
        .from(workoutSession)
        // .leftJoin(event, eq(event.id, workoutSession.eventId));
        .leftJoin(
          workoutResult,
          eq(workoutSession.id, workoutResult.workoutSessionId)
        )

      const qb = db
        .select()
        .from(workoutSession)
        // .leftJoin(event, eq(event.id, workoutSession.eventId));
        .leftJoin(
          workoutResult,
          eq(workoutSession.id, workoutResult.workoutSessionId)
        )

I don't understand why workoutSession.workoutResult is not an array, since there are many workoutResults with the same workoutSessionId I hope I'm clear enough. I've also tried adding the .all() at the end of the query, but this does not seem to exist anywhere in drizzle 🤔

23 replies

Gaming

Programming