package postgres

import (
	"database/sql"
	"os"
	"testing"
)

func TestSpeciesModelListsSeededGlobalSpecies(t *testing.T) {
	dsn := os.Getenv("GARDOMATIC_TEST_DB_DSN")
	if dsn == "" {
		t.Skip("set GARDOMATIC_TEST_DB_DSN to run PostgreSQL integration tests")
	}

	db, err := sql.Open("postgres", dsn)
	if err != nil {
		t.Fatal(err)
	}
	t.Cleanup(func() { _ = db.Close() })
	if err := db.Ping(); err != nil {
		t.Fatalf("connect to PostgreSQL: %v", err)
	}

	species, err := (SpeciesModel{DB: db}).GetAllForGarden(2_147_483_647)
	if err != nil {
		t.Fatalf("list global species: %v", err)
	}

	for _, item := range species {
		if item.GardenID == nil && item.CommonName == "Tomate" {
			return
		}
	}
	t.Fatal("seeded global species Tomate was not returned")
}