Killing docker at the end

export const DatabaseTestLayer = Layer.unwrapEffect(
  Effect.gen(function* () {
    // const instance = yield* Effect.promise(() => createDockerPostgres())
    // yield* Effect.addFinalizer(() => Effect.promise(() => instance.stop()))
    const instanceBuilder = Effect.promise(() => createDockerPostgres())
    const instance = yield* Effect.acquireRelease(instanceBuilder, (instance) =>
      Effect.promise(() => instance.stop())
    )

    const db = drizzle(instance.connectionString, { schema })
    yield* Effect.promise(() =>
      migrate(db, {
        migrationsFolder: "packages/databases/src/main/migrations",
      })
    )

    return mainDatabaseLayer(Redacted.make(instance.connectionString), false)
  })
)

import { Effect, pipe } from "effect"
import { describe, expect, it } from "vitest"

import { DatabaseTestLayer, MainDatabase, sql } from "@unio/databases"

describe("saveFile", () => {
  it("should save a file", async () => {
    const result = await pipe(
      Effect.gen(function* () {
        const db = yield* MainDatabase
        const result = yield* db.execute((client) => client.execute(sql`SELECT NOW()`))
        return result
      }),
      Effect.provide(DatabaseTestLayer),
      Effect.scoped,
      Effect.runPromise
    )
    console.log(result)

    expect(result).toBeDefined()
  })
})