Argument of type 'SQL<unknown>' is not assignable to parameter
I have the following:
```ts
const projects = await db
.select()...
documented types for the return of `drizzle()` and the return of `mysqlTable()`
my most pressing need is documented types: https://github.com/drizzle-team/drizzle-orm/issues/273
Specifically the 2 that are holding me up right now are how to pass a the mysql2 version of drizzle() (aka a db reference) and a model reference (the result of mysqlTable()) around through my app...
.andWhere()
I know that
.andWhere()
isn't a function, but I'm wondering if there's a way to start a query in one function, and return it. And then have the receiver be able to continue to add to the where clause?
Something like:
```ts...Example failed to run: `pg` does not provide an export named `Pool`
I'm trying to run the example from the
README
file. I made a minial version, installed pg
, @types/pg
, drizzle-orm
and drizzle-kit
and tried to run it via tsx
.
This is my stripped down example:
```
import { drizzle } from "drizzle-orm/node-postgres";...how do you pass a query in a typesafe way?
Let's say i want to paginate a query, so I'm going to pass a query such as this to a pagination function
...
db.select().from(users).where(like(users.email, '%@gmail.com'))
db.select().from(users).where(like(users.email, '%@gmail.com'))
help with column builder types
As I play around with learning drizzle, I wondered if I could generate a drizzle schema from a master schema. I'm very close to being able to do that. As you can see in this repo I created: https://github.com/rizen/drizzle-icing/blob/main/user.ts
The code works perfectly, but problem is that when I try to use
InferModel
to get the column types from my schema, I'm getting
```ts...migration on mysql errors
I've written this migrator:
```ts
import { migrate } from 'drizzle-orm/mysql2/migrator';
import { drizzle } from 'drizzle-orm/mysql2';...
drizzle-kit generates mysql 8 syntax, but AWS Aurora uses 5.7 syntax, any way to switch?
I think the title says it all
error: there is no transaction in progress
I created a drizzle table:
```ts
export const passwordTypeEnum = pgEnum('passwordType', ['bcrypt']);
export const useAsDisplayNameEnum = pgEnum('useAsDisplayName', ['username', 'email', 'realName']);...
Having a problem just connecting with drizzle
Howdy, I just found out about drizzle and thought I might give it a try, but unfortunately I'm having trouble just getting the example working from the documentation.
I've created this sample file:
```ts...