Function insertNoteChildComment

shared-edge/src/kysely.ts:792–828

(
	parentCommentId: CommentId,
	text: string,
	authorId: UserId,
)

}

export async function insertNoteChildComment(
	parentCommentId: CommentId,
	text: string,
	authorId: UserId,
) {
	const parentCommentDbId = fromBase64Url(parentCommentId)
	const parent = await db
		.selectFrom('noteComment')
		.select(['level', 'noteId'])
		.where('id', '=', parentCommentDbId)
		.executeTakeFirst()
	if (parent == null) throwExp(`Comment ${parentCommentId} not found.`)
	await db.transaction().execute(
		async (tx) =>
			await Promise.all([
				tx
					.updateTable('note')
					.set({
						commentsCount: (x) => sql`${x.ref('commentsCount')} + 1`,
					})
					.where('note.id', '=', parent.noteId)
					.execute(),
				await tx
					.insertInto('noteComment')
					.values({
						id: unhex(hexId()),
						authorId,
						level: parent.level + 1,
						noteId: parent.noteId,
						votes: '',
						text,
						parentId: parentCommentDbId,
					})
					.execute(),
			]),
	)
}

export async function userOwnsNoteAndHasMedia(
	ids: RemoteNoteId[],