Function Test_SingleNode_DisallowedPragmas

system_test/single_node_test.go:226–288

(t *testing.T)

}

func Test_SingleNode_DisallowedPragmas(t *testing.T) {
	node := mustNewLeaderNode("node1")
	defer node.Deprovision()

	tests := []struct {
		stmt     string
		expected string
	}{
		{
			stmt:     `PRAGMA JOURNAL_MODE=DELETE`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
		{
			stmt:     `PRAGMA wal_autocheckpoint = 1000`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
		{
			stmt:     `PRAGMA wal_autocheckpoint = 1000`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
		{
			stmt:     `PRAGMA synchronous = NORMAL`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
		{
			stmt:     `  PRAGMA synchronous = NORMAL`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
		{
			stmt:     `PRAGMA      synchronous = NORMAL`,
			expected: `{"results":[],"error":"disallowed pragma"}`,
		},
	}

	for i, tt := range tests {
		var r string
		var err error

		r, err = node.Execute(tt.stmt)
		if err != nil {
			t.Fatalf(`test %d failed "%s": %s`, i, tt.stmt, err.Error())
		}
		if r != tt.expected {
			t.Fatalf(`test %d received wrong result "%s" got: %s exp: %s`, i, tt.stmt, r, tt.expected)
		}

		r, err = node.Query(tt.stmt)
		if err != nil {
			t.Fatalf(`test %d failed "%s": %s`, i, tt.stmt, err.Error())
		}
		if r != tt.expected {
			t.Fatalf(`test %d received wrong result "%s" got: %s exp: %s`, i, tt.stmt, r, tt.expected)
		}

		r, err = node.Request(tt.stmt)
		if err != nil {
			t.Fatalf(`test %d failed "%s": %s`, i, tt.stmt, err.Error())
		}