msu Posts - Answer Overflow

msu

Explore posts from servers

•Created by msu on 10/2/2023 in #help

Does Drizzle autogenerate prepared statements under the hood?

Supabase is telling me that PGBouncer and their own Supavisor both don't support prepared statements. We don't use prepared statement but I see queries that look like autogenerated prepared statement ids If so, can we disable it?

9 replies

DTDrizzle Team

•Created by msu on 9/17/2023 in #help

Delete limit and offset?

I get Property 'limit' does not exist on type 'Omit<PgDelete<PgTableWithColumns> const results = await db .delete(scheduledCalls) .where(eq(scheduledCalls.queueName, queueName)) .limit(limit) .offset(offset)

13 replies

DTDrizzle Team

•Created by msu on 9/17/2023 in #help

Relational delete with returning

Is there a way to get deleted rows back but also selecting relations? Right now we have:

  const results = await db.query.scheduledCalls.findMany({
    limit,
    offset,
    where: eq(scheduledCalls.queueName, queueName),
    with: {
      lead: true,
    },
  });

  const results = await db.query.scheduledCalls.findMany({
    limit,
    offset,
    where: eq(scheduledCalls.queueName, queueName),
    with: {
      lead: true,
    },
  });

But we want to do with the delete() and returning()

4 replies

DTDrizzle Team

•Created by msu on 9/16/2023 in #help

How do you infer the type of a relations query?

I tried infer model and schema but it misses the relations created

5 replies

DTDrizzle Team

•Created by msu on 9/8/2023 in #help

Postgres read slaves?

Is there a way to connect the orm to use a read slave for selects and master for writes?

16 replies

DTDrizzle Team

•Created by msu on 6/9/2023 in #help

"bind message supplies 1 parameters, but prepared statement \"\" requires 0"

  const results = await drizzleDb
    .select({ count: sql<number>`count(*)` })
    .from(calls)
    .where(
      sql`${calls.accountSid} = '${accountSid}' AND (${calls.createdAt} AT TIME ZONE 'EST')::date = current_date`
    );

  const results = await drizzleDb
    .select({ count: sql<number>`count(*)` })
    .from(calls)
    .where(
      sql`${calls.accountSid} = '${accountSid}' AND (${calls.createdAt} AT TIME ZONE 'EST')::date = current_date`
    );

throw: "bind message supplies 1 parameters, but prepared statement \"\" requires 0" It looks to me like accountSid is a parameter that's needed, but not sure why this isn't working.

2 replies

Gaming

Programming