Function TestExtractEdgeCases

pkg/gosqlx/coverage_test.go:216–552

TestExtractEdgeCases covers more extract paths for collectFromExpression coverage.

(t *testing.T)

// TestExtractEdgeCases covers more extract paths for collectFromExpression coverage.
func TestExtractEdgeCases(t *testing.T) {
	t.Run("columns from CASE", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT CASE WHEN status = 'active' THEN name ELSE email END FROM users")
		cols := ExtractColumns(r)
		if len(cols) == 0 {
			t.Error("expected columns")
		}
	})

	t.Run("columns from CAST", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT CAST(age AS TEXT) FROM users")
		cols := ExtractColumns(r)
		if len(cols) == 0 {
			t.Error("expected columns from CAST expression")
		}
	})

	t.Run("columns from IN", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT * FROM t WHERE status IN ('a', 'b', 'c')")
		cols := ExtractColumns(r)
		if len(cols) == 0 {
			t.Error("expected columns from IN expression")
		}
	})

	t.Run("columns from BETWEEN", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT * FROM t WHERE age BETWEEN min_age AND max_age")
		cols := ExtractColumns(r)
		if len(cols) == 0 {
			t.Error("expected columns from BETWEEN expression")
		}
	})

	t.Run("columns from unary NOT", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT * FROM t WHERE NOT active")
		cols := ExtractColumns(r)
		if len(cols) == 0 {
			t.Error("expected columns from NOT expression")
		}
	})

	t.Run("tables from UNION", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT * FROM t1 UNION SELECT * FROM t2")
		tables := ExtractTables(r)
		if len(tables) < 2 {
			t.Errorf("expected >= 2 tables, got %d", len(tables))
		}
	})

	t.Run("tables from subquery", func(t *testing.T) {
		r := mustParseHelper(t, "SELECT * FROM (SELECT * FROM inner_t) AS sub JOIN outer_t ON sub.id = outer_t.id")
		tables := ExtractTables(r)
		if len(tables) == 0 {
			t.Error("expected tables")
		}
	})

	t.Run("functions from nested calls", func(t *testing.T) {