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!

11/12/2023

Duplicate indexes when using `serial('').primaryKey()`

I have observed than whenever I use serial('id').primaryKey() in one of my tables, the primary key index gets duplicated. ```text mysql> SHOW INDEXES FROM tokens; +--------+------------+--------------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+...

11/11/2023

Multiple .where() calls with $dynamic not working

When adding multiple .where() calls to a query created with .$dynamic() only the last .where() call gets applied to the resulting query. I put together the following example that adds two .where() calls but only the last one is applied. You can see the resulting query in the console. https://codesandbox.io/p/sandbox/charming-herschel-8c9rk6?file=%2Findex.js%3A7%2C11...

potato

11/11/2023

Can't figure out this simple one-to-many relationship

Hey, so i have two tables, a patient one and a village one. I just want to define a simple one-to-many, one village for many patients, what am I missing here? My villageRelations is throwing type errors `export const patient = mysqlTable("patient", {...

danEE

11/11/2023

InferSelectModel on views

Is there any possibility to get correct typescript types from views? There seems to be nothing like InferSelectModel for views. Appreciate your help!...

CharlesCharlieCharles

11/11/2023

get last inserted id with mysql

noob question, but what is the preffered way to get the last inserted id using mysql? const data = await db.insert(brand).values(brandInsert) const lastId = ?? ...

Twiser

11/11/2023

How to retrieve database credentials from drizzle.config.ts

I'm attempting to retrieve Neon database credentials dynamically from drizzle.config.ts , instead of saving them in a .env, by running drizzle-kit push. The issue, both methods I tried rely on top-level await and throw Top-level await is currently not supported with the "cjs" output format exception. 1. @aws-sdk/client-ssm example: ``` const { SSMClient, GetParameterCommand } = require("@aws-sdk/client-ssm");...

srleom

11/11/2023

How to query todos from multiple lists/all lists

Using drizzle ORM and SvelteKit, how do I select todos from multiple lists or all lists? Right now this query function only allows me to query 1 list. I'm still an amateur trying to figure out SvelteKit and Drizzle. Appreciate the help!...

paaradiso

11/11/2023

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

would i have to use raw sql & an if/else statement?

SacredAI

11/10/2023

mysql 5.7.4 lateral issues

Mysql 5.7.4 doesn't include the lateral joins which is the default for drizzle query builder. Is there anyway to tell drizzle not to use lateral joins so I can use the query builder?...

makisuo

11/10/2023

Extracting the Query "With" Type

As title said I'm trying to extract the with type of a query, I tried out a bunch of stuff with no luck so far.

const query = db.user.findFirst({ with: This Type})

const query = db.user.findFirst({ with: This Type})

...

T.T

11/10/2023

Table foreign key action fields

Hello, I'd like to use the new foreignKey option inside the table config so that I do not have issues with the identifier being longer than allowed. Is there a way to achieve this whilst also setting the onCascade and onUpdate action properties like you could previously with the .references() syntax? I tried leaving both of them in place (like in the code below) with the hope that it would only generate one foreign key with my name provided and the actions I set with references() but it generates two constraints in the SQL migration file, one with my custom identifier and no actions and one with the default generated constraint name (too long for my DB) and with the actions. I didn't really expected this to work but It would be good to know the best approach going forward to set the custom FK name and also set the actions. Perhaps it is something missed with the latest update for the new foreignKey() functionality? (I could always just change the migration file manually, like I had previously been doing for the foreign key names which were too long but they kept coming back in future migrations with the default generated name, presumably because the _journal.json files have references to the generated fk names which I had overwritten?)...

Vengeance

11/10/2023

Decimal Inferred is a string

Any idea why my decimal is being inferred as a string instead of a number?

Solution:

This is correct behavior. The problem is that decimal can have a lot more decimals than a JS number. See here for more info https://github.com/drizzle-team/drizzle-orm/issues/1026#issuecomment-1694040929

Emerson

11/10/2023

error with ILIKE on libsql

I'm trying to use ILIKE clause on libsql and I receive a error. Repository to reproduce the error: https://github.com/emersonlaurentino/libsql-ilike-error...

Emerson

11/10/2023

Dynamic query building

I'm trying to replicate the documentation and create a withPagination function using query building, but the types are causing an error. https://orm.drizzle.team/docs/dynamic-query-building...

Glorrin

11/10/2023

Another SSL error on import

I have an existing database and I wanted to try drizzle on it. Database is from a lesser known provider and is impossible to find reliable help to access it, but unfortunately I cannot change it. I want to use drizzle-kit introspect:pg here is my drizzle.config.ts...

Sophon

11/10/2023

Confusing error with neon

Hi all! Just setup a project with drizzle (via create-t3-app) but I get this odd, vague error when I try to push my schema to my neon db. Any ideas on how to even begin debugging this? ```$ dotenv drizzle-kit push:pg drizzle-kit: v0.19.13 drizzle-orm: v0.28.6 ...

justaname

11/10/2023

Generate Random UUID Sqlite

Hey i was wondering how i would create a unique ID that contains a random string of characters for a text?

model User {
  id             String       @id @default(uuid())
}

model User {
  id             String       @id @default(uuid())
}

Something like this but instead of mysql and primsa. Have Sqlite and Drizzle...

algoguy

11/10/2023

Logging query time

Is it possible to log query time? I see that the current logger implementation sends the sql and the params of sql but I couldn't find anything which lets me see the time it took to run the query

LaunchThat.App

11/10/2023

[How To?] Generate uuids properly on cloudflare d1 sqlite...

I am running an app with Drizzle, TRPC, and Cloudflare D1 sqlite database: My initial project databasse schema looks like: ``` export const CarTable = sqliteTable('Car', {...

thdxr

11/10/2023

Dropping primary keys every time

so latest drizzle-kit fixed a bunch of issues with dropping indexes and preserving pk order but it's still dropping and recreating PKs every time

``
ALTER TABLE

account` DROP PRIMARY KEY;...

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!