Polypheny-DB Enhanced the auto-Completion

Summary

Add missing identifiers to the list of suggested names in the auto-completion provided in the SQL query console of the Polypheny-UI.

Fixes #43

ToDo

[x] Add Constraints
[x] Add Indexes
[x] Add Adapters
[x] Add QueryInterfaces

Mar 09 '24 03:03 alyaa999

Hi, @hennlo I need some help,plz Should I implement adapters and QueryInterface in a separate endpoint ?,

Mar 09 '24 04:03 alyaa999

Hi @alyaa999 What do you mean by 'in a sperate endpoint'?

Mar 10 '24 10:03 hennlo

Reference in new

@hennlo I mean that the getSchemaTree method retrieves objects situated under schemas, whereas adapters and the query interface are not part of the schema. Therefore, we should create a new method to specifically return adapters and the query interface, and then add it to the suggestion list in the editor component (Polypheny-UI) or return adapters and query interfaces with getSchemaTree method ??

Mar 10 '24 10:03 alyaa999

@alyaa999 Ah okay I get the question now, thanks for clarifying. Yes indeed a separate method(s) would be desirable since adapters and inetrfaces are not part of any schema 👍

Mar 10 '24 18:03 hennlo

I have a question related to the "getSchemaTree" method. This method accepts a parameter called "depth," and the user interface (UI) sends a request with a depth of 3, indicating schemas, tables, and columns. My question is whether I should adjust this depth to 5 or 4 to express constrains and indexes

Mar 12 '24 15:03 alyaa999