Function TestTokenizeAlterStatement

go/sql/parser_test.go:97–134

(t *testing.T)

}

func TestTokenizeAlterStatement(t *testing.T) {
	parser := NewAlterTableParser()
	{
		alterStatement := "add column t int"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int"}, tokens)
	}
	{
		alterStatement := "add column t int, change column i int"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int", "change column i int"}, tokens)
	}
	{
		alterStatement := "add column t int, change column i int 'some comment'"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int", "change column i int 'some comment'"}, tokens)
	}
	{
		alterStatement := "add column t int, change column i int 'some comment, with comma'"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int", "change column i int 'some comment, with comma'"}, tokens)
	}
	{
		alterStatement := "add column t int, add column d decimal(10,2)"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int", "add column d decimal(10,2)"}, tokens)
	}
	{
		alterStatement := "add column t int, add column e enum('a','b','c')"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int", "add column e enum('a','b','c')"}, tokens)
	}
	{
		alterStatement := "add column t int(11), add column e enum('a','b','c')"
		tokens := parser.tokenizeAlterStatement(alterStatement)
		require.Equal(t, []string{"add column t int(11)", "add column e enum('a','b','c')"}, tokens)
	}
}

func TestSanitizeQuotesFromAlterStatement(t *testing.T) {
	parser := NewAlterTableParser()