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

import path from 'path'
import runMigrationSqlite from './../src/migration.js'
import getOrCreateSqlite from './../src/sqlite.js'

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

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

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