M
PRAGMA foreign_keys=off is a no-op (per SQLite spec). The defer works, as you can see.
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> query against a table with 4 rows from the D1 dashboard console.speed.cloudflare.com. I'm in Melb, Aus.
KK0:28MK
bfd358ee-8478-4a08-a37d-75dcabbf231b
N
HN
JHJHHJJN
EHH
O
KKOC
npx wrangler d1 export can I blacklist a specific table (migrations)?C--table ? From the docs it seem that you can either export all tables or only one specific. I would like all but migrations.Cexport && execute but migrations mess everything up ✘ [ERROR] UNIQUE constraint failed: d1_migrations.idC
VV
M
RM
user_id ?PRAGMA foreign_keys=offdefervar 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);SELECT * FROM <table>speed.cloudflare.com0:28bfd358ee-8478-4a08-a37d-75dcabbf231bnpx wrangler d1 export--tableexport && execute✘ [ERROR] UNIQUE constraint failed: d1_migrations.idD1_ERROR: D1 storage operation exceeded timeout which caused object to be reset.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();
};user_id"db:export": "npx wrangler d1 export db_name --remote --no-schema --output export.sql && npx wrangler d1 execute db_name --file=export.sql"