No matter what I try, npm run migrate defaults to my .env file. Npm run generate works just fine.

import { defineConfig } from "drizzle-kit";
import dotenv from "dotenv";
import path from "path";

// Load environment variables
const envFile =
  process.env.NODE_ENV === "production" ? ".env" : ".env.development";
const absolutePath = path.resolve(process.cwd(), envFile);



dotenv.config({ path: absolutePath });

const DB_URL = process.env.DATABASE_URL;

if (!DB_URL) {
  console.error("DATABASE_URL is not defined in the environment variables.");
  process.exit(1); // Terminate the application
}

/** @type { import("drizzle-kit").Config } */
export default defineConfig({
  dialect: "postgresql",
  schema: "./src/db/schema.ts",
  out: "./src/db/drizzle",
  dbCredentials: {
    url: DB_URL,
  },
});

import { defineConfig } from "drizzle-kit";
import dotenv from "dotenv";
import path from "path";

// Load environment variables
const envFile =
  process.env.NODE_ENV === "production" ? ".env" : ".env.development";
const absolutePath = path.resolve(process.cwd(), envFile);



dotenv.config({ path: absolutePath });

const DB_URL = process.env.DATABASE_URL;

if (!DB_URL) {
  console.error("DATABASE_URL is not defined in the environment variables.");
  process.exit(1); // Terminate the application
}

/** @type { import("drizzle-kit").Config } */
export default defineConfig({
  dialect: "postgresql",
  schema: "./src/db/schema.ts",
  out: "./src/db/drizzle",
  dbCredentials: {
    url: DB_URL,
  },
});