import { PrismaClient } from '@prisma/client';
import { config } from '../config';

export const database: PrismaClient = new PrismaClient({
  datasources: {
    db: {
      url: createConnectionUrl(config.database),
    }
  }
});

export function createConnectionUrl(params: { username: string, password: string; host: string; port: number; name: string; schema?: string }): string {
  const { username, password, host, port, name, schema } = params;
  return `postgresql://${username}:${password}@${host}:${port}/${name}?schema=${schema ?? 'public'}`
}