Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Join

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Join

liv

6/22/2023

re-formatting duplicated data

so i have a db with the schema shown below a userPost object consists of the following: ```...

Battle

6/22/2023

Transforming const to the configured target environment ("es5") is not supported yet

Below is my schema file. `import { InferModel } from 'drizzle-orm' import { mysqlTable, serial, text, timestamp } from 'drizzle-orm/mysql-core' ...

liv

6/21/2023

nested relation queries

```graphql userPost: { id, description, createdAt,...

Aimen

6/21/2023

CommonJS import error

I'm using drizzle inside of a scipt the is commonJS. ``` node version: v18.16.0 drizzle-orm: 0.26.5...

Startup Spells 🪄 Newsletter Guy

6/21/2023

Unable to delete all rows from SQLite using Transactions?

i have a route api/delete-all that looks like: ```ts import { NextResponse } from 'next/server' ...

Goldstair

6/21/2023

Inserting into columns of type Enum

Hi, any code written here was done in TypeScript and the database I’m connecting to is AWS Aurora PostgreSQL. (I’m on mobile, sorry about the format) I’ve defined an enum as follows:...

PapaFinn

6/20/2023

Extracting literal values from Drizzle enums

I'm trying to make a zod enum schema from the values of a Drizzle enum I've created. I've looked through several other posts trying to do the same thing and it's unclear to me how to do this, particularly for mysqlEnum. The most promising way came from inspecting the enums at runtime. I found that I could access the values, just as I wanted, at myEnum.config.enumValues. The only problem is that Typescript declares config protected and I get type errors.

liv

6/20/2023

`where` within `where`? confused about complex query

```ts export const posts = pgTable('posts', { id: uuid('id').defaultRandom().primaryKey(), userId: char('user_id', { length: 17 }).notNull().references(() => users.id), description: text('description'),...

Mendy

6/20/2023

IS IT POSSIBLE: to use a relation field in a where clause?

Anyone knows if it's possible to have a nested relation in a where clause?

Cory

6/20/2023

Is there a way to save the generated response Type from a query?

I see that when you hover over the type for the response of a query, you can see what data will be returned. Is there a way to extract, or save that Type somehow, so I can use it elsewhere?

josefkjaergaard

6/20/2023

Ordering by relation in relational query

I am trying to sort on an attribute of a relation using the relational queries api, but as far as I can tell it is not supported? Example: ``` await db.query.city.findMany({...

artur_gabrielyan

6/20/2023

Nested Schema, Helper Functions

Hi, I am new to Drizzle. 1. I have the following User schema and I was wondering is there any way for combining some columns in one type, in this case I want to merge all profile fields into one type. const User = pgSchema(configService.postgres.schema).table('users', {...

liv

6/19/2023

types from nested relational queries

wondering what the type of user is? ```ts async function getUserWithSettings(steamId: string): Promise<User> { const user = await db.query.users.findFirst({ where: (user, { eq }) => eq(user.steamId, steamId),...

alex (he/him)

6/19/2023

drizzle-kit@win still not working. What am I doing wrong?

/Users/alexanderniebuhr/Developer/Projects/alexanderniebuhr_blog/packages/db/drizzle.config.ts ``` import type { Config } from 'drizzle-kit' export default {...

Michael

6/19/2023

SQLITE_ERROR: near "ilike": syntax error

I've currently setup an my SQL query as follows: ```ts export const getObservationsByUserId = async ( db: LibSQLDatabase,...

liv

6/19/2023

Composite Primary Key from Foreign Keys

```ts export const userItemsHas = pgTable('user_items_has', { postId: uuid('post_id').references(() => posts.id), userItemId: serial("user_item_id").references(() => userItems.id), },(table) => {...

Julian1001

6/19/2023

Introspect command failing

I'm setting up Drizzle for the first time, I'm trying to get the introspect command to run with mysql / planetscale. When I run introspect I get "Expected undefined or a fully resolved URL string to be returned for the "responseURL" from the "drizzle-kit/loader.mjs 'load'" function but got instance of String.". Has anyone seen this one before? package.json...

SPS | Shootmail

6/19/2023

Error while push:sqlite after update

I am getting this error while using