Method insertColumns

backend/plugin/parser/mysql/completion.go:270–312

(c *Completer, databases, tables map[string]bool)

}

func (m CompletionMap) insertColumns(c *Completer, databases, tables map[string]bool) {
	for database := range databases {
		if len(database) == 0 {
			for _, table := range c.cteTables {
				if tables[table.Table] {
					for _, column := range table.Columns {
						m.Insert(base.Candidate{
							Type: base.CandidateTypeColumn,
							Text: c.quotedIdentifierIfNeeded(column),
						})
					}
				}
			}
			continue
		}
		if _, exists := c.metadataCache[database]; !exists {
			_, metadata, err := c.getMetadata(c.ctx, c.instanceID, database)
			if err != nil || metadata == nil {
				continue
			}
			c.metadataCache[database] = metadata
		}

		for table := range tables {
			tableMeta := c.metadataCache[database].GetSchemaMetadata("").GetTable(table)
			if tableMeta == nil {
				continue
			}
			for _, column := range tableMeta.GetProto().GetColumns() {
				definition := fmt.Sprintf("%s | %s", table, column.Type)
				if !column.Nullable {
					definition += ", NOT NULL"
				}
				m.Insert(base.Candidate{
					Type:       base.CandidateTypeColumn,
					Text:       c.quotedIdentifierIfNeeded(column.Name),
					Definition: definition,
					Comment:    column.Comment,
				})
			}
		}
	}
}

func (m CompletionMap) insertAllColumns(c *Completer) {
	if _, exists := c.metadataCache[c.defaultDatabase]; !exists {