Method parseCommand

rel/parse_sql.go:670–703

First keyword was SET, USE

()

// First keyword was SET, USE
func (m *Sqlbridge) parseCommand() (*SqlCommand, error) {

	/*
		- SET CHARACTER SET utf8
		- SET NAMES utf8
	*/
	req := &SqlCommand{Columns: make(CommandColumns, 0)}
	req.kw = m.Next().T // USE, SET

	// USE `baseball`;
	if req.kw == lex.TokenUse {
		req.Identity = m.Next().V
		return req, nil
	}

	cur := m.Cur()
	peek := m.Peek()
	// Look for special cases for mysql weird SET syntax
	switch {
	case cur.T == lex.TokenIdentity && strings.ToLower(cur.V) == "names":
		//SET NAMES utf8
		m.Next() // consume NAMES
		col := &CommandColumn{Name: fmt.Sprintf("%s %s", cur.V, m.Next().V)}
		req.Columns = append(req.Columns, col)
		return req, nil
	case cur.T == lex.TokenIdentity && strings.ToLower(cur.V) == "character" && strings.ToLower(peek.V) == "set":
		m.Next() // consume character
		m.Next() // consume set
		col := &CommandColumn{Name: fmt.Sprintf("character set %s", m.Next().V)}
		req.Columns = append(req.Columns, col)
		return req, nil
	}
	return req, m.parseCommandColumns(req)
}

// First keyword was CREATE
func (m *Sqlbridge) parseCreate() (*SqlCreate, error) {