Scheduling infrastructure for absolutely everyone.
import { PrismaClient } from "@calcom/prisma/client";
import { Injectable, Logger, OnModuleDestroy, OnModuleInit } from "@nestjs/common";
import { ConfigService } from "@nestjs/config";
import { PrismaPg } from "@prisma/adapter-pg";
import { Pool } from "pg";
const DB_MAX_POOL_CONNECTION = 5;
export interface PrismaServiceOptions {
writeUrl?: string;
maxWriteConnections?: number;
e2e?: boolean;
usePool?: boolean;
type: "main" | "worker";
}
@Injectable()
export class PrismaWriteService implements OnModuleInit, OnModuleDestroy {
private logger = new Logger("PrismaWriteService");
public prisma!: PrismaClient;
private pool!: Pool;
constructor(configService?: ConfigService) {
if (configService) {
const writeUrl = configService.get<string>("db.writeUrl", { infer: true });
const poolMax = parseInt(
String(configService.get<number>("db.writePoolMax", { infer: true }) ?? DB_MAX_POOL_CONNECTION),
10
);
const e2e = configService.get<boolean>("e2e", { infer: true }) ?? false;
const usePool = configService.get<boolean>("db.usePool", { infer: true }) ?? true;
this.setOptions({
writeUrl,
maxWriteConnections: poolMax,
e2e,
usePool,
type: "main",
});
}
}
setOptions(options: PrismaServiceOptions): void {
const dbUrl = options.writeUrl;
const isE2E = options.e2e ?? false;
const usePool = options.usePool ?? true;
if (usePool) {
let maxWriteConnections = options.maxWriteConnections ?? DB_MAX_POOL_CONNECTION;
if (isE2E) {
maxWriteConnections = 1;
}
this.pool = new Pool({
connectionString: dbUrl,
max: maxWriteConnections,
idleTimeoutMillis: 300000,
});
const adapter = new PrismaPg(this.pool);
this.prisma = new PrismaClient({ adapter });
} else {
const adapter = new PrismaPg({ connectionString: dbUrl });
this.prisma = new PrismaClient({
adapter,
});
}
}
async onModuleInit(): Promise<void> {
if (!this.prisma) return;
try {
await this.prisma.$connect();
this.logger.log("Connected to write database");
} catch (error) {
this.logger.error("Database connection failed", error);
}
}
async onModuleDestroy(): Promise<void> {
try {
if (this.prisma) await this.prisma.$disconnect();
if (this.pool) await this.pool.end();
} catch (error) {
this.logger.error("Error disconnecting from write database", error);
}
}
}