// drizzle.config.ts
import { defineConfig } from "drizzle-kit";
import { Resource } from "sst";

export default defineConfig({
  dialect: "postgresql",
  dbCredentials: {
    user: Resource.MyDatabase.username,
    password: Resource.MyDatabase.password,
    host: Resource.MyDatabase.host,
    port: Resource.MyDatabase.port,
    database: Resource.MyDatabase.database,
  },
  schema: ["./src/**/*.sql.ts"],
  out: "../../migrations",
});

// sst.config.ts
/// <reference path="./.sst/platform/config.d.ts" />
export default $config({
  app(input) {
    return {
      name: "project-name-here",
      removal: input?.stage === "production" ? "retain" : "remove",
      home: "aws",
    };
  },
  async run() {
    const vpc = new sst.aws.Vpc("MyVpc", {
      bastion: true, // enable this if you want to use sst tunnel to connect to the database from your local machine
    });

    const database = new sst.aws.Postgres("MyDatabase", {
      vpc,
    });

    new sst.aws.Nextjs("MyWeb", {
      vpc,
      link: [database],
    });
  },
});

import { Resource } from "sst";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";

const client = new Pool({
  user: Resource.MyDatabase.username,
  password: Resource.MyDatabase.password,
  database: Resource.MyDatabase.database,
  host: Resource.MyDatabase.host,
  port: Resource.MyDatabase.port,
});

export const db = drizzle(client, {
  logger:
    process.env.DRIZZLE_LOG === "true"
      ? {
          logQuery(query, params) {
            console.log("query:", query);
            console.log("params:", params);
          },
        }
      : undefined,
});