Difference between revisions of "Mylyn/Incubator/Generic Industrial Connector"
|Line 56:||Line 56:|
Image:Mylyn_sql_1.png|Full Workbench showing all relevant structures
Image:Dbconfig.png|New Repository Wizard]]
Revision as of 10:36, 18 March 2008
This is a temp doc space for the generic SQL connector for mylyn.
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.
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
- in the list of TaskComments and - in the list of TaskAttachments.