Function findManyChannelMessagesCounts

packages/core/src/channel.ts:146–156

(channelIds: string[])

}

export async function findManyChannelMessagesCounts(channelIds: string[]) {
	if (channelIds.length === 0) return Promise.resolve([]);
	return dbReplica
		.select({
			channelId: dbMessages.channelId,
			count: sql<number>`count(*)`,
		})
		.from(dbMessages)
		.where(inArray(dbMessages.channelId, channelIds))
		.groupBy(dbMessages.channelId);
}

export async function findLatestThreads(args: { take: number }) {
	const data = await dbReplica.query.dbChannels.findMany({