Scheduling infrastructure for absolutely everyone.
import { APPS_TYPE_ID_MAPPING } from "@calcom/platform-constants";
import { credentialForCalendarServiceSelect } from "@calcom/platform-libraries";
import type { Prisma } from "@calcom/prisma/client";
import { Injectable } from "@nestjs/common";
import { PrismaReadService } from "@/modules/prisma/prisma-read.service";
import { PrismaWriteService } from "@/modules/prisma/prisma-write.service";
@Injectable()
export class CredentialsRepository {
constructor(
private readonly dbRead: PrismaReadService,
private readonly dbWrite: PrismaWriteService
) {}
async upsertUserAppCredential(
type: keyof typeof APPS_TYPE_ID_MAPPING,
key: Prisma.InputJsonValue,
userId: number,
credentialId?: number | null
) {
return this.dbWrite.prisma.credential.upsert({
create: {
type,
key,
userId,
appId: APPS_TYPE_ID_MAPPING[type],
},
update: {
key,
invalid: false,
},
where: {
id: credentialId ?? 0,
},
});
}
async upsertTeamAppCredential(
type: keyof typeof APPS_TYPE_ID_MAPPING,
key: Prisma.InputJsonValue,
teamId: number,
credentialId?: number | null
) {
return this.dbWrite.prisma.credential.upsert({
create: {
type,
key,
teamId,
appId: APPS_TYPE_ID_MAPPING[type],
},
update: {
key,
invalid: false,
},
where: {
id: credentialId ?? 0,
},
});
}
findCredentialByTypeAndUserId(type: string, userId: number) {
return this.dbWrite.prisma.credential.findFirst({ where: { type, userId } });
}
/** Find a user's credential by type with delegation info (for unified calendar API). */
findCredentialWithDelegationByTypeAndUserId(type: string, userId: number) {
return this.dbRead.prisma.credential.findFirst({
where: { type, userId },
select: {
id: true,
type: true,
key: true,
invalid: true,
delegationCredentialId: true,
user: { select: { email: true } },
},
});
}
findAllCredentialsByTypeAndUserId(type: string, userId: number) {
return this.dbWrite.prisma.credential.findMany({ where: { type, userId } });
}
findCredentialByTypeAndTeamId(type: string, teamId: number) {
return this.dbWrite.prisma.credential.findFirst({ where: { type, teamId } });
}
findAllCredentialsByTypeAndTeamId(type: string, teamId: number) {
return this.dbWrite.prisma.credential.findMany({ where: { type, teamId } });
}
getAllUserCredentialsByTypeAndId(type: string, userId: number) {
return this.dbRead.prisma.credential.findMany({ where: { type, userId } });
}
getUserCredentialsByIds(userId: number, credentialIds: number[]) {
return this.dbRead.prisma.credential.findMany({
where: {
id: {
in: credentialIds,
},
userId: userId,
},
select: {
id: true,
type: true,
key: true,
encryptedKey: true,
userId: true,
teamId: true,
appId: true,
invalid: true,
user: {
select: {
email: true,
},
},
},
});
}
async getAllUserCredentialsById(userId: number) {
return await this.dbRead.prisma.credential.findMany({
where: {
userId,
},
select: credentialForCalendarServiceSelect,
orderBy: {
id: "asc",
},
});
}
async getUserCredentialById(userId: number, credentialId: number, type: string) {
return await this.dbRead.prisma.credential.findUnique({
where: {
userId,
type,
id: credentialId,
},
select: {
id: true,
type: true,
key: true,
userId: true,
teamId: true,
appId: true,
invalid: true,
user: {
select: {
email: true,
},
},
},
});
}
/** Find a user's credential by id only (for connection-scoped API). */
async findCredentialByIdAndUserId(credentialId: number, userId: number) {
return this.dbRead.prisma.credential.findFirst({
where: { id: credentialId, userId },
select: {
id: true,
type: true,
key: true,
invalid: true,
delegationCredentialId: true,
user: { select: { email: true } },
},
});
}
async deleteUserCredentialById(userId: number, credentialId: number) {
return await this.dbWrite.prisma.credential.delete({
where: { id: credentialId, userId },
});
}
}
export type CredentialsWithUserEmail = Awaited<
ReturnType<typeof CredentialsRepository.prototype.getUserCredentialsByIds>
>;