Method parseTableReferences

backend/plugin/parser/mysql/completion.go:926–956

(fromClause string)

}

func (c *Completer) parseTableReferences(fromClause string) {
	const prefix = "SELECT * "
	tokens := mysqlparser.Tokenize(fromClause)

	var selStmt *ast.SelectStmt
	var wrappedSQL string
	for end := len(tokens); end > 0; end-- {
		if end < len(tokens) {
			lastTok := tokens[end-1]
			wrappedSQL = prefix + fromClause[:lastTok.End]
		} else {
			wrappedSQL = prefix + fromClause
		}
		parsed, err := ParseMySQLOmni(wrappedSQL)
		if err != nil || parsed == nil || len(parsed.Items) == 0 {
			continue
		}
		sel, ok := parsed.Items[0].(*ast.SelectStmt)
		if ok && len(sel.From) > 0 {
			selStmt = sel
			break
		}
	}
	if selStmt == nil {
		return
	}

	for _, item := range selStmt.From {
		c.extractFromItem(item, wrappedSQL)
	}
}

func (c *Completer) parseInsertTableReferences(insertClause string) {
	tokens := mysqlparser.Tokenize(insertClause)