H
V
returned. If i have to put them into an array like so:returned variable i can now use, so what do i do?HH
T
JJTTJTTJT
M
J
d1 in the github repo linked in the docs, and it creates the db for testing using migrations. I expected to test my local d1 directly and this will know my local db from my bindings (toml is passed to vitest.config.mts).V
D
ZH
IIIII
IMI
OMOOO
R
Internal error in D1 storage caused object to be reset.VV
CH
Anpx wrangler d1 create to create a D1 database, he has to manually insert the new D1 binding configuration to the file wrangler.tomlwrangler.toml
M
L
C
RR
M
Internal error in D1 storage caused object to be reset. errorsRR
returnedreturnedd1vitest.config.mtsInternal error in D1 storage caused object to be reset.Internal error in D1 storage caused object to be reset.npx wrangler d1 createconst returned = await tx
.insert(schema.universities)
.values({ handle: form.data.handle })
.returning({ id: schema.universities.id });
await tx.insert(schema.localizedUniversityNames).values({
university: returned[0].id,
languageTag: form.data.languageTag,
name: form.data.name,
});db.bulk([
db.insert(schema.universities).values({ handle: form.data.handle }).returning({ id: schema.universities.id }),
db.insert(schema.localizedUniversityNames).values({university: returned[0].id,languageTag: form.data.languageTag,name: form.data.name}),
]);import { env } from "cloudflare:test";
import { describe, it, expect } from "vitest";
import { Env } from "../src/index.js";
//This is in the docs for env
declare module "cloudflare:test" {
interface ProvidedEnv extends Env {}
}
it("Prepared statements", async () => {
//test some function that uses env, but doesn't query d1, and it works
...
//test some function which queries my local d1 db
// doesn't found the table/s used in my query, sql error.
const table_list = await env.MY_DB.exec("pragma table_list;");
console.log("Table list:", table_list);
// which prints: Table list: { count: 1, duration: 0 }
})