Function TestConvert

cel2sql_test.go:18–437

(t *testing.T)

)

func TestConvert(t *testing.T) {
	env, err := cel.NewEnv(
		cel.CustomTypeProvider(bq.NewTypeProvider(map[string]bigquery.Schema{
			"trigrams":  test.NewTrigramsTableMetadata().Schema,
			"wikipedia": test.NewWikipediaTableMetadata().Schema,
		})),
		sqltypes.SQLTypeDeclarations,
		cel.Declarations(
			decls.NewVar("name", decls.String),
			decls.NewVar("age", decls.Int),
			decls.NewVar("adult", decls.Bool),
			decls.NewVar("height", decls.Double),
			decls.NewVar("string_list", decls.NewListType(decls.String)),
			decls.NewVar("string_int_map", decls.NewMapType(decls.String, decls.Int)),
			decls.NewVar("null_var", decls.Null),
			decls.NewVar("birthday", sqltypes.Date),
			decls.NewVar("fixed_time", sqltypes.Time),
			decls.NewVar("scheduled_at", sqltypes.DateTime),
			decls.NewVar("created_at", decls.Timestamp),
			decls.NewVar("trigram", decls.NewObjectType("trigrams")),
			decls.NewVar("page", decls.NewObjectType("wikipedia")),
		),
	)
	require.NoError(t, err)
	type args struct {
		source string
	}
	tests := []struct {
		name    string
		args    args
		want    string
		wantErr bool
	}{
		{
			name:    "startsWith",
			args:    args{source: `name.startsWith("a")`},
			want:    "STARTS_WITH(`name`, \"a\")",
			wantErr: false,
		},
		{
			name:    "endsWith",
			args:    args{source: `name.endsWith("z")`},
			want:    "ENDS_WITH(`name`, \"z\")",
			wantErr: false,
		},
		{
			name:    "matches",
			args:    args{source: `name.matches("a+")`},
			want:    "REGEXP_CONTAINS(`name`, \"a+\")",
			wantErr: false,
		},
		{
			name:    "contains",
			args:    args{source: `name.contains("abc")`},
			want:    "INSTR(`name`, \"abc\") != 0",
			wantErr: false,
		},
		{