hi all, Is there a limit on tables?
hi all, Is there a limit on tables?
batch with an array of objects or something of that nature?stmt.bindERROR 9009: SQL prepare error: incomplete input [code: 7500] which I've seen reported elsewhere in here. Anyone experience this and get past it? Even the simplest trigger fails when trying to use the --file operator from wrangler to seed the live DB.INSERT INTO example_table (activity_id, user_id, status)
VALUES
(2496, 1, 'AVAILALBE'),
(2496, 1, 'NOT_AVAILABLE'),
(2496, 2, 'AVAILABLE')
ON CONFLICT DO UPDATE SET status = excluded.status;stmt.bindERROR 9009: SQL prepare error: incomplete input [code: 7500]--file➜ npx wrangler@d1 d1 execute test-db --file 0000_initial.sql
🌀 Mapping SQL input into an array of statements
🌀 Parsing 25 statements
🌀 Executing on test-db (c020574a-5623-407b-be0c-cd192bab9545):CREATE TRIGGER 'updated_records_to_changelog' AFTER UPDATE OF 'status' ON 'availabilities'
WHEN OLD.status <> NEW.status
BEGIN
INSERT INTO changelog (c_id, for_date, status_was, status_is)
VALUES (OLD.c_id, OLD.for_date, OLD.status, NEW.status);
END;