F
H
N
C
DN
M
wrangler d1 insights
M
wrangler
I
M/query
IMM
exec()prepare()
M
Ddb-envdb-prodmigrations/0001_init.sqlmigrations/0002_init.sqlwrangler.tomlmigrations_dir
DDDmigrations_dir
NCNNC
OCO
JRight now, deletes are treated as writes.
M
J
ON UPDATE RESTRICT
E
KIIIK
[
{
"query": "SELECT * FROM [Order] ORDER BY random() LIMIT ?",
"avgRowsRead": 2000,
"totalRowsRead": 2842000,
"avgRowsWritten": 0,
"totalRowsWritten": 0,
"avgDurationMs": 3.9992672061928225,
"totalDurationMs": 5682.958700000001,
"numberOfTimesRun": 1421
},
{
"query": "DROP TABLE IF EXISTS \"Order\";",
"avgRowsRead": 13,
"totalRowsRead": 17004,
"avgRowsWritten": 0,
"totalRowsWritten": 0,
"avgDurationMs": 0.35294311926605504,
"totalDurationMs": 461.6496,
"numberOfTimesRun": 1308
},[env.prod]
build = { command = "worker-build --release" }
d1_databases = [{ binding = "DB_PROD", database_name = "foo-prod", database_id = "id-2" }]
[env.dev]
build = { command = "worker-build --dev" }
d1_databases = [{ binding = "DB_DEV", database_name = "foo-dev", database_id = "id-1" }]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);