machour Comments - Answer Overflow

Topics

machour

•Created by machour on 5/17/2023 in #help

Proper query results inference

Thank you both in advance!

8 replies

•Created by machour on 5/17/2023 in #help

Proper query results inference

I've been postponing a launch for a few days now

8 replies

•Created by machour on 5/17/2023 in #help

Proper query results inference

@Andrew Sherman I'd definitely appreciate if you can give this a look 🙏

8 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

And I also needed to tap into query._.selectedFields 😁

9 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

generating an additional generated.ts file re-exporting from the generated files would also help I guess

9 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

I also needed the SelectResult type, but it seems to only be defined in generated files under node_modules/drizzle-orm/ :/

9 replies

•Created by Zen on 5/7/2023 in #help

Replace on Insert

I see a onDuplicateKeyUpdate for MySQL tho

10 replies

•Created by Zen on 5/7/2023 in #help

Replace on Insert

well, using MySQL that would be a REPLACE INTO ..

10 replies

•Created by Zen on 5/7/2023 in #help

Replace on Insert

just discovered that all drivers don't implement all methods 😅

10 replies

•Created by Zen on 5/7/2023 in #help

Replace on Insert

Check this: https://github.com/drizzle-team/drizzle-orm/blob/ee82b36acc3da94cc3a2f1a5c18f76e6476b1508/drizzle-orm/src/pg-core/README.md#upsert-insert-with-on-conflict-statement

10 replies

•Created by Zen on 5/7/2023 in #help

Replace on Insert

Still discovering Drizzle, but I think you're looking for onConflictDoUpdate() to make an upsert

10 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

My use case is for a data provider function, where I pass a query, and it gives me back paginated results (adding limit().offset()) and and the global pagination info

9 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

In that case, would changing config visibility something that could be considered?

9 replies

•Created by machour on 5/7/2023 in #help

Is there a way to modify the select() on an existing query ?

I feel like the answer to my question is no, since the initial .select().from() is crucial for Drizzle typing..

9 replies