Method completion

backend/plugin/parser/mysql/completion.go:151–196

()

}

func (c *Completer) completion() ([]base.Candidate, error) {
	// Check if the caret is inside or at the start of a backtick-quoted identifier.
	// caretTokenIndex points to the first token at or after cursorByteOffset, so
	// the containing token (when the cursor is inside one) is at index-1.
	checkTokenQuoted := func(idx int) bool {
		if idx < 0 || idx >= len(c.tokens) {
			return false
		}
		tok := c.tokens[idx]
		return mysqlparser.IsIdentTokenType(tok.Type) && tok.Loc < len(c.sql) && c.sql[tok.Loc] == '`'
	}
	if checkTokenQuoted(c.caretTokenIndex) {
		c.caretTokenIsQuoted = true
	} else if c.caretTokenIndex > 0 {
		prev := c.tokens[c.caretTokenIndex-1]
		if prev.End >= c.cursorByteOffset && checkTokenQuoted(c.caretTokenIndex-1) {
			c.caretTokenIsQuoted = true
		}
	}

	caretIndex := c.caretTokenIndex
	if caretIndex > 0 && !isNoSeparatorRequired(c.tokens[caretIndex-1].Type) {
		caretIndex--
	}
	c.referencesStack = append([][]base.TableReference{{}}, c.referencesStack...)

	candidates := mysqlparser.Collect(c.sql, c.cursorByteOffset)

	if len(candidates.Rules) == 0 {
		if prefixTok, ok := c.prefixToken(); ok {
			candidates = mysqlparser.Collect(c.sql, prefixTok.Loc)
		}
	}

	for _, rc := range candidates.Rules {
		if rc.Rule == "columnref" {
			c.collectLeadingTableReferences(caretIndex)
			c.takeReferencesSnapshot()
			c.collectRemainingTableReferences()
			c.takeReferencesSnapshot()
			break
		}
	}

	return c.convertCandidates(candidates)
}

func (c *Completer) prefixToken() (mysqlparser.Token, bool) {
	idx := c.caretTokenIndex