🐸 Rybbit - open-source and privacy-friendly alternative to Google Analytics that is 10x more intuitive.
import { isSiteGrantRole, SITE_GRANT_ROLES } from "@rybbit/shared";
import { eq, and, inArray } from "drizzle-orm";
import { FastifyReply, FastifyRequest } from "fastify";
import { db } from "../../db/postgres/postgres.js";
import { team, teamMember, teamSiteAccess, member, sites } from "../../db/postgres/schema.js";
import { teamMembershipKey } from "../../lib/teamMembership.js";
import { invalidateSitesAccessCache } from "../../lib/auth-utils.js";
interface CreateTeamBody {
name: string;
memberUserIds?: string[];
siteIds?: number[];
/** Role the team's members get on its sites (editor, member or viewer); omit or null for each member's organization role. */
siteRole?: string | null;
}
export async function createTeam(
request: FastifyRequest<{
Params: { organizationId: string };
Body: CreateTeamBody;
}>,
reply: FastifyReply
) {
const { organizationId } = request.params;
const { name, siteIds } = request.body;
const memberUserIds = request.body.memberUserIds === undefined ? undefined : [...new Set(request.body.memberUserIds)];
if (!name || !name.trim()) {
return reply.status(400).send({ error: "Team name is required" });
}
const siteRole = request.body.siteRole ?? null;
if (siteRole !== null && !isSiteGrantRole(siteRole)) {
return reply.status(400).send({ error: `siteRole must be one of: ${SITE_GRANT_ROLES.join(", ")}` });
}
try {
// Validate memberUserIds are org members
if (memberUserIds && memberUserIds.length > 0) {
const orgMembers = await db
.select({ userId: member.userId })
.from(member)
.where(and(eq(member.organizationId, organizationId), inArray(member.userId, memberUserIds)));
const validUserIds = new Set(orgMembers.map(m => m.userId));
const invalidUserIds = memberUserIds.filter(id => !validUserIds.has(id));
if (invalidUserIds.length > 0) {
return reply.status(400).send({
error: `Users not in organization: ${invalidUserIds.join(", ")}`,
});
}
}
// Validate siteIds belong to org
if (siteIds && siteIds.length > 0) {
const orgSites = await db
.select({ siteId: sites.siteId })
.from(sites)
.where(and(eq(sites.organizationId, organizationId), inArray(sites.siteId, siteIds)));
const validSiteIds = new Set(orgSites.map(s => s.siteId));
const invalidSiteIds = siteIds.filter(id => !validSiteIds.has(id));
if (invalidSiteIds.length > 0) {
return reply.status(400).send({
error: `Sites not in organization: ${invalidSiteIds.join(", ")}`,
});
}
}
const teamId = crypto.randomUUID();
const now = new Date().toISOString();
await db.transaction(async tx => {
// Insert team
await tx.insert(team).values({
id: teamId,
name: name.trim(),
memberCount: memberUserIds?.length ?? 0,
organizationId,
createdAt: now,
updatedAt: now,
});
// Insert team members
if (memberUserIds && memberUserIds.length > 0) {
await tx.insert(teamMember).values(
memberUserIds.map(userId => ({
id: crypto.randomUUID(),
teamId,
userId,
membershipKey: teamMembershipKey(teamId, userId),
createdAt: now,
}))
);
}
// Insert team site access
if (siteIds && siteIds.length > 0) {
await tx.insert(teamSiteAccess).values(
siteIds.map(siteId => ({
teamId,
siteId,
role: siteRole,
}))
);
}
});
// Invalidate cache for affected users
if (memberUserIds) {
for (const userId of memberUserIds) {
invalidateSitesAccessCache(userId);
}
}
return reply.status(201).send({
id: teamId,
name: name.trim(),
organizationId,
createdAt: now,
updatedAt: now,
members: memberUserIds || [],
siteIds: siteIds || [],
siteRole,
});
} catch (error) {
request.log.error({ err: error }, "Error creating team");
return reply.status(500).send({ error: "Failed to create team" });
}
}