Offline, privacy-first grammar checker. Fast, open-source, Rust-powered
import { and, gte, lte } from 'drizzle-orm';
import { createInsertSchema, createSelectSchema } from 'drizzle-zod';
import { countReportsByDay } from '$lib/adminUtils';
import { db } from '..';
import { domainReviewTable } from '../schema';
export type DomainReviewRow = typeof domainReviewTable.$inferSelect;
const DomainReviewRowParser = createSelectSchema(domainReviewTable);
export type DomainReviewSubmission = typeof domainReviewTable.$inferInsert;
const DomainReviewSubmissionParser = createInsertSchema(domainReviewTable);
export default class DomainReviews {
public static async validateAndCreate(rec: any) {
const parsed = DomainReviewSubmissionParser.parse(rec);
await this.create(parsed);
}
public static async create(rec: DomainReviewSubmission) {
await db.insert(domainReviewTable).values(rec);
}
public static async getAllSince(date: Date) {
return await db.select().from(domainReviewTable).where(gte(domainReviewTable.timestamp, date));
}
/**
* Count one domain's reports by UTC day, including zero-count days.
* Start is inclusive and end is exclusive; both must be UTC midnight.
* A null start uses the first matching report's day, or returns no points if none exist.
*/
public static async getDailyReportCounts(
domain: string,
start: Date | null,
end: Date,
): Promise<{ date: Date; value: number }[]> {
const endTime = end.getTime();
const reports = await this.getAllBetween(start ?? new Date(0), new Date(endTime - 1));
return countReportsByDay(
reports.filter((report) => (report.domain ?? 'OTHER') === domain),
start,
end,
);
}
public static async getAllBetween(start: Date, end: Date) {
return await db
.select()
.from(domainReviewTable)
.where(and(gte(domainReviewTable.timestamp, start), lte(domainReviewTable.timestamp, end)));
}
}