kbemaster Comments - Answer Overflow

kbemaster

Explore posts from servers

TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Tekipeps on 6/20/2024 in #help

How do I make .returning() return only the inserted value instead of array

I like to do the following, when I know I just return 1 element

const [insertedValue] = db.insert(table).values(someValue).returning()

const [insertedValue] = db.insert(table).values(someValue).returning()

11 replies

DTDrizzle Team

•Created by kbemaster on 2/26/2024 in #help

Shouldn't the fields related to the Query API be of type <T | undefined> ?

Thanks!

6 replies

DTDrizzle Team

•Created by kbemaster on 2/26/2024 in #help

Shouldn't the fields related to the Query API be of type <T | undefined> ?

I will try that

6 replies

DTDrizzle Team

•Created by kbemaster on 2/26/2024 in #help

Shouldn't the fields related to the Query API be of type <T | undefined> ?

const lesson = db.query.lessonTable
  .findFirst({
    where: (columns, { eq }) => eq(columns.id, "lessonId"),
    with:{
      author: true
    },
  });

// lesson.author.name -> error because author was undefined and I tried to access .name

const lesson = db.query.lessonTable
  .findFirst({
    where: (columns, { eq }) => eq(columns.id, "lessonId"),
    with:{
      author: true
    },
  });

// lesson.author.name -> error because author was undefined and I tried to access .name