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"

m (SQL Query Builder)
(SQL Query Builder)
Line 3: Line 3:
 
== SQL Query Builder ==
 
== SQL Query Builder ==
 
The SQL Query Builder Project Plan is broken down into the following bugzilla enhancement requests.
 
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'''
 
'''PRIORITY 1'''
Line 24: Line 21:
 
*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.''
:Est: 15 days, Target: '''M4'''
+
:Est: 15 days, Target: '''M6'''
 
 
 
*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: '''M4'''
+
:Est: 5 days, Target: '''M6'''
+
*SQL Support: Comment Handling, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202602  202602].
+
:''Support comments preceding or inside SQL statements.''
+
: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].
 
:''Make the SQL Query 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: '''M6'''
 
 
 
*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: '''M5'''
+
:Est: 7 days, Target: '''M6'''
 
 
 +
*SQL Support: Comment Handling, [https://bugs.eclipse.org/bugs/show_bug.cgi?id=202602  202602].
 +
:''Support comments preceding or inside SQL statements.''
 +
:Est: 8 days, 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: '''M6'''
+
:Est: 30 days, 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: '''M6'''
+
:Est: 15 days, 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: '''M6'''
+
:Est: 10 days, Target: post Ganymede
  
 
Total Estimate: 129 days / 26 weeks
 
Total Estimate: 129 days / 26 weeks

Revision as of 11:23, 28 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 Query Builder database and sql dialect Neutral, 202586.
Est: 5 days, 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.
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: M6
  • SQL Support: Variables, 202600.
Includes support for variables and parameter markers.
Est: 5 days, Target: M6
  • 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: M6
  • Integration with DTP SQLScrapbook, 202591.
Allow SQLScrapbook to invoke the SQL Query Builder.
Est: 7 days, Target: M6
  • SQL Support: Comment Handling, 202602.
Support comments preceding or inside SQL statements.
Est: 8 days, Target: post Ganymede
  • DTP Enablement: SQL Dialect Support / Extensibility, 202592.
Define enablement framework to support SQL dialect variations.
Est: 30 days, Target: post Ganymede
  • DTP Enablement: User-Interface Enablement, 202593.
Define enablement framework for UI
Est: 15 days, Target: post Ganymede
  • DTP Enablement: Enablement for exemplary database, 202594.
Enable the SQL Query Builder for an exemplary database, probably Apache Derby.
Est: 10 days, Target: post Ganymede

Total Estimate: 129 days / 26 weeks

PRIORITY 2

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
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
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

Back to the top