Function TestVeryComplexQueryWithArrayColumns

tests/array_test.go:123–209

TODO: Fix: Does not work in MYSQL

(t *testing.T)

// TODO: Fix: Does not work in MYSQL
func TestVeryComplexQueryWithArrayColumns(t *testing.T) {
	skipCassandra(t, "array/collection columns are not seeded in the cassandra fixture")
	skipClickHouse(t, "array/collection columns are not seeded in the fixture")
	if dbType == "mssql" {
		t.Skip("skipping test for mssql (JSON virtual tables and deep nesting not yet supported)")
	}
	if dbType == "snowflake" {
		t.Skip("snowflake: VARIANT as JSON-virtual-table needs RelEmbedded/RenderFromEdge lateral-join compiler support (not yet implemented)")
	}
	if dbType == "bigquery" {
		t.Skip("bigquery: JSON virtual tables over arrays need RelEmbedded UNNEST lowering in the dialect/simulator")
	}

	gql := `query {
		products(
			# returns only 1 items
			limit: 1,
	
			# starts from item 10, commented out for now
			# offset: 10,
	
			# orders the response items by highest price
			order_by: { price: desc },
	
			# only items with an id >= 30 and < 30 are returned
			where: { id: { and: { greater_or_equals: 20, lt: 28 } } }) {
			id
			name
			price
			owner {
				full_name
				picture : avatar
				email
				category_counts(limit: 2, order_by: { category_id: asc }) {
					count
					category {
						name
					}
				}
			}
			category(limit: 2) {
				id
				name
			}
		}
	}`

	conf := newConfig(&core.Config{DBType: dbType, DisableAllowList: true})
	conf.Tables = append(conf.Tables, core.Table{
		Name:  "category_counts",
		Table: "users",
		Type:  "json",
		Columns: []core.Column{
			{Name: "category_id", Type: "int", ForeignKey: "categories.id"},
			{Name: "count", Type: "int"},
		},
	})
	// Append array column config to existing products table or add new