Function TestEquality

coderd/rbac/regosql/sqltypes/equality_test.go:12–129

(t *testing.T)

)

func TestEquality(t *testing.T) {
	t.Parallel()
	testCases := []struct {
		Name           string
		Equality       sqltypes.Node
		ExpectedSQL    string
		ExpectedErrors int
	}{
		{
			Name: "String=String",
			Equality: sqltypes.Equality(false,
				sqltypes.String("foo"),
				sqltypes.String("bar"),
			),
			ExpectedSQL: "'foo' = 'bar'",
		},
		{
			Name: "Number=Number",
			Equality: sqltypes.Equality(false,
				sqltypes.Number("", json.Number("5")),
				sqltypes.Number("", json.Number("22")),
			),
			ExpectedSQL: "5 = 22",
		},
		{
			Name: "Bool=Bool",
			Equality: sqltypes.Equality(false,
				sqltypes.Bool(true),
				sqltypes.Bool(false),
			),
			ExpectedSQL: "true = false",
		},
		{
			Name: "Bool=Equality",
			Equality: sqltypes.Equality(false,
				sqltypes.Bool(true),
				sqltypes.Equality(true,
					sqltypes.Equality(true,
						sqltypes.String("foo"),
						sqltypes.String("bar"),
					),
					sqltypes.Bool(false),
				),
			),
			ExpectedSQL: "true = (('foo' != 'bar') != false)",
		},
		{
			Name: "Equality=Equality",
			Equality: sqltypes.Equality(false,
				sqltypes.Equality(true,
					sqltypes.Bool(true),
					sqltypes.Bool(false),
				),
				sqltypes.Equality(false,
					sqltypes.String("foo"),
					sqltypes.String("foo"),
				),
			),