Skip to content

Infisical is the open-source platform for securing secrets, certificates, access, and AI Agents.

1.7 KB
Raw Blame
import { TDbClient } from "@app/db";
import { TableName } from "@app/db/schemas";
import { DatabaseError } from "@app/lib/errors";
import { ormify } from "@app/lib/knex";

export type TProjectAccessRequestDALFactory = ReturnType<typeof projectAccessRequestDALFactory>;

export const projectAccessRequestDALFactory = (db: TDbClient) => {
  const orm = ormify(db, TableName.ProjectAccessRequest);

  const findPendingForRequesterInOrg = async (requesterUserId: string, orgId: string) => {
    return db
      .replicaNode()(TableName.ProjectAccessRequest)
      .join(TableName.Project, `${TableName.Project}.id`, `${TableName.ProjectAccessRequest}.projectId`)
      .where(`${TableName.ProjectAccessRequest}.requesterUserId`, requesterUserId)
      .where(`${TableName.ProjectAccessRequest}.status`, "pending")
      .where(`${TableName.Project}.orgId`, orgId)
      .select<{ projectId: string; createdAt: Date }[]>(
        `${TableName.ProjectAccessRequest}.projectId`,
        `${TableName.ProjectAccessRequest}.createdAt`
      );
  };

  const upsertPendingRequest = async ({
    projectId,
    requesterUserId,
    comment
  }: {
    projectId: string;
    requesterUserId: string;
    comment: string | null;
  }) => {
    try {
      const [row] = await db(TableName.ProjectAccessRequest)
        .insert({ projectId, requesterUserId, status: "pending", comment })
        .onConflict(["projectId", "requesterUserId"])
        .merge({ status: "pending", comment, createdAt: db.fn.now() } as never)
        .returning("*");
      return row;
    } catch (error) {
      throw new DatabaseError({ error, name: "UpsertPendingProjectAccessRequest" });
    }
  };

  return { ...orm, findPendingForRequesterInOrg, upsertPendingRequest };
};