a tool for shared writing and social publishing
leaflet.pub
1"use server";
2
3import { drizzle } from "drizzle-orm/node-postgres";
4import { permission_token_on_homepage } from "drizzle/schema";
5import postgres from "postgres";
6import { v7 } from "uuid";
7import { sql, eq, inArray, and } from "drizzle-orm";
8import { cookies } from "next/headers";
9import { getIdentityData } from "./getIdentityData";
10import { pool } from "supabase/pool";
11
12export async function removeLeafletFromHome(tokens: string[]) {
13 const identity = await getIdentityData();
14 if (!identity) return null;
15
16 const client = await pool.connect();
17 const db = drizzle(client);
18
19 await db
20 .delete(permission_token_on_homepage)
21 .where(
22 and(
23 eq(permission_token_on_homepage.identity, identity.id),
24 inArray(permission_token_on_homepage.token, tokens),
25 ),
26 );
27
28 client.release();
29 return true;
30}