PronounsPage/server/user.ts

import SQL from 'sql-template-strings';

import type { User } from '#shared/user.ts';
import type { Database } from '~~/server/db.ts';

export const isAllowedToPost = async (db: Database, user: User | null): Promise<boolean> => {
    if (!user) {
        return false;
    }
    const dbUser = await db.get<Pick<User, 'bannedReason'>>(SQL`SELECT bannedReason FROM users WHERE id = ${user.id}`);
    return !!dbUser && !dbUser.bannedReason;
};