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











SourceForge.net 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.

 

Last edit by cxl on 04/12/2018. Do you want to contribute?. T++