Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "DTP SQL Query Builder Ganymede Project Plan"
(→SQL Query Builder) |
m |
||
| (18 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== SQL Query Builder == | == SQL Query Builder == | ||
| − | The SQL Query Builder Project Plan | + | The SQL Query Builder Project Plan is broken down into the following bugzilla enhancement requests. |
| − | + | ||
| − | + | ||
'''PRIORITY 1''' | '''PRIORITY 1''' | ||
| − | Migrate Project Properties to Preferences and SQL Properties, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202585 202585] | + | *Migrate Project Properties to Preferences and SQL Properties, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202585 202585]. |
| − | + | :''These properties enable/disable the inclusion of the current schema name in generated SQL.'' | |
| + | :Target: '''M3''' | ||
| − | Make SQL Builder database and sql dialect Neutral, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202586 202586] | + | *Make SQL Query Builder database and sql dialect Neutral, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202586 202586]. |
| − | + | :Target: '''M3''' | |
| − | Componentization, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202587 202587] | + | *Componentization, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202587 202587]. |
| − | + | :- ''Rather than loading a file containing a SQL statement and a Connection Profile, the SQL statement and Connection Profile will be passed to/from the SQL Query Builder through an API.'' | |
| + | :- ''Make the SQL Query Builder a component which can be invoked through an API.'' | ||
| + | :- ''Allow the SQL Query Builder to run in a dialog.'' | ||
| + | :Target: '''M3''' | ||
| − | + | *Integration with DTP SQLScrapbook, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202591 202591]. | |
| − | + | :''Allow SQLScrapbook to invoke the SQL Query Builder.'' | |
| + | :Target: '''M4''' | ||
| − | + | *SQL Support: Variables, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202600 202600]. | |
| − | + | :''Includes support for variables and parameter markers.'' | |
| + | :Target: '''M5''' | ||
| + | |||
| + | *Improved look and feel, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202589 202589]. | ||
| + | :''Improve the layout of the SQL Query Builder's panes, making them customizable.'' | ||
| + | :''This task will be viewed as a development pressure and will be ongoing throughout the period M3 - M6.'' | ||
| + | :Target: '''M6''' | ||
| − | + | *Improve Core UI, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202596 202596]. | |
| − | + | :''Usability enhancements to the UI.'' | |
| + | :Target: post Ganymede. Parts of this have been done for M5. | ||
| − | + | *SQL Support: Comment Handling, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202602 202602]. | |
| − | + | :''Support comments preceding or inside SQL statements.'' | |
| + | :Target: post Ganymede | ||
| − | DTP Enablement: | + | *DTP Enablement: SQL Dialect Support / Extensibility, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202592 202592]. |
| − | + | :''Define enablement framework to support SQL dialect variations.'' | |
| + | :Target: post Ganymede | ||
| − | DTP Enablement: Enablement for exemplary database, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202594 202594] | + | *DTP Enablement: User-Interface Enablement, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202593 202593]. |
| − | + | :''Define enablement framework for UI'' | |
| + | :Target: post Ganymede | ||
| + | |||
| + | *DTP Enablement: Enablement for exemplary database, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202594 202594]. | ||
| + | :''Enable the SQL Query Builder for an exemplary database, probably Apache Derby.'' | ||
| + | :Target: post Ganymede | ||
| − | |||
'''PRIORITY 2''' | '''PRIORITY 2''' | ||
| − | + | *Easy Access to Database objects, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202597 202597]. | |
| − | + | :''Enhanced support for accessing database objects.'' | |
| + | :Target: post Ganymede | ||
| − | + | *Properties Pane, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202598 202598]. | |
| − | + | :''Re-work the bottom pane of the SQL Query Builder's UI, where detailed parts of SQL Queries are defined.'' | |
| − | + | :Target: post Ganymede | |
| − | + | ||
| − | + | *Integration with DTP SQLEditor, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202590 202590]. | |
| − | + | :''Make the SQL Query Builder use the DTP SQLEditor's editing control, rather than its own control.'' | |
| − | SQL Support: | + | :Target: post Ganymede |
| − | + | ||
| + | *DTP Enablement: Variables Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=216556 216556]. | ||
| + | :''The enablement framework part of support for variables'' | ||
| + | :Target: post Ganymede | ||
| + | |||
| + | *SQL Support: Quoted Identifiers, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202601 202601]. | ||
| + | :''Support quoted and unquoted identifiers.'' | ||
| + | :Target: post Ganymede | ||
| − | SQL Support: | + | *SQL Support: Qualified and Unqualified Names, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202603 202603]. |
| − | + | :''Support qualified and unqualified names.'' | |
| + | :Target: post Ganymede | ||
| − | SQL Support: | + | *SQL Support: SQL Execution, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202604 202604]. |
| − | + | :''Enhance ability to execute SQL queries from SQL Query Builder.'' | |
| + | :Target: post Ganymede | ||
| − | SQL Support: | + | *SQL Support: Subquery Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202605 202605]. |
| − | + | :''The SQL Query Builder currently has very limited support for subqueries. This will be enhanced.'' | |
| + | :Target: post Ganymede | ||
| − | SQL Support: | + | *SQL Support: UNION, INTERSECT, EXCEPT, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202606 202606]. |
| − | + | :''Improve support for UNION, INTERSECT, EXCEPT.'' | |
| − | + | :Target: post Ganymede | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
'''PRIORITY 3''' | '''PRIORITY 3''' | ||
| − | Type mismatch detection, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202607 202607] | + | *Type mismatch detection, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202607 202607]. |
| − | + | :''Detect type mismatches and suggest type conversions where possible.'' | |
| + | :Target: post Ganymede | ||
| − | SQL Validation, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202608 202608] | + | *SQL Validation, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202608 202608]. |
| − | + | :''Apply SQL validation constraints.'' | |
| + | :Target: post Ganymede | ||
| − | Improve Expression and Condition Builder UI, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202609 202609] | + | *Improve Expression and Condition Builder UI, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202609 202609]. |
| − | + | :''Rewrite the expression and condition builder to make them more user friendly.'' | |
| + | :Target: post Ganymede | ||
| − | Undo and redo Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202610 ] | + | *Undo and redo Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202610 202610]. |
| − | + | :''Add undo and redo editing support.'' | |
| + | :Target: post Ganymede | ||
| + | |||
| + | '''Milestone Dates for Ganymede''' | ||
| − | + | :M2: 09/26/07 | |
| + | :M3: 11/07/07 | ||
| + | :M4: 12/19/07 | ||
| + | :M5: 02/13/08 | ||
| + | :M6: Est 03/26/08 | ||
| + | :M7: Est 05/07/08 | ||
Latest revision as of 10:24, 28 February 2008
← Back to DTP SQLDevTools Ganymede Project Plan
SQL Query Builder
The SQL Query Builder Project Plan is broken down into the following bugzilla enhancement requests.
PRIORITY 1
- Migrate Project Properties to Preferences and SQL Properties, 202585.
- These properties enable/disable the inclusion of the current schema name in generated SQL.
- Target: M3
- Make SQL Query Builder database and sql dialect Neutral, 202586.
- Target: M3
- Componentization, 202587.
- - Rather than loading a file containing a SQL statement and a Connection Profile, the SQL statement and Connection Profile will be passed to/from the SQL Query Builder through an API.
- - Make the SQL Query Builder a component which can be invoked through an API.
- - Allow the SQL Query Builder to run in a dialog.
- Target: M3
- Integration with DTP SQLScrapbook, 202591.
- Allow SQLScrapbook to invoke the SQL Query Builder.
- Target: M4
- SQL Support: Variables, 202600.
- Includes support for variables and parameter markers.
- Target: M5
- Improved look and feel, 202589.
- Improve the layout of the SQL Query Builder's panes, making them customizable.
- This task will be viewed as a development pressure and will be ongoing throughout the period M3 - M6.
- Target: M6
- Improve Core UI, 202596.
- Usability enhancements to the UI.
- Target: post Ganymede. Parts of this have been done for M5.
- SQL Support: Comment Handling, 202602.
- Support comments preceding or inside SQL statements.
- Target: post Ganymede
- DTP Enablement: SQL Dialect Support / Extensibility, 202592.
- Define enablement framework to support SQL dialect variations.
- Target: post Ganymede
- DTP Enablement: User-Interface Enablement, 202593.
- Define enablement framework for UI
- Target: post Ganymede
- DTP Enablement: Enablement for exemplary database, 202594.
- Enable the SQL Query Builder for an exemplary database, probably Apache Derby.
- Target: post Ganymede
PRIORITY 2
- Easy Access to Database objects, 202597.
- Enhanced support for accessing database objects.
- Target: post Ganymede
- Properties Pane, 202598.
- Re-work the bottom pane of the SQL Query Builder's UI, where detailed parts of SQL Queries are defined.
- Target: post Ganymede
- Integration with DTP SQLEditor, 202590.
- Make the SQL Query Builder use the DTP SQLEditor's editing control, rather than its own control.
- Target: post Ganymede
- DTP Enablement: Variables Support, 216556.
- The enablement framework part of support for variables
- Target: post Ganymede
- SQL Support: Quoted Identifiers, 202601.
- Support quoted and unquoted identifiers.
- Target: post Ganymede
- SQL Support: Qualified and Unqualified Names, 202603.
- Support qualified and unqualified names.
- Target: post Ganymede
- SQL Support: SQL Execution, 202604.
- Enhance ability to execute SQL queries from SQL Query Builder.
- Target: post Ganymede
- SQL Support: Subquery Support, 202605.
- The SQL Query Builder currently has very limited support for subqueries. This will be enhanced.
- Target: post Ganymede
- SQL Support: UNION, INTERSECT, EXCEPT, 202606.
- Improve support for UNION, INTERSECT, EXCEPT.
- Target: post Ganymede
PRIORITY 3
- Type mismatch detection, 202607.
- Detect type mismatches and suggest type conversions where possible.
- Target: post Ganymede
- SQL Validation, 202608.
- Apply SQL validation constraints.
- Target: post Ganymede
- Improve Expression and Condition Builder UI, 202609.
- Rewrite the expression and condition builder to make them more user friendly.
- Target: post Ganymede
- Undo and redo Support, 202610.
- Add undo and redo editing support.
- Target: post Ganymede
Milestone Dates for Ganymede
- M2: 09/26/07
- M3: 11/07/07
- M4: 12/19/07
- M5: 02/13/08
- M6: Est 03/26/08
- M7: Est 05/07/08