zod or similar because it enforces exact 1:1 match between types and actual output share versus types drifting away from the actual typeid INTEGER PRIMARY KEY AUTOINCREMENT is only one-digit, I want to replace this with 10-digit uuid. Anyone got a solution for this?id = str(uuid.uuid4()) is the easiest. I thought there might be some native methods from cloudflare side.results from the return Response.json(results) area? I'm getting this: results.get('results') throws an error. Also, type(results) is undefined?Map so the .get() doesn't exist on objects. You can just do response.results.bind function in the wrong way?PRAGMA table_info(?); but it threw another error:"PRAGMA table_info(\""+table+"\")". It worked good.db.prepare("PRAGMA table_info(?)").bind(table)ERROR] {"D1_RESET_DO":true} or ✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset. when trying to import a sql dump. has anyone managed to get this work without this obscure error?But on production the 5 records are displaying instead of the 21 records.What exactly do you mean by this? You said that the D1 Dashboard correctly shows the 21 records, so what is "production" in this sentence that still shows 5 records?
{"success":true,"meta":{"served_by":"v3-prod","duration":0.1977,"changes":0,"last_row_id":0,"changed_db":false,"size_after":16384,"rows_read":1,"rows_written":0},"results":[{"test":"a"}]}Map.get()response.resultsWrong number of parameter bindings for SQL query.bindPRAGMA table_info(?);near "?": syntax error at offset 18: SQLITE_ERROR"PRAGMA table_info(\""+table+"\")"db.prepare("PRAGMA table_info(?)").bind(table)ERROR] {"D1_RESET_DO":true}✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset.npx wrangler d1 execute mydb --file scripts/sql/db.sql --remote
⛅️ wrangler 3.95.0
-------------------
:heavy_check_mark: :warning: This process may take some time, during which your D1 database will be unavailable to serve queries.
Ok to proceed? … yes
:cyclone: Executing on remote database mydb ([redacted]):
:cyclone: To execute on your local development database, remove the --remote flag from your wrangler command.
Note: if the execution fails to complete, your DB will return to its original state and you can safely retry.
:cyclone: File already uploaded. Processing.
:cyclone: Starting import...
:cyclone: Processed 36213 queries.
:cyclone: Processed 52452 queries.
:cyclone: Processed 69008 queries.
:cyclone: Processed 85617 queries.
:cyclone: Processed 101990 queries.
:cyclone: Processed 118607 queries.
:cyclone: Processed 135103 queries.
:cyclone: Processed 151403 queries.
:cyclone: Processed 168062 queries.
:cyclone: Processed 184991 queries.
:cyclone: Processed 201756 queries.
:cyclone: Processed 218587 queries.
:cyclone: Processed 235727 queries.
:cyclone: Processed 252693 queries.
:cyclone: Processed 269614 queries.
:cyclone: Processed 288195 queries.
:cyclone: Processed 305191 queries.
✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset.var table='PLiFNg5fXiX33oJoBNfuq2yO7exoc_9qJW';
var queries=[env.db.prepare("PRAGMA table_info(\"?\")").bind(table)]
const batchResult = await env.db.batch(queries)