Open source Loom alternative. Beautiful, shareable screen recordings.
Rust appcapcossloommacnextjsnextjs15open-sourceossreactrecordrustscreen-capturescreen-recorderscreenshotsolidjstauritauri-apptypescriptvite
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],
},
) {}