-- Shared database helpers for the contact form
local M = {}

M.dbName = "_data/contact.db"

function M.ensureTable(mydb)
    local ok, err = mydb:exec[[
        CREATE TABLE IF NOT EXISTS messages (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT NOT NULL,
            email TEXT NOT NULL,
            message TEXT NOT NULL,
            created_at TEXT NOT NULL
        )
    ]]
    if not ok then
        return nil, err
    end
    return true, nil
end

function M.openDatabase()
    local mydb, err = db.open(M.dbName)
    if err then
        return nil, err
    end
    return mydb, nil
end

_M = M