[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":30,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","example/api.ts","latestPath","fileId","cd48db04-c8ef-11f0-8c99-42dde27851f2","name","api.ts","fileType","script","content","/**\n * Example API with Drizzle ORM\n *\n * This shows how to use your schema with full type safety!\n *\n * Endpoints:\n * GET /users - List all users\n * POST /users - Create user (JSON: { name, email })\n * GET /posts - List posts with authors\n * POST /posts - Create post (JSON: { userId, title, content })\n *\n * Try it:\n * https://nbbaier-drizzleExampleApp.web.val.run/users\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { eq } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/better-sqlite3\";\nimport * as schema from \"./schema.ts\";\n\nconst db = drizzle(sqlite, { schema });\n\nexport default async function (req: Request) {\n\tconst url = new URL(req.url);\n\n\t// GET /users - List all users\n\tif (url.pathname === \"/users\" && req.method === \"GET\") {\n\t\tconst users = await db.select().from(schema.users);\n\t\treturn Response.json(users);\n\t}\n\n\t// POST /users - Create user\n\tif (url.pathname === \"/users\" && req.method === \"POST\") {\n\t\tconst body = await req.json();\n\n\t\tconst [user] = await db\n\t\t\t.insert(schema.users)\n\t\t\t.values({\n\t\t\t\tname: body.name,\n\t\t\t\temail: body.email,\n\t\t\t})\n\t\t\t.returning();\n\n\t\treturn Response.json(user);\n\t}\n\n\t// GET /posts - List posts with user info\n\tif (url.pathname === \"/posts\" && req.method === \"GET\") {\n\t\tconst posts = await db\n\t\t\t.select()\n\t\t\t.from(schema.posts)\n\t\t\t.leftJoin(schema.users, eq(schema.posts.userId, schema.users.id));\n\n\t\treturn Response.json(posts);\n\t}\n\n\t// POST /posts - Create post\n\tif (url.pathname === \"/posts\" && req.method === \"POST\") {\n\t\tconst body = await req.json();\n\n\t\tconst [post] = await db\n\t\t\t.insert(schema.posts)\n\t\t\t.values({\n\t\t\t\tuserId: body.userId,\n\t\t\t\ttitle: body.title,\n\t\t\t\tcontent: body.content,\n\t\t\t\tpublished: body.published ?? false,\n\t\t\t})\n\t\t\t.returning();\n\n\t\treturn Response.json(post);\n\t}\n\n\t// Home page with instructions\n\tif (url.pathname === \"/\") {\n\t\treturn new Response(\n\t\t\t`\n

Drizzle ORM Example API

Endpoints:

GET /users - List users
POST /users - Create user
GET /posts - List posts
POST /posts - Create post

View users

View posts

\n `,\n\t\t\t{\n\t\t\t\theaders: { \"Content-Type\": \"text/html\" },\n\t\t\t},\n\t\t);\n\t}\n\n\treturn Response.json({ error: \"Not found\" }, { status: 404 });\n}\n","createdAt",["D",1763959271527],"branchVersion","branchId","e6f06124-c8ec-11f0-928c-42dde27851f2","id","e6efa630-c8ec-11f0-928c-42dde27851f2","drizzleMigrations",["D",1763958026076],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Type-safe Drizzle migrations for Val Town (no filesystem needed)","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",31,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":168,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":30,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":169,"_79":170,"_81":171,"_83":24},"tree",[154,156],"files",[154,155,156],"counts",{"_144":61,"_145":131,"_146":61,"_147":148,"_149":150},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":57,"_37":141,"_13":61,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":143},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":24,"_37":133,"_13":61,"_33":34,"_35":134,"_23":24,"_135":-5,"_26":136},"e6f3ab68-c8ec-11f0-928c-42dde27851f2","main.ts","e6f3abfe-c8ec-11f0-928c-42dde27851f2","parentId",1,"latest",["D",1763958026095],"/**\n * Lightweight Drizzle Schema to SQL Migration Generator\n * Built for Val Town (no filesystem, no drizzle-kit)\n * \n * Usage:\n * import { generateCreateTableSQL, migrate } from '@YOUR_USERNAME/drizzleMigrations';\n * \n * const sql = generateCreateTableSQL(myTable);\n * // or\n * await migrate(db, { users, posts, ... });\n */\n\n// Symbol keys that Drizzle uses\nconst DRIZZLE_SYMBOLS = {\n Name: Symbol.for('drizzle:Name'),\n Columns: Symbol.for('drizzle:Columns'),\n SQLiteInlineForeignKeys: Symbol.for('drizzle:SQLiteInlineForeignKeys'),\n ExtraConfigBuilder: Symbol.for('drizzle:ExtraConfigBuilder'),\n};\n\ninterface ColumnMetadata {\n name: string;\n columnType: string;\n dataType: string;\n notNull: boolean;\n primary: boolean;\n default?: any;\n isUnique: boolean;\n autoIncrement?: boolean;\n enumValues?: string[];\n config?: any;\n}\n\ninterface ForeignKeyMetadata {\n reference: () => any;\n onUpdate?: string;\n onDelete?: string;\n}\n\n/**\n * Generate CREATE TABLE SQL for a Drizzle table\n */\nexport function generateCreateTableSQL(table: any): string {\n const tableName = table[DRIZZLE_SYMBOLS.Name];\n const columns = table[DRIZZLE_SYMBOLS.Columns];\n \n if (!tableName || !columns) {\n throw new Error('Invalid Drizzle table object');\n }\n \n const columnDefs: string[] = [];\n const constraints: string[] = [];\n \n // Process columns\n for (const [_key, column] of Object.entries(columns)) {\n const col = column as ColumnMetadata;\n columnDefs.push(generateColumnDef(col));\n }\n \n // Process foreign keys\n const foreignKeys = table[DRIZZLE_SYMBOLS.SQLiteInlineForeignKeys] || [];\n for (const fk of foreignKeys) {\n const fkDef = generateForeignKeyDef(fk);\n if (fkDef) constraints.push(fkDef);\n }\n \n const allDefs = [...columnDefs, ...constraints];\n return `CREATE TABLE IF NOT EXISTS \"${tableName}\" (\\n ${allDefs.join(',\\n ')}\\n);`;\n}\n\n/**\n * Generate column definition\n */\nfunction generateColumnDef(col: ColumnMetadata): string {\n let def = `\"${col.name}\" `;\n \n // Map Drizzle types to SQLite types\n switch (col.columnType) {\n case 'SQLiteInteger':\n def += 'INTEGER';\n break;\n case 'SQLiteText':\n def += 'TEXT';\n break;\n case 'SQLiteReal':\n def += 'REAL';\n break;\n case 'SQLiteBlob':\n def += 'BLOB';\n break;\n default:\n def += 'TEXT';\n }\n \n // PRIMARY KEY\n if (col.primary) {\n def += ' PRIMARY KEY';\n if (col.autoIncrement) {\n def += ' AUTOINCREMENT';\n }\n }\n \n // NOT NULL\n if (col.notNull && !col.primary) {\n def += ' NOT NULL';\n }\n \n // UNIQUE\n if (col.isUnique) {\n def += ' UNIQUE';\n }\n \n // DEFAULT\n if (col.default !== undefined) {\n if (typeof col.default === 'string') {\n def += ` DEFAULT '${col.default}'`;\n } else if (typeof col.default === 'number') {\n def += ` DEFAULT ${col.default}`;\n } else if (typeof col.default === 'boolean') {\n def += ` DEFAULT ${col.default ? 1 : 0}`;\n }\n }\n \n return def;\n}\n\n/**\n * Generate foreign key constraint\n */\nfunction generateForeignKeyDef(fk: ForeignKeyMetadata): string | null {\n try {\n // Call the reference function to get FK info\n const ref = fk.reference();\n \n // ref has: columns (local), foreignTable, foreignColumns (referenced)\n if (!ref || !ref.foreignTable || !ref.columns || !ref.foreignColumns) {\n return null;\n }\n \n const foreignTableName = ref.foreignTable[DRIZZLE_SYMBOLS.Name];\n if (!foreignTableName) {\n return null;\n }\n \n // Get column names\n const localColumns = ref.columns.map((col: any) => `\"${col.name}\"`).join(', ');\n const foreignColumns = ref.foreignColumns.map((col: any) => `\"${col.name}\"`).join(', ');\n \n let def = `FOREIGN KEY (${localColumns}) REFERENCES \"${foreignTableName}\" (${foreignColumns})`;\n \n if (fk.onUpdate) {\n def += ` ON UPDATE ${fk.onUpdate.toUpperCase()}`;\n }\n \n if (fk.onDelete) {\n def += ` ON DELETE ${fk.onDelete.toUpperCase()}`;\n }\n \n return def;\n } catch (e) {\n // Silently skip FK generation if it fails - not critical\n return null;\n }\n}\n\n/**\n * Generate CREATE INDEX SQL for a Drizzle index\n */\nexport function generateCreateIndexSQL(\n tableName: string,\n indexName: string,\n index: any\n): string {\n const unique = index.config?.unique ? 'UNIQUE ' : '';\n const columns = index.config?.columns || [];\n \n const columnNames = columns\n .map((col: any) => `\"${col.name}\"`)\n .join(', ');\n \n return `CREATE ${unique}INDEX IF NOT EXISTS \"${indexName}\" ON \"${tableName}\" (${columnNames});`;\n}\n\n/**\n * Extract all indexes from a table\n */\nexport function extractIndexes(table: any): Array<{ name: string; sql: string }> {\n const tableName = table[DRIZZLE_SYMBOLS.Name];\n const columns = table[DRIZZLE_SYMBOLS.Columns];\n const extraConfigBuilder = table[DRIZZLE_SYMBOLS.ExtraConfigBuilder];\n \n const indexes: Array<{ name: string; sql: string }> = [];\n \n if (extraConfigBuilder) {\n const config = extraConfigBuilder(columns);\n for (const [name, index] of Object.entries(config)) {\n const sql = generateCreateIndexSQL(tableName, name, index);\n indexes.push({ name, sql });\n }\n }\n \n return indexes;\n}\n\n/**\n * Migration system - stores state in SQLite\n */\ninterface MigrationState {\n version: number;\n tables: Record; // table name -> SQL hash\n appliedAt: string;\n}\n\n/**\n * Initialize migrations table\n */\nasync function initMigrationsTable(db: any): Promise {\n await db.execute(`\n CREATE TABLE IF NOT EXISTS __drizzle_migrations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n version INTEGER NOT NULL UNIQUE,\n tables TEXT NOT NULL,\n applied_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n\n/**\n * Get current migration state\n */\nasync function getCurrentState(db: any): Promise {\n const result = await db.execute(`\n SELECT version, tables, applied_at\n FROM __drizzle_migrations\n ORDER BY version DESC\n LIMIT 1\n `);\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n version: row[0] as number,\n tables: JSON.parse(row[1] as string),\n appliedAt: row[2] as string,\n };\n}\n\n/**\n * Simple hash function for SQL strings\n */\nfunction hashSQL(sql: string): string {\n let hash = 0;\n for (let i = 0; i < sql.length; i++) {\n const char = sql.charCodeAt(i);\n hash = ((hash << 5) - hash) + char;\n hash = hash & hash; // Convert to 32bit integer\n }\n return hash.toString(36);\n}\n\n/**\n * Main migration function\n * Pass in your db instance and an object with all your tables\n */\nexport async function migrate(\n db: any,\n tables: Record,\n options: { dryRun?: boolean } = {}\n): Promise<{ applied: string[]; skipped: string[]; version?: number }> {\n await initMigrationsTable(db);\n \n const currentState = await getCurrentState(db);\n const newVersion = (currentState?.version || 0) + 1;\n \n const applied: string[] = [];\n const skipped: string[] = [];\n const newTableHashes: Record = {};\n \n console.log(`\\n=== Migration v${newVersion} ===`);\n \n // Generate SQL for all tables\n for (const [tableName, table] of Object.entries(tables)) {\n const sql = generateCreateTableSQL(table);\n const hash = hashSQL(sql);\n \n newTableHashes[tableName] = hash;\n \n // Check if this table needs to be created/updated\n const previousHash = currentState?.tables[tableName];\n \n if (!previousHash) {\n console.log(`[NEW] Creating table: ${tableName}`);\n console.log(sql);\n \n if (!options.dryRun) {\n await db.execute(sql);\n \n // Create indexes\n const indexes = extractIndexes(table);\n for (const idx of indexes) {\n console.log(`[INDEX] ${idx.name}`);\n console.log(idx.sql);\n await db.execute(idx.sql);\n }\n }\n \n applied.push(tableName);\n } else if (previousHash !== hash) {\n console.log(`[CHANGED] Table schema changed: ${tableName}`);\n console.log('⚠️ Manual migration required for schema changes');\n console.log('New SQL:', sql);\n skipped.push(tableName);\n } else {\n console.log(`[SKIP] No changes: ${tableName}`);\n skipped.push(tableName);\n }\n }\n \n // Save new state\n if (!options.dryRun && applied.length > 0) {\n await db.execute(`\n INSERT INTO __drizzle_migrations (version, tables)\n VALUES (?, ?)\n `, [newVersion, JSON.stringify(newTableHashes)]);\n \n console.log(`\\n✅ Migration v${newVersion} applied`);\n }\n \n return { applied, skipped, version: newVersion };\n}\n\n/**\n * Generate SQL for an entire schema (useful for inspection)\n */\nexport function generateSchemaSQL(tables: Record): string {\n const statements: string[] = [];\n \n for (const [tableName, table] of Object.entries(tables)) {\n statements.push(generateCreateTableSQL(table));\n \n const indexes = extractIndexes(table);\n for (const idx of indexes) {\n statements.push(idx.sql);\n }\n \n statements.push(''); // blank line between tables\n }\n \n return statements.join('\\n');\n}","label",[128],"cd3a7c3a-c8ef-11f0-8c99-42dde27851f2","example","cd3a7d20-c8ef-11f0-8c99-42dde27851f2",2,["D",1763959271434],"directory",[138],"pulls","branches","forks","envVars",{"_151":61,"_153":61},"connections",{"_151":61,"_152":61},"count","unfilledCount","emptyCount",{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":57,"_37":165,"_13":61,"_33":142,"_35":-5,"_23":24,"_135":-5,"_158":166,"_26":167},{"_42":161,"_31":32,"_29":30,"_130":139,"_40":41,"_39":14,"_132":24,"_37":162,"_13":61,"_33":34,"_35":36,"_23":24,"_135":-5,"_158":163,"_26":164},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":24,"_37":157,"_13":61,"_33":34,"_35":134,"_23":24,"_135":-5,"_158":159,"_26":160},["D",1763958026095],"children",[],[128],"cd48da28-c8ef-11f0-8c99-42dde27851f2",["D",1763959271527],[],[138,32],["D",1763959271434],[155],[138],["D",1763958026076],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":205,"_206":207,"_208":209,"_210":24,"_211":24,"_212":24,"_213":57,"_214":-5,"_215":-7,"_216":-7,"_217":61,"_218":24,"_219":24,"_220":-5,"_221":24,"_222":24,"_223":24,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":85,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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 · v3