User, then run DROP TABLE User; - is it expected that running the migration command again returns :white_check_mark: No migrations to apply!?
UserDROP TABLE User;:white_check_mark: No migrations to apply!
A
id
KError: D1_ERROR: D1 storage operation exceeded timeout which caused object to be reset.Anything going on?
P
M
AA
B
C
BCB
V
EXPLAIN QUERY PLAN
M
NError: Too many API requests by single worker invocation I know workers has a 1000 request invocation limit but I was wondering if there was a way insert large amounts of rows with a single request like pythons executemany command. I'm currently inserting a single row per request like this NNexecute() on a giant sql insert statement stringMMBBM
L
H
C
FCCCCCCC
CHCCCCHCCA
Error: Too many API requests by single worker invocationexecutemanyexecute()const prepared = db.prepare("INSERT OR IGNORE INTO r2_objects_metadata (object_key, eTag) VALUES (?1, ?2)");
const queriesToRun = newBucketObjects.map(bucketObject => prepared.bind(bucketObject.Key, bucketObject.ETag));
await db.batch(queriesToRun);[[d1_databases]]
binding = "DB" # available in your Worker on env.DB
database_name = "prod-d1-tutorial"
database_id = "<unique-ID-for-your-database>"
[[d1_databases]]
binding = "DB2" # available in your Worker on env.DB
database_name = "prod-d1-tutorial-v2"
database_id = "<unique-ID-for-your-database>"for (let i = 0; i < newBucketObjects.length; i++) {
const Key = newBucketObjects[i].Key;
const ETag = newBucketObjects[i].ETag;
await db.prepare(
`INSERT OR IGNORE INTO r2_objects_metadata
(object_key, eTag) VALUES (?, ?)`
).bind(Key, ETag).run();
}let masiveInsert = "";
for (let i = 0; i < newBucketObjects.length; i++) {
const Key = newBucketObjects[i].Key;
const ETag = newBucketObjects[i].ETag;
let insert = `INSERT OR IGNORE INTO r2_objects_metadata (object_key, eTag) VALUES ('${Key}', '${ETag}');`;
masiveInsert += '\n';
masiveInsert += insert;
}
await db.exec(masiveInsert);