Cannot run "drizzle-kit generate" anymore
I run the following command: npm run generate The error is:"
No config path provided, using default 'drizzle.config.ts'
Reading config file '/home/bprovoos/Desktop/transcendence/packages/db/drizzle.config.ts'
Please install latest version of drizzle-orm
npm ERR! Lifecycle script
npm ERR! Error: command failed
npm ERR! in workspace: @repo/db@1.0.0
npm ERR! at location: /home/bprovoos/Desktop/transcendence/packages/db"
This is what the package.json look like:"
{
..
"scripts": {
"generate": "drizzle-kit generate",
"migrate": "drizzle-kit migrate",
"update": "drizzle-kit generate && drizzle-kit migrate",
"studio": "drizzle-kit studio",
"dev": "tsup src/index.ts --format cjs,esm --dts",
"build": "tsup src/index.ts --format cjs,esm --dts",
"clean": "rm -rf dist"
},
"devDependencies": {
"drizzle-kit": "^0.23.0"
},
"peerDependencies": {
"typescript": "latest"
},
"author": "Trancendence",
"dependencies": {
"drizzle-orm": "^0.32.1",
"drizzle-zod": "^0.5.1",
"postgres": "^3.4.4",
"tsup": "^8.2.2",
"zod": "^3.23.8"
},
"publishConfig": {
"access": "public"
}
}"
This is what the drizzle.config.ts file looks like:
"import { defineConfig } from 'drizzle-kit';
import * as dotenv from 'dotenv';
dotenv.config({
path: '../../.env',
});
if (!process.env.DATABASE_URL_LOCAL) {
throw new Error('cannot read .env OR DATABASE_URL_LOCAL is not set');
}
export default defineConfig({
schema: './src/schema.ts',
dialect: 'postgresql',
dbCredentials: {
url: process.env.DATABASE_URL_LOCAL,
},
migrations: { schema: './drizzle' },
verbose: true,
strict: true,
});"
As I run: ls -la ../../.env I get:
-rwxrwxrwx 1 bprovoos piscine 443 mrt 15 11:26 ../../.env
When I run: npm install drizzle-orm@latest then I get the same error. Can someone please help me
@repo/db@1.0.0 generate
drizzle-kit generate
No config path provided, using default 'drizzle.config.ts'
Reading config file '/home/bprovoos/Desktop/transcendence/packages/db/drizzle.config.ts'
Please install latest version of drizzle-orm
npm ERR! Lifecycle script
generatenpm ERR! Error: command failed
npm ERR! in workspace: @repo/db@1.0.0
npm ERR! at location: /home/bprovoos/Desktop/transcendence/packages/db"
This is what the package.json look like:"
{
..
"scripts": {
"generate": "drizzle-kit generate",
"migrate": "drizzle-kit migrate",
"update": "drizzle-kit generate && drizzle-kit migrate",
"studio": "drizzle-kit studio",
"dev": "tsup src/index.ts --format cjs,esm --dts",
"build": "tsup src/index.ts --format cjs,esm --dts",
"clean": "rm -rf dist"
},
"devDependencies": {
"drizzle-kit": "^0.23.0"
},
"peerDependencies": {
"typescript": "latest"
},
"author": "Trancendence",
"dependencies": {
"drizzle-orm": "^0.32.1",
"drizzle-zod": "^0.5.1",
"postgres": "^3.4.4",
"tsup": "^8.2.2",
"zod": "^3.23.8"
},
"publishConfig": {
"access": "public"
}
}"
This is what the drizzle.config.ts file looks like:
"import { defineConfig } from 'drizzle-kit';
import * as dotenv from 'dotenv';
dotenv.config({
path: '../../.env',
});
if (!process.env.DATABASE_URL_LOCAL) {
throw new Error('cannot read .env OR DATABASE_URL_LOCAL is not set');
}
export default defineConfig({
schema: './src/schema.ts',
dialect: 'postgresql',
dbCredentials: {
url: process.env.DATABASE_URL_LOCAL,
},
migrations: { schema: './drizzle' },
verbose: true,
strict: true,
});"
As I run: ls -la ../../.env I get:
-rwxrwxrwx 1 bprovoos piscine 443 mrt 15 11:26 ../../.env
When I run: npm install drizzle-orm@latest then I get the same error. Can someone please help me
