E
HH
O
KKO
C
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
R
M
user_id
P
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
PKBEGIN
IP![[wrangler] Made D1 BEGIN and CASE regex case insensitive by polvall...](https://images-ext-1.discordapp.net/external/NPSWk-yEcuFJG-Ln2ONb01LK_s7_DWt__2lag0H4l2g/https/opengraph.githubassets.com/e9577be72f920471d0c1bb206d5c80e5f17dfe6a9065ab870e22ca0e1abdff99/cloudflare/workers-sdk/pull/5889)
IIV
HHHHMM
d1_
5/22/24, 2:51 PM
HH.sqlite.wrangler
A
UserDROP TABLE User;:white_check_mark: No migrations to apply!
id
KError: D1_ERROR: D1 storage operation exceeded timeout which caused object to be reset.Anything going on?
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();
};CREATE TRIGGER delete_item_tags
AFTER DELETE ON list_item
begin
DELETE FROM list_item_tags
WHERE item_id = OLD.id;
END;npx wrangler d1 export--tableexport && execute✘ [ERROR] UNIQUE constraint failed: d1_migrations.id"db:export": "npx wrangler d1 export db_name --remote --no-schema --output export.sql && npx wrangler d1 execute db_name --file=export.sql"