Skip to content

armgit / Cap

Public Imported from GitHub
0

Open source Loom alternative. Beautiful, shareable screen recordings.

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

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

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

		return {
			membershipsForVideos: (
				userId: User.UserId,
				videoIds: readonly Video.VideoId[],
			) =>
				db.use((db) =>
					db
						.select({
							videoId: Db.spaceVideos.videoId,
							membershipId: Db.spaceMembers.id,
						})
						.from(Db.spaceMembers)
						.innerJoin(
							Db.spaceVideos,
							Dz.eq(Db.spaceMembers.spaceId, Db.spaceVideos.spaceId),
						)
						.where(
							Dz.and(
								Dz.eq(Db.spaceMembers.userId, userId),
								Dz.inArray(Db.spaceVideos.videoId, [...videoIds]),
							),
						),
				),
			passwordsForVideos: (videoIds: readonly Video.VideoId[]) =>
				db.use((db) =>
					db
						.select({
							videoId: Db.spaceVideos.videoId,
							password: Db.spaces.password,
						})
						.from(Db.spaceVideos)
						.innerJoin(Db.spaces, Dz.eq(Db.spaceVideos.spaceId, Db.spaces.id))
						.where(Dz.inArray(Db.spaceVideos.videoId, [...videoIds])),
				),
			membershipForVideo: (userId: User.UserId, videoId: Video.VideoId) =>
				db
					.use((db) =>
						db
							.select({ membershipId: Db.spaceMembers.id })
							.from(Db.spaceMembers)
							.leftJoin(
								Db.spaceVideos,
								Dz.eq(Db.spaceMembers.spaceId, Db.spaceVideos.spaceId),
							)
							.where(
								Dz.and(
									Dz.eq(Db.spaceMembers.userId, userId),
									Dz.eq(Db.spaceVideos.videoId, videoId),
								),
							),
					)
					.pipe(Effect.map(Array.get(0))),

			passwordsForVideo: (videoId: Video.VideoId) =>
				db.use((db) =>
					db
						.select({
							id: Db.spaces.id,
							name: Db.spaces.name,
							password: Db.spaces.password,
						})
						.from(Db.spaceVideos)
						.innerJoin(Db.spaces, Dz.eq(Db.spaceVideos.spaceId, Db.spaces.id))
						.where(Dz.eq(Db.spaceVideos.videoId, videoId)),
				),

			membership: (
				userId: User.UserId,
				spaceId: Space.SpaceIdOrOrganisationId,
			) =>
				db
					.use((db) =>
						db
							.select({
								membershipId: Db.spaceMembers.id,
								role: Db.spaceMembers.role,
							})
							.from(Db.spaceMembers)
							.where(
								Dz.and(
									Dz.eq(Db.spaceMembers.userId, userId),
									Dz.eq(Db.spaceMembers.spaceId, spaceId),
								),
							),
					)
					.pipe(Effect.map(Array.get(0))),

			getById: (spaceId: Space.SpaceIdOrOrganisationId) =>
				db
					.use((db) =>
						db.select().from(Db.spaces).where(Dz.eq(Db.spaces.id, spaceId)),
					)
					.pipe(Effect.map(Array.get(0))),
		};
	}),
	dependencies: [Database.Default],
}) {}