Skip to main content
Jump to: navigation, search

Difference between revisions of "Mylyn/Incubator/Generic Industrial Connector"

(Plan)
(Generic Task Structure to map to any SQL DB)
Line 19: Line 19:
  
 
==Generic Task Structure to map to any SQL DB==
 
==Generic Task Structure to map to any SQL DB==
These are mainly the fields from AbstractTask
+
===These are mainly the fields from AbstractTask===
  
 
  - repositoryUrl
 
  - repositoryUrl
Line 32: Line 32:
 
  - notes
 
  - notes
  
Further more a generic Task can hold:
+
===Further more a generic Task can hold:===
  
 
  - a list of TaskComments and
 
  - a list of TaskComments and
Line 38: Line 38:
  
 
But how?
 
But how?
 +
 +
===Task Context===
 +
Blob containing the Task context
  
 
==Generic Query Structure to map to any SQL DB==
 
==Generic Query Structure to map to any SQL DB==

Revision as of 17:34, 18 March 2008

This work is funded by Remain Software and Industrial-TSI.

This is a temp doc space for the generic SQL connector for mylyn.

Temporary SVN

svn://bugs.industrial-tsi.com/mylyn_gsc

Members

Maarten Meijer
Wim Jongman

Plan

Initial Request: bug 184532 Discussion: bug 223048

Current work is done using Apache Ibatis so that all configuration can be stored in the ibatis xml configuration files.

Legal parameter sets for various fields can then be stored as pseudo queries.

Generic Task Structure to map to any SQL DB

These are mainly the fields from AbstractTask

- repositoryUrl
- taskId
- owner
- summary
- priority (as P1, P2, P3, P4 or P5)
- completed
- completionDate (null is not completed)
- creationDate
- dueDate
- notes

Further more a generic Task can hold:

- a list of TaskComments and
- a list of TaskAttachments.

But how?

Task Context

Blob containing the Task context

Generic Query Structure to map to any SQL DB

There will be a Query window allowing (full text) selection on:

- taskId : match a specific ID
- owner : match a known owner from a list
- summary : match a string in a description
- priority (as P1, P2, P3, P4 or P5) : match one or more priorities
- completed : match true or false
- completionDate (null is not completed)  : match before, after and null
- creationDate  : match before, after and null
- dueDate  : match before, after and null
- notes : match a string in a description

and possibly:

- in the list of TaskComments and
- in the list of TaskAttachments.


Screenshots

Back to the top