package engines

import (
	"database/sql"
	"log"

	"github.com/readysite/readysite/pkg/database"
	_ "github.com/tursodatabase/go-libsql"
)

// NewMemory creates a new in-memory database.
// Useful for testing and development.
// Data is lost when the connection is closed.
func NewMemory() *database.Database {
	db, err := sql.Open("libsql", ":memory:")
	if err != nil {
		log.Fatal("Failed to open database:", err)
	}

	// Must use single connection — each connection to :memory: gets its own
	// empty database, so multiple connections would lose data.
	db.SetMaxOpenConns(1)

	return &database.Database{DB: db}
}