Handling Migrations with Drizzle and Effect/SQL for MySQL

import { MysqlDrizzle } from '@effect/sql-drizzle/Mysql'
import { beforeAll } from '@effect/vitest'
import { migrate } from 'drizzle-orm/mysql-proxy/migrator'
import { Console, Effect } from 'effect'
import { DatabaseTest } from './database-test'

beforeAll(async () => {
  await Effect.runPromise(
    Effect.gen(function* () {
      yield* Console.log('Running migrations...')
      const db = yield* MysqlDrizzle

      yield* Effect.promise(async () => {
        await migrate(
          db,
          async (queries) => {
            for (const query of queries) {
              await db.execute(query)
            }
          },
          {
            migrationsFolder: '../../database/migrations'
          }
        )
      })

       yield* Console.log('Migrations completed')
    }).pipe(Effect.provide(DatabaseTest))
  ).catch((error) => console.error(error))
})