Method parseSqlSelect

rel/parse_sql.go:170–278

First keyword was SELECT, so use the SELECT parser rule-set

()

// First keyword was SELECT, so use the SELECT parser rule-set
func (m *Sqlbridge) parseSqlSelect() (*SqlSelect, error) {

	req := NewSqlSelect()
	req.Raw = m.l.RawInput()
	m.Next() // Consume Select?

	// Optional DISTINCT keyword always immediately after SELECT KW
	if m.Cur().T == lex.TokenDistinct {
		m.Next()
		req.Distinct = true
	}

	// columns
	if err := parseColumns(m, m.funcs, req); err != nil {
		return nil, err
	}

	// select @@myvar limit 1
	if m.Cur().T == lex.TokenLimit {
		if err := m.parseLimit(req); err != nil {
			return nil, err
		}
		if m.isEnd() {
			return req, nil
		}
	}

	// SPECIAL END CASE for simple selects
	// SELECT last_insert_id();
	if m.Cur().T == lex.TokenEOS || m.Cur().T == lex.TokenEOF {
		// valid end
		return req, nil
	}

	// INTO
	discardComments(m)
	if err := m.parseInto(req); err != nil {
		return nil, err
	}

	// FROM
	discardComments(m)
	if err := m.parseSources(req); err != nil {
		return nil, err
	}

	// WHERE
	discardComments(m)
	if err := m.parseWhereSelect(req); err != nil {
		return nil, err
	}

	// GROUP BY
	discardComments(m)
	if err := m.parseGroupBy(req); err != nil {
		return nil, err
	}