Skip to main content

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.

Jump to: navigation, search

Difference between revisions of "DTP SQL Query Builder Ganymede Project Plan"

(SQL Query Builder)
m
 
(7 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
*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: '''M3'''
+
:Target: '''M3'''
 
 
 
*Make SQL Query 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'''
+
: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 17: Line 17:
 
:- ''Make the SQL Query 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 Query Builder to run in a dialog.''
 
:- ''Allow the SQL Query Builder to run in a dialog.''
:Est: 17 days, Target: '''M3'''
+
:Target: '''M3'''
 
 
 
*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 Query Builder.''
 
:''Allow SQLScrapbook to invoke the SQL Query Builder.''
:Est: 7 days, Target: '''M4'''
+
: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: '''M5'''
+
:Target: '''M5'''
+
 
*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.''
+
:Est: 10 days, Target: '''M6'''
+
+
 
*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 Query Builder's panes, making them customizable.''
 
:''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 from M3 - M6.''
+
:''This task will be viewed as a development pressure and will be ongoing throughout the period M3 - M6.''
:Est: 15 days, Target: '''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].
 
*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: post Ganymede
+
:Target: post Ganymede
 
 
 
*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: post Ganymede
+
:Target: post Ganymede
 
 
 
*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: post Ganymede
+
:Target: post Ganymede
 
 
 
*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 Query Builder for an exemplary database, probably Apache Derby.''
 
:''Enable the SQL Query Builder for an exemplary database, probably Apache Derby.''
:Est: 10 days, Target: post Ganymede
+
:Target: post Ganymede
  
Total Estimate: 129 days / 26 weeks
 
  
 
'''PRIORITY 2'''
 
'''PRIORITY 2'''
  
*Improve Core UI, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202596  202596].
 
:''Usability enhancements to the UI.''
 
:Est: 20 days, Target: post Ganymede
 
 
 
*Easy Access to Database objects, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202597  202597].
 
*Easy Access to Database objects, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202597  202597].
 
:''Enhanced support for accessing database objects.''
 
:''Enhanced support for accessing database objects.''
:Est: 7 days, Target: post Ganymede
+
:Target: post Ganymede
 
 
 
*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 Query 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
+
: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.''
 +
: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].
 
*SQL Support: Quoted Identifiers, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202601  202601].
 
:''Support quoted and unquoted identifiers.''
 
:''Support quoted and unquoted identifiers.''
:Est: 5 days, Target: post Ganymede
+
:Target: post Ganymede
 
 
 
*SQL Support: Qualified and Unqualified Names, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202603  202603].
 
*SQL Support: Qualified and Unqualified Names, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202603  202603].
 
:''Support qualified and unqualified names.''
 
:''Support qualified and unqualified names.''
:Est: 5 days, Target: post Ganymede
+
:Target: post Ganymede
 
 
 
*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 Query Builder.''
 
:''Enhance ability to execute SQL queries from SQL Query Builder.''
:Est: 1 days, Target: post Ganymede
+
: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 Query 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
+
:Target: post Ganymede
 
 
 
*SQL Support: UNION, INTERSECT, EXCEPT, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202606  202606].
 
*SQL Support: UNION, INTERSECT, EXCEPT, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202606  202606].
 
:''Improve support for UNION, INTERSECT, EXCEPT.''
 
:''Improve support for UNION, INTERSECT, EXCEPT.''
:Est: 12 days, Target: post Ganymede
+
:Target: post Ganymede
 
+
Total Estimate: 85 days / 17 weeks
+
  
 
'''PRIORITY 3'''
 
'''PRIORITY 3'''
Line 94: Line 95:
 
*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.''
 
:''Detect type mismatches and suggest type conversions where possible.''
:Est: 10 days, Target: post Ganymede
+
: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.''
 
:''Apply SQL validation constraints.''
:Est: 13 days, Target: post Ganymede
+
: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.''
 
:''Rewrite the expression and condition builder to make them more user friendly.''
:Est: 60 days, Target: post Ganymede
+
:Target: post Ganymede
 
 
 
*Undo and redo Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202610  202610].
 
*Undo and redo Support, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202610  202610].
 
:''Add undo and redo editing support.''
 
:''Add undo and redo editing support.''
:Est: 15 days, Target: post Ganymede
+
:Target: post Ganymede
 +
 
 +
'''Milestone Dates for Ganymede'''
  
Total Estimate: 98 days / 20 weeks
+
: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
- 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
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
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
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

Back to the top