package model

import (
	"database/sql"
	"fmt"
	"os"
	"path/filepath"
	"reflect"
	"testing"
)

func TestRecipeCrud(t *testing.T) {
	storagePath, err := os.MkdirTemp("", "ceres")
	if err != nil {
		fmt.Println("Error creating temporary directory:", err)
		return
	}
	t.Logf("Storage path: %v\n", storagePath)
	defer os.RemoveAll(storagePath)

	storage := NewStorage(storagePath)

	database, err := OpenDB(filepath.Join(storage.Path, "ceres.sqlite3"))
	if err != nil {
		t.Fatal(err)
	}
	defer func() {
		err := database.Close()
		if err != nil {
			t.Fatal(err)
		}
	}()

	err = database.Migrate()
	if err != nil {
		t.Fatal(err)
	}

	err = database.CreateExamples()
	if err != nil {
		t.Fatal(err)
	}

	err = database.Transaction(func(tx *sql.Tx) error {
		var original, readback, update, updated, deleted Recipe

		recipes := RecipeTestData()
		original = recipes[0]
		update = recipes[1]

		err = original.Create(tx)
		if err != nil {
			t.Fatalf("Failed to create test recipe in DB: %v\n", err)
		}

		readback.Id = original.Id
		err = readback.Read(tx)
		if err != nil {
			t.Fatalf("Failed to read test recipe from DB: %v\n", err)
		}

		if !reflect.DeepEqual(original, readback) {
			t.Fatalf("Recipes did not match after create / read cycle:\n"+
				"Before: %s\nAfter: %s\n", original, readback)
		}

		update.Id = original.Id

		err = update.Update(tx)
		if err != nil {
			t.Fatalf("Failed to update recipe: %v\n", err)
		}

		updated.Id = original.Id
		err = updated.Read(tx)
		if err != nil {
			t.Fatalf("Failed to read back updated recipe: %v\n", err)
		}

		if !reflect.DeepEqual(update, updated) {
			t.Fatalf("Recipes did not match after update / read cycle:\n"+
				"Update: %s\nUpdated: %s\n", update, updated)
		}

		if reflect.DeepEqual(updated, original) {
			t.Fatalf("Updated and original recipe match")
		}

		err = updated.Delete(tx)
		if err != nil {
			t.Fatalf("Failed to delete updated recipe: %v\n", err)
		}

		deleted.Id = updated.Id
		err = deleted.Read(tx)
		if err == nil {
			t.Fatalf("Was able to read back deleted recipe")
		}

		return nil
	})
	if err != nil {
		t.Fatalf("Failed to read recipes from database: %s", err)
	}
}