Auto-Suggestions for Inner-Joins - Githubissues

Gouravmoy / QueryGenerator

Generic Query Generator For ETL Projects

1 stars 0 forks source link

Auto-Suggestions for Inner-Joins #11

Open Gouravmoy opened 8 years ago

Gouravmoy commented 8 years ago

In the Inner Join UI, we have to do the following:

[ ] Auto suggestion of Join conditions of selected tables
[ ] Different colors for Primary Keys and Foreign Keys

Priority - Medium

Gouravmoy commented 8 years ago

For Reference Dynamically Building SQL Queries Using Metadata Tables and Macro Processing.pdf

Gouravmoy commented 8 years ago

autoSuggestJoins.txt

Gouravmoy commented 8 years ago

Deferred as of now

Gouravmoy commented 8 years ago

Gouravmoy commented 8 years ago

[x] 1st Check For Bridge Joins
[x] If not available in Bridge, the check for endpoints in both tables
[x] Assign Start and End Table
[ ] Start Recursion
Termination Conditions
- Terminate if we have End Table
- Terminate if count of foreign keys is zero

Gouravmoy commented 8 years ago

Completed for Bridge Tables and Dirrect Relation Tables. Moving to release 1.0.2 for Recursion Auto Suggestion of Inner Joins to be implemented for Case and Co-lace Tabs