All files / apps/web/src/handlers/sessions cleanup.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
 
6x
 
 
 
 
 
2x
2x
 
 
 
2x
 
 
import { unauthProcedure } from "~web/handlers/trpc";
 
export const procedure = unauthProcedure
	.meta({
		title: "Clean up sessions",
		description: "Deletes all expired sessions.",
	})
	.mutation(async ({ ctx }) => {
		const { database } = ctx;
		const result = await database
			.deleteFrom("sessions")
			.where("expirationTimestamp", "<", Temporal.Now.zonedDateTimeISO())
			.executeTakeFirstOrThrow();
		return { count: Number(result.numDeletedRows) };
	});