import { test } from 'node:test'
import assert from 'node:assert/strict'

import path from 'path'
import { runMigrationSqlite, getOrCreateSqlite } from '@nano/sqlite'

test('migration', async () => {
    const db = getOrCreateSqlite({ 'uri': ':memory:', 'create': true, 'readwrite': true })
    await runMigrationSqlite(path.resolve(path.resolve(), './src/migration'), db)

    // check for boxes
    const results = db.prepare("SELECT name FROM sqlite_master WHERE type='table' AND name='sessions'").get()

    assert.equal(results.name, 'sessions')
})