import SQL from 'sql-template-strings';

export default defineEventHandler(async (): Promise<Record<string, string>> => {
    const db = useDatabase();

    const keys = await db.all<{ key: string }>(SQL`
        SELECT trim(key) AS key
        FROM sources
        WHERE key IS NOT NULL
          AND deleted = 0
          AND approved = 1
        GROUP BY key
        ORDER BY key
    `);

    return Object.fromEntries(keys.map((k) => [k.key, k.key]));
});