22 replies

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

workoutResults

with the same

workoutSessionId

workoutSessionId

I hope I'm clear enough.
I've also tried adding the

.all()

.all()

at the end of the query, but this does not seem to exist anywhere in drizzle

Drizzle Team•3y ago•

22 replies

Mr.T

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

workoutResults

with the same

workoutSessionId

workoutSessionId

I hope I'm clear enough.
I've also tried adding the

.all()

.all()

at the end of the query, but this does not seem to exist anywhere in drizzle

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads