local contact = require("contact._contact")

function GET(req)
    local mydb, err = contact.openDatabase()
    if err then
        return 500, {error = "Database error: " .. err}
    end

    contact.ensureTable(mydb)

    local messages, query_err = mydb:query(
        "SELECT id, name, email, message, created_at FROM messages ORDER BY id DESC LIMIT 50")

    if query_err then
        mydb:close()
        return 500, {error = "Query error: " .. query_err}
    end

    local countRow, _ = mydb:queryRow("SELECT COUNT(*) as total FROM messages")
    mydb:close()

    return 200, {messages = messages, total = countRow}
end

function DELETE(req)
    local id = tonumber(req.query.id)
    if not id then
        return 400, {error = "Missing or invalid message ID"}
    end

    local mydb, err = contact.openDatabase()
    if err then
        return 500, {error = "Database error: " .. err}
    end

    mydb:exec("DELETE FROM messages WHERE id = ?", id)
    mydb:close()

    return 200, {deleted = true, id = id}
end