Drizzle Team

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

Drizzle Team

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

9/27/2023

Type cannot be inferred when using returning on insert

I have this function and it is causing typescript errors ``` export async function inviteUsers(data: z.infer<typeof sendInvitesValidator>) { const res = await db...

zendev

9/27/2023

get drizzle to correctly infer type with limit 1

If you do something simple like this: ```ts const user = await db .select() .from(users)...

nobody

9/27/2023

How to use drizzle as a sql builder?

I want to use drizzle with planet scale. Sadly for mysql drizzle does not support the returning function (although databasejs returns e.g the insertedId after an insert statement). Anyways I would be more than happy to just use drizzle as a SQL builder so I can pass the SQL to planet scale through databasejs. Any ideas how to achieve that? Awesome library by far, keep up the great work!

Nicolas

9/27/2023

How to make sql.placeholder() type safe

I have the following prepared statement: ``` export const listDeployments = db .select()...

Drew

9/27/2023

drizzle-kit tsconfig.json paths alias

Not a drizzle issue per-se, but running into an issue trying to make drizzle-kit work again by changing target to esnext. The database schema file references some other files using an alias defined in the tsconfig.json. Any advice on getting drizzle-kit to recognize this setting? ```json "compilerOptions": { "target": "esnext",...

Thogn

9/27/2023

how to set default null to an int column

I want the parentId to have the default Null, how to do that ``` export const comments = mysqlTable( 'comments',...

victormesquita.

9/26/2023

Can't run drizzle-kit push:pg - error: column is in a primary key

Hi,
I get this error every time i run push:pg error: column "userId" is in a primary key at Parser.parseErrorMessage (/Users/victormesquita/Documents/Projects/MobiData/node_modules/drizzle-kit/index.cjs:40722:98)...

Gruntilda

9/26/2023

Best way to get raw SQL for a SQLite insert statement (with inline parameters)?

I tried doing this: ``` class InlineSQLiteSyncDialect extends SQLiteSyncDialect { public inlineParams = true; }...

Jim

9/26/2023

id on transaction conflict

hey all, using mysql (planetscale). when a transaction conflict happens over an insert with the same 'serial' id i believe that mysql will resolve this by changing one of the inserts to the next available. my concern is that within a transaction i want to reference the returned id to use as a reference. will this id match the 'new' id after the conflict has resolved, or will it reference the original? here is some code to better explain maybe: ```ts...

Hugo

9/26/2023

Select Entry in db with relational tables

Hi, i'm using this request to get a store corresponding to the cuid, an di want to get also all his related categories from store_categories tabe ```js const result = await db.select() .from(stores) .where(eq(stores.cuid_store, cuid_store))...

zendev

9/26/2023

environment variables undefined in drizzle.config.ts

I have my config set up like this: ```ts import { type Config } from "drizzle-kit"; if (!process.env.DATABASE_URL) {...

dion

9/26/2023

Class inheritance (Inherits keyword)

Is there anyway to easily replicate this behaviour in drizzle?

``
-- Creating the parent table

person` CREATE TABLE person ( id SERIAL PRIMARY KEY,...

bipvanwinkle

9/25/2023

Drizzle w/o Typescript

I'm working on a project that is not currently using Typescript and is unlikely to start in the near future. Is Typescript required to use Drizzle?

cobite

9/25/2023

Omit not working for me

I am trying to use Omit to return the object with the id field removed:

export type Item = InferSelectModel<typeof items>;
export type ReturnItem = Omit<Item, 'id'> & {};

export type Item = InferSelectModel<typeof items>;
export type ReturnItem = Omit<Item, 'id'> & {};

...

Mr.T

9/25/2023

Can't filter using 'query' when relation is one to one

Hello, I'm trying to use where filter on this query: ``` const qb = db.query.event.findMany({ with: { workoutSession: { where: eq(workoutSession.athleteId, userId),...

GabrielC

9/25/2023

How can I get a type from SelectedFields<MySqlColumn, Table>?

Hi guys sorry to bother buy I'm trying to build a Repository Pattern with Drizzle and I stuck with a type. The interface with I came up is ```ts interface BaseRepository<T extends MySqlTable,...

0xMazout

9/25/2023

Insert and Select Schema - Force to overide type , because types of Serials, boolean are unknown

Hello it's more a question than an help because i have find the answer In the previous version i didn't have the needs to override my Insert and Select Schema because it detected very well my types. (screenshot 1) Now if i delete my override i have an error of mismatching type. ( screenshot 2)...

eatmoose

9/25/2023

storing time?

Hello, how to store time in drizzle? If I store new Date(), does it handle timezone? Is it stored as utc or Unix milliseconds?

cobite

9/24/2023

Making a column only allow letters and characters, including capitals

I am using Yup for my validation on the client side. For example the username field does this:

.matches(/^[a-zA-Z0-9]*$/, 'Username can only contain letters and numbers')

.matches(/^[a-zA-Z0-9]*$/, 'Username can only contain letters and numbers')

My user schema on the drizzle side is:...

maupiszon

9/24/2023

How to use Query with relations ?

Hello, I'm encountering an issue when trying to execute a query with relations in my code. Here's the function I'm working with: ```ts async getOneWithRelations(id: string): Promise<AlbumWithRelationsResponse> { const { db, withErrorHandling } = this; return withErrorHandling(async () => {...

Previous Next

Gaming

Programming

Drizzle Team

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

Drizzle Team

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