M
F
JJ
R
var batch_arr = [];
const delete_r = env.DB.prepare("DELETE FROM table");
batch_arr.push(delete_r);
const stmt = env.DB.prepare("INSERT INTO table (n, v) VALUES (?1, ?2)");
for(var i = 0; i < 100; i++) {
batch_arr.push(stmt.bind( i, 'str' ));
}
const batch = await env.DB.batch(batch_arr);
M
IIRIIM
K
SELECT * FROM <table>speed.cloudflare.com
KK0:28
bfd358ee-8478-4a08-a37d-75dcabbf231b
N
HN
JHJHHJJN
EHH
O
KKOC
npx wrangler d1 export--tableexport && execute✘ [ERROR] UNIQUE constraint failed: d1_migrations.id
VV
M
R
M
user_id
Pexecute or with migrations, it outputs this:P--file) and as a command (--command "CREATE TRIGGER delete_item_tags after delete on list_item begin DELETE FROM list_item_tags WHERE item_id = OLD.id; END;")K
begin fully caps, i.e BEGINvar batch_arr = [];
const delete_r = env.DB.prepare("DELETE FROM table");
batch_arr.push(delete_r);
const stmt = env.DB.prepare("INSERT INTO table (n, v) VALUES (?1, ?2)");
for(var i = 0; i < 100; i++) {
batch_arr.push(stmt.bind( i, 'str' ));
}
const batch = await env.DB.batch(batch_arr);"db:export": "npx wrangler d1 export db_name --remote --no-schema --output export.sql && npx wrangler d1 execute db_name --file=export.sql"export const getUser = async (
env: Bindings,
userId: number
): Promise<Resource | null> => {
const sqlQuery = env.DB.prepare(
`SELECT * FROM Users WHERE user_id = ?`
).bind(userId);
return await sqlQuery.first();
};execute--file--command "CREATE TRIGGER delete_item_tags after delete on list_item begin DELETE FROM list_item_tags WHERE item_id = OLD.id; END;"beginBEGIN✘ [ERROR] incomplete inputCREATE TRIGGER delete_item_tags
AFTER DELETE ON list_item
begin
DELETE FROM list_item_tags
WHERE item_id = OLD.id;
END;