Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
UppHub
Status & Roadmap
FAQ
Authors & License
Forums
Funding U++
Search on this site











SourceForge.net Logo

SourceForge.net Logo

GitHub Logo

Discord Logo

Schema introspection

 

SqlBool FindSchJoin(const String& tables)

Finds a join condition based in REFERENCE attributes of .sch files for a list of tables tables separated by comma. Function runs two phases of matching foreign keys, in the first phase it performs a match based on the name too - the same named columns or foreign key is referenced_table + '_' + referenced_primary_key (e.g. PERSON_ID matches ID of table PERSON) are match. If no match is found in the first phase, in second phase, any correct foreign key matches. If there are more matching columns, first column in .sch definition is used.

 


 

Vector<StringGetSchTables()

Returns a list of all tables defined by .sch schema files.

 


 

ArrayMapString, Array<SchColumnInfo> > GetSchAll()

Returns the information of all .sch defined tables. Table names are map keys. SchColumnInfo contains name of column, the table it REFERENCES (if any) and the name of foreign key.

 


 

Vector<StringGetSchColumns(const String& table)

Returns all columns for table defined by .sch schema files.

 

Do you want to contribute?