# Run all tests
make test

# Run with verbose output
go test -v ./...

# Run specific package
go test -v ./internal/api/handlers/...

# Run specific test
go test -v -run TestTableCreate ./tests/unit/...

tests/
├── unit/           # Unit tests
├── integration/    # Integration tests (require database)
├── contract/       # API contract tests
├── e2e/            # End-to-end tests
├── benchmark/      # Performance benchmarks
└── fixtures/       # Test data and SQL fixtures

# Run unit tests only
go test -v ./internal/...

# Start dependencies
make docker-up

# Run integration tests
make test-integration

//go:build integration

package integration

func TestDatabaseOperations(t *testing.T) {
    // ...
}

go test -v ./tests/contract/...

func TestFeature_Scenario_ExpectedBehavior(t *testing.T) {
    // Example: TestTableCreate_WithValidInput_ReturnsCreatedTable
}

func TestValidation(t *testing.T) {
    tests := []struct {
        name    string
        input   string
        wantErr bool
    }{
        {"valid input", "test", false},
        {"empty input", "", true},
    }

    for _, tt := range tests {
        t.Run(tt.name, func(t *testing.T) {
            err := Validate(tt.input)
            if (err != nil) != tt.wantErr {
                t.Errorf("Validate() error = %v, wantErr %v", err, tt.wantErr)
            }
        })
    }
}

tests/fixtures/
├── namespaces.sql
├── tables.sql
└── cleanup.sql

# Run all benchmarks
make bench

# Run specific benchmark
go test -bench=BenchmarkTable -benchmem ./tests/benchmark/...

# Compare before/after
go test -bench=. ./tests/benchmark/... | tee before.txt
# Make changes
go test -bench=. ./tests/benchmark/... | tee after.txt
benchstat before.txt after.txt

# Generate coverage report
go test -coverprofile=coverage.out ./...

# View in browser
go tool cover -html=coverage.out

# Check coverage percentage
go tool cover -func=coverage.out