Skip to content

armgit / Cap

Public Imported from GitHub
0

Open source Loom alternative. Beautiful, shareable screen recordings.

3.2 KB
Raw Blame
import * as Db from "@cap/database/schema";
import type { Organisation, User, Video } from "@cap/web-domain";
import * as Dz from "drizzle-orm";
import { Array, Effect, Option } from "effect";

import { Database } from "../Database.ts";

export class OrganisationsRepo extends Effect.Service<OrganisationsRepo>()(
	"OrganisationsRepo",
	{
		effect: Effect.gen(function* () {
			const db = yield* Database;

			return {
				membershipsForVideos: (
					userId: User.UserId,
					videoIds: readonly Video.VideoId[],
				) =>
					db.use((db) =>
						db
							.select({
								videoId: Db.sharedVideos.videoId,
								membershipId: Db.organizationMembers.id,
							})
							.from(Db.organizationMembers)
							.innerJoin(
								Db.sharedVideos,
								Dz.eq(
									Db.organizationMembers.organizationId,
									Db.sharedVideos.organizationId,
								),
							)
							.where(
								Dz.and(
									Dz.eq(Db.organizationMembers.userId, userId),
									Dz.inArray(Db.sharedVideos.videoId, [...videoIds]),
								),
							),
					),
				membershipForVideo: (userId: User.UserId, videoId: Video.VideoId) =>
					db.use((db) =>
						db
							.select({ membershipId: Db.organizationMembers.id })
							.from(Db.organizationMembers)
							.leftJoin(
								Db.sharedVideos,
								Dz.eq(
									Db.organizationMembers.organizationId,
									Db.sharedVideos.organizationId,
								),
							)
							.where(
								Dz.and(
									Dz.eq(Db.organizationMembers.userId, userId),
									Dz.eq(Db.sharedVideos.videoId, videoId),
								),
							),
					),
				membership: (userId: User.UserId, orgId: Organisation.OrganisationId) =>
					db
						.use((db) =>
							db
								.select({
									membershipId: Db.organizationMembers.id,
									ownerId: Db.organizations.ownerId,
									role: Db.organizationMembers.role,
								})
								.from(Db.organizations)
								.leftJoin(
									Db.organizationMembers,
									Dz.and(
										Dz.eq(
											Db.organizationMembers.organizationId,
											Db.organizations.id,
										),
										Dz.eq(Db.organizationMembers.userId, userId),
									),
								)
								.where(
									Dz.and(
										Dz.eq(Db.organizations.id, orgId),
										Dz.or(
											Dz.eq(Db.organizations.ownerId, userId),
											Dz.eq(Db.organizationMembers.userId, userId),
										),
									),
								),
						)
						.pipe(
							Effect.map(Array.get(0)),
							Effect.map(
								Option.map((row) => ({
									membershipId: row.membershipId,
									role:
										row.ownerId === userId
											? ("owner" as const)
											: row.role === "owner"
												? ("member" as const)
												: row.role,
								})),
							),
						),
				allowedEmailDomain: (orgId: Organisation.OrganisationId) =>
					db
						.use((db) =>
							db
								.select({
									allowedEmailDomain: Db.organizations.allowedEmailDomain,
								})
								.from(Db.organizations)
								.where(Dz.eq(Db.organizations.id, orgId))
								.limit(1),
						)
						.pipe(
							Effect.map(Array.get(0)),
							Effect.map(
								Option.flatMap((row) =>
									Option.fromNullable(row.allowedEmailDomain?.trim() || null),
								),
							),
						),
			};
		}),
		dependencies: [Database.Default],
	},
) {}