package layoutownership

import (
	"context"
	"database/sql"
	"errors"
	"testing"

	"github.com/DATA-DOG/go-sqlmock"
)

func TestLoadSingleLivePageLayoutRowForObject_ReturnsNilOnNoRows(t *testing.T) {
	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	mock.ExpectQuery(`SELECT .*FROM .*_System_PageLayout.*LOWER\(`).
		WithArgs("Order").
		WillReturnError(sql.ErrNoRows)

	row, err := LoadSingleLivePageLayoutRowForObject(context.Background(), db, "Order")
	if err != nil {
		t.Fatalf("LoadSingleLivePageLayoutRowForObject() error = %v", err)
	}
	if row != nil {
		t.Fatalf("LoadSingleLivePageLayoutRowForObject() row = %+v, want nil", row)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}

func TestLoadSingleLivePageLayoutRowForObject_ReturnsRow(t *testing.T) {
	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	mock.ExpectQuery(`SELECT .*FROM .*_System_PageLayout.*LOWER\(`).
		WithArgs("Order").
		WillReturnRows(sqlmock.NewRows([]string{"Id", "Config", "Source", "IsCustomized", "IsDefault"}).
			AddRow("std_layout_Order", `{"objectApiName":"Order"}`, "curated", false, true))

	row, err := LoadSingleLivePageLayoutRowForObject(context.Background(), db, "Order")
	if err != nil {
		t.Fatalf("LoadSingleLivePageLayoutRowForObject() error = %v", err)
	}
	if row == nil {
		t.Fatal("LoadSingleLivePageLayoutRowForObject() row = nil, want populated row")
	}
	if row.ID != "std_layout_Order" || row.Source != "curated" || !row.IsDefault {
		t.Fatalf("LoadSingleLivePageLayoutRowForObject() row = %+v, want curated default Order row", row)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}

func TestLoadSingleLivePageLayoutRowForObject_PropagatesSQLError(t *testing.T) {
	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	mock.ExpectQuery(`SELECT .*FROM .*_System_PageLayout.*LOWER\(`).
		WithArgs("Order").
		WillReturnError(errors.New("db offline"))

	row, err := LoadSingleLivePageLayoutRowForObject(context.Background(), db, "Order")
	if err == nil {
		t.Fatal("LoadSingleLivePageLayoutRowForObject() error = nil, want db error")
	}
	if row != nil {
		t.Fatalf("LoadSingleLivePageLayoutRowForObject() row = %+v, want nil on error", row)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}