unit tests with vitest, drizzle and d1

import { defineWorkersConfig } from '@cloudflare/vitest-pool-workers/config'
import path from 'path';

export default defineWorkersConfig({
  resolve: {
    alias: {
      '@': path.resolve(__dirname, './src'),
    },
  },
  test: {
    globals: true,
    poolOptions: {
      workers: {
        isolatedStorage: false,
        wrangler: { configPath: './wrangler.toml' }
      },
    }
  }
})

name = "api"
compatibility_date = "2023-12-01"
compatibility_flags = ['nodejs_compat']

[vars]
MY_VAR = "my-variable"

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "..."
database_id = "..."

import app from "../src/index"
import { env } from 'cloudflare:test'

describe('Collections', () => {
  test('POST /collections', async () => {
    console.log(env)
    const res = await app.request('/api/v1/collections', {
      method: "POST",
      body: JSON.stringify({
        name: "collection",
        status: "draft",
        icon: "icon",
        color: "red",
      })
    }, env)
    console.log(await res.json())
    // it should return a "{data: {...}, status: {...}}" object but returns an empty object
  })

  test('GET /collections', async () => {
    console.log(env)
    const res = await app.request('/api/v1/collections', {}, env)
    console.log(await res.json())
    // it should return an object {data: [...], status: {...}} where data has length = 3 but returns an empty object
  })
})