[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","rafitaaa","name","discord-bot-forge","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/rafitaaa/discord-bot-forge/code/db.ts","extension","id","b6e24f9e-4c69-4055-b166-705a5997f3d9","fileId","85a3fa7e-b2ad-11f1-b876-1607ee4eb77e","parentId","branchId","37544b5e-d483-4a6e-a9ea-9e395772fd07","branchVersion",50,"latest",true,"createdAt",["D",1789711856828],"version",5,"fileType","script","content","/**\n * Capa de datos (SQLite de Val Town).\n * Guarda: usuarios, sesiones, bots (token cifrado), historial de chat IA y plantillas de embeds.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const MAX_BOTS_PER_USER = 25;\n\nexport type User = {\n id: number;\n email: string;\n name: string | null;\n picture: string | null;\n discord_id: string | null;\n created_at: string;\n};\n\nexport type Bot = {\n id: number;\n user_id: number;\n name: string;\n token_enc: string;\n token_hint: string | null;\n avatar: string | null;\n guild_id: string | null;\n guild_name: string | null;\n code: string;\n desired_state: string;\n status: string;\n last_error: string | null;\n created_at: string;\n updated_at: string;\n};\n\nexport type ChatMessage = {\n id: number;\n bot_id: number;\n role: string;\n content: string;\n created_at: string;\n};\n\nexport type EmbedTemplate = {\n id: number;\n bot_id: number;\n name: string;\n payload: string;\n created_at: string;\n};\n\n/**\n * `sqlite` es un cliente libsql y su API es `execute(sql, args)`, NO una\n * plantilla etiquetada. Al pasarle un TemplateStringsArray lo trata como\n * `[sql, args]`: usa sólo el primer trozo de SQL y descarta los parámetros\n * (la consulta llegaba cortada justo en el primer `${}`).\n * Estas ayudas aplanan la plantilla a SQL con `?` + array de parámetros.\n */\nfunction toSql(strings: TemplateStringsArray, args: unknown[]): [string, unknown[]] {\n let sql = strings[0];\n for (let i = 0; i < args.length; i++) sql += `?${strings[i + 1]}`;\n // libsql no acepta `undefined`; los booleanos van como 0/1.\n const params = args.map((v) =>\n v === undefined ? null : typeof v === \"boolean\" ? (v ? 1 : 0) : v\n );\n return [sql, params];\n}\n\n/** Ejecuta SQL con parámetros y devuelve las filas. */\nasync function query(strings: TemplateStringsArray, ...args: unknown[]): Promise {\n const [sql, params] = toSql(strings, args);\n const result = await sqlite.execute(sql, params as never);\n return (result.rows ?? []) as T[];\n}\n\n/** Igual que `query`, para sentencias que no devuelven filas. */\nasync function exec(strings: TemplateStringsArray, ...args: unknown[]): Promise {\n const [sql, params] = toSql(strings, args);\n await sqlite.execute(sql, params as never);\n}\n\nlet initPromise: Promise | null = null;\n\n/** Crea las tablas la primera vez que se usa el val (idempotente). */\nexport function initDb(): Promise {\n if (!initPromise) initPromise = migrate();\n return initPromise;\n}\n\nasync function migrate(): Promise {\n await exec`create table if not exists users (\n id integer primary key autoincrement,\n email text not null unique,\n name text,\n picture text,\n discord_id text unique,\n created_at text not null default (datetime('now'))\n )`;\n // Migración: bases creadas antes del login con Discord solo tenían `google_sub`.\n try {\n await exec`alter table users add column discord_id text`;\n } catch {\n // La columna ya existe (tabla nueva o migración ya aplicada).\n }\n await exec`create unique index if not exists idx_users_discord on users(discord_id)`;\n await exec`create table if not exists sessions (\n token_hash text primary key,\n user_id integer not null,\n created_at text not null default (datetime('now')),\n expires_at text not null\n )`;\n await exec`create table if not exists bots (\n id integer primary key autoincrement,\n user_id integer not null,\n name text not null,\n token_enc text not null,\n token_hint text,\n avatar text,\n guild_id text,\n guild_name text,\n code text not null default '',\n desired_state text not null default 'offline',\n status text not null default 'offline',\n last_error text,\n created_at text not null default (datetime('now')),\n updated_at text not null default (datetime('now'))\n )`;\n await exec`create table if not exists messages (\n id integer primary key autoincrement,\n bot_id integer not null,\n role text not null,\n content text not null,\n created_at text not null default (datetime('now'))\n )`;\n await exec`create table if not exists embeds (\n id integer primary key autoincrement,\n bot_id integer not null,\n name text not null,\n payload text not null,\n created_at text not null default (datetime('now'))\n )`;\n await exec`create index if not exists idx_bots_user on bots(user_id)`;\n await exec`create index if not exists idx_messages_bot on messages(bot_id)`;\n await exec`create index if not exists idx_embeds_bot on embeds(bot_id)`;\n}\n\n/* ----------------------------- usuarios ----------------------------- */\n\nexport async function upsertUser(input: {\n email: string;\n name?: string | null;\n picture?: string | null;\n discord_id?: string | null;\n}): Promise {\n const email = input.email.trim().toLowerCase();\n // Primero por id de Discord (identidad estable), luego por correo.\n const existing = input.discord_id\n ? await query`select * from users where discord_id = ${input.discord_id} limit 1`\n : [];\n const rows = existing.length\n ? existing\n : await query`select * from users where email = ${email} limit 1`;\n\n if (rows.length) {\n const row = rows[0];\n const name = input.name ?? row.name;\n const picture = input.picture ?? row.picture;\n const discordId = input.discord_id ?? row.discord_id ?? null;\n await exec`update users set email = ${email}, name = ${name}, picture = ${picture},\n discord_id = ${discordId} where id = ${row.id}`;\n return { ...row, email, name, picture, discord_id: discordId };\n }\n const created = await query`insert into users (email, name, picture, discord_id)\n values (${email}, ${input.name ?? null}, ${input.picture ?? null}, ${input.discord_id ?? null})\n returning *`;\n return created[0];\n}\n\n/* ----------------------------- sesiones ----------------------------- */\n\nexport async function createSession(tokenHash: string, userId: number, expiresAt: string): Promise {\n await exec`insert or replace into sessions (token_hash, user_id, expires_at)\n values (${tokenHash}, ${userId}, ${expiresAt})`;\n}\n\nexport async function userBySession(tokenHash: string): Promise {\n const rows = await query`select u.* from sessions s\n join users u on u.id = s.user_id\n where s.token_hash = ${tokenHash} and s.expires_at > datetime('now') limit 1`;\n return rows[0] ?? null;\n}\n\nexport async function deleteSession(tokenHash: string): Promise {\n await exec`delete from sessions where token_hash = ${tokenHash}`;\n}\n\n/* ------------------------------- bots ------------------------------- */\n\nexport async function countBots(userId: number): Promise {\n const rows = await query<{ n: number }>`select count(*) as n from bots where user_id = ${userId}`;\n return Number(rows[0]?.n ?? 0);\n}\n\nexport async function listBots(userId: number): Promise {\n return query`select * from bots where user_id = ${userId} order by id desc`;\n}\n\nexport async function getBot(id: number, userId: number): Promise {\n const rows = await query`select * from bots where id = ${id} and user_id = ${userId} limit 1`;\n return rows[0] ?? null;\n}\n\nexport async function createBot(input: {\n userId: number;\n name: string;\n tokenEnc: string;\n tokenHint: string;\n avatar: string | null;\n guildId: string | null;\n guildName: string | null;\n}): Promise {\n const rows = await query`insert into bots (user_id, name, token_enc, token_hint, avatar, guild_id, guild_name)\n values (${input.userId}, ${input.name}, ${input.tokenEnc}, ${input.tokenHint}, ${input.avatar}, ${input.guildId}, ${input.guildName})\n returning *`;\n return rows[0];\n}\n\nexport async function updateBotCode(id: number, code: string): Promise {\n await exec`update bots set code = ${code}, updated_at = datetime('now') where id = ${id}`;\n}\n\nexport async function setBotState(id: number, desired: string, status: string, error: string | null = null): Promise {\n await exec`update bots set desired_state = ${desired}, status = ${status}, last_error = ${error},\n updated_at = datetime('now') where id = ${id}`;\n}\n\nexport async function deleteBot(id: number, userId: number): Promise {\n await exec`delete from messages where bot_id = ${id}`;\n await exec`delete from embeds where bot_id = ${id}`;\n await exec`delete from bots where id = ${id} and user_id = ${userId}`;\n}\n\nexport async function listDesiredOnline(): Promise {\n return query`select * from bots where desired_state = 'online'`;\n}\n\n/* ---------------------------- historial IA --------------------------- */\n\nexport async function addMessage(botId: number, role: string, content: string): Promise {\n const rows = await query`insert into messages (bot_id, role, content)\n values (${botId}, ${role}, ${content}) returning *`;\n return rows[0];\n}\n\nexport async function listMessages(botId: number, limit = 30): Promise {\n const rows = await query`select * from messages where bot_id = ${botId} order by id desc limit ${limit}`;\n return rows.reverse();\n}\n\nexport async function clearMessages(botId: number): Promise {\n await exec`delete from messages where bot_id = ${botId}`;\n}\n\n/* ------------------------- plantillas de embed ------------------------ */\n\nexport async function saveEmbedTemplate(botId: number, name: string, payload: string): Promise {\n const rows = await query`insert into embeds (bot_id, name, payload)\n values (${botId}, ${name}, ${payload}) returning *`;\n return rows[0];\n}\n\nexport async function listEmbedTemplates(botId: number): Promise {\n return query`select * from embeds where bot_id = ${botId} order by id desc`;\n}\n\nexport async function deleteEmbedTemplate(id: number, botId: number): Promise {\n await exec`delete from embeds where id = ${id} and bot_id = ${botId}`;\n}","deleted",false,"label",[14],"f897dca2-6f6c-4e1b-bb1c-d687260cd088",["D",1789659345779],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Aloja bots de Discord con IA: dashboard, chat Groq y embeds","imageUrl","userId","04c4c364-ec5f-41c5-b6fc-a8c10bee7499","pinnedFileId","e0cd2760-b2b0-11f1-a86f-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0afee-eeb7-70d6-a0b0-b625cf083eb5","tursoName","f897dca26f6c4e1bbb1cd687260cd088","tursoHostname","f897dca26f6c4e1bbb1cd687260cd088-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789661495919],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Rafa Toro","avatar","https://lh3.googleusercontent.com/a/ACg8ocLgNOftv9O9CrbLlEgoHJjCfJGq2N0FRZ2eB4sJUvoGFzOCsg=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]