Function findMessageResultPage

packages/core/src/pages.ts:228–382

(
	messageId: string,
	userServers: DiscordAPIServer[] | null,
)

>;

export async function findMessageResultPage(
	messageId: string,
	userServers: DiscordAPIServer[] | null,
) {
	const targetMessage = await findMessageById(messageId);
	if (!targetMessage) {
		return null;
	}
	// Declare as const to make TypeScript not yell at us when used in arrow functions
	const threadId = getThreadIdOfMessage(targetMessage);
	// TODO: These should maybe be a different error code
	const parentId = getParentChannelOfMessage(targetMessage);

	if (!parentId) {
		return null;
	}

	const startTime = Date.now();

	const [result, rootMessage, messages] = await Promise.all([
		db.query.dbChannels.findFirst({
			where: eq(dbChannels.id, threadId ?? parentId),
			with: {
				server: true,
				parent: true,
			},
		}),
		threadId ? findMessageByIdWithDiscordAccount(threadId) : undefined,
		db.query.dbMessages.findMany({
			where: and(
				eq(dbMessages.channelId, threadId ?? parentId),
				!threadId ? gte(dbMessages.id, targetMessage.id) : undefined,
			),
			orderBy: asc(dbMessages.id),
			limit: !threadId ? NUMBER_OF_CHANNEL_MESSAGES_TO_LOAD : undefined,
			columns: {
				id: true,
				content: true,
				questionId: true,
				serverId: true,
				authorId: true,
				channelId: true,
				parentChannelId: true,
				childThreadId: true,
				embeds: true,
			},
			with: {
				author: {
					with: {
						userServerSettings: {
							where: eq(dbUserServerSettings.serverId, targetMessage.serverId),
						},
					},
				},
				attachments: true,
				reference: {
					with: {
						author: {