[{"_1":2,"_294":-5,"_295":-5},"loaderData",{"_3":4,"_91":92,"_286":287},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4373f8772d13833b680eef333848fc46c0efa417","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_148":149,"_246":247,"_248":249,"_254":255,"_175":-5,"_280":-5,"_281":-5,"_282":22,"_283":22,"_284":285},"handle","maxm","name","dexieish","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_147":22},"id","7519e720-88ee-11f0-a287-0224a6c84d84","createdAt",["D",1756921819665],"deletedAt","legacyEnvVars","privacy","public","description","Data storage library. Val-scoped, SQLite backed, Dexie inspired.","imageUrl","418c1e39-eb48-4f2f-8c97-122ece94631c","pinnedFileId","pinPreview","screenshotVersion","likeCount",2,"c1e7642a-74cc-4d69-8652-20abbdeaa94e","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJnTEtkSHlOMWxWZm1GRHdKYUVTNklYM3FpdiJ9","org",{"_93":94,"_134":131},"avatar","branch",{"_99":137,"_95":43,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},93,"751a4c06-88ee-11f0-a287-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[150,180,189,199,208,217,227,237],{"_102":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_104":161,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":168,"_98":179},"98063a36-88ee-11f0-8af4-0224a6c84d84",".claude","fileId","98063ae0-88ee-11f0-8af4-0224a6c84d84","parentId","branchId","branchVersion",1,"latest",true,["D",1756921878252],"fileType","directory","content","deleted","label","children",[169],{"_102":170,"_95":171,"_153":172,"_155":154,"_156":138,"_157":173,"_159":160,"_104":174,"_99":32,"_162":175,"_164":176,"_165":22,"_166":-5,"_167":177,"_98":178},"99b90bb0-88ee-11f0-9b1c-0224a6c84d84","settings.local.json","99b90c6e-88ee-11f0-9b1c-0224a6c84d84",36,["D",1756921881019],"file","{\n \"permissions\": {\n \"allow\": [\n \"Bash(deno check:*)\"\n ],\n \"deny\": []\n }\n}",[],[152,171],[152],{"_102":181,"_95":182,"_153":183,"_155":-5,"_156":138,"_157":184,"_159":160,"_104":185,"_99":158,"_162":175,"_164":186,"_165":22,"_166":-5,"_167":187,"_98":188},"b164c3e4-88ee-11f0-90bb-0224a6c84d84",".vtignore","9a44cd12-88ee-11f0-87f3-0224a6c84d84",68,["D",1756921920818],".env\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor\n.gitignore\n.git\n",[],[182],{"_102":190,"_95":191,"_153":192,"_155":-5,"_156":138,"_157":193,"_159":160,"_104":194,"_99":195,"_162":175,"_164":196,"_165":22,"_166":-5,"_167":197,"_98":198},"f089327e-8909-11f0-96c3-0224a6c84d84","README.md","99c3f6ce-88ee-11f0-9074-0224a6c84d84",92,["D",1756933623157],3,"# Dexieish\n\nA minimal Dexie-like API on top of SQLite using\n[val.town/x/std/sqlite2](https://www.val.town/x/std/sqlite2).\n\nProvides val-scoped data storage using sqlite.\n\n## Quick Start\n\n```typescript\nimport { Dexieish } from \"https://esm.town/v/maxm/dexieish/main.ts\";\n\nconst db = new Dexieish();\n\n// Define schema\ndb.version(1).stores({\n users: \"++id, name, email\",\n});\n\nawait db.ready();\n```\n\n## Examples\n\n### Basic CRUD Operations\n\n```typescript\nconst db = new Dexieish();\n\ndb.version(1).stores({\n users: \"++id, name, &email, age\", // auto-increment id, unique email\n});\n\nawait db.ready();\nconst users = db.table(\"users\")!;\n\n// Create\nconst userId = await users.add({\n name: \"Alice\",\n email: \"alice@example.com\",\n age: 25,\n});\n\n// Read\nconst user = await users.get(userId);\nconst allUsers = await users.toArray();\n\n// Update\nawait users.update(userId, { age: 26 });\n\n// Delete\nawait users.delete(userId);\n```\n\n### Schema Definitions\n\n```typescript\n// Auto-increment primary key\n\"++id, name, email\";\n\n// Unique constraint\n\"++id, name, &email\"; // unique email\n\n// Compound index\n\"++id, name, email, [name+age]\"; // index on name+age combination\n\n// Unique compound index\n\"++id, name, email, &[category+slug]\"; // unique category+slug\n```\n\n### Querying with Where Clauses\n\n```typescript\nconst posts = db.table(\"posts\")!;\n\n// Exact match\nconst published = await posts.where(\"status\").equals(\"published\").toArray();\n\n// Range queries\nconst recent = await posts.where(\"createdAt\").above(\"2024-01-01\").toArray();\nconst range = await posts.where(\"score\").between(80, 100).toArray();\n\n// Multiple values\nconst categories = await posts.where(\"category\").anyOf([\"tech\", \"news\"])\n .toArray();\n\n// String prefix matching\nconst drafts = await posts.where(\"title\").startsWith(\"Draft\").toArray();\n\n// Ordering and pagination\nconst topPosts = await posts\n .orderBy(\"score\")\n .limit(10)\n .offset(20)\n .toArray();\n\n// Get first result\nconst latestPost = await posts\n .orderBy(\"createdAt\")\n .first();\n\n// Count results\nconst draftCount = await posts.where(\"status\").equals(\"draft\").count();\n```\n\n### Complex Relationships\n\n```typescript\ninterface BlogSchema {\n users: { id?: number; name: string; email: string };\n posts: { id?: number; userId: string; title: string; slug: string };\n comments: { id?: number; postId: string; userId: string; content: string };\n tags: { id?: number; name: string };\n post_tags: { id?: number; postId: string; tagId: string };\n}\n\nconst db = new Dexieish();\n\ndb.version(1).stores({\n users: \"++id, &email, name\",\n posts: \"++id, userId, title, &slug, createdAt\",\n comments: \"++id, postId, userId, createdAt\",\n tags: \"++id, &name\",\n post_tags: \"++id, postId, tagId, [postId+tagId]\",\n});\n\nawait db.ready();\n\n// Create relationships\nconst userId = await db.table(\"users\")!.add({\n name: \"Bob\",\n email: \"bob@example.com\",\n});\n\nconst postId = await db.table(\"posts\")!.add({\n userId,\n title: \"My First Post\",\n slug: \"my-first-post\",\n createdAt: new Date().toISOString(),\n});\n\nawait db.table(\"comments\")!.add({\n postId,\n userId,\n content: \"Great post!\",\n});\n\n// Query relationships\nconst userPosts = await db.table(\"posts\")!\n .where(\"userId\").equals(userId)\n .toArray();\n\nconst postComments = await db.table(\"comments\")!\n .where(\"postId\").equals(postId)\n .toArray();\n```\n\n### Bulk Operations\n\n```typescript\nconst users = db.table(\"users\")!;\n\n// Bulk insert\nconst newUsers = [\n { name: \"Alice\", email: \"alice@example.com\" },\n { name: \"Bob\", email: \"bob@example.com\" },\n { name: \"Charlie\", email: \"charlie@example.com\" },\n];\n\nconst count = await users.bulkAdd(newUsers);\nconsole.log(`Added ${count} users`);\n```\n\n### Schema Migrations\n\n```typescript\nconst db = new Dexieish();\n\n// Version 1: Initial schema\ndb.version(1).stores({\n users: \"++id, name, age\",\n});\n\n// Version 2: Add email field and posts table\ndb.version(2).stores({\n users: \"++id, name, age, email\", // Added email\n posts: \"++id, userId, title\", // New table\n});\n\n// Version 3: Make email unique, add indexes\ndb.version(3).stores({\n users: \"++id, name, age, &email\", // Made email unique\n posts: \"++id, userId, &title, content\", // Made title unique, added content\n});\n\nawait db.ready(); // Automatically migrates to latest version\n```\n\n### Table Prefixes for Testing\n\nOn Val Town VALTOWN_ENTRYPOINT is used to come up with a per-val prefix. You can\noverride it if you'd like.\n\n```typescript\n// Use table prefixes to isolate test data.\nconst testDb = new Dexieish({\n tablePrefix: \"test_\",\n});\n\ndb.version(1).stores({\n users: \"++id, name\", // Creates table \"test_users\"\n});\n\nawait testDb.ready();\n\n// Clean up all tables when done\nawait testDb.cleanup();\n```\n\n## Schema String Reference\n\n| Pattern | Description |\n| ------------------ | ---------------------------------- |\n| `++id` | Auto-increment integer primary key |\n| `id` | String primary key |\n| `&email` | Unique constraint on email field |\n| `name` | Regular indexed field |\n| `[name+age]` | Compound index on name and age |\n| `&[category+slug]` | Unique compound index |\n\n## TypeScript Support\n\n```typescript\ninterface User {\n id?: number;\n name: string;\n email: string;\n age?: number;\n}\n\ninterface AppSchema {\n users: User;\n posts: Post;\n}\n\nconst db = new Dexieish();\nconst users = db.table(\"users\")!; // Fully typed table operations\n```\n",[],[191],{"_102":200,"_95":201,"_153":202,"_155":-5,"_156":138,"_157":203,"_159":160,"_104":204,"_99":32,"_162":175,"_164":205,"_165":22,"_166":-5,"_167":206,"_98":207},"99b1546a-88ee-11f0-ba45-0224a6c84d84","deno.json","99b15672-88ee-11f0-ba45-0224a6c84d84",34,["D",1756921881017],"{\n \"lint\": {\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"tasks\": {\n \"dev\": \"deno run --watch main.ts\",\n \"test\": \"deno test --allow-net --allow-env --env-file .\"\n },\n \"imports\": {\n \"@std/assert\": \"jsr:@std/assert@1\"\n }\n}\n",[],[201],{"_102":209,"_95":210,"_153":211,"_155":-5,"_156":138,"_157":212,"_159":160,"_104":213,"_99":158,"_162":175,"_164":214,"_165":22,"_166":-5,"_167":215,"_98":216},"efcd7cc0-88ee-11f0-900a-0224a6c84d84","deno.lock","9a1b4082-88ee-11f0-8211-0224a6c84d84",71,["D",1756922025484],"{\n \"version\": \"5\",\n \"specifiers\": {\n \"jsr:@std/assert@1\": \"1.0.14\",\n \"jsr:@std/internal@^1.0.10\": \"1.0.10\",\n \"npm:@libsql/client@0\": \"0.1.6\",\n \"npm:@libsql/client@0.1\": \"0.1.6\",\n \"npm:@libsql/client@0.14\": \"0.14.0\",\n \"npm:@libsql/client@0.14.0\": \"0.14.0\",\n \"npm:@libsql/client@0.15.9\": \"0.15.9\"\n },\n \"jsr\": {\n \"@std/assert@1.0.14\": {\n \"integrity\": \"68d0d4a43b365abc927f45a9b85c639ea18a9fab96ad92281e493e4ed84abaa4\",\n \"dependencies\": [\n \"jsr:@std/internal\"\n ]\n },\n \"@std/internal@1.0.10\": {\n \"integrity\": \"e3be62ce42cab0e177c27698e5d9800122f67b766a0bea6ca4867886cbde8cf7\"\n }\n },\n \"npm\": {\n \"@libsql/client@0.1.6\": {\n \"integrity\": \"sha512-43XPfgqHqUTlPAOKqEI1SFWUbKYZrqQXQrh81oyw2QZ3ZRvAdGgnaKYHoKQNvC0nJOtVCgvT6VIJdLDORCYwGw==\",\n \"dependencies\": [\n \"@libsql/hrana-client@0.3.13\",\n \"@libsql/isomorphic-fetch@0.1.12\",\n \"better-sqlite3\",\n \"js-base64\"\n ]\n },\n \"@libsql/client@0.14.0\": {\n \"integrity\": \"sha512-/9HEKfn6fwXB5aTEEoMeFh4CtG0ZzbncBb1e++OCdVpgKZ/xyMsIVYXm0w7Pv4RUel803vE6LwniB3PqD72R0Q==\",\n \"dependencies\": [\n \"@libsql/core@0.14.0\",\n \"@libsql/hrana-client@0.7.0\",\n \"js-base64\",\n \"libsql@0.4.7\",\n \"promise-limit\"\n ]\n },\n \"@libsql/client@0.15.9\": {\n \"integrity\": \"sha512-VT3do0a0vwYVaNcp/y05ikkKS3OrFR5UeEf5SUuYZVgKVl1Nc1k9ajoYSsOid8AD/vlhLDB5yFQaV4HmT/OB9w==\",\n \"dependencies\": [\n \"@libsql/core@0.15.12\",\n \"@libsql/hrana-client@0.7.0\",\n \"js-base64\",\n \"libsql@0.5.17\",\n \"promise-limit\"\n ]\n },\n \"@libsql/core@0.14.0\": {\n \"integrity\": \"sha512-nhbuXf7GP3PSZgdCY2Ecj8vz187ptHlZQ0VRc751oB2C1W8jQUXKKklvt7t1LJiUTQBVJuadF628eUk+3cRi4Q==\",\n \"dependencies\": [\n \"js-base64\"\n ]\n },\n \"@libsql/core@0.15.12\": {\n \"integrity\": \"sha512-S3tF6885ZizVjfym7f8SevL2VId/+DzxiKmP5zFbrhA8oMLh2XH8bYXChmhab7o9qUSHx+XjK4jCFpUwR5g+Ig==\",\n \"dependencies\": [\n \"js-base64\"\n ]\n },\n \"@libsql/darwin-arm64@0.4.7\": {\n \"integrity\": \"sha512-yOL742IfWUlUevnI5PdnIT4fryY3LYTdLm56bnY0wXBw7dhFcnjuA7jrH3oSVz2mjZTHujxoITgAE7V6Z+eAbg==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/darwin-arm64@0.5.17\": {\n \"integrity\": \"sha512-WTYG2skZsUnZmfZ2v7WFj7s3/5s2PfrYBZOWBKOnxHA8g4XCDc/4bFDaqob9Q2e88+GC7cWeJ8VNkVBFpD2Xxg==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/darwin-x64@0.4.7\": {\n \"integrity\": \"sha512-ezc7V75+eoyyH07BO9tIyJdqXXcRfZMbKcLCeF8+qWK5nP8wWuMcfOVywecsXGRbT99zc5eNra4NEx6z5PkSsA==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/darwin-x64@0.5.17\": {\n \"integrity\": \"sha512-ab0RlTR4KYrxgjNrZhAhY/10GibKoq6G0W4oi0kdm+eYiAv/Ip8GDMpSaZdAcoKA4T+iKR/ehczKHnMEB8MFxA==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/hrana-client@0.3.13\": {\n \"integrity\": \"sha512-2Tof1k1bhSN8dqcxg5/i1KMBPnvTQ7swtbsOf5z8EI98tTh84jf2RgV01/t39H50epov6nIrwFTsGmgia0uBiw==\",\n \"dependencies\": [\n \"@libsql/isomorphic-ws\",\n \"js-base64\"\n ]\n },\n \"@libsql/hrana-client@0.7.0\": {\n \"integrity\": \"sha512-OF8fFQSkbL7vJY9rfuegK1R7sPgQ6kFMkDamiEccNUvieQ+3urzfDFI616oPl8V7T9zRmnTkSjMOImYCAVRVuw==\",\n \"dependencies\": [\n \"@libsql/isomorphic-fetch@0.3.1\",\n \"@libsql/isomorphic-ws\",\n \"js-base64\",\n \"node-fetch@3.3.2\"\n ]\n },\n \"@libsql/isomorphic-fetch@0.1.12\": {\n \"integrity\": \"sha512-MRo4UcmjAGAa3ac56LoD5OE13m2p0lu0VEtZC2NZMcogM/jc5fU9YtMQ3qbPjFJ+u2BBjFZgMPkQaLS1dlMhpg==\",\n \"dependencies\": [\n \"@types/node-fetch\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"@libsql/isomorphic-fetch@0.3.1\": {\n \"integrity\": \"sha512-6kK3SUK5Uu56zPq/Las620n5aS9xJq+jMBcNSOmjhNf/MUvdyji4vrMTqD7ptY7/4/CAVEAYDeotUz60LNQHtw==\"\n },\n \"@libsql/isomorphic-ws@0.1.5\": {\n \"integrity\": \"sha512-DtLWIH29onUYR00i0GlQ3UdcTRC6EP4u9w/h9LxpUZJWRMARk6dQwZ6Jkd+QdwVpuAOrdxt18v0K2uIYR3fwFg==\",\n \"dependencies\": [\n \"@types/ws\",\n \"ws\"\n ]\n },\n \"@libsql/linux-arm-gnueabihf@0.5.17\": {\n \"integrity\": \"sha512-PcASh4k47RqC+kMWAbLUKf1y6Do0q8vnUGi0yhKY4ghJcimMExViBimjbjYRSa+WIb/zh3QxNoXOhQAXx3tiuw==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm\"]\n },\n \"@libsql/linux-arm-musleabihf@0.5.17\": {\n \"integrity\": \"sha512-vxOkSLG9Wspit+SNle84nuIzMtr2G2qaxFzW7BhsZBjlZ8+kErf9RXcT2YJQdJYxmBYRbsOrc91gg0jLEQVCqg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm\"]\n },\n \"@libsql/linux-arm64-gnu@0.4.7\": {\n \"integrity\": \"sha512-WlX2VYB5diM4kFfNaYcyhw5y+UJAI3xcMkEUJZPtRDEIu85SsSFrQ+gvoKfcVh76B//ztSeEX2wl9yrjF7BBCA==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-arm64-gnu@0.5.17\": {\n \"integrity\": \"sha512-L8jnaN01TxjBJlDuDTX2W2BKzBkAOhcnKfCOf3xzvvygblxnDOK0whkYwIXeTfwtd/rr4jN/d6dZD/bcHiDxEQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-arm64-musl@0.4.7\": {\n \"integrity\": \"sha512-6kK9xAArVRlTCpWeqnNMCoXW1pe7WITI378n4NpvU5EJ0Ok3aNTIC2nRPRjhro90QcnmLL1jPcrVwO4WD1U0xw==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-arm64-musl@0.5.17\": {\n \"integrity\": \"sha512-HfFD7TzQtmmTwyQsuiHhWZdMRtdNpKJ1p4tbMMTMRECk+971NFHrj69D64cc2ClVTAmn7fA9XibKPil7WN/Q7w==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-x64-gnu@0.4.7\": {\n \"integrity\": \"sha512-CMnNRCmlWQqqzlTw6NeaZXzLWI8bydaXDke63JTUCvu8R+fj/ENsLrVBtPDlxQ0wGsYdXGlrUCH8Qi9gJep0yQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/linux-x64-gnu@0.5.17\": {\n \"integrity\": \"sha512-5l3XxWqUPVFrtX0xnZaXwqsXs0BFbP4w6ahRFTPSdXU50YBfUOajFznJRB6bJTMsCvraDSD0IkHhjSNfrE1CuQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/linux-x64-musl@0.4.7\": {\n \"integrity\": \"sha512-nI6tpS1t6WzGAt1Kx1n1HsvtBbZ+jHn0m7ogNNT6pQHZQj7AFFTIMeDQw/i/Nt5H38np1GVRNsFe99eSIMs9XA==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/linux-x64-musl@0.5.17\": {\n \"integrity\": \"sha512-FvSpWlwc+dIeYIFYlsSv+UdQ/NiZWr+SstwVji+QZ//8NnvzwWQU9cgP+Vpps6Qiq4jyYQm9chJhTYOVT9Y3BA==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/win32-x64-msvc@0.4.7\": {\n \"integrity\": \"sha512-7pJzOWzPm6oJUxml+PCDRzYQ4A1hTMHAciTAHfFK4fkbDZX33nWPVG7Y3vqdKtslcwAzwmrNDc6sXy2nwWnbiw==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/win32-x64-msvc@0.5.17\": {\n \"integrity\": \"sha512-f5bGH8+3A5sn6Lrqg8FsQ09a1pYXPnKGXGTFiAYlfQXVst1tUTxDTugnuWcJYKXyzDe/T7ccxyIZXeSmPOhq8A==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@neon-rs/load@0.0.4\": {\n \"integrity\": \"sha512-kTPhdZyTQxB+2wpiRcFWrDcejc4JI6tkPuS7UZCG4l6Zvc5kU/gGQ/ozvHTh1XR5tS+UlfAfGuPajjzQjCiHCw==\"\n },\n \"@types/node-fetch@2.6.13\": {\n \"integrity\": \"sha512-QGpRVpzSaUs30JBSGPjOg4Uveu384erbHBoT1zeONvyCfwQxIkUshLAOqN/k9EjGviPRmWTTe6aH2qySWKTVSw==\",\n \"dependencies\": [\n \"@types/node\",\n \"form-data\"\n ]\n },\n \"@types/node@22.15.15\": {\n \"integrity\": \"sha512-R5muMcZob3/Jjchn5LcO8jdKwSCbzqmPB6ruBxMcf9kbxtniZHP327s6C37iOfuw8mbKK3cAQa7sEl7afLrQ8A==\",\n \"dependencies\": [\n \"undici-types\"\n ]\n },\n \"@types/ws@8.18.1\": {\n \"integrity\": \"sha512-ThVF6DCVhA8kUGy+aazFQ4kXQ7E1Ty7A3ypFOe0IcJV8O/M511G99AW24irKrW56Wt44yG9+ij8FaqoBGkuBXg==\",\n \"dependencies\": [\n \"@types/node\"\n ]\n },\n \"asynckit@0.4.0\": {\n \"integrity\": \"sha512-Oei9OH4tRh0YqU3GxhX79dM/mwVgvbZJaSNaRk+bshkj0S5cfHcgYakreBjrHwatXKbz+IoIdYLxrKim2MjW0Q==\"\n },\n \"base64-js@1.5.1\": {\n \"integrity\": \"sha512-AKpaYlHn8t4SVbOHCy+b5+KKgvR4vrsD8vbvrbiQJps7fKDTkjkDry6ji0rUJjC0kzbNePLwzxq8iypo41qeWA==\"\n },\n \"better-sqlite3@8.7.0\": {\n \"integrity\": \"sha512-99jZU4le+f3G6aIl6PmmV0cxUIWqKieHxsiF7G34CVFiE+/UabpYqkU0NJIkY/96mQKikHeBjtR27vFfs5JpEw==\",\n \"dependencies\": [\n \"bindings\",\n \"prebuild-install\"\n ],\n \"scripts\": true\n },\n \"bindings@1.5.0\": {\n \"integrity\": \"sha512-p2q/t/mhvuOj/UeLlV6566GD/guowlr0hHxClI0W9m7MWYkL1F0hLo+0Aexs9HSPCtR1SXQ0TD3MMKrXZajbiQ==\",\n \"dependencies\": [\n \"file-uri-to-path\"\n ]\n },\n \"bl@4.1.0\": {\n \"integrity\": \"sha512-1W07cM9gS6DcLperZfFSj+bWLtaPGSOHWhPiGzXmvVJbRLdG82sH/Kn8EtW1VqWVA54AKf2h5k5BbnIbwF3h6w==\",\n \"dependencies\": [\n \"buffer\",\n \"inherits\",\n \"readable-stream\"\n ]\n },\n \"buffer@5.7.1\": {\n \"integrity\": \"sha512-EHcyIPBQ4BSGlvjB16k5KgAJ27CIsHY/2JBmCRReo48y9rQ3MaUzWX3KVlBa4U7MyX02HdVj0K7C3WaB3ju7FQ==\",\n \"dependencies\": [\n \"base64-js\",\n \"ieee754\"\n ]\n },\n \"call-bind-apply-helpers@1.0.2\": {\n \"integrity\": \"sha512-Sp1ablJ0ivDkSzjcaJdxEunN5/XvksFJ2sMBFfq6x0ryhQV/2b/KwFe21cMpmHtPOSij8K99/wSfoEuTObmuMQ==\",\n \"dependencies\": [\n \"es-errors\",\n \"function-bind\"\n ]\n },\n \"chownr@1.1.4\": {\n \"integrity\": \"sha512-jJ0bqzaylmJtVnNgzTeSOs8DPavpbYgEr/b0YL8/2GO3xJEhInFmhKMUnEJQjZumK7KXGFhUy89PrsJWlakBVg==\"\n },\n \"combined-stream@1.0.8\": {\n \"integrity\": \"sha512-FQN4MRfuJeHf7cBbBMJFXhKSDq+2kAArBlmRBvcvFE5BB1HZKXtSFASDhdlz9zOYwxh8lDdnvmMOe/+5cdoEdg==\",\n \"dependencies\": [\n \"delayed-stream\"\n ]\n },\n \"data-uri-to-buffer@4.0.1\": {\n \"integrity\": \"sha512-0R9ikRb668HB7QDxT1vkpuUBtqc53YyAwMwGeUFKRojY/NWKvdZ+9UYtRfGmhqNbRkTSVpMbmyhXipFFv2cb/A==\"\n },\n \"decompress-response@6.0.0\": {\n \"integrity\": \"sha512-aW35yZM6Bb/4oJlZncMH2LCoZtJXTRxES17vE3hoRiowU2kWHaJKFkSBDnDR+cm9J+9QhXmREyIfv0pji9ejCQ==\",\n \"dependencies\": [\n \"mimic-response\"\n ]\n },\n \"deep-extend@0.6.0\": {\n \"integrity\": \"sha512-LOHxIOaPYdHlJRtCQfDIVZtfw/ufM8+rVj649RIHzcm/vGwQRXFt6OPqIFWsm2XEMrNIEtWR64sY1LEKD2vAOA==\"\n },\n \"delayed-stream@1.0.0\": {\n \"integrity\": \"sha512-ZySD7Nf91aLB0RxL4KGrKHBXl7Eds1DAmEdcoVawXnLD7SDhpNgtuII2aAkg7a7QS41jxPSZ17p4VdGnMHk3MQ==\"\n },\n \"detect-libc@2.0.2\": {\n \"integrity\": \"sha512-UX6sGumvvqSaXgdKGUsgZWqcUyIXZ/vZTrlRT/iobiKhGL0zL4d3osHj3uqllWJK+i+sixDS/3COVEOFbupFyw==\"\n },\n \"dunder-proto@1.0.1\": {\n \"integrity\": \"sha512-KIN/nDJBQRcXw0MLVhZE9iQHmG68qAVIBg9CqmUYjmQIhgij9U5MFvrqkUL5FbtyyzZuOeOt0zdeRe4UY7ct+A==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-errors\",\n \"gopd\"\n ]\n },\n \"end-of-stream@1.4.5\": {\n \"integrity\": \"sha512-ooEGc6HP26xXq/N+GCGOT0JKCLDGrq2bQUZrQ7gyrJiZANJ/8YDTxTpQBXGMn+WbIQXNVpyWymm7KYVICQnyOg==\",\n \"dependencies\": [\n \"once\"\n ]\n },\n \"es-define-property@1.0.1\": {\n \"integrity\": \"sha512-e3nRfgfUZ4rNGL232gUgX06QNyyez04KdjFrF+LTRoOXmrOgFKDg4BCdsjW8EnT69eqdYGmRpJwiPVYNrCaW3g==\"\n },\n \"es-errors@1.3.0\": {\n \"integrity\": \"sha512-Zf5H2Kxt2xjTvbJvP2ZWLEICxA6j+hAmMzIlypy4xcBg1vKVnx89Wy0GbS+kf5cwCVFFzdCFh2XSCFNULS6csw==\"\n },\n \"es-object-atoms@1.1.1\": {\n \"integrity\": \"sha512-FGgH2h8zKNim9ljj7dankFPcICIK9Cp5bm+c2gQSYePhpaG5+esrLODihIorn+Pe6FGJzWhXQotPv73jTaldXA==\",\n \"dependencies\": [\n \"es-errors\"\n ]\n },\n \"es-set-tostringtag@2.1.0\": {\n \"integrity\": \"sha512-j6vWzfrGVfyXxge+O0x5sh6cvxAog0a/4Rdd2K36zCMV5eJ+/+tOAngRO8cODMNWbVRdVlmGZQL2YS3yR8bIUA==\",\n \"dependencies\": [\n \"es-errors\",\n \"get-intrinsic\",\n \"has-tostringtag\",\n \"hasown\"\n ]\n },\n \"expand-template@2.0.3\": {\n \"integrity\": \"sha512-XYfuKMvj4O35f/pOXLObndIRvyQ+/+6AhODh+OKWj9S9498pHHn/IMszH+gt0fBCRWMNfk1ZSp5x3AifmnI2vg==\"\n },\n \"fetch-blob@3.2.0\": {\n \"integrity\": \"sha512-7yAQpD2UMJzLi1Dqv7qFYnPbaPx7ZfFK6PiIxQ4PfkGPyNyl2Ugx+a/umUonmKqjhM4DnfbMvdX6otXq83soQQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill\"\n ]\n },\n \"file-uri-to-path@1.0.0\": {\n \"integrity\": \"sha512-0Zt+s3L7Vf1biwWZ29aARiVYLx7iMGnEUl9x33fbB/j3jR81u/O2LbqK+Bm1CDSNDKVtJ/YjwY7TUd5SkeLQLw==\"\n },\n \"form-data@4.0.4\": {\n \"integrity\": \"sha512-KrGhL9Q4zjj0kiUt5OO4Mr/A/jlI2jDYs5eHBpYHPcBEVSiipAvn2Ko2HnPe20rmcuuvMHNdZFp+4IlGTMF0Ow==\",\n \"dependencies\": [\n \"asynckit\",\n \"combined-stream\",\n \"es-set-tostringtag\",\n \"hasown\",\n \"mime-types\"\n ]\n },\n \"formdata-polyfill@4.0.10\": {\n \"integrity\": \"sha512-buewHzMvYL29jdeQTVILecSaZKnt/RJWjoZCF5OW60Z67/GmSLBkOFM7qh1PI3zFNtJbaZL5eQu1vLfazOwj4g==\",\n \"dependencies\": [\n \"fetch-blob\"\n ]\n },\n \"fs-constants@1.0.0\": {\n \"integrity\": \"sha512-y6OAwoSIf7FyjMIv94u+b5rdheZEjzR63GTyZJm5qh4Bi+2YgwLCcI/fPFZkL5PSixOt6ZNKm+w+Hfp/Bciwow==\"\n },\n \"function-bind@1.1.2\": {\n \"integrity\": \"sha512-7XHNxH7qX9xG5mIwxkhumTox/MIRNcOgDrxWsMt2pAr23WHp6MrRlN7FBSFpCpr+oVO0F744iUgR82nJMfG2SA==\"\n },\n \"get-intrinsic@1.3.0\": {\n \"integrity\": \"sha512-9fSjSaos/fRIVIp+xSJlE6lfwhES7LNtKaCBIamHsjr2na1BiABJPo0mOjjz8GJDURarmCPGqaiVg5mfjb98CQ==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-define-property\",\n \"es-errors\",\n \"es-object-atoms\",\n \"function-bind\",\n \"get-proto\",\n \"gopd\",\n \"has-symbols\",\n \"hasown\",\n \"math-intrinsics\"\n ]\n },\n \"get-proto@1.0.1\": {\n \"integrity\": \"sha512-sTSfBjoXBp89JvIKIefqw7U2CCebsc74kiY6awiGogKtoSGbgjYE/G/+l9sF3MWFPNc9IcoOC4ODfKHfxFmp0g==\",\n \"dependencies\": [\n \"dunder-proto\",\n \"es-object-atoms\"\n ]\n },\n \"github-from-package@0.0.0\": {\n \"integrity\": \"sha512-SyHy3T1v2NUXn29OsWdxmK6RwHD+vkj3v8en8AOBZ1wBQ/hCAQ5bAQTD02kW4W9tUp/3Qh6J8r9EvntiyCmOOw==\"\n },\n \"gopd@1.2.0\": {\n \"integrity\": \"sha512-ZUKRh6/kUFoAiTAtTYPZJ3hw9wNxx+BIBOijnlG9PnrJsCcSjs1wyyD6vJpaYtgnzDrKYRSqf3OO6Rfa93xsRg==\"\n },\n \"has-symbols@1.1.0\": {\n \"integrity\": \"sha512-1cDNdwJ2Jaohmb3sg4OmKaMBwuC48sYni5HUw2DvsC8LjGTLK9h+eb1X6RyuOHe4hT0ULCW68iomhjUoKUqlPQ==\"\n },\n \"has-tostringtag@1.0.2\": {\n \"integrity\": \"sha512-NqADB8VjPFLM2V0VvHUewwwsw0ZWBaIdgo+ieHtK3hasLz4qeCRjYcqfB6AQrBggRKppKF8L52/VqdVsO47Dlw==\",\n \"dependencies\": [\n \"has-symbols\"\n ]\n },\n \"hasown@2.0.2\": {\n \"integrity\": \"sha512-0hJU9SCPvmMzIBdZFqNPXWa6dqh7WdH0cII9y+CyS8rG3nL48Bclra9HmKhVVUHyPWNH5Y7xDwAB7bfgSjkUMQ==\",\n \"dependencies\": [\n \"function-bind\"\n ]\n },\n \"ieee754@1.2.1\": {\n \"integrity\": \"sha512-dcyqhDvX1C46lXZcVqCpK+FtMRQVdIMN6/Df5js2zouUsqG7I6sFxitIC+7KYK29KdXOLHdu9zL4sFnoVQnqaA==\"\n },\n \"inherits@2.0.4\": {\n \"integrity\": \"sha512-k/vGaX4/Yla3WzyMCvTQOXYeIHvqOKtnqBduzTHpzpQZzAskKMhZ2K+EnBiSM9zGSoIFeMpXKxa4dYeZIQqewQ==\"\n },\n \"ini@1.3.8\": {\n \"integrity\": \"sha512-JV/yugV2uzW5iMRSiZAyDtQd+nxtUnjeLt0acNdw98kKLrvuRVyB80tsREOE7yvGVgalhZ6RNXCmEHkUKBKxew==\"\n },\n \"js-base64@3.7.8\": {\n \"integrity\": \"sha512-hNngCeKxIUQiEUN3GPJOkz4wF/YvdUdbNL9hsBcMQTkKzboD7T/q3OYOuuPZLUE6dBxSGpwhk5mwuDud7JVAow==\"\n },\n \"libsql@0.4.7\": {\n \"integrity\": \"sha512-T9eIRCs6b0J1SHKYIvD8+KCJMcWZ900iZyxdnSCdqxN12Z1ijzT+jY5nrk72Jw4B0HGzms2NgpryArlJqvc3Lw==\",\n \"dependencies\": [\n \"@neon-rs/load\",\n \"detect-libc\"\n ],\n \"optionalDependencies\": [\n \"@libsql/darwin-arm64@0.4.7\",\n \"@libsql/darwin-x64@0.4.7\",\n \"@libsql/linux-arm64-gnu@0.4.7\",\n \"@libsql/linux-arm64-musl@0.4.7\",\n \"@libsql/linux-x64-gnu@0.4.7\",\n \"@libsql/linux-x64-musl@0.4.7\",\n \"@libsql/win32-x64-msvc@0.4.7\"\n ],\n \"os\": [\"darwin\", \"linux\", \"win32\"],\n \"cpu\": [\"x64\", \"arm64\", \"wasm32\"]\n },\n \"libsql@0.5.17\": {\n \"integrity\": \"sha512-RRlj5XQI9+Wq+/5UY8EnugSWfRmHEw4hn3DKlPrkUgZONsge1PwTtHcpStP6MSNi8ohcbsRgEHJaymA33a8cBw==\",\n \"dependencies\": [\n \"@neon-rs/load\",\n \"detect-libc\"\n ],\n \"optionalDependencies\": [\n \"@libsql/darwin-arm64@0.5.17\",\n \"@libsql/darwin-x64@0.5.17\",\n \"@libsql/linux-arm-gnueabihf\",\n \"@libsql/linux-arm-musleabihf\",\n \"@libsql/linux-arm64-gnu@0.5.17\",\n \"@libsql/linux-arm64-musl@0.5.17\",\n \"@libsql/linux-x64-gnu@0.5.17\",\n \"@libsql/linux-x64-musl@0.5.17\",\n \"@libsql/win32-x64-msvc@0.5.17\"\n ],\n \"os\": [\"darwin\", \"linux\", \"win32\"],\n \"cpu\": [\"x64\", \"arm64\", \"wasm32\", \"arm\"]\n },\n \"math-intrinsics@1.1.0\": {\n \"integrity\": \"sha512-/IXtbwEk5HTPyEwyKX6hGkYXxM9nbj64B+ilVJnC/R6B0pH5G4V3b0pVbL7DBj4tkhBAppbQUlf6F6Xl9LHu1g==\"\n },\n \"mime-db@1.52.0\": {\n \"integrity\": \"sha512-sPU4uV7dYlvtWJxwwxHD0PuihVNiE7TyAbQ5SWxDCB9mUYvOgroQOwYQQOKPJ8CIbE+1ETVlOoK1UC2nU3gYvg==\"\n },\n \"mime-types@2.1.35\": {\n \"integrity\": \"sha512-ZDY+bPm5zTTF+YpCrAU9nK0UgICYPT0QtT1NZWFv4s++TNkcgVaT0g6+4R2uI4MjQjzysHB1zxuWL50hzaeXiw==\",\n \"dependencies\": [\n \"mime-db\"\n ]\n },\n \"mimic-response@3.1.0\": {\n \"integrity\": \"sha512-z0yWI+4FDrrweS8Zmt4Ej5HdJmky15+L2e6Wgn3+iK5fWzb6T3fhNFq2+MeTRb064c6Wr4N/wv0DzQTjNzHNGQ==\"\n },\n \"minimist@1.2.8\": {\n \"integrity\": \"sha512-2yyAR8qBkN3YuheJanUpWC5U3bb5osDywNB8RzDVlDwDHbocAJveqqj1u8+SVD7jkWT4yvsHCpWqqWqAxb0zCA==\"\n },\n \"mkdirp-classic@0.5.3\": {\n \"integrity\": \"sha512-gKLcREMhtuZRwRAfqP3RFW+TK4JqApVBtOIftVgjuABpAtpxhPGaDcfvbhNvD0B8iD1oUr/txX35NjcaY6Ns/A==\"\n },\n \"napi-build-utils@2.0.0\": {\n \"integrity\": \"sha512-GEbrYkbfF7MoNaoh2iGG84Mnf/WZfB0GdGEsM8wz7Expx/LlWf5U8t9nvJKXSp3qr5IsEbK04cBGhol/KwOsWA==\"\n },\n \"node-abi@3.75.0\": {\n \"integrity\": \"sha512-OhYaY5sDsIka7H7AtijtI9jwGYLyl29eQn/W623DiN/MIv5sUqc4g7BIDThX+gb7di9f6xK02nkp8sdfFWZLTg==\",\n \"dependencies\": [\n \"semver\"\n ]\n },\n \"node-domexception@1.0.0\": {\n \"integrity\": \"sha512-/jKZoMpw0F8GRwl4/eLROPA3cfcXtLApP0QzLmUT/HuPCZWyB7IY9ZrMeKw2O/nFIqPQB3PVM9aYm0F312AXDQ==\",\n \"deprecated\": true\n },\n \"node-fetch@2.7.0\": {\n \"integrity\": \"sha512-c4FRfUm/dbcWZ7U+1Wq0AwCyFL+3nt2bEw05wfxSz+DWpWsitgmSgYmy2dQdWyKC1694ELPqMs/YzUSNozLt8A==\",\n \"dependencies\": [\n \"whatwg-url\"\n ]\n },\n \"node-fetch@3.3.2\": {\n \"integrity\": \"sha512-dRB78srN/l6gqWulah9SrxeYnxeddIG30+GOqK/9OlLVyLg3HPnr6SqOWTWOXKRwC2eGYCkZ59NNuSgvSrpgOA==\",\n \"dependencies\": [\n \"data-uri-to-buffer\",\n \"fetch-blob\",\n \"formdata-polyfill\"\n ]\n },\n \"once@1.4.0\": {\n \"integrity\": \"sha512-lNaJgI+2Q5URQBkccEKHTQOPaXdUxnZZElQTZY0MFUAuaEqe1E+Nyvgdz/aIyNi6Z9MzO5dv1H8n58/GELp3+w==\",\n \"dependencies\": [\n \"wrappy\"\n ]\n },\n \"prebuild-install@7.1.3\": {\n \"integrity\": \"sha512-8Mf2cbV7x1cXPUILADGI3wuhfqWvtiLA1iclTDbFRZkgRQS0NqsPZphna9V+HyTEadheuPmjaJMsbzKQFOzLug==\",\n \"dependencies\": [\n \"detect-libc\",\n \"expand-template\",\n \"github-from-package\",\n \"minimist\",\n \"mkdirp-classic\",\n \"napi-build-utils\",\n \"node-abi\",\n \"pump\",\n \"rc\",\n \"simple-get\",\n \"tar-fs\",\n \"tunnel-agent\"\n ],\n \"bin\": true\n },\n \"promise-limit@2.7.0\": {\n \"integrity\": \"sha512-7nJ6v5lnJsXwGprnGXga4wx6d1POjvi5Qmf1ivTRxTjH4Z/9Czja/UCMLVmB9N93GeWOU93XaFaEt6jbuoagNw==\"\n },\n \"pump@3.0.3\": {\n \"integrity\": \"sha512-todwxLMY7/heScKmntwQG8CXVkWUOdYxIvY2s0VWAAMh/nd8SoYiRaKjlr7+iCs984f2P8zvrfWcDDYVb73NfA==\",\n \"dependencies\": [\n \"end-of-stream\",\n \"once\"\n ]\n },\n \"rc@1.2.8\": {\n \"integrity\": \"sha512-y3bGgqKj3QBdxLbLkomlohkvsA8gdAiUQlSBJnBhfn+BPxg4bc62d8TcBW15wavDfgexCgccckhcZvywyQYPOw==\",\n \"dependencies\": [\n \"deep-extend\",\n \"ini\",\n \"minimist\",\n \"strip-json-comments\"\n ],\n \"bin\": true\n },\n \"readable-stream@3.6.2\": {\n \"integrity\": \"sha512-9u/sniCrY3D5WdsERHzHE4G2YCXqoG5FTHUiCC4SIbr6XcLZBY05ya9EKjYek9O5xOAwjGq+1JdGBAS7Q9ScoA==\",\n \"dependencies\": [\n \"inherits\",\n \"string_decoder\",\n \"util-deprecate\"\n ]\n },\n \"safe-buffer@5.2.1\": {\n \"integrity\": \"sha512-rp3So07KcdmmKbGvgaNxQSJr7bGVSVk5S9Eq1F+ppbRo70+YeaDxkw5Dd8NPN+GD6bjnYm2VuPuCXmpuYvmCXQ==\"\n },\n \"semver@7.7.2\": {\n \"integrity\": \"sha512-RF0Fw+rO5AMf9MAyaRXI4AV0Ulj5lMHqVxxdSgiVbixSCXoEmmX/jk0CuJw4+3SqroYO9VoUh+HcuJivvtJemA==\",\n \"bin\": true\n },\n \"simple-concat@1.0.1\": {\n \"integrity\": \"sha512-cSFtAPtRhljv69IK0hTVZQ+OfE9nePi/rtJmw5UjHeVyVroEqJXP1sFztKUy1qU+xvz3u/sfYJLa947b7nAN2Q==\"\n },\n \"simple-get@4.0.1\": {\n \"integrity\": \"sha512-brv7p5WgH0jmQJr1ZDDfKDOSeWWg+OVypG99A/5vYGPqJ6pxiaHLy8nxtFjBA7oMa01ebA9gfh1uMCFqOuXxvA==\",\n \"dependencies\": [\n \"decompress-response\",\n \"once\",\n \"simple-concat\"\n ]\n },\n \"string_decoder@1.3.0\": {\n \"integrity\": \"sha512-hkRX8U1WjJFd8LsDJ2yQ/wWWxaopEsABU1XfkM8A+j0+85JAGppt16cr1Whg6KIbb4okU6Mql6BOj+uup/wKeA==\",\n \"dependencies\": [\n \"safe-buffer\"\n ]\n },\n \"strip-json-comments@2.0.1\": {\n \"integrity\": \"sha512-4gB8na07fecVVkOI6Rs4e7T6NOTki5EmL7TUduTs6bu3EdnSycntVJ4re8kgZA+wx9IueI2Y11bfbgwtzuE0KQ==\"\n },\n \"tar-fs@2.1.3\": {\n \"integrity\": \"sha512-090nwYJDmlhwFwEW3QQl+vaNnxsO2yVsd45eTKRBzSzu+hlb1w2K9inVq5b0ngXuLVqQ4ApvsUHHnu/zQNkWAg==\",\n \"dependencies\": [\n \"chownr\",\n \"mkdirp-classic\",\n \"pump\",\n \"tar-stream\"\n ]\n },\n \"tar-stream@2.2.0\": {\n \"integrity\": \"sha512-ujeqbceABgwMZxEJnk2HDY2DlnUZ+9oEcb1KzTVfYHio0UE6dG71n60d8D2I4qNvleWrrXpmjpt7vZeF1LnMZQ==\",\n \"dependencies\": [\n \"bl\",\n \"end-of-stream\",\n \"fs-constants\",\n \"inherits\",\n \"readable-stream\"\n ]\n },\n \"tr46@0.0.3\": {\n \"integrity\": \"sha512-N3WMsuqV66lT30CrXNbEjx4GEwlow3v6rr4mCcv6prnfwhS01rkgyFdjPNBYd9br7LpXV1+Emh01fHnq2Gdgrw==\"\n },\n \"tunnel-agent@0.6.0\": {\n \"integrity\": \"sha512-McnNiV1l8RYeY8tBgEpuodCC1mLUdbSN+CYBL7kJsJNInOP8UjDDEwdk6Mw60vdLLrr5NHKZhMAOSrR2NZuQ+w==\",\n \"dependencies\": [\n \"safe-buffer\"\n ]\n },\n \"undici-types@6.21.0\": {\n \"integrity\": \"sha512-iwDZqg0QAGrg9Rav5H4n0M64c3mkR59cJ6wQp+7C4nI0gsmExaedaYLNO44eT4AtBBwjbTiGPMlt2Md0T9H9JQ==\"\n },\n \"util-deprecate@1.0.2\": {\n \"integrity\": \"sha512-EPD5q1uXyFxJpCrLnCc1nHnq3gOa6DZBocAIiI2TaSCA7VCJ1UJDMagCzIkXNsUYfD1daK//LTEQ8xiIbrHtcw==\"\n },\n \"web-streams-polyfill@3.3.3\": {\n \"integrity\": \"sha512-d2JWLCivmZYTSIoge9MsgFCZrt571BikcWGYkjC1khllbTeDlGqZ2D8vD8E/lJa8WGWbb7Plm8/XJYV7IJHZZw==\"\n },\n \"webidl-conversions@3.0.1\": {\n \"integrity\": \"sha512-2JAn3z8AR6rjK8Sm8orRC0h/bcl/DqL7tRPdGZ4I1CjdF+EaMLmYxBHyXuKL849eucPFhvBoxMsflfOb8kxaeQ==\"\n },\n \"whatwg-url@5.0.0\": {\n \"integrity\": \"sha512-saE57nupxk6v3HY35+jzBwYa0rKSy0XR8JSxZPwgLr7ys0IBzhGviA1/TUGJLmSVqs8pb9AnvICXEuOHLprYTw==\",\n \"dependencies\": [\n \"tr46\",\n \"webidl-conversions\"\n ]\n },\n \"wrappy@1.0.2\": {\n \"integrity\": \"sha512-l4Sp/DRseor9wL6EvV2+TuQn63dMkPjZ/sp9XkghTEbV9KlPS1xUsZ3u7/IQO4wxtcFB4bgpQPRcR3QCvezPcQ==\"\n },\n \"ws@8.18.3\": {\n \"integrity\": \"sha512-PEIGCY5tSlUt50cqyMXfCzX+oOPqN0vuGqWzbcJ2xvnkzkq46oOpz7dQaTDBdfICb4N14+GARUDw2XV2N4tvzg==\"\n }\n },\n \"redirects\": {\n \"https://esm.town/v/maxm/dexieish/main.ts\": \"https://esm.town/v/maxm/dexieish@68-main/main.ts\"\n },\n \"remote\": {\n \"https://esm.town/v/maxm/dexieish@68-main/main.ts\": \"760ad6bd076a9e3667502ba056035104bcb3ac93905dc51c650aea8f38b3ac74\"\n },\n \"workspace\": {\n \"dependencies\": [\n \"jsr:@std/assert@1\"\n ]\n }\n}\n",[],[210],{"_102":218,"_95":219,"_153":220,"_155":-5,"_156":138,"_157":137,"_159":160,"_104":221,"_99":222,"_162":223,"_164":224,"_165":22,"_166":-5,"_167":225,"_98":226},"a809398a-89be-11f0-b49c-0224a6c84d84","example.http.ts","efc3d44a-88ee-11f0-9b89-0224a6c84d84",["D",1757011240434],15,"http","import { Dexieish } from \"./main.ts\";\n// import { Dexieish } from \"https://esm.town/v/maxm/dexieish/main.ts\";\n\nconst db = new Dexieish();\n\n// Define schema\ndb.version(1).stores({\n users: \"++id, name, email\",\n});\n\nawait db.ready();\n\nasync function _addUsers() {\n const users = db.table(\"users\");\n\n await users.add({ name: \"Alice\", email: \"hi@hello.com\" });\n await users.add({ name: \"Bob\", email: \"bob@bob.law\" });\n}\n\nexport default async function (req: Request) {\n // await _addUsers();\n const users = db.table(\"users\");\n const allUsers = await users.where(\"name\").equals(\"Alice\").toArray();\n return Response.json(allUsers);\n}",[],[219],{"_102":228,"_95":229,"_153":230,"_155":-5,"_156":138,"_157":231,"_159":160,"_104":232,"_99":195,"_162":233,"_164":234,"_165":22,"_166":-5,"_167":235,"_98":236},"dccd2dfe-8908-11f0-b779-0224a6c84d84","main.ts","99ac7fb2-88ee-11f0-8211-0224a6c84d84",76,["D",1756933160551],"script","import { createClient, type Client } from \"npm:@libsql/client@0.15.9\";\n\n// ---- Types ----\ninterface SchemaConfig {\n primaryKey: { name: string; auto: boolean; type: string };\n singleIndexes: Array<{ name: string; unique: boolean }>;\n compoundIndexes: Array<{ fields: string[]; unique: boolean }>;\n indexColumns: Set;\n}\n\ninterface StoreDefinition {\n [tableName: string]: string;\n}\n\ninterface TableSchemaMap {\n [tableName: string]: any;\n}\n\ninterface VersionConfig {\n version: number;\n stores: StoreDefinition;\n}\n\ninterface SchemaVersion {\n version: number;\n applied_at: string;\n schema: string;\n}\n\ninterface ChangeEvent {\n table: string;\n type: 'add' | 'put' | 'update' | 'delete';\n id: string;\n obj: any;\n}\n\n\n// ---- Utilities ----\nconst isObject = (v: any): v is object => v !== null && typeof v === 'object';\nconst toJSON = (v: any): string => (isObject(v) ? JSON.stringify(v) : v);\nconst fromJSON = (v: any): any => {\n if (typeof v !== 'string') return v;\n try { return JSON.parse(v); } catch { return v; }\n};\n\n// Parse a Dexie-like stores() schema string, e.g. '++id, name, &email, [name+age]'\nfunction parseSchemaString(schemaStr: string): SchemaConfig {\n const tokens = schemaStr.split(',').map(t => t.trim()).filter(Boolean);\n if (!tokens.length) throw new Error('Invalid schema: empty');\n\n const primaryTok = tokens[0];\n if (primaryTok.startsWith('[')) {\n throw new Error('Compound primary keys are not supported in this quick version');\n }\n\n const res: SchemaConfig = {\n primaryKey: { name: '', auto: false, type: 'TEXT' },\n singleIndexes: [], // { name, unique }\n compoundIndexes: [], // { fields: [a,b], unique }\n indexColumns: new Set(),\n };\n\n // primary key\n if (primaryTok.startsWith('++')) {\n res.primaryKey.name = primaryTok.replace('++', '');\n res.primaryKey.auto = true;\n res.primaryKey.type = 'INTEGER';\n } else if (primaryTok.startsWith('&')) {\n res.primaryKey.name = primaryTok.replace('&', '');\n // unique string pk\n } else {\n res.primaryKey.name = primaryTok;\n }\n\n // indexes\n for (let i = 1; i < tokens.length; i++) {\n const tok = tokens[i];\n if (tok.startsWith('[')) {\n const unique = tok.startsWith('&[');\n const inner = tok.replace(/^&?\\[/, '').replace(/]$/, '');\n const fields = inner.split('+').map(s => s.trim());\n fields.forEach(f => res.indexColumns.add(f));\n res.compoundIndexes.push({ fields, unique });\n } else {\n const unique = tok.startsWith('&');\n const name = tok.replace('&', '');\n res.indexColumns.add(name);\n res.singleIndexes.push({ name, unique });\n }\n }\n\n return res;\n}\n\nfunction parseProjectName(url: string): string | null {\n const match = url.match(/^https:\\/\\/esm\\.town\\/v\\/([^\\/]+)\\/([^@]+)@([^\\/]+)/);\n return match ? match[2] : null;\n}\n\n\n\n// ---- Core classes ----\nexport class Dexieish> extends EventTarget {\n public client: Client;\n public tablePrefix: string;\n #_tables: Map> = new Map();\n #_versionConfigs: VersionConfig[] = [];\n #_currentVersion: number = 0;\n\n constructor(options?: { url?: string; tablePrefix?: string }) {\n super();\n const entrypoint = Deno.env.get(\"VALTOWN_ENTRYPOINT\");\n this.tablePrefix = entrypoint ? `dxi_${parseProjectName(entrypoint)}_` : options?.tablePrefix || '';\n this.client = createClient({\n url: options?.url || (Deno.env.has(\"VAL_TOWN_API_KEY\") ? \"https://api.val.town/v2/sqlite/\" : Deno.env.get(\"LIBSQL_URL\") as string),\n authToken: Deno.env.get(\"VAL_TOWN_API_KEY\") || Deno.env.get(\"TURSO_AUTH_TOKEN\"),\n });\n }\n\n version(n: number) {\n return {\n stores: (def: StoreDefinition) => {\n // Store version config instead of immediately applying\n this.#_versionConfigs.push({ version: n, stores: def });\n this.#_currentVersion = Math.max(this.#_currentVersion, n);\n return this;\n }\n };\n }\n\n async ready(): Promise {\n await this._initializeSchemaVersionTable();\n await this._runMigrations();\n }\n\n private _getFullTableName(tableName: string): string {\n return this.tablePrefix ? `${this.tablePrefix}${tableName}` : tableName;\n }\n\n async cleanup(): Promise {\n // Drop all tables created by this instance\n const tableNames = Array.from(this.#_tables.keys());\n const dropStatements = tableNames.map(name =>\n `DROP TABLE IF EXISTS ${quoteIdent(this._getFullTableName(name))}`\n );\n // Also drop schema version table\n dropStatements.push(`DROP TABLE IF EXISTS ${quoteIdent(this._getFullTableName('__schema_version'))}`);\n if (dropStatements.length > 0) {\n await this.client.batch(dropStatements, \"write\");\n }\n this.#_tables.clear();\n }\n\n table(name: K): Table | undefined {\n return this.#_tables.get(name as string) as Table | undefined;\n }\n\n private async _initializeSchemaVersionTable(): Promise {\n const tableName = this._getFullTableName('__schema_version');\n const createSql = `CREATE TABLE IF NOT EXISTS ${quoteIdent(tableName)} (\n version INTEGER PRIMARY KEY,\n applied_at TEXT NOT NULL,\n schema TEXT NOT NULL\n )`;\n await this.client.execute(createSql);\n }\n\n private async _getCurrentSchemaVersion(): Promise {\n const tableName = this._getFullTableName('__schema_version');\n const result = await this.client.execute(\n `SELECT * FROM ${quoteIdent(tableName)} ORDER BY version DESC LIMIT 1`\n );\n if (!result.rows.length) return null;\n const row = result.rows[0] as any;\n return {\n version: row.version,\n applied_at: row.applied_at,\n schema: row.schema\n };\n }\n\n private async _saveSchemaVersion(version: number, schema: string): Promise {\n const tableName = this._getFullTableName('__schema_version');\n await this.client.execute({\n sql: `INSERT OR REPLACE INTO ${quoteIdent(tableName)} (version, applied_at, schema) VALUES (?, ?, ?)`,\n args: [version, new Date().toISOString(), schema]\n });\n }\n\n private async _runMigrations(): Promise {\n if (this.#_versionConfigs.length === 0) return;\n\n // Sort version configs by version number\n this.#_versionConfigs.sort((a, b) => a.version - b.version);\n const targetVersion = this.#_versionConfigs[this.#_versionConfigs.length - 1];\n\n const currentVersion = await this._getCurrentSchemaVersion();\n const currentVersionNum = currentVersion?.version || 0;\n\n if (currentVersionNum >= targetVersion.version) {\n // Apply current schema without migration\n await this._applyStores(targetVersion.stores);\n return;\n }\n\n // Find the version config to migrate to\n const targetConfig = this.#_versionConfigs.find(v => v.version === targetVersion.version);\n if (!targetConfig) return;\n\n if (currentVersion) {\n // Perform migration\n const oldSchema = JSON.parse(currentVersion.schema);\n await this._performMigration(oldSchema, targetConfig.stores);\n } else {\n // Fresh installation\n await this._applyStores(targetConfig.stores);\n }\n\n // Save new schema version\n await this._saveSchemaVersion(targetVersion.version, JSON.stringify(targetConfig.stores));\n }\n\n private async _performMigration(oldSchema: StoreDefinition, newSchema: StoreDefinition): Promise {\n const migrationStatements: string[] = [];\n\n // Compare schemas and generate migration SQL\n const oldTables = new Set(Object.keys(oldSchema));\n const newTables = new Set(Object.keys(newSchema));\n\n // Handle new tables\n for (const tableName of newTables) {\n if (!oldTables.has(tableName)) {\n // Create new table\n const parsed = parseSchemaString(newSchema[tableName]);\n const fullTableName = this._getFullTableName(tableName);\n const statements = this._generateCreateTableSQL(fullTableName, parsed);\n migrationStatements.push(...statements);\n } else {\n // Check for schema changes in existing tables\n const oldParsed = parseSchemaString(oldSchema[tableName]);\n const newParsed = parseSchemaString(newSchema[tableName]);\n const alterStatements = this._generateAlterTableSQL(tableName, oldParsed, newParsed);\n migrationStatements.push(...alterStatements);\n }\n }\n\n // Handle removed tables\n for (const tableName of oldTables) {\n if (!newTables.has(tableName)) {\n const fullTableName = this._getFullTableName(tableName);\n migrationStatements.push(`DROP TABLE IF EXISTS ${quoteIdent(fullTableName)}`);\n }\n }\n\n // Execute migration statements\n if (migrationStatements.length > 0) {\n await this.client.batch(migrationStatements, \"write\");\n }\n\n // Apply the new schema to create table instances\n await this._applyStores(newSchema);\n }\n\n private _generateCreateTableSQL(fullTableName: string, parsed: SchemaConfig): string[] {\n const pk = parsed.primaryKey;\n const cols = [];\n cols.push('data TEXT NOT NULL');\n\n parsed.indexColumns.forEach(col => {\n if (col === pk.name) return;\n cols.push(`${col} TEXT`);\n });\n\n let pkClause;\n if (pk.auto) {\n pkClause = `${pk.name} INTEGER PRIMARY KEY AUTOINCREMENT`;\n } else {\n pkClause = `${pk.name} TEXT PRIMARY KEY`;\n }\n\n const createSql = `CREATE TABLE IF NOT EXISTS ${quoteIdent(fullTableName)} (\n ${pkClause},\n ${cols.join(',\\n ')}\n )`;\n\n const statements = [createSql];\n\n // Create indexes\n for (const idx of parsed.singleIndexes) {\n const idxName = `${fullTableName}_${idx.name}_${idx.unique ? 'uniq' : 'idx'}`;\n const sql = `CREATE ${idx.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${quoteIdent(idx.name)})`;\n statements.push(sql);\n }\n\n for (const c of parsed.compoundIndexes) {\n const idxName = `${fullTableName}_${c.fields.join('_')}_${c.unique ? 'uniq' : 'idx'}`;\n const colsSql = c.fields.map(f => quoteIdent(f)).join(',');\n const sql = `CREATE ${c.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${colsSql})`;\n statements.push(sql);\n }\n\n return statements;\n }\n\n private _generateAlterTableSQL(tableName: string, oldParsed: SchemaConfig, newParsed: SchemaConfig): string[] {\n const statements: string[] = [];\n const fullTableName = this._getFullTableName(tableName);\n\n // Find new columns to add\n const oldCols = new Set(oldParsed.indexColumns);\n const newCols = new Set(newParsed.indexColumns);\n\n for (const col of newCols) {\n if (!oldCols.has(col) && col !== newParsed.primaryKey.name) {\n statements.push(`ALTER TABLE ${quoteIdent(fullTableName)} ADD COLUMN ${quoteIdent(col)} TEXT`);\n }\n }\n\n // Handle index changes - drop old indexes and create new ones\n // Drop old single indexes that no longer exist\n for (const oldIdx of oldParsed.singleIndexes) {\n const stillExists = newParsed.singleIndexes.some(newIdx =>\n newIdx.name === oldIdx.name && newIdx.unique === oldIdx.unique\n );\n if (!stillExists) {\n const idxName = `${fullTableName}_${oldIdx.name}_${oldIdx.unique ? 'uniq' : 'idx'}`;\n statements.push(`DROP INDEX IF EXISTS ${quoteIdent(idxName)}`);\n }\n }\n\n // Drop old compound indexes that no longer exist\n for (const oldIdx of oldParsed.compoundIndexes) {\n const stillExists = newParsed.compoundIndexes.some(newIdx =>\n JSON.stringify(newIdx.fields) === JSON.stringify(oldIdx.fields) && newIdx.unique === oldIdx.unique\n );\n if (!stillExists) {\n const idxName = `${fullTableName}_${oldIdx.fields.join('_')}_${oldIdx.unique ? 'uniq' : 'idx'}`;\n statements.push(`DROP INDEX IF EXISTS ${quoteIdent(idxName)}`);\n }\n }\n\n // Create new single indexes\n for (const newIdx of newParsed.singleIndexes) {\n const alreadyExists = oldParsed.singleIndexes.some(oldIdx =>\n oldIdx.name === newIdx.name && oldIdx.unique === newIdx.unique\n );\n if (!alreadyExists) {\n const idxName = `${fullTableName}_${newIdx.name}_${newIdx.unique ? 'uniq' : 'idx'}`;\n const sql = `CREATE ${newIdx.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${quoteIdent(newIdx.name)})`;\n statements.push(sql);\n }\n }\n\n // Create new compound indexes\n for (const newIdx of newParsed.compoundIndexes) {\n const alreadyExists = oldParsed.compoundIndexes.some(oldIdx =>\n JSON.stringify(oldIdx.fields) === JSON.stringify(newIdx.fields) && oldIdx.unique === newIdx.unique\n );\n if (!alreadyExists) {\n const idxName = `${fullTableName}_${newIdx.fields.join('_')}_${newIdx.unique ? 'uniq' : 'idx'}`;\n const colsSql = newIdx.fields.map(f => quoteIdent(f)).join(',');\n const sql = `CREATE ${newIdx.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${colsSql})`;\n statements.push(sql);\n }\n }\n\n return statements;\n }\n\n private async _applyStores(def: StoreDefinition): Promise {\n for (const [tableName, schemaStr] of Object.entries(def)) {\n const parsed = parseSchemaString(schemaStr);\n const fullTableName = this._getFullTableName(tableName);\n await this._createTableAndIndexes(fullTableName, parsed);\n const table = new Table(this, tableName, fullTableName, parsed);\n this.#_tables.set(tableName, table as Table);\n (this as any)[tableName] = table; // ergonomic access: db.users\n }\n }\n\n private async _createTableAndIndexes(fullTableName: string, parsed: SchemaConfig): Promise {\n const pk = parsed.primaryKey;\n const cols = [];\n // JSON payload column mirrors Dexie storing whole objects\n cols.push('data TEXT NOT NULL');\n\n // Indexed columns as TEXT for simplicity (works for most comparisons)\n parsed.indexColumns.forEach(col => {\n if (col === pk.name) return; // pk defined separately\n cols.push(`${col} TEXT`);\n });\n\n let pkClause;\n if (pk.auto) {\n pkClause = `${pk.name} INTEGER PRIMARY KEY AUTOINCREMENT`;\n } else {\n pkClause = `${pk.name} TEXT PRIMARY KEY`;\n }\n\n const createSql = `CREATE TABLE IF NOT EXISTS ${quoteIdent(fullTableName)} (\n ${pkClause},\n ${cols.join(',\\n ')}\n )`;\n\n const statements = [createSql];\n\n // Create single-field indexes\n for (const idx of parsed.singleIndexes) {\n const idxName = `${fullTableName}_${idx.name}_${idx.unique ? 'uniq' : 'idx'}`;\n const sql = `CREATE ${idx.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${quoteIdent(idx.name)})`;\n statements.push(sql);\n }\n\n // Create compound indexes\n for (const c of parsed.compoundIndexes) {\n const idxName = `${fullTableName}_${c.fields.join('_')}_${c.unique ? 'uniq' : 'idx'}`;\n const colsSql = c.fields.map(f => quoteIdent(f)).join(',');\n const sql = `CREATE ${c.unique ? 'UNIQUE ' : ''}INDEX IF NOT EXISTS ${quoteIdent(idxName)} ON ${quoteIdent(fullTableName)}(${colsSql})`;\n statements.push(sql);\n }\n\n await this.client.batch(statements, \"write\");\n }\n}\n\nclass Table = any> {\n private _db: Dexieish;\n public name: string; // logical name (users)\n public fullName: string; // actual table name with prefix (test_users)\n public pk: string;\n private _auto: boolean;\n private _indexedCols: string[];\n\n constructor(db: Dexieish, name: string, fullName: string, parsed: SchemaConfig) {\n this._db = db;\n this.name = name;\n this.fullName = fullName;\n this.pk = parsed.primaryKey.name;\n this._auto = parsed.primaryKey.auto;\n this._indexedCols = Array.from(parsed.indexColumns);\n }\n\n async add(obj: T): Promise {\n const { sql, params } = this._buildInsert(obj, /*replace*/ false);\n const result = await this._db.client.execute({ sql, args: params });\n const id = this._auto ? String(result.lastInsertRowid) : String((obj as any)[this.pk]);\n return id;\n }\n\n async bulkAdd(objs: T[] = []): Promise {\n const statements = objs.map(obj => {\n const { sql, params } = this._buildInsert(obj, false);\n return { sql, args: params };\n });\n await this._db.client.batch(statements, \"write\");\n return objs.length;\n }\n\n async put(obj: T): Promise {\n const { sql, params } = this._buildInsert(obj, /*replace*/ true);\n const result = await this._db.client.execute({ sql, args: params });\n const id = this._auto && (obj as any)[this.pk] == null ? String(result.lastInsertRowid) : String((obj as any)[this.pk]);\n return id;\n }\n\n async update(id: string | number, changes: Partial): Promise {\n const row = await this.get(id);\n if (!row) return 0;\n const merged = { ...row, ...changes };\n const { sql, params } = this._buildUpdate(id, merged);\n const result = await this._db.client.execute({ sql, args: params });\n return Number(result.rowsAffected);\n }\n\n async delete(id: string | number): Promise {\n const result = await this._db.client.execute({\n sql: `DELETE FROM ${quoteIdent(this.fullName)} WHERE ${quoteIdent(this.pk)} = ?`,\n args: [id]\n });\n return Number(result.rowsAffected);\n }\n\n async get(id: string | number): Promise {\n const result = await this._db.client.execute({\n sql: `SELECT * FROM ${quoteIdent(this.fullName)} WHERE ${quoteIdent(this.pk)} = ?`,\n args: [id]\n });\n if (!result.rows.length) return null;\n const row = result.rows[0];\n const obj = fromJSON(row.data);\n return { ...obj, [this.pk]: row[this.pk] };\n }\n\n async toArray(): Promise {\n const result = await this._db.client.execute(`SELECT * FROM ${quoteIdent(this.fullName)}`);\n return result.rows.map((r: any) => ({ ...fromJSON(r.data), [this.pk]: r[this.pk] }));\n }\n\n where(indexOrProp: string): WhereClause {\n // Dexie where() only works on indexed fields or primary key\n return new WhereClause(this, indexOrProp);\n }\n\n orderBy(indexOrProp: string): Collection {\n const c = new Collection(this, '', [], indexOrProp);\n return c;\n }\n\n async count(): Promise {\n const result = await this._db.client.execute(`SELECT COUNT(*) as c FROM ${quoteIdent(this.fullName)}`);\n return Number(result.rows[0].c);\n }\n\n private _buildInsert(obj: T, replace: boolean): { sql: string; params: any[] } {\n const data = toJSON(obj);\n const cols = ['data'];\n const vals = [data];\n\n // include indexed columns from object for fast queries\n for (const col of this._indexedCols) {\n if (col === this.pk) continue; // pk handled separately\n cols.push(col);\n vals.push(toJSON((obj as any)[col]));\n }\n\n if (!this._auto || (obj as any)[this.pk] != null) {\n cols.unshift(this.pk);\n vals.unshift((obj as any)[this.pk]);\n }\n\n const placeholders = cols.map(() => '?').join(',');\n const sql = `INSERT ${replace ? 'OR REPLACE ' : ''}INTO ${quoteIdent(this.fullName)} (${cols.map(quoteIdent).join(',')}) VALUES (${placeholders})`;\n return { sql, params: vals };\n }\n\n private _buildUpdate(id: string | number, obj: T): { sql: string; params: any[] } {\n const sets = ['data = ?'];\n const params = [toJSON(obj)];\n\n for (const col of this._indexedCols) {\n if (col === this.pk) continue;\n sets.push(`${quoteIdent(col)} = ?`);\n params.push(toJSON((obj as any)[col]));\n }\n\n params.push(String(id));\n const sql = `UPDATE ${quoteIdent(this.fullName)} SET ${sets.join(', ')} WHERE ${quoteIdent(this.pk)} = ?`;\n return { sql, params };\n }\n\n}\n\nclass WhereClause = any> {\n constructor(private table: Table, private prop: string) {}\n\n private _collection(op: string, args: any[]): Collection {\n return new Collection(this.table, `${quoteIdent(this.prop)} ${op}`, args);\n }\n\n equals(v: any): Collection { return this._collection('= ?', [toJSON(v)]); }\n notEqual(v: any): Collection { return this._collection('<> ?', [toJSON(v)]); }\n above(v: any): Collection { return this._collection('> ?', [toJSON(v)]); }\n aboveOrEqual(v: any): Collection { return this._collection('>= ?', [toJSON(v)]); }\n below(v: any): Collection { return this._collection('< ?', [toJSON(v)]); }\n belowOrEqual(v: any): Collection { return this._collection('<= ?', [toJSON(v)]); }\n between(a: any, b: any, opts = { includeLower: true, includeUpper: true }): Collection {\n const lowOp = opts.includeLower ? '>= ?' : '> ?';\n const highOp = opts.includeUpper ? '<= ?' : '< ?';\n const clause = `${quoteIdent(this.prop)} ${lowOp} AND ${quoteIdent(this.prop)} ${highOp}`;\n return new Collection(this.table, clause, [toJSON(a), toJSON(b)]);\n }\n anyOf(arr: any[]): Collection {\n const qs = arr.map(() => '?').join(',');\n return new Collection(this.table, `${quoteIdent(this.prop)} IN (${qs})`, arr.map(toJSON));\n }\n startsWith(prefix: string): Collection {\n return this._collection('LIKE ?', [prefix + '%']);\n }\n}\n\nclass Collection = any> {\n public table: Table;\n public whereSql: string;\n public whereParams: any[];\n private _orderBy: string | null;\n private _limit: number | null;\n private _offset: number | null;\n\n constructor(table: Table, whereSql: string, whereParams: any[] = [], orderBy: string | null = null) {\n this.table = table;\n this.whereSql = whereSql; // e.g. 'name = ?' or ''\n this.whereParams = whereParams;\n this._orderBy = orderBy; // column name\n this._limit = null;\n this._offset = null;\n }\n\n orderBy(col: string): Collection { this._orderBy = col; return this; }\n limit(n: number): Collection { this._limit = n; return this; }\n offset(n: number): Collection { this._offset = n; return this; }\n\n async toArray(): Promise {\n const { sql, params } = this._buildSelect();\n const result = await (this.table as any)._db.client.execute({ sql, args: params });\n return result.rows.map((r: any) => ({ ...fromJSON(r.data), [this.table.pk]: r[this.table.pk] }));\n }\n\n async first(): Promise {\n this._limit = 1;\n const arr = await this.toArray();\n return arr[0] ?? undefined;\n }\n\n async count(): Promise {\n const { sql, params } = this._buildSelect(true);\n const result = await (this.table as any)._db.client.execute({ sql, args: params });\n return Number(result.rows[0].c);\n }\n\n private _buildSelect(onlyCount = false): { sql: string; params: any[] } {\n const table = quoteIdent(this.table.fullName);\n let sql = onlyCount ? `SELECT COUNT(*) as c FROM ${table}` : `SELECT * FROM ${table}`;\n const params = [...this.whereParams];\n\n if (this.whereSql) sql += ` WHERE ${this.whereSql}`;\n if (!onlyCount && this._orderBy) sql += ` ORDER BY ${quoteIdent(this._orderBy)}`;\n if (!onlyCount && this._limit != null) sql += ` LIMIT ${this._limit}`;\n if (!onlyCount && this._offset != null) sql += ` OFFSET ${this._offset}`;\n\n return { sql, params };\n }\n}\n\n// ---- Helpers ----\nfunction quoteIdent(name: string): string {\n if (!/^[_a-zA-Z][_a-zA-Z0-9]*$/.test(name)) throw new Error(`Invalid identifier: ${name}`);\n return name;\n}\n\n",[],[229],{"_102":238,"_95":239,"_153":240,"_155":-5,"_156":138,"_157":241,"_159":160,"_104":242,"_99":118,"_162":233,"_164":243,"_165":22,"_166":-5,"_167":244,"_98":245},"dcd2da1a-8908-11f0-b07c-0224a6c84d84","main_test.ts","99b5efc0-88ee-11f0-9bc1-0224a6c84d84",77,["D",1756933160591],"import { assertEquals, assertExists } from \"@std/assert\";\nimport { Dexieish } from \"./main.ts\";\n\n// Type definitions for test data\ninterface User {\n id?: number;\n name: string;\n email?: string;\n age?: number;\n}\n\ninterface Post {\n id?: number;\n userId: string;\n title: string;\n content: string;\n slug?: string;\n createdAt?: string;\n}\n\ninterface Comment {\n id?: number;\n postId: string;\n userId?: string;\n content: string;\n createdAt?: string;\n}\n\ninterface Tag {\n id?: number;\n name: string;\n}\n\ninterface PostTag {\n id?: number;\n postId: string;\n tagId: string;\n}\n\n// Schema type definitions\ninterface BasicSchema {\n users: User;\n}\n\ninterface ComplexSchema {\n users: User;\n posts: Post;\n comments: Comment;\n tags: Tag;\n post_tags: PostTag;\n}\n\ninterface MigrationSchema {\n users: User;\n posts: Post;\n comments: Comment;\n}\n\n// Helper function to dump all tables and their data for debugging\nasync function dumpAllTables(db: Dexieish, testName: string) {\n if (Deno.env.get(\"DEBUG\") !== \"true\") return;\n\n console.log(`\\n=== ${testName} - Database Dump ===`);\n\n // Get all tables that exist\n const result = await db.client.execute(`\n SELECT name FROM sqlite_master\n WHERE type='table' AND name NOT LIKE 'sqlite_%'\n ORDER BY name\n `);\n\n for (const row of result.rows) {\n const tableName = row.name as string;\n console.log(`\\nTable: ${tableName}`);\n\n // Get table schema\n const schemaResult = await db.client.execute(`PRAGMA table_info(${tableName})`);\n const columns = schemaResult.rows.map(r => `${r.name} (${r.type})`).join(', ');\n console.log(`Schema: ${columns}`);\n\n // Get table data\n try {\n const dataResult = await db.client.execute(`SELECT * FROM ${tableName}`);\n if (dataResult.rows.length === 0) {\n console.log(`Data: (empty)`);\n } else {\n console.log(`Data (${dataResult.rows.length} rows):`);\n dataResult.rows.forEach((row, i) => {\n console.log(` Row ${i + 1}:`, row);\n });\n }\n } catch (error) {\n console.log(`Error reading data: ${error instanceof Error ? error.message : String(error)}`);\n }\n }\n\n console.log(`=== End ${testName} Dump ===\\n`);\n}\n\nDeno.test(\"Dexieish basic operations with cleanup\", async function() {\n const testId = Date.now().toString();\n const db = new Dexieish( {\n tablePrefix: `test_${testId}_`\n });\n\n try {\n // Setup a simple users table\n db.version(1).stores({\n users: \"++id, name, email\"\n });\n\n // Wait for tables to be created\n await db.ready();\n\n const users = db.table(\"users\")!;\n\n // Test add operation\n const userId = await users.add({ name: \"John\", email: \"john@example.com\" });\n\n // Test get operation\n const user = await users.get(userId);\n assertEquals(user!.name, \"John\");\n assertEquals(user!.email, \"john@example.com\");\n\n // Test count\n const count = await users.count();\n assertEquals(count, 1);\n\n // Test toArray\n const allUsers = await users.toArray();\n assertEquals(allUsers.length, 1);\n assertEquals(allUsers[0].name, \"John\");\n\n // Test where clause\n const johnUsers = await users.where(\"name\").equals(\"John\").toArray();\n assertEquals(johnUsers.length, 1);\n assertEquals(johnUsers[0].name, \"John\");\n } finally {\n // Dump database state before cleanup\n await dumpAllTables(db, \"Basic Operations\");\n // Cleanup database\n await db.cleanup();\n }\n});\n\nDeno.test(\"Complex table structures with relationships\", async function() {\n const testId = Date.now().toString();\n const db = new Dexieish({\n tablePrefix: `complex_${testId}_`\n });\n\n try {\n // Setup complex schema with relationships\n db.version(1).stores({\n users: \"++id, &email, name, age, [name+age]\", // unique email, compound index on name+age\n posts: \"++id, userId, title, content, createdAt, &slug\", // unique slug\n comments: \"++id, postId, userId, content, createdAt\",\n tags: \"++id, &name\", // unique tag names\n post_tags: \"++id, postId, tagId, [postId+tagId]\" // junction table with compound index\n });\n\n await db.ready();\n\n const users = db.table(\"users\")!;\n const posts = db.table(\"posts\")!;\n const comments = db.table(\"comments\")!;\n const tags = db.table(\"tags\")!;\n const postTags = db.table(\"post_tags\")!;\n\n // Create test data\n const user1Id = await users.add({\n email: \"alice@example.com\",\n name: \"Alice\",\n age: 25\n });\n const user2Id = await users.add({\n email: \"bob@example.com\",\n name: \"Bob\",\n age: 30\n });\n\n // Test compound index query\n const youngUsers = await users.where(\"age\").below(28).toArray();\n assertEquals(youngUsers.length, 1);\n assertEquals(youngUsers[0].name, \"Alice\");\n\n // Create posts\n const post1Id = await posts.add({\n userId: user1Id,\n title: \"First Post\",\n content: \"Hello World!\",\n slug: \"first-post\",\n createdAt: new Date().toISOString()\n });\n\n const post2Id = await posts.add({\n userId: user2Id,\n title: \"Second Post\",\n content: \"TypeScript is great!\",\n slug: \"second-post\",\n createdAt: new Date().toISOString()\n });\n\n // Test unique constraint (slug)\n const postBySlug = await posts.where(\"slug\").equals(\"first-post\").first();\n assertExists(postBySlug);\n assertEquals(postBySlug.title, \"First Post\");\n\n // Create comments\n await comments.add({\n postId: post1Id,\n userId: user2Id,\n content: \"Great post!\",\n createdAt: new Date().toISOString()\n });\n\n await comments.add({\n postId: post1Id,\n userId: user1Id,\n content: \"Thanks!\",\n createdAt: new Date().toISOString()\n });\n\n // Test comments by post\n const post1Comments = await comments.where(\"postId\").equals(post1Id).toArray();\n assertEquals(post1Comments.length, 2);\n\n // Create tags and relationships\n const jsTagId = await tags.add({ name: \"JavaScript\" });\n const tsTagId = await tags.add({ name: \"TypeScript\" });\n\n await postTags.add({ postId: post1Id, tagId: jsTagId });\n await postTags.add({ postId: post2Id, tagId: tsTagId });\n await postTags.add({ postId: post2Id, tagId: jsTagId });\n\n // Test junction table queries\n const post2Tags = await postTags.where(\"postId\").equals(post2Id).toArray();\n assertEquals(post2Tags.length, 2);\n\n // Test ordering and pagination\n const orderedUsers = await users.orderBy(\"age\").limit(1).toArray();\n assertEquals(orderedUsers.length, 1);\n assertEquals(orderedUsers[0].name, \"Alice\");\n\n const offsetUsers = await users.orderBy(\"age\").offset(1).limit(1).toArray();\n assertEquals(offsetUsers.length, 1);\n assertEquals(offsetUsers[0].name, \"Bob\");\n\n // Test bulk operations\n const morePosts = [\n { userId: user1Id, title: \"Bulk Post 1\", content: \"Content 1\", slug: \"bulk-1\", createdAt: new Date().toISOString() },\n { userId: user1Id, title: \"Bulk Post 2\", content: \"Content 2\", slug: \"bulk-2\", createdAt: new Date().toISOString() },\n { userId: user2Id, title: \"Bulk Post 3\", content: \"Content 3\", slug: \"bulk-3\", createdAt: new Date().toISOString() }\n ];\n\n const bulkCount = await posts.bulkAdd(morePosts);\n assertEquals(bulkCount, 3);\n\n // Test final counts\n const totalPosts = await posts.count();\n assertEquals(totalPosts, 5); // 2 original + 3 bulk\n\n const alicePosts = await posts.where(\"userId\").equals(user1Id).count();\n assertEquals(alicePosts, 3); // 1 original + 2 bulk\n\n // Test update operation\n const updatedRows = await users.update(user1Id, { age: 26 });\n assertEquals(updatedRows, 1);\n\n const updatedUser = await users.get(user1Id);\n assertEquals(updatedUser!.age, 26);\n\n // Test delete operation\n const deletedRows = await comments.delete(post1Comments[0].id!);\n assertEquals(deletedRows, 1);\n\n const remainingComments = await comments.where(\"postId\").equals(post1Id).count();\n assertEquals(remainingComments, 1);\n\n } finally {\n // Dump database state before cleanup\n await dumpAllTables(db, \"Complex Structures\");\n // Cleanup database\n await db.cleanup();\n }\n});\n\nDeno.test(\"Table prefix isolation\", async function() {\n const testId1 = Date.now().toString();\n const testId2 = (Date.now() + 1).toString();\n\n const db1 = new Dexieish( { tablePrefix: `prefix1_${testId1}_` });\n const db2 = new Dexieish( { tablePrefix: `prefix2_${testId2}_` });\n\n try {\n // Setup identical schemas but different prefixes\n db1.version(1).stores({ users: \"++id, name\" });\n db2.version(1).stores({ users: \"++id, name\" });\n\n await db1.ready();\n await db2.ready();\n\n const users1 = db1.table(\"users\")!;\n const users2 = db2.table(\"users\")!;\n\n // Add data to each database\n await users1.add({ name: \"Alice\" });\n await users2.add({ name: \"Bob\" });\n await users2.add({ name: \"Charlie\" });\n\n // Verify isolation\n const db1Count = await users1.count();\n const db2Count = await users2.count();\n\n assertEquals(db1Count, 1);\n assertEquals(db2Count, 2);\n\n const db1Users = await users1.toArray();\n const db2Users = await users2.toArray();\n\n assertEquals(db1Users[0].name, \"Alice\");\n assertEquals(db2Users.length, 2);\n\n } finally {\n // Dump database state before cleanup\n await dumpAllTables(db1, \"Table Prefix Isolation - DB1\");\n await dumpAllTables(db2, \"Table Prefix Isolation - DB2\");\n // Cleanup both databases\n await db1.cleanup();\n await db2.cleanup();\n }\n});\n\nDeno.test(\"module parsing\", () => {\n try {\n Deno.env.set(\"VALTOWN_ENTRYPOINT\", \"https://esm.town/v/maxm/scratch2@62-main/new-file-8522.tsx\");\n const db = new Dexieish();\n assertEquals(db.tablePrefix, \"dxi_scratch2_\");\n } finally {\n Deno.env.delete(\"VALTOWN_ENTRYPOINT\");\n }\n})\n\nDeno.test(\"Schema migration system\", async function() {\n const testId = Date.now().toString();\n const db = new Dexieish( {\n tablePrefix: `migration_${testId}_`\n });\n\n try {\n // V1: Initial schema with just users\n db.version(1).stores({\n users: \"++id, name, age\"\n });\n\n await db.ready();\n\n const users = db.table(\"users\")!;\n\n // Add some initial data\n const user1Id = await users.add({ name: \"Alice\", age: 25 });\n const _user2Id = await users.add({ name: \"Bob\", age: 30 });\n\n // Verify initial data\n assertEquals(await users.count(), 2);\n\n // Simulate app restart with schema evolution\n const db2 = new Dexieish( {\n tablePrefix: `migration_${testId}_`\n });\n\n // V2: Add email column to users and new posts table\n db2.version(1).stores({\n users: \"++id, name, age\"\n });\n db2.version(2).stores({\n users: \"++id, name, age, email\", // Added email column\n posts: \"++id, userId, title, content\" // New posts table\n });\n\n await db2.ready();\n\n const users2 = db2.table(\"users\")!;\n const posts2 = db2.table(\"posts\")!;\n\n // Verify data is preserved after migration\n assertEquals(await users2.count(), 2);\n const preservedUsers = await users2.toArray();\n assertEquals(preservedUsers.length, 2);\n assertEquals(preservedUsers[0].name, \"Alice\");\n assertEquals(preservedUsers[1].name, \"Bob\");\n\n // Test that new column can be used\n await users2.update(user1Id, { email: \"alice@example.com\" });\n const updatedUser = await users2.get(user1Id);\n assertEquals(updatedUser!.email, \"alice@example.com\");\n\n // Test new table works\n const postId = await posts2.add({\n userId: user1Id,\n title: \"My First Post\",\n content: \"Hello world!\"\n });\n assertEquals(typeof postId, \"string\");\n\n const post = await posts2.get(postId);\n assertEquals(post!.title, \"My First Post\");\n\n // Simulate another app restart with further schema evolution\n const db3 = new Dexieish( {\n tablePrefix: `migration_${testId}_`\n });\n\n // V3: Add index to posts title, remove users (data loss acceptable per plan)\n db3.version(1).stores({\n users: \"++id, name, age\"\n });\n db3.version(2).stores({\n users: \"++id, name, age, email\",\n posts: \"++id, userId, title, content\"\n });\n db3.version(3).stores({\n posts: \"++id, userId, &title, content\", // Made title unique\n comments: \"++id, postId, content\" // New comments table\n });\n\n await db3.ready();\n\n // Verify users table is gone, posts table still has data\n assertEquals(db3.table(\"users\"), undefined);\n const posts3 = db3.table(\"posts\")!;\n const comments3 = db3.table(\"comments\")!;\n\n // Posts should still exist\n assertEquals(await posts3.count(), 1);\n const migratedPost = await posts3.toArray();\n assertEquals(migratedPost[0].title, \"My First Post\");\n\n // Test new comments table\n const commentId = await comments3.add({\n postId: postId,\n content: \"Great post!\"\n });\n assertEquals(typeof commentId, \"string\");\n\n // Dump final state before cleanup\n await dumpAllTables(db3, \"Schema Migration - Final State\");\n\n // Cleanup\n await db3.cleanup();\n\n } finally {\n // Ensure cleanup\n try {\n await db.cleanup();\n } catch {\n // May already be cleaned up\n }\n }\n});\n",[],[239],"files",[150,169,180,189,199,208,217,227,237],"counts",{"_250":32,"_251":158,"_252":32,"_253":32},"pulls","branches","forks","envVars","contents",[256,259,262,265,268,271,274,277],{"_102":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_104":257,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":258},["D",1756921878252],[152],{"_102":181,"_95":182,"_153":183,"_155":-5,"_156":138,"_157":184,"_159":160,"_104":260,"_99":158,"_162":175,"_164":186,"_165":22,"_166":-5,"_98":261},["D",1756921920818],[182],{"_102":190,"_95":191,"_153":192,"_155":-5,"_156":138,"_157":193,"_159":160,"_104":263,"_99":195,"_162":175,"_164":196,"_165":22,"_166":-5,"_98":264},["D",1756933623157],[191],{"_102":200,"_95":201,"_153":202,"_155":-5,"_156":138,"_157":203,"_159":160,"_104":266,"_99":32,"_162":175,"_164":205,"_165":22,"_166":-5,"_98":267},["D",1756921881017],[201],{"_102":209,"_95":210,"_153":211,"_155":-5,"_156":138,"_157":212,"_159":160,"_104":269,"_99":158,"_162":175,"_164":214,"_165":22,"_166":-5,"_98":270},["D",1756922025484],[210],{"_102":218,"_95":219,"_153":220,"_155":-5,"_156":138,"_157":137,"_159":160,"_104":272,"_99":222,"_162":223,"_164":224,"_165":22,"_166":-5,"_98":273},["D",1757011240434],[219],{"_102":228,"_95":229,"_153":230,"_155":-5,"_156":138,"_157":231,"_159":160,"_104":275,"_99":195,"_162":233,"_164":234,"_165":22,"_166":-5,"_98":276},["D",1756933160551],[229],{"_102":238,"_95":239,"_153":240,"_155":-5,"_156":138,"_157":241,"_159":160,"_104":278,"_99":118,"_162":233,"_164":243,"_165":22,"_166":-5,"_98":279},["D",1756933160591],[239],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":288,"_253":293},{"_102":103,"_95":96,"_104":289,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":290,"_132":291,"_135":292,"_147":22},["D",1756921819665],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_99":137,"_95":43,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[],"actionData","errors"]

Environment variables