makaron pelnoziarnisty Posts

makaron pelnoziarnisty

Explore posts from servers

DIAdiscord.js - Imagine an app TtRPC DTDrizzle Team

•Created by makaron pelnoziarnisty on 2/8/2024 in #help

Cannot read properties of undefined (reading 'columns')

I'm using turso, trying to push with Drizzle Kit, but unfortunately getting this error:

> drizzle-kit push:sqlite

No config path provided, using default path
Reading config file 'x\drizzle.config.ts'
drizzle-kit: v0.20.14
drizzle-orm: v0.29.3

TypeError: Cannot read properties of undefined (reading 'columns')
    at _moveDataStatements (x\drizzle-kit\bin.cjs:62603:61)
    at logSuggestionsAndReturn2 (x\drizzle-kit\bin.cjs:62828:39)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Command.<anonymous> (x\drizzle-kit\bin.cjs:63311:11)

> drizzle-kit push:sqlite

No config path provided, using default path
Reading config file 'x\drizzle.config.ts'
drizzle-kit: v0.20.14
drizzle-orm: v0.29.3

TypeError: Cannot read properties of undefined (reading 'columns')
    at _moveDataStatements (x\drizzle-kit\bin.cjs:62603:61)
    at logSuggestionsAndReturn2 (x\drizzle-kit\bin.cjs:62828:39)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Command.<anonymous> (x\drizzle-kit\bin.cjs:63311:11)

5 replies

DTDrizzle Team

•Created by makaron pelnoziarnisty on 7/4/2023 in #help

Delete limit

Hi, how do I delete just 1 row from a table?

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

13 replies

DTDrizzle Team

•Created by makaron pelnoziarnisty on 6/17/2023 in #help

Full Text Search

Is it possible to add full text indexes in Drizzle (MySQL)? If not, can we expect it to be supported in the future?

3 replies

DTDrizzle Team

•Created by makaron pelnoziarnisty on 6/8/2023 in #help

Error when running drizzle-kit generate:mysql

I have no clue what this means

...>pnpm drizzle-kit generate:mysql
drizzle-kit: v0.17.1
drizzle-orm: v0.26.5

No config path provided, using default 'drizzle.config.ts'
Reading config file '...\drizzle.config.ts'
Reading schema files:
...\schemas\orders.ts
...\schemas\products.ts
...\schemas\promoCodes.ts
...\schemas\subscriptions.ts
...\schemas\users.ts
...\schemas\verificationTokens.ts
Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './table' is not defined by "exports" in ...\node_modules\drizzle-orm\package.json
    at __node_internal_captureLargerStackTrace (node:internal/errors:484:5)
    at new NodeError (node:internal/errors:393:5)
    at src/serializer/mysqlSerializer.ts (...\node_modules\.pnpm\drizzle-kit@0.17.1-609a4f0\node_modules\drizzle-kit\index.js:25853:20)

...>pnpm drizzle-kit generate:mysql
drizzle-kit: v0.17.1
drizzle-orm: v0.26.5

No config path provided, using default 'drizzle.config.ts'
Reading config file '...\drizzle.config.ts'
Reading schema files:
...\schemas\orders.ts
...\schemas\products.ts
...\schemas\promoCodes.ts
...\schemas\subscriptions.ts
...\schemas\users.ts
...\schemas\verificationTokens.ts
Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './table' is not defined by "exports" in ...\node_modules\drizzle-orm\package.json
    at __node_internal_captureLargerStackTrace (node:internal/errors:484:5)
    at new NodeError (node:internal/errors:393:5)
    at src/serializer/mysqlSerializer.ts (...\node_modules\.pnpm\drizzle-kit@0.17.1-609a4f0\node_modules\drizzle-kit\index.js:25853:20)

5 replies

DTDrizzle Team

•Created by makaron pelnoziarnisty on 5/14/2023 in #help

Connecting to Vercel Postgres

I'm trying to connect to Vercel Postgres like this:

import { drizzle } from "drizzle-orm/vercel-postgres";
import { sql } from "@vercel/postgres";

export const db = drizzle(sql, { logger: true });

import { drizzle } from "drizzle-orm/vercel-postgres";
import { sql } from "@vercel/postgres";

export const db = drizzle(sql, { logger: true });

But I'm getting this error:

n [VercelPostgresError]: VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString' and no 'POSTGRES_URL' env var was found.

It seems like there's no credentials passing here and this sql thing should read the connection string from .env file which you need to pull from Vercel? Am I doing something wrong or is the Vercel + Drizzle ORM mix not supported in dev environment yet?

6 replies

DTDrizzle Team

•Created by makaron pelnoziarnisty on 4/12/2023 in #help

Config in Typescript?