Function TestCollectionSaveViewWrapping

core/collection_model_test.go:1574–1680

(t *testing.T)

}

func TestCollectionSaveViewWrapping(t *testing.T) {
	t.Parallel()

	viewName := "test_wrapping"

	// note: some of the queries use "limit 0" because the tested field value could be empty
	// which will trigger the extra sample records validation that are not important for this test
	scenarios := []struct {
		name     string
		query    string
		expected string
	}{
		{
			"no wrapping - id field",
			"select id, bool from demo1",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select id, bool from demo1)",
		},
		{
			"no wrapping - text field",
			"select text as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select text as id, bool from demo1 limit 0)",
		},
		{
			"no wrapping - relation field",
			"select rel_one as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select rel_one as id, bool from demo1 limit 0)",
		},
		{
			"no wrapping - select field",
			"select select_many as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select select_many as id, bool from demo1 limit 0)",
		},
		{
			"no wrapping - email field",
			"select email as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select email as id, bool from demo1 limit 0)",
		},
		{
			"no wrapping - datetime field",
			"select datetime as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select datetime as id, bool from demo1 limit 0)",
		},
		{
			"no wrapping - url field",
			"select url as id, bool from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (select url as id, bool from demo1 limit 0)",
		},
		{
			"wrapping - bool field",
			"select bool as id, text as txt, url from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (SELECT CAST(`id` as TEXT) `id`,`txt`,`url` FROM (select bool as id, text as txt, url from demo1 limit 0))",
		},
		{
			"wrapping - bool field (different order)",
			"select text as txt, url, bool as id from demo1 limit 0",
			"CREATE VIEW `test_wrapping` AS SELECT * FROM (SELECT `txt`,`url`,CAST(`id` as TEXT) `id` FROM (select text as txt, url, bool as id from demo1 limit 0))",
		},
		{