Skip to content

A free and open source instant messaging and VoIP chat app built for friends, groups, and communities.

TypeScript fluxerfluxerapp
4.7 KB
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-or-later

import type {GuildID} from '@app/api/BrandedTypes';
import {BatchBuilder, fetchMany, fetchOne, fetchPage} from '@app/api/database/CassandraQueryExecution';
import type {GuildDiscoveryByStatusRow, GuildDiscoveryRow} from '@app/api/database/types/GuildDiscoveryTypes';
import {GuildDiscovery, GuildDiscoveryByStatus} from '@app/api/Tables';
import {DISCOVERY_DEFAULT_LANGUAGE, DiscoveryCategories} from '@fluxer/constants/src/DiscoveryConstants';
import {BACKGROUND_READ_TIMEOUT_MS} from '@pkgs/cassandra/src/Client';

const FETCH_DISCOVERY_BY_GUILD_ID = GuildDiscovery.selectCql({
	where: GuildDiscovery.where.eq('guild_id'),
	limit: 1,
});
const FETCH_DISCOVERY_BY_STATUS = GuildDiscoveryByStatus.selectCql({
	where: GuildDiscoveryByStatus.where.eq('status'),
});
const SCAN_DISCOVERY = GuildDiscovery.selectCql({
	columns: ['guild_id', 'status', 'applied_at'],
});

export class GuildDiscoveryRepository {
	async findByGuildId(guildId: GuildID): Promise<GuildDiscoveryRow | null> {
		const row = await fetchOne<GuildDiscoveryRow>(FETCH_DISCOVERY_BY_GUILD_ID, {
			guild_id: guildId,
		});
		if (row) {
			row.category_type ??= DiscoveryCategories.GAMING;
			row.primary_language ??= DISCOVERY_DEFAULT_LANGUAGE;
			row.custom_tags ??= [];
		}
		return row;
	}

	async listByStatus(status: string): Promise<Array<GuildDiscoveryByStatusRow>> {
		return fetchMany<GuildDiscoveryByStatusRow>(FETCH_DISCOVERY_BY_STATUS, {
			status,
		});
	}

	async scanStatuses(
		pageState: string | null,
		pageSize: number,
	): Promise<{rows: Array<GuildDiscoveryByStatusRow>; pageState: string | null}> {
		const result = await fetchPage<GuildDiscoveryByStatusRow>(
			SCAN_DISCOVERY,
			{},
			{pageSize, pageState, readTimeout: BACKGROUND_READ_TIMEOUT_MS},
		);
		return {rows: result.rows, pageState: result.pageState};
	}

	async addStatusEntry(row: GuildDiscoveryByStatusRow): Promise<void> {
		const batch = new BatchBuilder();
		batch.addPrepared(
			GuildDiscoveryByStatus.insert({
				status: row.status,
				applied_at: row.applied_at,
				guild_id: row.guild_id,
			}),
		);
		await batch.execute();
	}

	async listFullByStatus(status: string): Promise<Array<GuildDiscoveryRow>> {
		const indexRows = await this.listByStatus(status);
		const fullRows = await Promise.all(indexRows.map((indexRow) => this.findByGuildId(indexRow.guild_id)));
		return fullRows.filter((row): row is GuildDiscoveryRow => row !== null);
	}

	async upsert(row: GuildDiscoveryRow): Promise<void> {
		const batch = new BatchBuilder();
		batch.addPrepared(
			GuildDiscovery.insert({
				guild_id: row.guild_id,
				status: row.status,
				category_type: row.category_type,
				description: row.description,
				primary_language: row.primary_language,
				custom_tags: row.custom_tags,
				applied_at: row.applied_at,
				reviewed_at: row.reviewed_at,
				reviewed_by: row.reviewed_by,
				review_reason: row.review_reason,
				removed_at: row.removed_at,
				removed_by: row.removed_by,
				removal_reason: row.removal_reason,
			}),
		);
		batch.addPrepared(
			GuildDiscoveryByStatus.insert({
				status: row.status,
				applied_at: row.applied_at,
				guild_id: row.guild_id,
			}),
		);
		await batch.execute();
	}

	async deleteByGuildId(guildId: GuildID, status: string, appliedAt: Date): Promise<void> {
		const batch = new BatchBuilder();
		batch.addPrepared(GuildDiscovery.deleteByPk({guild_id: guildId}));
		batch.addPrepared(
			GuildDiscoveryByStatus.deleteByPk({
				status,
				applied_at: appliedAt,
				guild_id: guildId,
			}),
		);
		await batch.execute();
	}

	async updateStatus(
		guildId: GuildID,
		oldStatus: string,
		oldAppliedAt: Date,
		updatedRow: GuildDiscoveryRow,
	): Promise<void> {
		const batch = new BatchBuilder();
		const sameEntry = oldStatus === updatedRow.status && oldAppliedAt.getTime() === updatedRow.applied_at.getTime();
		if (!sameEntry) {
			batch.addPrepared(
				GuildDiscoveryByStatus.deleteByPk({
					status: oldStatus,
					applied_at: oldAppliedAt,
					guild_id: guildId,
				}),
			);
		}
		batch.addPrepared(
			GuildDiscovery.insert({
				guild_id: updatedRow.guild_id,
				status: updatedRow.status,
				category_type: updatedRow.category_type,
				description: updatedRow.description,
				primary_language: updatedRow.primary_language,
				custom_tags: updatedRow.custom_tags,
				applied_at: updatedRow.applied_at,
				reviewed_at: updatedRow.reviewed_at,
				reviewed_by: updatedRow.reviewed_by,
				review_reason: updatedRow.review_reason,
				removed_at: updatedRow.removed_at,
				removed_by: updatedRow.removed_by,
				removal_reason: updatedRow.removal_reason,
			}),
		);
		batch.addPrepared(
			GuildDiscoveryByStatus.insert({
				status: updatedRow.status,
				applied_at: updatedRow.applied_at,
				guild_id: updatedRow.guild_id,
			}),
		);
		await batch.execute();
	}
}