Welcome to the official Cloudflare Developers server. Here you can ask for help and stay updated with the latest news
83,498Members
View on DiscordResources
Similar Threads
Was this page helpful?
JJ
III
MMM
E
KIIIKKEIIKEM
D
B
wrangler d1 execute --local --file=.sql approach. I thought I could just move the .wrangler/state/v3/d1 dir over to another dir and spin things up but that did not work. Is there some other approach I could use?
Hdatabase_iddatabase_name?MBBBM
.sqlite file and run .dump.sqlite file, unless you are referring to a remote D1 Database?BBBH.sqlite file. D1 in local development is just a wrapper around that .sqlite fileH
B.wrangler
M
MM
T
db.exec disabled inside pages functions? Works fine locally with wrangler, but not after deployed.T
.exec, do you get a db.exec is not a function error? I'm getting that, wondering if it's the same thing you are seeing and if you found a workaround?CREATE TABLE `experiences` (
`id` text PRIMARY KEY NOT NULL,
`name` text NOT NULL
);
CREATE TABLE `users` (
`id` text PRIMARY KEY NOT NULL,
`name` text NOT NULL
);
CREATE TABLE `experience_owners` (
`experience_id` text NOT NULL,
`user_id` text NOT NULL,
PRIMARY KEY(`experience_id`, `user_id`),
FOREIGN KEY (`experience_id`) REFERENCES `experiences`(`id`) ON UPDATE no action ON DELETE cascade
FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE no action
);
insert into experiences (id, name) VALUES (1, 'owning a house');
insert into users (id, name) VALUES (1, 'some guy');
insert into experience_owners (experience_id, user_id) VALUES (1,1);wrangler d1 execute --local --file=.sql.wrangler/state/v3/d1database_name.sqlite.sqlite.sqlite.sqlitedb.exec.execdb.exec is not a function