[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_201":202,"_203":204},"routes/_app.x.$handle.$name",{"_94":93,"_31":42,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_40":41,"_31":42,"_35":43,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":50,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":20,"_33":34,"_35":36,"_37":14,"_38":39,"_23":24},"previous","deleted",false,"deletedHere","path","README.md","latestPath","fileId","cd59b7bc-c8ef-11f0-bdd0-42dde27851f2","name","fileType","content","# Type-Safe Drizzle Migrations for Val Town\n\nA complete working example of filesystem-free migrations for Drizzle ORM.\n\n## What's Included\n\nFive vals that work together:\n\n1. **@nbbaier/drizzleMigrations** - Core migration library\n2. **@nbbaier/drizzleSchema** - Example schema definitions\n3. **@nbbaier/runDrizzleMigrations** - HTTP endpoint to run migrations\n4. **@nbbaier/inspectDrizzleSchema** - View generated SQL\n5. **@nbbaier/drizzleExampleApp** - Working API example\n\n## Quick Start (5 minutes)\n\n### 1. Run Migrations\n\nVisit: https://nbbaier-runDrizzleMigrations.web.val.run\n\nYou'll see:\n\n```json\n{\n \"success\": true,\n \"version\": 1,\n \"applied\": [\"users\", \"posts\"],\n \"skipped\": []\n}\n```\n\nThis created the `users` and `posts` tables in your SQLite database.\n\n### 2. Try the API\n\nVisit: https://nbbaier-drizzleExampleApp.web.val.run/users\n\nCreate a user:\n\n```bash\ncurl -X POST https://nbbaier-drizzleExampleApp.web.val.run/users \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\": \"Alice\", \"email\": \"alice@example.com\"}'\n```\n\n### 3. Inspect Generated SQL (Optional)\n\nVisit: https://nbbaier-inspectDrizzleSchema.web.val.run\n\nYou'll see the actual CREATE TABLE statements that were generated.\n\n## How to Use in Your Project\n\n### Step 1: Fork or Reference the Migration Library\n\n```typescript\nimport {\n migrate,\n generateCreateTableSQL,\n} from \"https://esm.town/v/nbbaier/drizzleMigrations\";\n```\n\nOr fork @nbbaier/drizzleMigrations to your own account.\n\n### Step 2: Define Your Schema\n\nCreate a val with your tables:\n\n```typescript\nimport { sqliteTable, text, integer } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const myTable = sqliteTable(\"my_table\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n});\n```\n\n### Step 3: Create a Migration Runner\n\n```typescript\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { migrate } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/YOUR_USERNAME/yourSchema\";\n\nexport default async function (req: Request) {\n const result = await migrate(sqlite, schema);\n return Response.json(result);\n}\n```\n\n### Step 4: Use Your Schema\n\n```typescript\nimport { drizzle } from \"npm:drizzle-orm/better-sqlite3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as schema from \"https://esm.town/v/YOUR_USERNAME/yourSchema\";\n\nconst db = drizzle(sqlite, { schema });\n\n// Now you have full type safety!\nconst results = await db.select().from(schema.myTable);\n```\n\n## Features\n\n- ✅ **Type-safe** - Full TypeScript inference from your schema\n- ✅ **No filesystem** - Works in Val Town's sandboxed environment\n- ✅ **Auto migrations** - Creates new tables automatically\n- ✅ **Change detection** - Warns when schemas change\n- ✅ **Foreign keys** - Handles relationships correctly\n- ✅ **Lightweight** - ~300 lines, zero dependencies beyond drizzle-orm\n\n## API Reference\n\n### `migrate(db, tables, options?)`\n\nRun migrations against your database.\n\n**Parameters:**\n\n- `db` - Val Town SQLite instance\n- `tables` - Object with table definitions\n- `options.dryRun` - (optional) Preview without executing\n\n**Returns:**\n\n```typescript\n{\n applied: string[], // New tables created\n skipped: string[], // Unchanged tables\n version: number // Migration version\n}\n```\n\n### `generateCreateTableSQL(table)`\n\nGenerate CREATE TABLE SQL for a single table.\n\n```typescript\nconst sql = generateCreateTableSQL(myTable);\nconsole.log(sql);\n// CREATE TABLE IF NOT EXISTS \"my_table\" (\n// \"id\" INTEGER PRIMARY KEY AUTOINCREMENT,\n// ...\n// );\n```\n\n### `generateSchemaSQL(tables)`\n\nGenerate SQL for all tables and indexes.\n\n```typescript\nconst sql = generateSchemaSQL({ users, posts });\n```\n\n## How It Works\n\n1. **Reads Drizzle metadata** - Uses Symbol keys to introspect schema\n2. **Generates SQL** - Walks column definitions to build CREATE TABLE\n3. **Tracks state in SQLite** - Stores migration versions in `__drizzle_migrations` table\n4. **Detects changes** - Compares SQL hashes to previous version\n5. **Safe updates** - Only creates new tables, warns about changes\n\n## Schema Changes\n\nWhen you modify an existing table:\n\n1. Update your schema val\n2. Run migrations again\n3. You'll see: `[CHANGED] Table schema changed: users`\n4. Write manual ALTER TABLE or recreate the table\n\nExample manual migration:\n\n```typescript\nawait sqlite.execute(`\n ALTER TABLE users ADD COLUMN bio TEXT;\n`);\n```\n\n## Comparison to Drizzle Kit\n\n| Feature | Drizzle Kit | This Solution |\n| --------------- | ----------- | --------------- |\n| Filesystem | Required | None |\n| Val Town | No | Yes |\n| Size | ~5MB | ~10KB |\n| Auto migrations | Yes | New tables only |\n| Type safety | Yes | Yes |\n\n## Tips\n\n### Add Authentication\n\n```typescript\nexport default async function (req: Request) {\n const auth = req.headers.get(\"authorization\");\n if (auth !== `Bearer ${Deno.env.get(\"MIGRATION_TOKEN\")}`) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n const result = await migrate(sqlite, schema);\n return Response.json(result);\n}\n```\n\nSet `MIGRATION_TOKEN` in Val Town secrets.\n\n### Dry Run\n\nSee what would happen without executing:\n\n```typescript\nconst result = await migrate(sqlite, schema, { dryRun: true });\n```\n\n### Multiple Environments\n\nEach Val Town user has their own SQLite database, so you can test changes before deploying.\n\n## Examples\n\nCheck out:\n\n- @nbbaier/drizzleSchema - Schema definitions\n- @nbbaier/runDrizzleMigrations - Migration runner\n- @nbbaier/drizzleExampleApp - Working API\n\n## License\n\nMIT - Use freely!\n\n## Questions?\n\nOpen an issue or ask in Val Town Discord.\n","createdAt",["D",1763959271562],"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","cd48db04-c8ef-11f0-8c99-42dde27851f2","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",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_40":39,"_85":41,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":42,"_92":93},"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",{"_40":41,"_31":42,"_35":197,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":50,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":198,"_78":199,"_80":200,"_82":24},"tree",[158,162,163],"files",[158,159,160,161,162,163],"counts",{"_148":60,"_149":131,"_150":60,"_151":152,"_153":154},"contents",[124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_40":141,"_31":142,"_29":143,"_130":-5,"_38":39,"_37":144,"_132":56,"_35":145,"_13":60,"_32":146,"_33":-5,"_23":24,"_136":-5,"_26":147},{"_40":138,"_31":27,"_29":30,"_130":-5,"_38":39,"_37":14,"_132":56,"_35":139,"_13":60,"_32":20,"_33":34,"_23":24,"_136":-5,"_26":140},{"_40":127,"_31":128,"_29":129,"_130":-5,"_38":39,"_37":131,"_132":24,"_35":133,"_13":60,"_32":134,"_33":135,"_23":24,"_136":-5,"_26":137},"e6f3ab68-c8ec-11f0-928c-42dde27851f2","main.ts","e6f3abfe-c8ec-11f0-928c-42dde27851f2","parentId",1,"latest",["D",1763958026095],"script","/**\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],"cd59b6e0-c8ef-11f0-bdd0-42dde27851f2",["D",1763959271562],[27],"cd3a7c3a-c8ef-11f0-8c99-42dde27851f2","example","cd3a7d20-c8ef-11f0-8c99-42dde27851f2",2,["D",1763959271434],"directory",[142],"pulls","branches","forks","envVars",{"_155":60,"_157":60},"connections",{"_155":60,"_156":60},"count","unfilledCount","emptyCount",{"_40":141,"_31":142,"_29":143,"_130":-5,"_38":39,"_37":144,"_132":56,"_35":194,"_13":60,"_32":146,"_33":-5,"_23":24,"_136":-5,"_165":195,"_26":196},{"_40":187,"_31":188,"_29":54,"_130":143,"_38":39,"_37":189,"_132":24,"_35":190,"_13":60,"_32":134,"_33":191,"_23":24,"_136":-5,"_165":192,"_26":193},{"_40":179,"_31":180,"_29":181,"_130":143,"_38":39,"_37":182,"_132":24,"_35":183,"_13":60,"_32":134,"_33":184,"_23":24,"_136":-5,"_165":185,"_26":186},{"_40":171,"_31":172,"_29":173,"_130":143,"_38":39,"_37":174,"_132":24,"_35":175,"_13":60,"_32":134,"_33":176,"_23":24,"_136":-5,"_165":177,"_26":178},{"_40":138,"_31":27,"_29":30,"_130":-5,"_38":39,"_37":14,"_132":56,"_35":168,"_13":60,"_32":20,"_33":34,"_23":24,"_136":-5,"_165":169,"_26":170},{"_40":127,"_31":128,"_29":129,"_130":-5,"_38":39,"_37":131,"_132":24,"_35":164,"_13":60,"_32":134,"_33":135,"_23":24,"_136":-5,"_165":166,"_26":167},["D",1763958026095],"children",[],[128],["D",1763959271562],[],[27],"cd52fb52-c8ef-11f0-aeb7-42dde27851f2","run-migrations.ts","cd52fc06-c8ef-11f0-aeb7-42dde27851f2",5,["D",1763959271591],"/**\n * Migration Runner\n *\n * Visit this endpoint to run migrations:\n * https://nbbaier-runDrizzleMigrations.web.val.run\n *\n * It will:\n * - Create new tables from your schema\n * - Track migration versions\n * - Warn about schema changes\n */\n\nimport { migrate } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/nbbaier/drizzleSchema\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (_req: Request) {\n\ttry {\n\t\tconst result = await migrate(sqlite, schema);\n\n\t\treturn Response.json({\n\t\t\tsuccess: true,\n\t\t\tversion: result.version,\n\t\t\tapplied: result.applied,\n\t\t\tskipped: result.skipped,\n\t\t\ttimestamp: new Date().toISOString(),\n\t\t});\n\t} catch (error) {\n\t\treturn Response.json(\n\t\t\t{\n\t\t\t\tsuccess: false,\n\t\t\t\terror: error.message,\n\t\t\t},\n\t\t\t{ status: 500 },\n\t\t);\n\t}\n}\n",[],[142,172],"cd4f91ba-c8ef-11f0-a862-42dde27851f2","inspect-schema.ts","cd4f92a0-c8ef-11f0-a862-42dde27851f2",4,["D",1763959271560],"/**\n * Schema Inspector\n *\n * View the SQL that will be generated from your Drizzle schema.\n * Useful for debugging or manual migrations.\n *\n * Visit: https://nbbaier-inspectDrizzleSchema.web.val.run\n */\nimport { generateSchemaSQL } from \"https://esm.town/v/nbbaier/drizzleMigrations\";\nimport * as schema from \"https://esm.town/v/nbbaier/drizzleSchema\";\n\nexport default function () {\n\tconst sql = generateSchemaSQL(schema);\n\treturn new Response(sql, {\n\t\theaders: { \"Content-Type\": \"text/plain\" },\n\t});\n}\n",[],[142,180],"cd48da28-c8ef-11f0-8c99-42dde27851f2","api.ts",3,["D",1763959271527],"/**\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",[],[142,188],["D",1763959271434],[159,160,161],[142],["D",1763958026076],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_40":39,"_85":41,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":42,"_92":93},"ctx",{"_76":-5,"_121":234,"_235":236,"_237":238,"_239":24,"_240":24,"_241":24,"_242":56,"_243":-5,"_244":-7,"_245":-7,"_246":60,"_247":24,"_248":24,"_249":-5,"_250":24,"_251":24,"_252":24,"_253":-5},"ENV",{"_205":206,"_207":208,"_209":84,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233},"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 · v6