Function NewTrickyCompleter

backend/plugin/parser/pg/completion.go:120–145

(ctx context.Context, cCtx base.CompletionContext, statement string, caretLine int, caretOffset int)

}

func NewTrickyCompleter(ctx context.Context, cCtx base.CompletionContext, statement string, caretLine int, caretOffset int) *Completer {
	sql, byteOffset := computeSQLAndByteOffset(statement, caretLine, caretOffset, true /* tricky */)
	tokens := pgparser.Tokenize(sql)
	caretTokenIndex := findCaretTokenIndex(tokens, byteOffset)
	defaultSchema := cCtx.DefaultSchema
	schemaNotSelected := defaultSchema == ""
	if defaultSchema == "" {
		defaultSchema = "public"
	}
	return &Completer{
		ctx:               ctx,
		scene:             cCtx.Scene,
		sql:               sql,
		cursorByteOffset:  byteOffset,
		tokens:            tokens,
		caretTokenIndex:   caretTokenIndex,
		instanceID:        cCtx.InstanceID,
		defaultDatabase:   cCtx.DefaultDatabase,
		defaultSchema:     defaultSchema,
		schemaNotSelected: schemaNotSelected,
		getMetadata:       cCtx.Metadata,
		listDatabaseNames: cCtx.ListDatabaseNames,
		metadataCache:     make(map[string]*model.DatabaseMetadata),
		cteCache:          make(map[int][]*base.VirtualTableReference),
	}
}

func NewStandardCompleter(ctx context.Context, cCtx base.CompletionContext, statement string, caretLine int, caretOffset int) *Completer {
	sql, byteOffset := computeSQLAndByteOffset(statement, caretLine, caretOffset, false /* tricky */)