⚡️⚡️⚡️ Self-hosted collaborative bookmark manager to collect, read, annotate, and fully preserve what matters, all in one place.
TypeScript bookmarkbookmark-managercollaborationnextjsreact-nativeread-it-laterself-hostedtypescript
import { prisma } from "@linkwarden/prisma";
import getPermission from "@/lib/api/getPermission";
import {
UpdateCollectionSchema,
UpdateCollectionSchemaType,
} from "@linkwarden/lib/schemaValidation";
export default async function updateCollection(
userId: number,
collectionId: number,
body: UpdateCollectionSchemaType
) {
if (!collectionId)
return { response: "Please choose a valid collection.", status: 401 };
const dataValidation = UpdateCollectionSchema.safeParse(body);
if (!dataValidation.success) {
return {
response: `Error: ${
dataValidation.error.issues[0].message
} [${dataValidation.error.issues[0].path.join(", ")}]`,
status: 400,
};
}
const data = dataValidation.data;
const collectionIsAccessible = await getPermission({
userId,
collectionId,
});
if (!(collectionIsAccessible?.ownerId === userId))
return { response: "Collection is not accessible.", status: 401 };
if (data.parentId) {
if (data.parentId !== "root") {
const findParentCollection = await prisma.collection.findUnique({
where: {
id: data.parentId,
},
select: {
ownerId: true,
parentId: true,
},
});
if (
findParentCollection?.ownerId !== userId ||
typeof data.parentId !== "number" ||
findParentCollection?.parentId === data.parentId
)
return {
response: "You are not authorized to create a sub-collection here.",
status: 403,
};
}
}
const uniqueMembers = data.members.filter(
(e, i, a) =>
a.findIndex((el) => el.userId === e.userId) === i &&
e.userId !== collectionIsAccessible.ownerId
);
const updatedCollection = await prisma.$transaction(async () => {
if (data.propagateToSubcollections) {
const getAllSubCollections = async (
parentId: number
): Promise<{ id: number; ownerId: number }[]> => {
const result: { id: number; ownerId: number }[] = [];
let frontier: number[] = [parentId];
const seen = new Set<number>(frontier);
while (frontier.length > 0) {
const children = await prisma.collection.findMany({
where: { parentId: { in: frontier } },
select: { id: true, ownerId: true },
});
if (children.length === 0) break;
for (const child of children) {
if (seen.has(child.id)) continue;
seen.add(child.id);
result.push(child);
}
frontier = children.map((c) => c.id);
}
return result;
};
const subCollections = await getAllSubCollections(collectionId);
for (const sub of subCollections) {
await prisma.usersAndCollections.deleteMany({
where: { collectionId: sub.id },
});
const subMembers = uniqueMembers.filter(
(m) => m.userId !== sub.ownerId
);
if (subMembers.length > 0) {
await prisma.usersAndCollections.createMany({
data: subMembers.map((e) => ({
userId: e.userId,
collectionId: sub.id,
canCreate: e.canCreate,
canUpdate: e.canUpdate,
canDelete: e.canDelete,
})),
});
}
}
}
await prisma.usersAndCollections.deleteMany({
where: {
collection: {
id: collectionId,
},
},
});
return await prisma.collection.update({
where: {
id: collectionId,
},
data: {
name: data.name.trim(),
description: data.description,
color: data.color,
icon: data.icon,
iconWeight: data.iconWeight,
isPublic: data.isPublic,
parent:
data.parentId && data.parentId !== "root"
? {
connect: {
id: data.parentId,
},
}
: data.parentId === "root"
? {
disconnect: true,
}
: undefined,
members: {
create: uniqueMembers.map((e) => ({
user: { connect: { id: e.userId } },
canCreate: e.canCreate,
canUpdate: e.canUpdate,
canDelete: e.canDelete,
})),
},
},
include: {
_count: {
select: { links: true },
},
links: {
select: {
id: true,
},
},
members: {
include: {
user: {
select: {
image: true,
username: true,
name: true,
id: true,
},
},
},
},
},
});
});
const { links, ...dataResponse } = updatedCollection;
const linkIds = links.map((link) => link.id);
await prisma.link.updateMany({
where: {
id: {
in: linkIds,
},
},
data: {
indexVersion: null,
},
});
return { response: dataResponse, status: 200 };
}