Macro version of DB migration for iffy

db_macro.nim

import db_sqlite
import strformat
import macros

type
    Migration = tuple[name:string, fn: proc(db:DbConn)]

macro sqlList(statements: static[openArray[string]]): untyped =
    result = newProc(params=[newEmptyNode(), newIdentDefs(ident("db"), ident("DbConn"))])

    var body = newStmtList()
    body.add(quote do:
      echo "inside proc"
    )

    for statement in statements:
      body.add(quote do:
        echo "statement : " & `statement`
        db.exec(sql`statement`)
      )

    result[6] = body

const migrations* = [
   (name: "initial", fn: sqlList([
        """CREATE TABLE foo (
            id INTEGER PRIMARY KEY
        )""",
   ])),
   (name: "second", fn: sqlList([
       """CREATE TABLE another (
           id INTEGER PRIMARY KEY
       )""",
   ])),
]

if isMainModule:
    let db = db_sqlite.open(":memory:", "", "", "")
    for migration in migrations:
      migration.fn(db)