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"
m (→SQL Query Builder) |
m (→SQL Query Builder) |
||
| Line 13: | Line 13: | ||
:Est: 7 days, Target: '''M3''' | :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 Query Builder database and sql dialect Neutral, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202586 202586]. |
:Est: 5 days, Target: '''M3''' | :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]. | ||
| − | :- ''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.'' | + | :- ''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 Builder a component which can be invoked through an API.'' | + | :- ''Make the SQL Query Builder a component which can be invoked through an API.'' |
| − | :- ''Allow the SQL Builder to run in a dialog.'' | + | :- ''Allow the SQL Query Builder to run in a dialog.'' |
:Est: 17 days, Target: '''M3''' | :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 Query Builder's panes, making them customizable.'' |
:Est: 15 days, Target: '''M4''' | :Est: 15 days, Target: '''M4''' | ||
| Line 35: | Line 35: | ||
*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]. | ||
| − | :''Make the SQL Builder use the DTP SQLEditor's editing control, rather than its own control.'' | + | :''Make the SQL Query Builder use the DTP SQLEditor's editing control, rather than its own control.'' |
:Est: 10 days, Target: '''M5''' | :Est: 10 days, Target: '''M5''' | ||
*Integration with DTP SQLScrapbook, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202591 202591]. | *Integration with DTP SQLScrapbook, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202591 202591]. | ||
| − | :''Allow SQLScrapbook to invoke the SQL Builder.'' | + | :''Allow SQLScrapbook to invoke the SQL Query Builder.'' |
:Est: 7 days, Target: '''M5''' | :Est: 7 days, Target: '''M5''' | ||
| Line 51: | Line 51: | ||
*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 Query Builder for an exemplary database, probably Apache Derby.'' |
:Est: 10 days, Target: '''M6''' | :Est: 10 days, Target: '''M6''' | ||
| Line 67: | Line 67: | ||
*Properties Pane, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202598 202598]. | *Properties Pane, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202598 202598]. | ||
| − | :''Re-work the bottom pane of the SQL Builder's UI, where detailed parts of SQL Queries are defined.'' | + | :''Re-work the bottom pane of the SQL Query Builder's UI, where detailed parts of SQL Queries are defined.'' |
:Est: 15 days, Target: post Ganymede | :Est: 15 days, Target: post Ganymede | ||
| Line 79: | Line 79: | ||
*SQL Support: SQL Execution, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202604 202604]. | *SQL Support: SQL Execution, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202604 202604]. | ||
| − | :''Enhance ability to execute SQL queries from SQL Builder.'' | + | :''Enhance ability to execute SQL queries from SQL Query Builder.'' |
:Est: 1 days, Target: post Ganymede | :Est: 1 days, Target: post Ganymede | ||
*SQL Support: Subquery Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202605 202605]. | *SQL Support: Subquery Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202605 202605]. | ||
| − | :''The SQL Builder currently has very limited support for subqueries. This will be enhanced.'' | + | :''The SQL Query Builder currently has very limited support for subqueries. This will be enhanced.'' |
:Est: 20 days, Target: post Ganymede | :Est: 20 days, Target: post Ganymede | ||
Revision as of 11:40, 27 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.
Note that the milestones targeted for each feature are currently under review and may be revised.
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 Query 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 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.
- Est: 17 days, Target: M3
- Improved look and feel, 202589.
- Improve the layout of the SQL Query 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 Query 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 Query 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 Query 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 Query 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 Query Builder.
- Est: 1 days, Target: post Ganymede
- SQL Support: Subquery Support, 202605.
- The SQL Query 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