J
M
PRAGMA foreign_keys=offdefer
ZZ
M
F
MF
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
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);"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();
};