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) |
(→SQL Query Builder) |
||
| Line 10: | Line 10: | ||
*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.'' | :''These properties enable/disable the inclusion of the current schema name in generated SQL.'' | ||
| − | :Est: 7 days, Target: ''' | + | :Est: 7 days, Target: '''M3''' |
*Make SQL Builder database and sql dialect Neutral, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202586 202586]. | *Make SQL Builder database and sql dialect Neutral, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202586 202586]. | ||
| − | :Est: 5 days, Target: ''' | + | :Est: 5 days, 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]. | ||
| Line 19: | Line 19: | ||
:- ''Make the SQL Builder a component which can be invoked through an API.'' | :- ''Make the SQL Builder a component which can be invoked through an API.'' | ||
:- ''Allow the SQL Builder to run in a dialog.'' | :- ''Allow the SQL Builder to run in a dialog.'' | ||
| − | :Est: 17 days, Target: ''' | + | :Est: 17 days, Target: '''M3''' |
*Improved look and feel, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202589 202589]. | *Improved look and feel, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202589 202589]. | ||
:''Improve the layout of the SQL Builder's panes, making them customizable.'' | :''Improve the layout of the SQL Builder's panes, making them customizable.'' | ||
| − | :Est: 15 days, Target: ''' | + | :Est: 15 days, Target: '''M4''' |
*SQL Support: Variables, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202600 202600]. | *SQL Support: Variables, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202600 202600]. | ||
:''Includes support for variables and parameter markers.'' | :''Includes support for variables and parameter markers.'' | ||
| − | :Est: 5 days, Target: ''' | + | :Est: 5 days, Target: '''M4''' |
*SQL Support: Comment Handling, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202602 202602]. | *SQL Support: Comment Handling, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202602 202602]. | ||
:''Support comments preceding or inside SQL statements.'' | :''Support comments preceding or inside SQL statements.'' | ||
| − | :Est: 8 days, Target: ''' | + | :Est: 8 days, Target: '''M4''' |
*Integration with DTP SQLEditor, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202590 202590]. | *Integration with DTP SQLEditor, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202590 202590]. | ||
| Line 43: | Line 43: | ||
*DTP Enablement: SQL Dialect Support / Extensibility, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202592 202592]. | *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.'' | :''Define enablement framework to support SQL dialect variations.'' | ||
| − | :Est: 30 days, Target: ''' | + | :Est: 30 days, Target: '''M6''' |
*DTP Enablement: User-Interface Enablement, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202593 202593]. | *DTP Enablement: User-Interface Enablement, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202593 202593]. | ||
:''Define enablement framework for UI'' | :''Define enablement framework for UI'' | ||
| − | :Est: 15 days, Target: ''' | + | :Est: 15 days, Target: '''M6''' |
*DTP Enablement: Enablement for exemplary database, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202594 202594]. | *DTP Enablement: Enablement for exemplary database, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202594 202594]. | ||
:''Enable the SQL Builder for an exemplary database, probably Apache Derby.'' | :''Enable the SQL Builder for an exemplary database, probably Apache Derby.'' | ||
| − | :Est: 10 days, Target: ''' | + | :Est: 10 days, Target: '''M6''' |
Total Estimate: 129 days / 26 weeks | Total Estimate: 129 days / 26 weeks | ||
Revision as of 05:33, 20 September 2007
← 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.
- Est: 7 days, Target: M3
- Make SQL Builder database and sql dialect Neutral, 202586.
- Est: 5 days, 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 Builder through an API.
- - Make the SQL Builder a component which can be invoked through an API.
- - Allow the SQL Builder to run in a dialog.
- Est: 17 days, Target: M3
- Improved look and feel, 202589.
- Improve the layout of the SQL Builder's panes, making them customizable.
- Est: 15 days, Target: M4
- SQL Support: Variables, 202600.
- Includes support for variables and parameter markers.
- Est: 5 days, Target: M4
- SQL Support: Comment Handling, 202602.
- Support comments preceding or inside SQL statements.
- Est: 8 days, Target: M4
- Integration with DTP SQLEditor, 202590.
- Make the SQL Builder use the DTP SQLEditor's editing control, rather than its own control.
- Est: 10 days, Target: M5
- Integration with DTP SQLScrapbook, 202591.
- Allow SQLScrapbook to invoke the SQL Builder.
- Est: 7 days, Target: M5
- DTP Enablement: SQL Dialect Support / Extensibility, 202592.
- Define enablement framework to support SQL dialect variations.
- Est: 30 days, Target: M6
- DTP Enablement: User-Interface Enablement, 202593.
- Define enablement framework for UI
- Est: 15 days, Target: M6
- DTP Enablement: Enablement for exemplary database, 202594.
- Enable the SQL Builder for an exemplary database, probably Apache Derby.
- Est: 10 days, Target: M6
Total Estimate: 129 days / 26 weeks
PRIORITY 2
- Improve Core UI, 202596.
- Usability enhancements to the UI.
- Est: 20 days, Target: post Ganymede
- Easy Access to Database objects, 202597.
- Enhanced support for accessing database objects.
- Est: 7 days, Target: post Ganymede
- Properties Pane, 202598.
- Re-work the bottom pane of the SQL Builder's UI, where detailed parts of SQL Queries are defined.
- Est: 15 days, Target: post Ganymede
- SQL Support: Quoted Identifiers, 202601.
- Support quoted and unquoted identifiers.
- Est: 5 days, Target: post Ganymede
- SQL Support: Qualified and Unqualified Names, 202603.
- Support qualified and unqualified names.
- Est: 5 days, Target: post Ganymede
- SQL Support: SQL Execution, 202604.
- Enhance ability to execute SQL queries from SQL Builder.
- Est: 1 days, Target: post Ganymede
- SQL Support: Subquery Support, 202605.
- The SQL Builder currently has very limited support for subqueries. This will be enhanced.
- Est: 20 days, Target: post Ganymede
- SQL Support: UNION, INTERSECT, EXCEPT, 202606.
- Improve support for UNION, INTERSECT, EXCEPT.
- Est: 12 days, Target: post Ganymede
Total Estimate: 85 days / 17 weeks
PRIORITY 3
- Type mismatch detection, 202607.
- Detect type mismatches and suggest type conversions where possible.
- Est: 10 days, Target: post Ganymede
- SQL Validation, 202608.
- Apply SQL validation constraints.
- Est: 13 days, Target: post Ganymede
- Improve Expression and Condition Builder UI, 202609.
- Rewrite the expression and condition builder to make them more user friendly.
- Est: 60 days, Target: post Ganymede
- Undo and redo Support, 202610.
- Add undo and redo editing support.
- Est: 15 days, Target: post Ganymede
Total Estimate: 98 days / 20 weeks