Function assertIsMod

shared-edge/src/nook.ts:113–151

(
	filter: FilterTemplate | FilterNooks,
	userId: UserId,
)

	templateIds: RemoteTemplateId[]
}
export async function assertIsMod(
	filter: FilterTemplate | FilterNooks,
	userId: UserId,
) {
	let expectedLength = -1
	const { c: modCount } = await db
		.selectFrom('nook')
		.select(db.fn.count<SqliteCount>('nook.id').as('c'))
		.where((eb) =>
			eb.exists(
				eb
					.selectFrom((eb) =>
						sql`json_each(${eb.ref('nook.moderators')})`.as('json_each'),
					)
					.select(sql`1`.as('_'))
					.where(sql`json_each.value`, '=', userId),
			),
		)
		.$if('nooks' in filter, (eb) => {
			const nooks = (filter as FilterNooks).nooks
			expectedLength = nooks.length
			return eb.where('nook.id', 'in', nooks)
		})
		.$if('templateIds' in filter, (eb) => {
			const templateIds = (filter as FilterTemplate).templateIds
			expectedLength = templateIds.length
			return eb
				.innerJoin('template', 'template.nook', 'nook.id')
				.where('template.id', 'in', templateIds.map(fromBase64Url))
		})
		.executeTakeFirstOrThrow()
	if (expectedLength === -1) throwExp('ya goofed')
	if (modCount !== expectedLength) {
		throw new TRPCError({
			code: 'UNAUTHORIZED',
			message: "You're not a mod.",
		})
	}
}