nikivi Comments - Answer Overflow

Topics

nikivi

Explore posts from servers

DDeno RRailway SSolidJS DTDrizzle Team

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

as .execute breaks for me and all docs examples use .execute

7 replies

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

i wanted to try raw sql string but blocked on that too

7 replies

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

7 replies

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

async function getTopicsForSidebar() {
  try {
    const res = await db
      .select({ name: topics.name, parent: topics.parentId })
      .from(topics)
      .leftJoin(topics, eq(topics.id, topics.parentId))
      .all()
    console.log(res)
  } catch (e) {
    console.error(e)
  }
}

async function getTopicsForSidebar() {
  try {
    const res = await db
      .select({ name: topics.name, parent: topics.parentId })
      .from(topics)
      .leftJoin(topics, eq(topics.id, topics.parentId))
      .all()
    console.log(res)
  } catch (e) {
    console.error(e)
  }
}

7 replies

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

i tried to port it myself at first

7 replies

•Created by nikivi on 6/28/2023 in #help

Need help with join, ChatGPT says drizzle orm does not support it

7 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

you cant do execute on sqlite

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

maybe its sqlite related

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

but for me it complains

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

https://orm.drizzle.team/docs/sql#sql-template

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

like every doc example mentions .execute

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

this makes no sense though

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

ok this should be it

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

      await tx
        .select({ id: topics.id })
        .from(topics)
        .where(and(like(topics.name, topic), eq(topics.ownerId, 1)))
        .all()

      await tx
        .select({ id: topics.id })
        .from(topics)
        .where(and(like(topics.name, topic), eq(topics.ownerId, 1)))
        .all()

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

    .where(
      and(
        like(topics.name, ctx.req.param("topic")),
        eq(topics.ownerId, parseInt(ctx.req.param("id")))
      )

    .where(
      and(
        like(topics.name, ctx.req.param("topic")),
        eq(topics.ownerId, parseInt(ctx.req.param("id")))
      )

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

trying to find doc on how .where are chained

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

makes no sense

29 replies

•Created by nikivi on 6/27/2023 in #help

help with drizzle types not inferred well

29 replies