[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_113":94,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":30,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",1,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","32a6b9f5-b532-4408-98c3-90c042c6e00c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","db.ts","latestPath","fileId","85a3fa7e-b2ad-11f1-b876-1607ee4eb77e","name","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 google_sub: 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/** Ejecuta SQL con parámetros y devuelve las filas. */\nasync function query(strings: TemplateStringsArray, ...args: unknown[]): Promise {\n const result = await (sqlite.execute as any)(strings, ...args);\n const rows = result?.rows ?? result ?? [];\n return rows as T[];\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 sqlite.execute`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 google_sub text unique,\n created_at text not null default (datetime('now'))\n )`;\n await sqlite.execute`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 sqlite.execute`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 sqlite.execute`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 sqlite.execute`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 sqlite.execute`create index if not exists idx_bots_user on bots(user_id)`;\n await sqlite.execute`create index if not exists idx_messages_bot on messages(bot_id)`;\n await sqlite.execute`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 google_sub?: string | null;\n}): Promise {\n const email = input.email.trim().toLowerCase();\n const existing = await query`select * from users where email = ${email} limit 1`;\n if (existing.length) {\n const row = existing[0];\n const name = input.name ?? row.name;\n const picture = input.picture ?? row.picture;\n const sub = input.google_sub ?? row.google_sub;\n await sqlite.execute`update users set name = ${name}, picture = ${picture}, google_sub = ${sub} where id = ${row.id}`;\n return { ...row, name, picture, google_sub: sub };\n }\n const created = await query`insert into users (email, name, picture, google_sub)\n values (${email}, ${input.name ?? null}, ${input.picture ?? null}, ${input.google_sub ?? 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 sqlite.execute`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 sqlite.execute`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 sqlite.execute`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 sqlite.execute`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 sqlite.execute`delete from messages where bot_id = ${id}`;\n await sqlite.execute`delete from embeds where bot_id = ${id}`;\n await sqlite.execute`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 sqlite.execute`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 sqlite.execute`delete from embeds where id = ${id} and bot_id = ${botId}`;\n}","createdAt",["D",1789659376629],"branchVersion","branchId","37544b5e-d483-4a6e-a9ea-9e395772fd07","id","f897dca2-6f6c-4e1b-bb1c-d687260cd088","discord-bot-forge",["D",1789659345779],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Aloja bots de Discord con IA: dashboard, chat Groq y embeds","imageUrl","04c4c364-ec5f-41c5-b6fc-a8c10bee7499","pinnedFileId","e0cd2760-b2b0-11f1-a86f-1607ee4eb77e","pinPreview",true,"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",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","rafitaaa","handle","displayName","Rafa Toro","avatar","https://lh3.googleusercontent.com/a/ACg8ocLgNOftv9O9CrbLlEgoHJjCfJGq2N0FRZ2eB4sJUvoGFzOCsg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":158,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":159,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":160,"_88":161,"_90":162,"_92":30},"tree",[153],"files",[153],"counts",{"_142":67,"_143":14,"_144":67,"_145":146,"_147":148},"contents",[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":136,"_37":33,"_35":36,"_137":-5,"_45":46,"_44":14,"_138":30,"_42":139,"_13":67,"_38":39,"_40":41,"_29":30,"_140":-5,"_32":141},"a239a329-a855-43c2-ab95-56e4f4bd354f","parentId","latest",["D",1789659376629],"label",[33],"pulls","branches","forks","envVars",{"_149":151,"_152":67},"connections",{"_149":67,"_150":67},"count","unfilledCount",4,"emptyCount",{"_47":136,"_37":33,"_35":36,"_137":-5,"_45":46,"_44":14,"_138":30,"_42":154,"_13":67,"_38":39,"_40":41,"_29":30,"_140":-5,"_155":156,"_32":157},["D",1789659376629],"children",[],[33],["D",1789659345779],["D",1789661495919],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":196,"_197":198,"_199":200,"_201":30,"_202":30,"_203":30,"_204":63,"_205":-5,"_206":-7,"_207":-7,"_208":67,"_209":30,"_210":30,"_211":-5,"_212":30,"_213":30,"_214":30,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":94,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v1