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' ]
Was this page helpful?