/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/core/SBMClient.java |
---|
24,8 → 24,10 |
import java.net.URL; |
import java.util.ArrayList; |
import java.util.Date; |
import java.util.HashMap; |
import java.util.Iterator; |
import java.util.List; |
import java.util.Map; |
import java.util.StringTokenizer; |
import javax.xml.namespace.QName; |
63,6 → 65,7 |
private TaskRepository repository; |
private ObjectFactory of; |
private List<TableData> tables = new ArrayList<TableData>(); |
private Map<String, List<SBMFieldValue>> validsets = new HashMap<String, List<SBMFieldValue>>(); |
/** |
* Instantiates a new SBM client. |
102,9 → 105,13 |
return true; |
} |
public List<TTItem> getTTItemsByTable(String tablename, String sql_where) throws CoreException { |
return getTTItemsByTable(tablename, sql_where, false); |
} |
/** |
* Gets the SBM items from a table. The result size is limited to 500 and the sorting is done |
* by submit date descending. |
* by TS_ID descending. |
* |
* @param tablename the tablename |
* @param sql_where the sql_where |
111,8 → 118,10 |
* @return the tT items by table |
* @throws CoreException the core exception |
*/ |
public List<TTItem> getTTItemsByTable(String tablename, String sql_where) throws CoreException { |
public List<TTItem> getTTItemsByTable(String tablename, String sql_where, boolean getFullData) throws CoreException { |
List<TTItem> list = new ArrayList<TTItem>(); |
String sections = "SECTION:FIXED"; |
if(getFullData) sections = "SECTION:ALL"; |
if(sql_where==null || sql_where.isEmpty()) sql_where = "TS_ID>0"; |
try { |
list = port.getItemsByQueryWithName( |
119,16 → 128,35 |
getAuth(), |
tablename, |
"("+sql_where+")", |
"TS_SUBMITDATE desc", |
BigInteger.valueOf(500l), null); |
"TS_ID desc", |
null, |
sections); |
} catch (AEWebservicesFaultFault e) { |
new CoreException( |
throw new CoreException( |
RepositoryStatus.createInternalError( |
SBMConnectorPlugin.PLUGIN_ID, e.getFaultInfo(), e)); |
} |
SBMConnectorPlugin.PLUGIN_ID, e.getMessage(), e)); |
} |
return list; |
} |
public int getResultCount(String tablename, String sql) throws CoreException { |
List<TTItem> list = new ArrayList<TTItem>(); |
try { |
list = port.getItemsByQueryWithName( |
getAuth(), |
tablename, |
"("+sql+")", |
"TS_ID desc", |
null, |
"SECTION:NONE"); |
} catch (AEWebservicesFaultFault e) { |
throw new CoreException( |
RepositoryStatus.createInternalError( |
SBMConnectorPlugin.PLUGIN_ID, e.getMessage(), e)); |
} |
return list.size(); |
} |
/** |
* Gets a SBM item specified by its internal identifier ([tableid:recordid]) |
* |
136,6 → 164,11 |
* @return the tT item |
*/ |
public TTItem getTTItem(String itemid) { |
int pos1; |
int pos2; |
pos1 = itemid.lastIndexOf("[")+1; |
pos2 = itemid.lastIndexOf("]"); |
itemid = itemid.substring(pos1, pos2); |
TTItem item = of.createTTItem(); |
try { |
item = port.getItem(getAuth(), itemid, null); |
296,7 → 329,7 |
break; |
} |
} |
return "label_UNKNOWN"; |
return fieldname; //field has not been found |
} |
/** |
454,6 → 487,7 |
} |
public List<SBMFieldValue> getValidSet(String tablename, String fieldname) { |
if(validsets.containsKey(tablename+":"+fieldname)) return validsets.get(tablename+":"+fieldname); |
List<SBMFieldValue> list = new ArrayList<SBMFieldValue>(); |
List<TTItem> ttlist = new ArrayList<TTItem>(); |
String sql = "TS_ID in (select max(TS_ID) from "+tablename+" group by ts_"+fieldname+")"; |
467,7 → 501,7 |
for(TTItem ttitem : ttlist) { |
list.add(getFieldValue(ttitem, fieldname)); |
} |
validsets.put(tablename+":"+fieldname, list); |
return list; |
} |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/core/model/SBMSystemFields.java |
---|
0,0 → 1,120 |
/* |
* Mylyn Connector for Serena Business Mashups |
* Copyright 2010 Brian Rosenberger (Brutex Network) |
* |
* Licensed under the Apache License, Version 2.0 (the "License"); |
* you may not use this file except in compliance with the License. |
* You may obtain a copy of the License at |
* |
* http://www.apache.org/licenses/LICENSE-2.0 |
* |
* Unless required by applicable law or agreed to in writing, software |
* distributed under the License is distributed on an "AS IS" BASIS, |
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
* See the License for the specific language governing permissions and |
* limitations under the License. |
* |
* Serena, TeamTrack and Serena Business Mashup are |
* registered trademarks of SERENA Software Inc. |
*/ |
package net.brutex.mylyn.sbmconnector.core.model; |
/** |
* System DBFieldnames for SBM/ TeamTrack. |
* |
* @author Brian Rosenberger |
*/ |
public enum SBMSystemFields { |
/** The internal item id in [tableid:recordid] format. */ |
ID("ID", true), |
/** The internal uuid. */ |
UUID("UUID", false), |
/** Whether the item is active or inactive in its current state */ |
ACTIVEINACTIVE("ACTIVEINACTIVE", false), |
/** The date that the item was closed */ |
CLOSEDATE("CLOSEDATE", true), |
/** Used for Partner Access to CRs They Submit */ |
COMPANY("COMPANY", false), |
/** Used for Partner Access to CRs They Submit */ |
CONTACT("CONTACT", false), |
/** Detailed information about the item */ |
DESCRIPTION("DESCRIPTION", true), |
/** The displayed identifier of the item */ |
ISSUEID("ISSUEID", true), |
/** The type of the item */ |
ISSUETYPE("ISSUETYPE", true), |
/** The last time the item's data was changed */ |
LASTMODIFIEDDATE("LASTMODIFIEDDATE", true), |
/** The last person to change the data in this item */ |
LASTMODIFIER("LASTMODIFIER", true), |
/** The last time the state of this item was changed */ |
LASTSTATECHANGEDATE("LASTSTATECHANGEDATE", false), |
/** The last person to change the state of this item */ |
LASTSTATECHANGER("LASTSTATECHANGER", false), |
/** The primary person who currently owns the item */ |
OWNER("OWNER", false), |
/** The project in which this item resides */ |
PROJECTID("PROJECTID", false), |
/** Detailed information about the resolution */ |
RESOLUTIONDESC("RESOLUTIONDESC", false), |
/** Summary description of the resolution */ |
RESOLUTIONSUMMARY("RESOLUTIONSUMMARY", false), |
/** The secondary people who currently own the item */ |
SECONDARYOWNER("SECONDARYOWNER", false), |
/** The current state of the item */ |
STATE("STATE", true), |
/** The date that the item was created/submitted */ |
SUBMITDATE("SUBMITDATE", true), |
/** The person who created/submitted the item */ |
SUBMITTER("SUBMITTER", true), |
/** Summary description of the item */ |
TITLE("TITLE", true); |
private final String value; |
private final boolean hasTaskAttribute; |
SBMSystemFields(String v, boolean hasTaskAttribute) { |
value = v; |
this.hasTaskAttribute = hasTaskAttribute; |
} |
public String getValue() { |
return value; |
} |
public boolean hasTaskAttribute() { |
return this.hasTaskAttribute; |
} |
public static SBMSystemFields fromValue(String v) { |
for (SBMSystemFields c: SBMSystemFields.values()) { |
if (c.value.equals(v)) { |
return c; |
} |
} |
throw new IllegalArgumentException(v); |
} |
} |
Property changes: |
Added: svn:mime-type |
+text/plain |
\ No newline at end of property |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/core/SBMTicketAttribute.java |
---|
70,7 → 70,8 |
"label_submitter", |
SBMFieldTypes.USER, |
TaskAttribute.USER_REPORTER, |
TaskAttribute.TYPE_PERSON), |
TaskAttribute.TYPE_PERSON, |
SBMTicketAttribute.HIDDEN), //hidden because has extra part |
SUBMITDATE( |
SBMStaticFields.SUBMITDATE.getValue(), |
"label_submitdate", |
88,7 → 89,8 |
"label_modifieddate", |
SBMFieldTypes.DATETIME, |
TaskAttribute.DATE_MODIFICATION, |
TaskAttribute.TYPE_DATETIME), |
TaskAttribute.TYPE_DATETIME, |
SBMTicketAttribute.HIDDEN), //hidden because has extra part |
CLOSEDATE( |
SBMStaticFields.CLOSEDATE.getValue(), |
"label_closedate", |
183,4 → 185,13 |
} |
return null; |
} |
public static boolean hasSBMField(String fieldname) { |
for (SBMTicketAttribute attribute : values()) { |
if (attribute.getSBMName().equals(fieldname)) { |
return true; |
} |
} |
return false; |
} |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/core/SBMRepositoryConnector.java |
---|
26,6 → 26,8 |
import net.brutex.mylyn.sbmconnector.SBMConnectorPlugin; |
import net.brutex.mylyn.sbmconnector.core.model.SBMStaticFields; |
import net.brutex.mylyn.sbmconnector.ui.SBMRepositoryQueryPage; |
import net.brutex.mylyn.sbmconnector.ui.SBMRepositorySettingsPage; |
import net.brutex.sbm.wsclient.TTItem; |
import org.eclipse.core.runtime.CoreException; |
32,6 → 34,7 |
import org.eclipse.core.runtime.IProgressMonitor; |
import org.eclipse.core.runtime.IStatus; |
import org.eclipse.core.runtime.Status; |
import org.eclipse.core.runtime.jobs.Job; |
import org.eclipse.mylyn.tasks.core.AbstractRepositoryConnector; |
import org.eclipse.mylyn.tasks.core.IRepositoryQuery; |
import org.eclipse.mylyn.tasks.core.ITask; |
42,6 → 45,7 |
import org.eclipse.mylyn.tasks.core.data.TaskDataCollector; |
import org.eclipse.mylyn.tasks.core.data.TaskMapper; |
import org.eclipse.mylyn.tasks.core.sync.ISynchronizationSession; |
import org.eclipse.ui.statushandlers.StatusManager; |
public class SBMRepositoryConnector extends AbstractRepositoryConnector { |
75,7 → 79,7 |
public boolean canSynchronizeTask(TaskRepository taskRepository, ITask task) { |
return true; |
} |
@Override |
public String getConnectorKind() { |
return SBMConnectorPlugin.CONNECTOR_KIND; |
100,7 → 104,7 |
try { |
SBMClient client = getClient(taskRepository); |
TTItem item = client.getTTItem(taskId); |
data = datahandler.convert(taskRepository, item, monitor); |
data = datahandler.convert(taskRepository, item, monitor, null); |
} finally { |
monitor.done(); |
142,20 → 146,29 |
public IStatus performQuery(TaskRepository repository, |
IRepositoryQuery query, TaskDataCollector collector, |
ISynchronizationSession session, IProgressMonitor monitor) { |
monitor.subTask("Calculating query result size ..."); |
try { |
monitor.beginTask("Lade Daten", IProgressMonitor.UNKNOWN); |
SBMClient client = new SBMClient(repository); |
List<TTItem> list = client.getTTItemsByTable(query |
.getAttribute("table"), query.getAttribute("sql_where")); |
int countItem = client.getResultCount(getQueryTable(repository), |
query.getAttribute("sql_where")); |
monitor.beginTask("", countItem); |
monitor.subTask("Loading "+countItem+" items ..."); |
List<TTItem> list = client.getTTItemsByTable( |
getQueryTable(repository), query.getAttribute("sql_where"), |
true); |
monitor.worked(1); |
for (TTItem ttitem : list) { |
TaskData data = datahandler |
.convert(repository, ttitem, monitor); |
TaskData data = datahandler.convert(repository, ttitem, |
monitor, query); |
collector.accept(data); |
monitor.worked(1); |
if(monitor.isCanceled()) return Status.CANCEL_STATUS; |
} |
} catch (CoreException e) { |
return new Status(IStatus.ERROR, SBMConnectorPlugin.PLUGIN_ID, |
"Query fehlgeschlagen.", e); |
IStatus status = new Status(IStatus.ERROR, SBMConnectorPlugin.PLUGIN_ID, |
e.getMessage(), e); |
//StatusManager.getManager().handle(status, StatusManager.BLOCK); |
return status; |
} finally { |
monitor.done(); |
} |
179,7 → 192,7 |
public TaskMapper getTaskMapping(TaskData taskData) { |
return new TaskMapper(taskData); |
} |
@Override |
public AbstractTaskDataHandler getTaskDataHandler() { |
return datahandler; |
189,12 → 202,17 |
public boolean canDeleteTask(TaskRepository repository, ITask task) { |
return false; |
} |
@Override |
public boolean hasRepositoryDueDate(TaskRepository taskRepository, |
ITask task, TaskData taskData) { |
// TODO Auto-generated method stub |
return false; |
return false; |
} |
private String getQueryTable(TaskRepository repository) { |
return repository |
.getProperty(SBMRepositorySettingsPage.STRING_SOLUTIONTABLE); |
} |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/core/SBMTicketDataHandler.java |
---|
19,9 → 19,15 |
*/ |
package net.brutex.mylyn.sbmconnector.core; |
import java.util.Date; |
import java.util.GregorianCalendar; |
import java.util.List; |
import java.util.Set; |
import javax.xml.datatype.DatatypeConfigurationException; |
import javax.xml.datatype.DatatypeFactory; |
import javax.xml.datatype.XMLGregorianCalendar; |
import net.brutex.mylyn.sbmconnector.SBMConnectorPlugin; |
import net.brutex.mylyn.sbmconnector.core.model.SBMField; |
import net.brutex.mylyn.sbmconnector.core.model.SBMFieldAttributes; |
29,10 → 35,13 |
import net.brutex.mylyn.sbmconnector.core.model.SBMFieldValue; |
import net.brutex.mylyn.sbmconnector.core.model.SBMNote; |
import net.brutex.mylyn.sbmconnector.core.model.SBMStaticFields; |
import net.brutex.mylyn.sbmconnector.core.model.SBMSystemFields; |
import net.brutex.mylyn.sbmconnector.ui.SBMRepositorySettingsPage; |
import net.brutex.sbm.wsclient.TTItem; |
import org.eclipse.core.runtime.CoreException; |
import org.eclipse.core.runtime.IProgressMonitor; |
import org.eclipse.mylyn.tasks.core.IRepositoryQuery; |
import org.eclipse.mylyn.tasks.core.ITaskMapping; |
import org.eclipse.mylyn.tasks.core.RepositoryResponse; |
import org.eclipse.mylyn.tasks.core.TaskRepository; |
49,18 → 58,23 |
/** The connector. */ |
private final SBMRepositoryConnector connector; |
/** |
* Instantiates a new SBM ticket data handler. |
* |
* @param connector the connector |
* |
* @param connector |
* the connector |
*/ |
public SBMTicketDataHandler(SBMRepositoryConnector connector) { |
this.connector = connector; |
} |
/* (non-Javadoc) |
* @see org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#getAttributeMapper(org.eclipse.mylyn.tasks.core.TaskRepository) |
/* |
* (non-Javadoc) |
* |
* @see |
* org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#getAttributeMapper |
* (org.eclipse.mylyn.tasks.core.TaskRepository) |
*/ |
@Override |
public TaskAttributeMapper getAttributeMapper(TaskRepository taskRepository) { |
67,45 → 81,33 |
return new SBMTicketAttributeMapper(taskRepository); |
} |
/* (non-Javadoc) |
* @see org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#initializeTaskData(org.eclipse.mylyn.tasks.core.TaskRepository, org.eclipse.mylyn.tasks.core.data.TaskData, org.eclipse.mylyn.tasks.core.ITaskMapping, org.eclipse.core.runtime.IProgressMonitor) |
/* |
* (non-Javadoc) |
* |
* @see |
* org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#initializeTaskData |
* (org.eclipse.mylyn.tasks.core.TaskRepository, |
* org.eclipse.mylyn.tasks.core.data.TaskData, |
* org.eclipse.mylyn.tasks.core.ITaskMapping, |
* org.eclipse.core.runtime.IProgressMonitor) |
*/ |
@Override |
public boolean initializeTaskData(TaskRepository repository, TaskData taskData, |
ITaskMapping initializationData, IProgressMonitor monitor) |
throws CoreException { |
/*TaskAttribute attribute = taskData.getRoot().createAttribute(SBMStaticFields.TITLE); |
attribute.getMetaData().setReadOnly(false).setType(TaskAttribute.TYPE_SHORT_TEXT).setLabel("Summary:"); |
/*attribute = taskData.getRoot().createAttribute(SBMStaticFields.DESCRIPTION); |
attribute.getMetaData().setReadOnly(false).setType(TaskAttribute.TYPE_LONG_TEXT).setLabel("Description:"); |
attribute = taskData.getRoot().createAttribute(SBMStaticFields.SUBMITDATE); |
attribute.getMetaData().setReadOnly(false).setType(TaskAttribute.TYPE_DATETIME).setLabel("Create Date:"); |
if (!taskData.isNew()) { |
attribute = taskData.getRoot().createAttribute(TaskAttribute.TASK_URL); |
attribute.getMetaData().setReadOnly(true).setKind(TaskAttribute.KIND_DEFAULT).setType( |
TaskAttribute.TYPE_URL).setLabel("Location:"); |
File file = client.getTask(taskData.getTaskId(), monitor); |
try { |
attribute.setValue(file.toURI().toURL().toString()); |
} catch (MalformedURLException e) { |
} |
} |
attribute = taskData.getRoot().createAttribute(TaskAttribute.PRODUCT); |
attribute.getMetaData().setReadOnly(false).setKind(TaskAttribute.KIND_DEFAULT).setType( |
TaskAttribute.TYPE_SINGLE_SELECT).setLabel("Project"); |
*/ |
public boolean initializeTaskData(TaskRepository repository, |
TaskData taskData, ITaskMapping initializationData, |
IProgressMonitor monitor) throws CoreException { |
monitor.subTask("Initialising task ..."); |
taskData.setPartial(true); |
return true; |
} |
/* (non-Javadoc) |
* @see org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#postTaskData(org.eclipse.mylyn.tasks.core.TaskRepository, org.eclipse.mylyn.tasks.core.data.TaskData, java.util.Set, org.eclipse.core.runtime.IProgressMonitor) |
/* |
* (non-Javadoc) |
* |
* @see |
* org.eclipse.mylyn.tasks.core.data.AbstractTaskDataHandler#postTaskData |
* (org.eclipse.mylyn.tasks.core.TaskRepository, |
* org.eclipse.mylyn.tasks.core.data.TaskData, java.util.Set, |
* org.eclipse.core.runtime.IProgressMonitor) |
*/ |
@Override |
public RepositoryResponse postTaskData(TaskRepository repository, |
114,106 → 116,182 |
// TODO Auto-generated method stub |
return null; |
} |
/** |
* Convert. |
* |
* @param repository the repository |
* @param ttitem the ttitem |
* @param monitor the monitor |
* |
* @param repository |
* the repository |
* @param ttitem |
* the ttitem |
* @param monitor |
* the monitor |
* @return the task data |
* @throws CoreException the core exception |
* @throws CoreException |
* the core exception |
*/ |
public TaskData convert(TaskRepository repository, TTItem ttitem, IProgressMonitor monitor) |
throws CoreException { |
public TaskData convert(TaskRepository repository, TTItem ttitem, |
IProgressMonitor monitor, IRepositoryQuery query) |
throws CoreException { |
SBMClient client = SBMRepositoryConnector.getClient(repository); |
TaskData data = new TaskData(new SBMTicketAttributeMapper(repository), |
SBMConnectorPlugin.CONNECTOR_KIND, |
repository.getRepositoryUrl(), |
ttitem.getGenericItem().getValue().getItemName().getValue()+" ["+ |
ttitem.getGenericItem().getValue().getItemID().getValue()+"]"); |
SBMConnectorPlugin.CONNECTOR_KIND, repository |
.getRepositoryUrl(), ttitem.getGenericItem().getValue() |
.getItemName().getValue() |
+ " [" |
+ ttitem.getGenericItem().getValue().getItemID() |
.getValue() + "]"); |
initializeTaskData(repository, data, null, monitor); |
String fieldlist = ""; |
if (repository |
.hasProperty(SBMRepositorySettingsPage.STRING_TABLEFIELDLIST)) { |
fieldlist = repository |
.getProperty(SBMRepositorySettingsPage.STRING_TABLEFIELDLIST); |
} |
// Create Fields for all the generic SBM (system) fields |
for (SBMTicketAttribute f : SBMTicketAttribute.values()) { |
TaskAttribute attr; |
if(f.getTaskName()!=null) { |
monitor.subTask("Creating generic SBM fields..."); |
for (SBMSystemFields sysfield : SBMSystemFields.values()) { |
if(!sysfield.hasTaskAttribute()) { |
// skip the field here, because we do not have a |
// matching task attribute to map. The field |
// will be processed in the custom field section |
continue; |
} |
if (!fieldlist.contains("," + sysfield.getValue() + ",")) { |
// do not process custom field when it has not |
// been selected by user in repository settings page |
continue; |
} |
// try to initialize the SBM attribute |
SBMTicketAttribute f = null; |
TaskAttribute attr = null; |
try { |
f = SBMTicketAttribute.valueOf(sysfield.getValue()); |
} catch (IllegalArgumentException e) { |
// the field is a valid sbm system field and is set up to |
// have an equivalent in the task attributes. It must have an |
// entry in the SBMTicketAttribute class ! |
continue; // we just skip the field |
} |
if (f.getTaskName() != null) { |
attr = data.getRoot().createMappedAttribute(f.getTaskName()); |
} else { |
attr = data.getRoot().createAttribute(f.getSBMName()); |
// again the field is set up to have an task attribute |
// equivalent, but it is not set up in SBMAttributes correctly |
continue; |
} |
try { |
SBMStaticFields.valueOf(f.getSBMName()); //check if in static field list |
attr.getMetaData().setReadOnly(true); |
} catch (IllegalArgumentException e) { |
attr.getMetaData().setReadOnly(false); |
} |
attr.getMetaData().setType(f.getTaskType()); |
attr.getMetaData().setLabel(client.getFieldLabel(ttitem, f.getSBMName())); |
if(f.isVisible()) { |
attr.getMetaData().setReadOnly(true); //we do not support writing yet |
attr.getMetaData().setType(f.getTaskType()); // set the mapped field type |
attr.getMetaData().setLabel(client.getFieldLabel(ttitem, f.getSBMName())); // get and set the field label |
if (f.isVisible()) { |
// field is not hidden, display it by setting KIND_DEFAULT |
attr.getMetaData().setKind(TaskAttribute.KIND_DEFAULT); |
} else { |
// field is hidden |
attr.getMetaData().setKind(null); |
} |
/* |
if(f.getTaskType()==TaskAttribute.TYPE_SINGLE_SELECT) { |
List<SBMFieldValue> options = |
client.getValidSet(client.getTableName(ttitem), f.getSBMName()); |
for( SBMFieldValue optionvalue: options) { |
attr.putOption(optionvalue.getValue(), optionvalue.getValue()); |
} |
} |
*/ |
attr.setValue(client.getStaticFieldValue(ttitem, f.getSBMName())); |
attr.setValue(client.getStaticFieldValue(ttitem, f.getSBMName())); // get and set the field value |
} |
monitor.worked(1); |
//Custom fields |
List<SBMField> customfields = client.getFields(client.getTableName(ttitem)); |
for(SBMField f : customfields) { |
if(SBMTicketAttribute.getSBMAttributeBySBMName(f.getName())!=null) { |
//-------------- |
// Custom fields |
//-------------- |
List<SBMField> customfields = client.getFields(client |
.getTableName(ttitem)); |
for (SBMField f : customfields) { |
if (!fieldlist.contains("," + f.getName() + ",")) { |
// do not process custom field when it has not |
// been selected by user in repository settings page |
continue; |
} |
try { |
SBMSystemFields sysfield = SBMSystemFields.valueOf(f.getName()); |
if( sysfield.hasTaskAttribute()) { |
// the field has an equivalent in the task attribute |
// mappings and therefore it can be skipped in the custom |
// fields section |
continue; |
} |
} catch (IllegalArgumentException e) { |
//field is not a system field, do nothing |
} |
monitor.subTask("Read custom field [" + f.getName() + "]"); |
TaskAttribute custom = data.getRoot().createAttribute(f.getName()); |
custom.getMetaData().setType( |
new SBMTicketAttributeMapper(repository).mapToTaskKey(f.getType())); |
new SBMTicketAttributeMapper(repository).mapToTaskKey(f |
.getType())); |
custom.getMetaData().setLabel(f.getLabel()); |
custom.getMetaData().setKind(TaskAttribute.KIND_DEFAULT); |
custom.getMetaData().setReadOnly(false); |
if(f.getType()==SBMFieldTypes.SELECTION && |
client.getFieldValue(ttitem, f.getName())!=null) { |
List<SBMFieldValue> options = |
client.getValidSet(client.getTableName(ttitem), f.getName()); |
for( SBMFieldValue optionvalue: options) { |
custom.putOption(optionvalue.getInternalValue(), optionvalue.getValue()); |
custom.getMetaData().setReadOnly(true); |
//set value/ values depending on field type |
// single selection |
if (f.getType() == SBMFieldTypes.SELECTION |
&& client.getFieldValue(ttitem, f.getName()) != null) { |
List<SBMFieldValue> options = client.getValidSet(client |
.getTableName(ttitem), f.getName()); |
for (SBMFieldValue optionvalue : options) { |
custom.putOption(optionvalue.getInternalValue(), |
optionvalue.getValue()); |
} |
String val = client.getFieldValue(ttitem, f.getName()).getValue(); |
String val = client.getFieldValue(ttitem, f.getName()) |
.getValue(); |
custom.setValue(val); |
} else if(f.getType()==SBMFieldTypes.MULTIPLE_SELECTION |
|| f.getType()==SBMFieldTypes.MULTIPLE_RELATIONAL |
|| f.getType()==SBMFieldTypes.MULTIPLE_GROUP |
|| f.getType()==SBMFieldTypes.MULTIPLE_USERGROUP) { |
List<SBMFieldValue> values = client.getFieldValues(ttitem, f.getName()); |
for(SBMFieldValue val : values) { |
// Multi-Type fields |
} else if (f.getType() == SBMFieldTypes.MULTIPLE_SELECTION |
|| f.getType() == SBMFieldTypes.MULTIPLE_RELATIONAL |
|| f.getType() == SBMFieldTypes.MULTIPLE_GROUP |
|| f.getType() == SBMFieldTypes.MULTIPLE_USERGROUP) { |
List<SBMFieldValue> values = client.getFieldValues(ttitem, f |
.getName()); |
for (SBMFieldValue val : values) { |
custom.putOption(val.getInternalValue(), val.getValue()); |
custom.addValue(val.getValue()); |
} |
} else if(client.getFieldValue(ttitem, f.getName())!=null) { |
custom.setValue(client.getFieldValue(ttitem, f.getName()).getValue()); |
} |
//Date fields |
} else if (f.getType() == SBMFieldTypes.DATETIME) { |
String datestring = client.getFieldValue(ttitem, f.getName()).getValue(); |
long timestamp; |
try { |
timestamp = DatatypeFactory.newInstance().newXMLGregorianCalendar(datestring).toGregorianCalendar().getTimeInMillis(); |
custom.setValue(String.valueOf(timestamp)); |
} catch (DatatypeConfigurationException e) { |
// TODO Auto-generated catch block |
e.printStackTrace(); |
} catch (IllegalArgumentException e) { |
//date field is probably empty |
custom.setValue(""); |
} |
// any other field type |
} else if (client.getFieldValue(ttitem, f.getName()) != null) { |
custom.setValue(client.getFieldValue(ttitem, f.getName()) |
.getValue()); |
} |
} |
//Notes |
for(SBMNote n : client.getNotes(ttitem)) { |
monitor.worked(1); |
// ---------- |
// Notes |
// ---------- |
monitor.subTask("Read notes."); |
for (SBMNote n : client.getNotes(ttitem)) { |
TaskCommentMapper mapper = new TaskCommentMapper(); |
mapper.setCommentId(n.getId()); |
mapper.setNumber(Integer.valueOf(n.getId())); |
mapper.setText(n.getText()); |
mapper.setCreationDate(n.getCreation()); |
TaskAttribute a = data.getRoot().createAttribute("NOTE"+n.getId()); |
TaskAttribute a = data.getRoot() |
.createAttribute("NOTE" + n.getId()); |
mapper.applyTo(a); |
} |
monitor.worked(1); |
data.setPartial(false); |
return data; |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/SBMConnectorPlugin.java |
---|
23,21 → 23,31 |
import org.eclipse.core.runtime.Plugin; |
/** |
* The Class SBMConnectorPlugin provides the Mylyn connector for Serena Business Mashups 2009 |
* SBM2009) plugin. |
* The Class SBMConnectorPlugin provides the Mylyn connector for Serena Business |
* Mashups 2009 SBM2009) plugin. |
*/ |
public class SBMConnectorPlugin extends Plugin { |
private static SBMConnectorPlugin INSTANCE; |
/** Short SBM version string/ technical identifier. */ |
public final static String CONNECTOR_KIND = "SBM2009R2.00"; |
/** Full SBM name and version. */ |
public final static String DESCRIPTION = "Serena Business Mashups 2009 R2"; |
/** SBM name without version information */ |
public final static String LABEL = "Serena Business Mashups"; |
/** Full, descriptive identifier of this plugin. */ |
public final static String PLUGIN_ID = "Brutex Network - Mylyn Connector for SBM"; |
public SBMConnectorPlugin() { |
super(); |
INSTANCE = this; |
} |
public static SBMConnectorPlugin getDefault() { |
return INSTANCE; |
} |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/ui/SBMRepositorySettingsPage.java |
---|
19,30 → 19,170 |
*/ |
package net.brutex.mylyn.sbmconnector.ui; |
import java.util.List; |
import net.brutex.mylyn.sbmconnector.SBMConnectorPlugin; |
import net.brutex.mylyn.sbmconnector.core.SBMClient; |
import net.brutex.mylyn.sbmconnector.core.SBMRepositoryConnector; |
import net.brutex.mylyn.sbmconnector.core.model.SBMField; |
import net.brutex.mylyn.sbmconnector.core.model.SBMSystemFields; |
import org.eclipse.core.runtime.CoreException; |
import org.eclipse.core.runtime.IProgressMonitor; |
import org.eclipse.jface.dialogs.IMessageProvider; |
import org.eclipse.mylyn.tasks.core.TaskRepository; |
import org.eclipse.mylyn.tasks.ui.wizards.AbstractRepositorySettingsPage; |
import org.eclipse.swt.SWT; |
import org.eclipse.swt.events.ModifyEvent; |
import org.eclipse.swt.events.ModifyListener; |
import org.eclipse.swt.layout.GridData; |
import org.eclipse.swt.layout.GridLayout; |
import org.eclipse.swt.widgets.Combo; |
import org.eclipse.swt.widgets.Composite; |
import org.eclipse.swt.widgets.Event; |
import org.eclipse.swt.widgets.Label; |
import org.eclipse.swt.widgets.Listener; |
import org.eclipse.swt.widgets.Table; |
import org.eclipse.swt.widgets.TableColumn; |
import org.eclipse.swt.widgets.TableItem; |
import org.eclipse.ui.forms.widgets.ExpandableComposite; |
import org.eclipse.ui.forms.widgets.FormToolkit; |
public class SBMRepositorySettingsPage extends AbstractRepositorySettingsPage { |
private Combo table; |
private Table list; |
private String solutionTable = ""; |
private String solutionTableList = ""; |
private String tableFieldList = ""; |
private String tableFullFieldList = ""; |
public static final String STRING_SOLUTIONTABLE = "solutionTable"; |
public static final String STRING_SOLUTIONTABLELIST = "solutionTableList"; |
public static final String STRING_TABLEFIELDLIST = "tableFieldList"; |
public static final String STRING_TABLEFULLFIELDLIST = "tableFullFieldList"; |
public SBMRepositorySettingsPage(String title, String description, |
TaskRepository taskRepository) { |
super(title, description, taskRepository); |
// TODO Auto-generated constructor stub |
setNeedsAdvanced(false); |
setNeedsValidation(true); |
setNeedsEncoding(false); |
// initialize table and table list if not null |
if (taskRepository.hasProperty(STRING_SOLUTIONTABLE)) { |
this.solutionTable = taskRepository |
.getProperty(STRING_SOLUTIONTABLE); |
} |
if (taskRepository.hasProperty(STRING_SOLUTIONTABLELIST)) { |
this.solutionTableList = taskRepository |
.getProperty(STRING_SOLUTIONTABLELIST); |
} |
if (taskRepository.hasProperty(STRING_TABLEFIELDLIST)) { |
this.tableFieldList = taskRepository |
.getProperty(STRING_TABLEFIELDLIST); |
} |
if (taskRepository.hasProperty(STRING_TABLEFULLFIELDLIST)) { |
this.tableFullFieldList = taskRepository |
.getProperty(STRING_TABLEFULLFIELDLIST); |
} |
} |
@Override |
protected void createAdditionalControls(Composite parent) { |
// TODO Auto-generated method stub |
public void applyTo(TaskRepository repository) { |
super.applyTo(repository); |
if (!solutionTable.isEmpty()) { |
repository.setProperty(STRING_SOLUTIONTABLE, solutionTable); |
repository.setProperty(STRING_SOLUTIONTABLELIST, solutionTableList); |
String fieldlist = ","; |
String fullfieldlist = ","; |
for (TableItem t : list.getItems()) { |
if (t.getChecked()) |
fieldlist = fieldlist + t.getText(2) + ","; |
fullfieldlist = fullfieldlist + t.getText(2) + ","; |
} |
repository.setProperty(STRING_TABLEFIELDLIST, fieldlist); |
repository.setProperty(STRING_TABLEFULLFIELDLIST, fullfieldlist); |
} |
} |
@Override |
public boolean isPageComplete() { |
if (table != null && table.getText().length() > 4) { |
return super.isPageComplete(); |
} |
return false; |
} |
@Override |
protected void createContributionControls(Composite parentControl) { |
ExpandableComposite expander = createSection(parentControl, |
"Mashup application"); |
FormToolkit toolkit = new FormToolkit(parentControl.getDisplay()); |
Composite control = toolkit.createComposite(expander, SWT.NONE); |
GridLayout gridLayout = new GridLayout(); |
gridLayout.numColumns = 2; |
gridLayout.verticalSpacing = 5; |
gridLayout.marginWidth = 0; |
control.setLayout(gridLayout); |
control.setBackground(parentControl.getBackground()); |
Label label = new Label(control, SWT.NONE); |
label.setText("Table:"); |
table = new Combo(control, SWT.SINGLE | SWT.BORDER); |
Label label_list = new Label(control, SWT.NONE | SWT.TOP); |
label_list.setText("Fields:"); |
list = new Table(control, SWT.MULTI | SWT.BORDER | SWT.V_SCROLL |
| SWT.H_SCROLL | SWT.FULL_SELECTION | SWT.CHECK); |
list.setLinesVisible(true); |
list.setHeaderVisible(true); |
GridData data = new GridData(SWT.FILL, SWT.FILL, true, true); |
data.heightHint = 200; |
list.setLayoutData(data); |
String[] titles = { " ", "Display Name", "DBName", "Type" }; |
for (int i = 0; i < titles.length; i++) { |
TableColumn column = new TableColumn(list, SWT.NONE); |
column.setText(titles[i]); |
} |
list.addListener(SWT.Selection, new Listener() { |
@Override |
public void handleEvent(Event event) { |
//avoid that a system field may be unchecked |
try { |
SBMSystemFields |
.valueOf(((TableItem) event.item).getText(2)); |
((TableItem) event.item).setChecked(true); |
} catch (IllegalArgumentException e) { |
// do nothing |
} |
} |
}); |
table.addListener(SWT.Selection, new Listener() { |
@Override |
public void handleEvent(Event arg0) { |
// when the table has been changed |
// try to re-read the field list |
tableFieldList = ""; |
tableFullFieldList = ""; |
try { |
SBMField[] fields = SBMRepositoryConnector.getClient( |
createTaskRepository()).getFields(table.getText()) |
.toArray(new SBMField[0]); |
fillList(list, fields); |
} catch (Exception e) { } |
if (getWizard() != null) { |
solutionTable = table.getText(); |
getWizard().getContainer().updateButtons(); |
} |
} |
}); |
regenerateTables(); |
expander.setClient(control); |
} |
@Override |
public String getConnectorKind() { |
return SBMConnectorPlugin.CONNECTOR_KIND; |
} |
54,38 → 194,106 |
@Override |
protected boolean isValidUrl(String url) { |
if(url.contains("<server>")) return false; |
if (url.contains("<server>")) |
return false; |
return true; |
} |
@Override |
protected void applyValidatorResult(Validator validator) { |
if (((SBMConnectionValidator) validator).getResult() != null) { |
getContainer().updateButtons(); |
setMessage("Validate first!", IMessageProvider.ERROR); |
setNeedsValidation(true); |
} else { |
regenerateTables(); |
} |
super.applyValidatorResult(validator); |
} |
private void regenerateTables() { |
try { |
List<String> tables = SBMRepositoryConnector.getClient( |
createTaskRepository()).getPrimaryTables(); |
for (String table_name : tables) { |
table.add(table_name); |
if (solutionTable.equals(table_name)) { |
table.setText(table_name); |
} |
} |
} catch (Exception e) { |
// it was not possible to read the list of tables |
// from the server, so just restore saved settings |
table.add(solutionTable); |
table.setText(solutionTable); |
} |
try { |
SBMField[] fields = SBMRepositoryConnector.getClient( |
createTaskRepository()).getFields(table.getText()).toArray( |
new SBMField[0]); |
fillList(list, fields); |
} catch (Exception e) { |
// it was not possible to read the fields for the given table |
// do nothing |
} |
} |
protected class SBMConnectionValidator extends Validator { |
private TaskRepository repository; |
private String result = null; |
protected SBMConnectionValidator(TaskRepository repository) { |
this.repository = repository; |
this.repository = repository; |
} |
@Override |
public void run(IProgressMonitor monitor) throws CoreException { |
monitor.beginTask("Prüfe Verbindung", IProgressMonitor.UNKNOWN); |
monitor.beginTask("Prüfe Verbindung", IProgressMonitor.UNKNOWN); |
SBMClient client = new SBMClient(repository); |
if(!client.canAuthenticate()) { |
if (!client.canAuthenticate()) { |
result = "Verbindung fehlgeschlagen"; |
} else { |
result = null; |
} |
result = "Verbindung erfolgreich"; |
monitor.done(); |
} |
public String getResult() { return result; } |
public String getResult() { |
return result; |
} |
} |
private void fillList(Table list, SBMField[] fields) { |
list.removeAll(); |
for (int i = 0; i < fields.length; i++) { |
TableItem item = new TableItem(list, 0); |
item.setText(0, ""); |
item.setText(1, fields[i].getLabel()); |
item.setText(2, fields[i].getName()); |
item.setText(3, fields[i].getType().getValue().replaceFirst( |
"FLDTYPE-", "")); |
try { |
// auto-select all system fields |
SBMSystemFields.valueOf(fields[i].getName()); |
item.setChecked(true); |
} catch (IllegalArgumentException e) { |
// do nothing |
} |
if (tableFieldList.contains(","+fields[i].getName()+",")) { |
// item has been checked before |
// so check it |
item.setChecked(true); |
} |
} |
for (TableColumn c : list.getColumns()) { |
c.pack(); |
} |
} |
@Override |
protected void createAdditionalControls(Composite arg0) { |
// TODO Auto-generated method stub |
} |
} |
/sbm4mylyn/trunk/src/net/brutex/mylyn/sbmconnector/ui/SBMRepositoryQueryPage.java |
---|
19,7 → 19,11 |
*/ |
package net.brutex.mylyn.sbmconnector.ui; |
import java.awt.Color; |
import net.brutex.mylyn.sbmconnector.core.SBMRepositoryConnector; |
import net.brutex.mylyn.sbmconnector.core.model.SBMField; |
import net.brutex.mylyn.sbmconnector.core.model.SBMSystemFields; |
import org.eclipse.jface.dialogs.Dialog; |
import org.eclipse.jface.layout.GridDataFactory; |
27,19 → 31,28 |
import org.eclipse.mylyn.tasks.core.TaskRepository; |
import org.eclipse.mylyn.tasks.ui.wizards.AbstractRepositoryQueryPage; |
import org.eclipse.swt.SWT; |
import org.eclipse.swt.events.SelectionEvent; |
import org.eclipse.swt.events.SelectionListener; |
import org.eclipse.swt.layout.GridData; |
import org.eclipse.swt.layout.GridLayout; |
import org.eclipse.swt.widgets.Combo; |
import org.eclipse.swt.widgets.Composite; |
import org.eclipse.swt.widgets.Display; |
import org.eclipse.swt.widgets.Event; |
import org.eclipse.swt.widgets.Label; |
import org.eclipse.swt.widgets.List; |
import org.eclipse.swt.widgets.Listener; |
import org.eclipse.swt.widgets.Table; |
import org.eclipse.swt.widgets.TableColumn; |
import org.eclipse.swt.widgets.TableItem; |
import org.eclipse.swt.widgets.Text; |
import org.eclipse.swt.widgets.Widget; |
public class SBMRepositoryQueryPage extends AbstractRepositoryQueryPage { |
private Combo table = null; |
private Text sql_where_clause = null; |
private Text query_title = null; |
public SBMRepositoryQueryPage(String pageName, TaskRepository repository, |
IRepositoryQuery query) { |
super(pageName, repository, query); |
52,54 → 65,42 |
if (getQueryTitle() != null) { |
query.setSummary(getQueryTitle()); |
} |
query.setAttribute("table", table.getText()); |
query.setAttribute("sql_where", sql_where_clause.getText()); |
query.setAttribute("name", query_title.getText()); |
} |
@Override |
public String getQueryTitle() { |
if(query_title!=null && !query_title.getText().isEmpty()) return query_title.getText(); |
if (query_title != null && !query_title.getText().isEmpty()) |
return query_title.getText(); |
return "new query"; |
} |
@Override |
public void createControl(Composite arg0) { |
Composite control = new Composite(arg0,SWT.BORDER); |
Composite control = new Composite(arg0, SWT.BORDER); |
control.setLayout(new GridLayout(2, false)); |
Label query_label = new Label(control, SWT.NONE); |
query_label.setText("Query Name:"); |
query_title = new Text(control, SWT.BORDER); |
if(getQuery()!=null) query_title.setText(getQuery().getAttribute("name")); |
Label label = new Label(control, SWT.NONE); |
label.setText("Table:"); |
table = new Combo(control, SWT.SINGLE | SWT.BORDER); |
for(String table_name : SBMRepositoryConnector.getClient(getTaskRepository()).getPrimaryTables()) { |
table.add(table_name); |
if(getQuery()!=null && getQuery().getAttribute("table").equals(table_name)) { |
table.setText(table_name); |
} |
} |
if (getQuery() != null) |
query_title.setText(getQuery().getAttribute("name")); |
GridData data = new GridData(SWT.FILL, SWT.FILL, true, true); |
data.heightHint = 200; |
Label label_sql = new Label(control, SWT.NONE); |
label_sql.setText("SQL where:"); |
sql_where_clause = new Text(control, SWT.MULTI | SWT.WRAP | SWT.V_SCROLL | SWT.BORDER); |
GridData gd = new GridData(300, 150); |
gd.horizontalSpan = 2; |
sql_where_clause.setLayoutData(gd); |
if(getQuery()!=null) sql_where_clause.setText(getQuery().getAttribute("sql_where")); |
GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo(table); |
GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo(query_title); |
if (getQuery() != null) |
sql_where_clause.setText(getQuery().getAttribute("sql_where")); |
GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo( |
query_title); |
Dialog.applyDialogFont(control); |
setControl(control); |
} |
} |