Subversion Repositories XServices

Rev

Rev 30 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 30 Rev 39
1
/*
1
/*
2
 *   Mylyn Connector for Serena Business Mashups
2
 *   Mylyn Connector for Serena Business Mashups
3
 * 	 Copyright 2010 Brian Rosenberger (Brutex Network)
3
 * 	 Copyright 2010 Brian Rosenberger (Brutex Network)
4
 *
4
 *
5
 *   Licensed under the Apache License, Version 2.0 (the "License");
5
 *   Licensed under the Apache License, Version 2.0 (the "License");
6
 *   you may not use this file except in compliance with the License.
6
 *   you may not use this file except in compliance with the License.
7
 *   You may obtain a copy of the License at
7
 *   You may obtain a copy of the License at
8
 *
8
 *
9
 *       http://www.apache.org/licenses/LICENSE-2.0
9
 *       http://www.apache.org/licenses/LICENSE-2.0
10
 *
10
 *
11
 *   Unless required by applicable law or agreed to in writing, software
11
 *   Unless required by applicable law or agreed to in writing, software
12
 *   distributed under the License is distributed on an "AS IS" BASIS,
12
 *   distributed under the License is distributed on an "AS IS" BASIS,
13
 *   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13
 *   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14
 *   See the License for the specific language governing permissions and
14
 *   See the License for the specific language governing permissions and
15
 *   limitations under the License.
15
 *   limitations under the License.
16
 * 
16
 * 
17
 *   Serena, TeamTrack and Serena Business Mashup are 
17
 *   Serena, TeamTrack and Serena Business Mashup are 
18
 * 	 registered trademarks of SERENA Software Inc.
18
 * 	 registered trademarks of SERENA Software Inc.
19
 */
19
 */
20
package net.brutex.mylyn.sbmconnector.ui;
20
package net.brutex.mylyn.sbmconnector.ui;
-
 
21
 
-
 
22
import java.awt.Color;
21
 
23
 
-
 
24
import net.brutex.mylyn.sbmconnector.core.SBMRepositoryConnector;
-
 
25
import net.brutex.mylyn.sbmconnector.core.model.SBMField;
22
import net.brutex.mylyn.sbmconnector.core.SBMRepositoryConnector;
26
import net.brutex.mylyn.sbmconnector.core.model.SBMSystemFields;
23
 
27
 
24
import org.eclipse.jface.dialogs.Dialog;
28
import org.eclipse.jface.dialogs.Dialog;
25
import org.eclipse.jface.layout.GridDataFactory;
29
import org.eclipse.jface.layout.GridDataFactory;
26
import org.eclipse.mylyn.tasks.core.IRepositoryQuery;
30
import org.eclipse.mylyn.tasks.core.IRepositoryQuery;
27
import org.eclipse.mylyn.tasks.core.TaskRepository;
31
import org.eclipse.mylyn.tasks.core.TaskRepository;
28
import org.eclipse.mylyn.tasks.ui.wizards.AbstractRepositoryQueryPage;
32
import org.eclipse.mylyn.tasks.ui.wizards.AbstractRepositoryQueryPage;
29
import org.eclipse.swt.SWT;
33
import org.eclipse.swt.SWT;
-
 
34
import org.eclipse.swt.events.SelectionEvent;
-
 
35
import org.eclipse.swt.events.SelectionListener;
30
import org.eclipse.swt.layout.GridData;
36
import org.eclipse.swt.layout.GridData;
31
import org.eclipse.swt.layout.GridLayout;
37
import org.eclipse.swt.layout.GridLayout;
32
import org.eclipse.swt.widgets.Combo;
38
import org.eclipse.swt.widgets.Combo;
33
import org.eclipse.swt.widgets.Composite;
39
import org.eclipse.swt.widgets.Composite;
-
 
40
import org.eclipse.swt.widgets.Display;
-
 
41
import org.eclipse.swt.widgets.Event;
34
import org.eclipse.swt.widgets.Label;
42
import org.eclipse.swt.widgets.Label;
-
 
43
import org.eclipse.swt.widgets.List;
-
 
44
import org.eclipse.swt.widgets.Listener;
-
 
45
import org.eclipse.swt.widgets.Table;
-
 
46
import org.eclipse.swt.widgets.TableColumn;
-
 
47
import org.eclipse.swt.widgets.TableItem;
35
import org.eclipse.swt.widgets.Text;
48
import org.eclipse.swt.widgets.Text;
-
 
49
import org.eclipse.swt.widgets.Widget;
36
 
50
 
37
public class SBMRepositoryQueryPage extends AbstractRepositoryQueryPage {
51
public class SBMRepositoryQueryPage extends AbstractRepositoryQueryPage {
38
	
-
 
39
	private Combo table = null;
52
 
40
	private Text sql_where_clause = null;
53
	private Text sql_where_clause = null;
41
	private Text query_title = null;
54
	private Text query_title = null;
42
	
55
 
43
	public SBMRepositoryQueryPage(String pageName, TaskRepository repository,
56
	public SBMRepositoryQueryPage(String pageName, TaskRepository repository,
44
			IRepositoryQuery query) {
57
			IRepositoryQuery query) {
45
		super(pageName, repository, query);
58
		super(pageName, repository, query);
46
		setTitle("SBM Query");
59
		setTitle("SBM Query");
47
		setDescription("Please specify table database name.");
60
		setDescription("Please specify table database name.");
48
	}
61
	}
49
 
62
 
50
	@Override
63
	@Override
51
	public void applyTo(IRepositoryQuery query) {
64
	public void applyTo(IRepositoryQuery query) {
52
		if (getQueryTitle() != null) {
65
		if (getQueryTitle() != null) {
53
			query.setSummary(getQueryTitle());
66
			query.setSummary(getQueryTitle());
54
		}
67
		}
55
		query.setAttribute("table", table.getText());
-
 
56
		query.setAttribute("sql_where", sql_where_clause.getText());
68
		query.setAttribute("sql_where", sql_where_clause.getText());
57
		query.setAttribute("name", query_title.getText());
69
		query.setAttribute("name", query_title.getText());
58
		
-
 
59
	}
70
	}
60
 
71
 
61
	@Override
72
	@Override
62
	public String getQueryTitle() {
73
	public String getQueryTitle() {
63
		if(query_title!=null && !query_title.getText().isEmpty()) return query_title.getText();
74
		if (query_title != null && !query_title.getText().isEmpty())
-
 
75
			return query_title.getText();
64
		return "new query";
76
		return "new query";
65
	}
77
	}
66
 
78
 
67
	@Override
79
	@Override
68
	public void createControl(Composite arg0) {
80
	public void createControl(Composite arg0) {
69
		Composite control = new Composite(arg0,SWT.BORDER);
81
		Composite control = new Composite(arg0, SWT.BORDER);
70
		control.setLayout(new GridLayout(2, false));
82
		control.setLayout(new GridLayout(2, false));
71
		Label query_label = new Label(control, SWT.NONE);
83
		Label query_label = new Label(control, SWT.NONE);
72
		query_label.setText("Query Name:");
84
		query_label.setText("Query Name:");
73
		query_title = new Text(control, SWT.BORDER);
85
		query_title = new Text(control, SWT.BORDER);
74
		if(getQuery()!=null) query_title.setText(getQuery().getAttribute("name"));
-
 
75
		
-
 
76
		Label label = new Label(control, SWT.NONE);
-
 
77
		label.setText("Table:");
86
		if (getQuery() != null)
78
		
-
 
79
		table = new Combo(control, SWT.SINGLE | SWT.BORDER);
-
 
80
		for(String table_name : SBMRepositoryConnector.getClient(getTaskRepository()).getPrimaryTables()) {
-
 
81
			table.add(table_name);
-
 
82
			if(getQuery()!=null && getQuery().getAttribute("table").equals(table_name)) {
87
			query_title.setText(getQuery().getAttribute("name"));
83
				table.setText(table_name);
-
 
84
			}
-
 
85
		}
-
 
-
 
88
 
-
 
89
				GridData data = new GridData(SWT.FILL, SWT.FILL, true, true);
86
 
-
 
87
		
-
 
-
 
90
		data.heightHint = 200;
-
 
91
		
88
		
92
		Label label_sql = new Label(control, SWT.NONE);
89
		
93
		label_sql.setText("SQL where:");
90
		sql_where_clause = new Text(control, SWT.MULTI | SWT.WRAP | SWT.V_SCROLL | SWT.BORDER);
94
		sql_where_clause = new Text(control, SWT.MULTI | SWT.WRAP | SWT.V_SCROLL | SWT.BORDER);
91
		GridData gd = new GridData(300, 150);
95
		GridData gd = new GridData(300, 150);
92
		gd.horizontalSpan = 2;
96
		gd.horizontalSpan = 2;
93
		sql_where_clause.setLayoutData(gd);
97
		sql_where_clause.setLayoutData(gd);
-
 
98
		if (getQuery() != null)
94
		if(getQuery()!=null) sql_where_clause.setText(getQuery().getAttribute("sql_where"));
99
			sql_where_clause.setText(getQuery().getAttribute("sql_where"));
95
		
100
 
96
		GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo(table);
101
		GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo(
97
		GridDataFactory.fillDefaults().align(SWT.FILL, SWT.TOP).applyTo(query_title);
102
				query_title);
98
		Dialog.applyDialogFont(control);
103
		Dialog.applyDialogFont(control);
99
		setControl(control);
104
		setControl(control);
100
	}
105
	}
101
	
-
 
102
	
-
 
103
 
-
 
104
 
-
 
105
}
106
}