Function findQuestionsForSitemap

packages/core/src/pages.ts:37–116

(serverId: string)

import { zServerPublic } from './zodSchemas/serverSchemas';

export async function findQuestionsForSitemap(serverId: string) {
	const res = await db.query.dbServers.findFirst({
		where: and(eq(dbServers.id, serverId)),
		with: {
			channels: {
				where: and(
					or(
						eq(dbChannels.type, ChannelType.GuildAnnouncement),
						eq(dbChannels.type, ChannelType.GuildText),
						eq(dbChannels.type, ChannelType.GuildForum),
					),
					sql`${dbChannels.bitfield} & ${channelBitfieldValues.indexingEnabled} > 0`,
				),
				with: {
					threads: {
						orderBy: desc(dbChannels.id),
					},
				},
			},
		},
	});

	if (!res) return null;
	const questionIds = res.channels.flatMap((c) => c.threads.map((t) => t.id));

	const questions =
		questionIds.length > 0
			? await db.query.dbMessages.findMany({
					where: and(
						eq(dbMessages.serverId, serverId),
						inArray(dbMessages.id, questionIds),
					),
					columns: {
						id: true,
						authorId: true,
					},
					with: {
						author: {
							with: {
								userServerSettings: true,
							},
						},
					},
				})
			: [];

	const questionLookup = new Map(questions.map((m) => [m.id, m]));
	const areAllServerMessagesPublic =
		addFlagsToServer(res).flags.considerAllMessagesPublic;
	return {
		questions: res.channels.flatMap((c) =>
			c.threads
				.map((t) => {
					const question = questionLookup.get(t.id);
					// Drizzle doesn't mark relations as optional, so we have to do this
					if (
						!question ||
						!question.author ||