Files
tasks/common/persistence/query_util_test.go
Alex ShtinandGitHub 8e8f1b0f7c Remove license header from every file (#7689)
## What changed?
<!-- Describe what has changed in this PR -->
Remove license header from every file. Because it is really hard to
follow in this PR here is the summary:
1. License header is removed from all `.go` and `.proto` files
:fireworks::fireworks:🎆.
2. `LICENSE` file in the root directory has only Temporal and Uber
copyrights.
3. 5 other `LICENSE` files added to the packages which have copyrights
different from Temporal and Uber: Datadog, Xargin, "Mat Ryer, Tyler
Bunnell and contributors".
4. `license_file` flag is removed from all code generation tools.
5. `copyright_file` flag is removed from `go:generate mockgen`
directive.
6. All copyright related targets are removed from `Makefile`.
7. Updated Temporal copyright year to 2025 everywhere.

## Why?
<!-- Tell your future self why have you made these changes -->
I double checked with legal department that it is not needed to have
license header in every file. One file per repo is enough. I put all
copyrights to the root `LICENSE` file and removed header from all other
files. Also updated tools and `Makefile`.
2025-05-01 18:50:21 -07:00

113 lines
3.0 KiB
Go

package persistence
import (
"bytes"
"io"
"testing"
"github.com/stretchr/testify/require"
"github.com/stretchr/testify/suite"
"go.temporal.io/server/common/log"
)
type (
queryUtilSuite struct {
suite.Suite
// override suite.Suite.Assertions with require.Assertions; this means that s.NotNil(nil) will stop the test,
// not merely log an error
*require.Assertions
logger log.Logger
}
)
func TestQueryUtilSuite(t *testing.T) {
s := new(queryUtilSuite)
suite.Run(t, s)
}
func (s *queryUtilSuite) SetupTest() {
s.logger = log.NewTestLogger()
// Have to define our overridden assertions in the test setup. If we did it earlier, s.T() will return nil
s.Assertions = require.New(s.T())
}
func (s *queryUtilSuite) TestLoadAndSplitQueryFromReaders() {
input := `
CREATE TABLE test (
id BIGINT not null,
col1 BIGINT, -- comment with unmatched parenthesis )
col2 VARCHAR(255),
PRIMARY KEY (id)
);
CREATE INDEX test_idx ON test (col1);
--begin
CREATE TRIGGER test_ai AFTER INSERT ON test
BEGIN
SELECT *, 'string with unmatched chars ")' FROM test;
--end
END;
-- trailing comment
`
statements, err := LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.NoError(err)
s.Equal(3, len(statements))
s.Equal(
`CREATE TABLE test (
id BIGINT not null,
col1 BIGINT,
col2 VARCHAR(255),
PRIMARY KEY (id)
);`,
statements[0],
)
s.Equal(`CREATE INDEX test_idx ON test (col1);`, statements[1])
// comments are removed, but the inner content is not trimmed
s.Equal(
`CREATE TRIGGER test_ai AFTER INSERT ON test
BEGIN
SELECT *, 'string with unmatched chars ")' FROM test;
END;`,
statements[2],
)
input = "CREATE TABLE test (;"
statements, err = LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.Error(err, "error reading contents: unmatched left parenthesis")
s.Nil(statements)
input = "CREATE TABLE test ());"
statements, err = LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.Error(err, "error reading contents: unmatched right parenthesis")
s.Nil(statements)
input = "begin"
statements, err = LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.Error(err, "error reading contents: unmatched `BEGIN` keyword")
s.Nil(statements)
input = "end"
statements, err = LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.Error(err, "error reading contents: unmatched `END` keyword")
s.Nil(statements)
input = "select ' from test;"
statements, err = LoadAndSplitQueryFromReaders([]io.Reader{bytes.NewBufferString(input)})
s.Error(err, "error reading contents: unmatched quotes")
s.Nil(statements)
}
func (s *queryUtilSuite) TestHasWordAt() {
s.True(hasWordAt("BEGIN", "BEGIN", 0))
s.True(hasWordAt(" BEGIN ", "BEGIN", 1))
s.True(hasWordAt(")BEGIN;", "BEGIN", 1))
s.False(hasWordAt("BEGIN", "BEGIN", 1))
s.False(hasWordAt("sBEGIN", "BEGIN", 1))
s.False(hasWordAt("BEGINs", "BEGIN", 0))
s.False(hasWordAt("7BEGIN", "BEGIN", 1))
s.False(hasWordAt("BEGIN7", "BEGIN", 0))
}