About d1db ``` describe('queries', async () => { const mf = new Miniflare({ name: 'main',
About d1db
describe('queries', async () => {
const mf = new Miniflare({
name: 'main',
modules: true,
script: `
export default {
async fetch(request, env, ctx){
return new Response('Hello World!');
},};
`,
d1Databases: ['D1'],
})
const d1db = await mf.getD1Database('D1')
// exec ddl...
test('assert table', async () => {
const { results } = await d1db.prepare('SELECT * FROM sqlite_master;').all()
const tableNames = results.map((result) => result.name)
console.debug('tableNames', tableNames)
expect(tableNames).toContain('user')
expect(tableNames).toContain('account')
}
// output:
// tableNames [ '_cf_KV', 'user', 'account' ]describe('queries', async () => {
const mf = new Miniflare({
name: 'main',
modules: true,
script: `
export default {
async fetch(request, env, ctx){
return new Response('Hello World!');
},};
`,
d1Databases: ['D1'],
})
const d1db = await mf.getD1Database('D1')
// exec ddl...
test('assert table', async () => {
const { results } = await d1db.prepare('SELECT * FROM sqlite_master;').all()
const tableNames = results.map((result) => result.name)
console.debug('tableNames', tableNames)
expect(tableNames).toContain('user')
expect(tableNames).toContain('account')
}
// output:
// tableNames [ '_cf_KV', 'user', 'account' ]