Method parseLimit

rel/parse_sql.go:1977–2018

(req *SqlSelect)

}

func (m *Sqlbridge) parseLimit(req *SqlSelect) error {
	if m.Cur().T != lex.TokenLimit {
		return nil
	}
	m.Next()
	if m.Cur().T != lex.TokenInteger {
		return m.ErrMsg("Limit must be an integer")
	}
	limval := m.Next()
	iv, err := strconv.Atoi(limval.V)
	if err != nil {
		return m.ErrMsg("Could not convert limit to integer")
	}
	req.Limit = int(iv)

	switch m.Cur().T {
	case lex.TokenComma:
		// LIMIT 0, 1000
		m.Next() // consume the comma
		if m.Cur().T != lex.TokenInteger {
			return m.ErrMsg("Limit 0, 1000 2nd number must be an integer")
		}
		iv, err = strconv.Atoi(m.Next().V)
		if err != nil {
			return m.ErrMsg("Could not convert limit to integer")
		}
		req.Offset = req.Limit
		req.Limit = iv
	case lex.TokenOffset:
		m.Next() // consume "OFFSET"
		if m.Cur().T != lex.TokenInteger {
			return m.ErrMsg("Offset must be an integer")
		}
		iv, err = strconv.Atoi(m.Cur().V)
		m.Next()
		if err != nil {
			return m.ErrMsg("Could not convert offset to integer")
		}
		req.Offset = iv
	}
	return nil
}
func (m *Sqlbridge) parseOffset(req *SqlSelect) error {
	if m.Cur().T != lex.TokenOffset {
		return nil