mr_pablo Comments - Answer Overflow

Topics

mr_pablo

•Created by asch on 8/29/2024 in #help

Does drizzle support querying across multiple mysql databases (same mysql server)?

yea, i need to query across the 2 DBs. Did you ever actually try it? Using db.select, how would I target the different databases?

5 replies

•Created by asch on 8/29/2024 in #help

Does drizzle support querying across multiple mysql databases (same mysql server)?

Any update on this? I have a use case for multiple databases on the same server. @asch where did you get up to without being able to use RQB?

5 replies

•Created by mr_pablo on 9/21/2023 in #help

MySQL UUID as PK

I did

logID: varchar('logID', { length: 48 }).default(sql`UUID()`).primaryKey(),

logID: varchar('logID', { length: 48 }).default(sql`UUID()`).primaryKey(),

and

logID: varchar('logID', { length: 48 }).default(sql`'UUID()'`).primaryKey(),

logID: varchar('logID', { length: 48 }).default(sql`'UUID()'`).primaryKey(),

These don't work. MySQL has a UUID() method, but as mentioned, right now, despite using the magic sql operator, the literal string value of UUID() is being inserted, not an actual UUID

7 replies

•Created by mr_pablo on 9/21/2023 in #help

MySQL UUID as PK

Oh, and I'm using Drizzle ORM 0.28.2 and Kit 0.19.13

7 replies

•Created by wdbsb on 8/8/2023 in #help

Baseline for introspected schema

my issue was i had breakpoints, and messed them up when editing a migration manually

48 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

put the loop inside the transaction

72 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

this doesnt seem like a drizzle issue

72 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

take drizzle out of the equation; how would you get the current value ?

72 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

the above code will work, its exactly what im doing in my code

72 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

well it can't be, it has to be an object

72 replies

•Created by --MON-- on 9/12/2023 in #help

onDuplicateKeyUpdate

do

await db.insert(myTable)
.values({id: id, name: name, etc})
.onDuplicateKeyUpdate({
  set: {name: name, etc}
})

await db.insert(myTable)
.values({id: id, name: name, etc})
.onDuplicateKeyUpdate({
  set: {name: name, etc}
})

72 replies

•Created by mr_pablo on 7/14/2023 in #help

orderBy related table column

So I can't do it just yet? Or it just a documentation issue?

9 replies

•Created by mr_pablo on 7/14/2023 in #help

orderBy related table column

yea

9 replies

•Created by mr_pablo on 7/14/2023 in #help

orderBy related table column

@Andrew Sherman any ideas?

9 replies

•Created by mr_pablo on 7/14/2023 in #help

orderBy related table column

I haven't yet

9 replies

•Created by wdbsb on 8/8/2023 in #help

Baseline for introspected schema

Hmm, looks like it was the breakpoints causing the issue. Seems the last statement in the SQL should not have a breakpoint

48 replies

•Created by wdbsb on 8/8/2023 in #help

Baseline for introspected schema

@Andrew Sherman I'm seeing the same "Query is empty" error. The migrations actually run, as I can see the changes, but the drizzle migration table does not get updated. Annoyingly, in my case, I;ve had to hand recreate my latest migration, as it's work done by a colleague in a different branch thats now being merged in

48 replies

•Created by mr_pablo on 8/25/2023 in #help

Cannot drop primary key

appreciate you taking your time to respond and look into it

19 replies