Function TestPostgresQueryFormat

testing/go/enginetest/query_converter_test.go:2037–2059

TestPostgresQueryFormat is a utility function to test how postgres parses and formats queries

(t *testing.T)

// TestPostgresQueryFormat is a utility function to test how postgres parses and formats queries
func TestPostgresQueryFormat(t *testing.T) {
	type test struct {
		input    string
		expected string
	}
	tests := []test{
		{
			input:    "CREATE TABLE foo (a INT primary key default nextval('myseq'))",
			expected: "CREATE TABLE foo (a INTEGER DEFAULT nextval('myseq') PRIMARY KEY)",
		},
	}

	for _, test := range tests {
		t.Run(test.input, func(t *testing.T) {
			s, err := parser.Parse(test.input)
			require.NoError(t, err)

			ctx := formatNodeWithUnqualifiedTableNames(s[0].AST)
			query := ctx.String()
			require.Equal(t, test.expected, query)
		})
	}
}

func TestConvertQuery(t *testing.T) {
	type test struct {