use of com.cubrid.cubridmanager.core.broker.model.BrokerInfoList in project cubrid-manager by CUBRID.
the class BrokerStatusView method refreshBasicTable.
/**
* refresh the basic info table viewer
*
* @param serverInfo the instance of ServerInfo
*/
private void refreshBasicTable(ServerInfo serverInfo) {
BrokerInfos brokerInfos = new BrokerInfos();
final GetBrokerStatusInfosTask<BrokerInfos> basicTask = new GetBrokerStatusInfosTask<BrokerInfos>(serverInfo, CommonSendMsg.getGetBrokerStatusItems(), brokerInfos);
basicTask.setBrokerName(nodeName);
basicTask.execute();
brokerInfos = basicTask.getResultModel();
if (null != brokerInfos) {
BrokerInfoList list = brokerInfos.getBorkerInfoList();
if (list != null && list.getBrokerInfoList() != null) {
basicInfoLst = list.getBrokerInfoList();
}
}
if (basicTableViewer != null) {
basicTableViewer.setInput(basicInfoLst);
basicTableViewer.refresh();
}
}
use of com.cubrid.cubridmanager.core.broker.model.BrokerInfoList in project cubrid-manager by CUBRID.
the class HaShardDemo method getBrokerNodeInfo.
protected NodeInfo getBrokerNodeInfo(ServerInfo serverInfo) {
BrokerNode nodeInfo = new BrokerNode();
BrokerInfos brokerInfos = new BrokerInfos();
GetBrokerStatusInfosTask<BrokerInfos> getBrokerStatusInfosTask = new GetBrokerStatusInfosTask<BrokerInfos>(serverInfo, CommonSendMsg.getGetBrokerStatusItems(), brokerInfos);
getBrokerStatusInfosTask.execute();
if (!getBrokerStatusInfosTask.isSuccess()) {
return null;
}
brokerInfos = getBrokerStatusInfosTask.getResultModel();
BrokerInfoList brokerInfoList = brokerInfos.getBorkerInfoList();
if (!(brokerInfoList != null && brokerInfoList.getBrokerInfoList() != null && brokerInfoList.getBrokerInfoList().size() > 0)) {
return null;
}
nodeInfo.setBrokerInfoList(brokerInfoList);
//Set<String> dbHosts = new HashSet<String>();
for (BrokerInfo brokerInfo : brokerInfoList.getBrokerInfoList()) {
if (brokerInfo == null) {
continue;
}
String brokerName = brokerInfo.getName();
String brokerPort = brokerInfo.getPort();
BrokerStatusInfos brokerStatusInfos = new BrokerStatusInfos();
GetBrokerStatusInfosTask<BrokerStatusInfos> statisTask = new GetBrokerStatusInfosTask<BrokerStatusInfos>(serverInfo, CommonSendMsg.getGetBrokerStatusItems(), brokerStatusInfos);
statisTask.setBrokerName(brokerName);
statisTask.execute();
if (!statisTask.isSuccess()) {
continue;
}
brokerStatusInfos = statisTask.getResultModel();
nodeInfo.addBrokerStatus(brokerPort, brokerStatusInfos);
}
return nodeInfo;
}
use of com.cubrid.cubridmanager.core.broker.model.BrokerInfoList in project cubrid-manager by CUBRID.
the class BrokerDashboardViewPart method performUpdate.
/**
* Perform update UI when data change event happen
*
* @param dataChangedEvent the instance of DataChangedEvent
*/
public void performUpdate(DataChangedEvent dataChangedEvent) {
if (composite == null || composite.isDisposed()) {
return;
}
if (dataChangedEvent != null) {
String brokerName = brokerNode.getBrokerName();
BrokerInfos brokerInfos = dataChangedEvent.getBrokerInfosMap().get(brokerName);
BrokerStatusInfos brokerStatusInfos = dataChangedEvent.getBrokerStatusInfosMap().get(brokerName);
BrokerDiagData brokerDiagData = dataChangedEvent.getBrokerDiagDataMap().get(brokerName);
List<String> basicTableLst = new ArrayList<String>();
if (brokerInfos == null) {
for (int i = 0; i < 10; i++) {
basicTableLst.add("");
}
} else {
BrokerInfoList brokerInfoList = brokerInfos.getBorkerInfoList();
if (brokerInfoList.getBrokerInfoList().isEmpty()) {
for (int i = 0; i < 10; i++) {
basicTableLst.add("");
}
}
for (BrokerInfo bi : brokerInfoList.getBrokerInfoList()) {
if (brokerName.equals(bi.getName())) {
basicTableLst.add(bi.getPid());
basicTableLst.add(bi.getPort());
basicTableLst.add(bi.getJq());
basicTableLst.add(bi.getAuto());
basicTableLst.add(bi.getSqll());
basicTableLst.add(bi.getLong_tran_time());
basicTableLst.add(bi.getLong_query_time());
basicTableLst.add(bi.getSes());
basicTableLst.add(bi.getKeep_conn());
basicTableLst.add(bi.getAccess_mode());
}
}
}
if (brokerDiagData == null) {
for (int i = 0; i < 3; i++) {
basicTableLst.add("");
}
} else {
basicTableLst.add(brokerDiagData.getCas_mon_active());
basicTableLst.add(brokerDiagData.getCas_mon_session());
basicTableLst.add(brokerDiagData.getCas_mon_tran());
}
//test
List<List<String>> basicColumnLst = new ArrayList<List<String>>();
basicColumnLst.add(basicTableLst);
basicTableViewer.setInput(basicColumnLst);
basicTableViewer.refresh();
List<ApplyServerInfo> asinfoLst = null;
List<JobInfo> jobinfoLst = null;
if (brokerStatusInfos == null) {
asinfoLst = new ArrayList<ApplyServerInfo>();
jobinfoLst = new ArrayList<JobInfo>();
} else {
asinfoLst = brokerStatusInfos.getAsinfo();
jobinfoLst = brokerStatusInfos.getJobinfo();
if (asinfoLst == null) {
asinfoLst = new ArrayList<ApplyServerInfo>();
}
if (jobinfoLst == null) {
jobinfoLst = new ArrayList<JobInfo>();
}
}
asTableViewer.setInput(asinfoLst);
asTableViewer.refresh();
jqTableViewer.setInput(jobinfoLst);
jqTableViewer.refresh();
}
}
use of com.cubrid.cubridmanager.core.broker.model.BrokerInfoList in project cubrid-manager by CUBRID.
the class ServiceDashboardEditor method setBrokerData.
/**
* Set Server Broker Data
*/
private void setBrokerData(ServiceDashboardInfo sDashInfo, BrokerInfos brokerInfos) {
String brokerPort = "";
int tps = 0, qps = 0, errorQ = 0;
if (brokerInfos != null) {
List<BrokerInfo> newBrokerInfoList = null;
BrokerInfoList list = brokerInfos.getBorkerInfoList();
if (list != null && list.getBrokerInfoList() != null) {
newBrokerInfoList = list.getBrokerInfoList();
}
if (newBrokerInfoList != null) {
for (BrokerInfo brokerInfo : newBrokerInfoList) {
brokerPort += brokerInfo.getPort() + " ";
tps += StringUtil.doubleValue(brokerInfo.getTran(), 0);
qps += StringUtil.doubleValue(brokerInfo.getQuery(), 0);
errorQ += StringUtil.doubleValue(brokerInfo.getError_query(), 0);
}
}
sDashInfo.setServerTps(tps);
sDashInfo.setServerQps(qps);
sDashInfo.setServerErrorQ(errorQ);
sDashInfo.setBrokerPort(brokerPort);
}
}
use of com.cubrid.cubridmanager.core.broker.model.BrokerInfoList in project cubrid-manager by CUBRID.
the class LoginDatabaseDialog method createDialogArea.
protected Control createDialogArea(Composite parent) {
Composite parentComp = (Composite) super.createDialogArea(parent);
final Composite composite = new Composite(parentComp, SWT.NONE);
composite.setLayoutData(new GridData(GridData.FILL_BOTH));
GridLayout layout = new GridLayout();
layout.numColumns = 5;
layout.marginHeight = convertVerticalDLUsToPixels(IDialogConstants.VERTICAL_MARGIN);
layout.marginWidth = convertHorizontalDLUsToPixels(IDialogConstants.HORIZONTAL_MARGIN);
layout.verticalSpacing = convertVerticalDLUsToPixels(IDialogConstants.VERTICAL_SPACING);
layout.horizontalSpacing = convertHorizontalDLUsToPixels(IDialogConstants.HORIZONTAL_SPACING);
composite.setLayout(layout);
Label userNameLabel = new Label(composite, SWT.LEFT);
userNameLabel.setText(Messages.lblDbUserName);
userNameLabel.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
userNameText = new Text(composite, SWT.LEFT | SWT.BORDER);
if (database != null && database.getUserName() != null) {
userNameText.setText(database.getUserName());
}
userNameText.addModifyListener(this);
userNameText.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 4, 1, 100, -1));
userNameText.setFocus();
Label passwordLabel = new Label(composite, SWT.LEFT);
passwordLabel.setText(Messages.lblDbPassword);
passwordLabel.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
passwordText = new Text(composite, SWT.LEFT | SWT.PASSWORD | SWT.BORDER);
passwordText.setTextLimit(ValidateUtil.MAX_PASSWORD_LENGTH);
passwordText.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 4, 1, 100, -1));
if (database != null && database.getPassword() != null && database.isAutoSavePassword()) {
passwordText.setText(database.getPassword());
}
if (database != null && database.getUserName() != null) {
passwordText.selectAll();
passwordText.setFocus();
}
new Composite(composite, SWT.NONE).setLayoutData(CommonUITool.createGridData(1, 1, 0, 0));
Button btnSavePassword = new Button(composite, SWT.CHECK);
btnSavePassword.setLayoutData(CommonUITool.createGridData(GridData.HORIZONTAL_ALIGN_FILL, 1, 1, -1, -1));
btnSavePassword.setText(Messages.btnSavePassword);
if (database == null) {
btnSavePassword.setSelection(true);
isSavePassword = true;
} else {
btnSavePassword.setSelection(database.isAutoSavePassword());
isSavePassword = database.isAutoSavePassword();
}
btnSavePassword.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) {
isSavePassword = !isSavePassword;
}
});
Label backgroundLabel = new Label(composite, SWT.None);
backgroundLabel.setText(Messages.lblBackground);
backgroundLabel.setLayoutData(CommonUITool.createGridData(GridData.HORIZONTAL_ALIGN_END | GridData.FILL_HORIZONTAL, 1, 1, -1, -1));
DatabaseEditorConfig editorConfig = QueryOptions.getEditorConfig(database, true);
RGB selectedColor = null;
if (editorConfig != null) {
selectedColor = editorConfig.getBackGround();
} else {
selectedColor = EditorConstance.getDefaultBackground();
}
selectColorCombo = new SelectColorCombo(composite, SWT.BORDER, selectedColor);
selectColorCombo.setLayoutData(CommonUITool.createGridData(GridData.HORIZONTAL_ALIGN_END, 2, 1, 110, -1));
Label commentLabel = new Label(composite, SWT.None);
commentLabel.setText(Messages.lblComment);
commentLabel.setLayoutData(CommonUITool.createGridData(GridData.HORIZONTAL_ALIGN_BEGINNING, 1, 1, -1, -1));
commentText = new Text(composite, SWT.BORDER);
commentText.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 4, 1, -1, -1));
commentText.setTextLimit(64);
if (editorConfig != null) {
commentText.setText(StringUtil.nvl(editorConfig.getDatabaseComment()));
}
new Label(composite, SWT.None);
Label commentDescLabel = new Label(composite, SWT.None);
commentDescLabel.setText(Messages.lblDescComment);
commentDescLabel.setLayoutData(CommonUITool.createGridData(GridData.HORIZONTAL_ALIGN_BEGINNING, 4, 1, -1, -1));
final Group brokerGroup = new Group(composite, SWT.NONE);
{
brokerGroup.setText(com.cubrid.common.ui.query.Messages.brokerGrp);
brokerGroup.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 5, 1, -1, -1));
GridLayout brokerLayout = new GridLayout();
brokerLayout.numColumns = 3;
brokerLayout.marginHeight = convertVerticalDLUsToPixels(IDialogConstants.VERTICAL_MARGIN);
brokerLayout.marginWidth = convertHorizontalDLUsToPixels(IDialogConstants.HORIZONTAL_MARGIN);
brokerLayout.verticalSpacing = convertVerticalDLUsToPixels(IDialogConstants.VERTICAL_SPACING);
brokerLayout.horizontalSpacing = convertHorizontalDLUsToPixels(IDialogConstants.HORIZONTAL_SPACING);
brokerGroup.setLayout(brokerLayout);
final Label labelBrokerIp = new Label(brokerGroup, SWT.NONE);
labelBrokerIp.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
labelBrokerIp.setText(com.cubrid.common.ui.query.Messages.brokerIP);
brokerIpText = new Text(brokerGroup, SWT.BORDER);
brokerIpText.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 2, 1, -1, -1));
final Label labelBrokerPort = new Label(brokerGroup, SWT.NONE);
labelBrokerPort.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
labelBrokerPort.setText(com.cubrid.common.ui.query.Messages.brokerPort);
brokerPortCombo = new Combo(brokerGroup, SWT.NONE);
brokerPortCombo.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 2, 1, -1, -1));
BrokerInfos brokerInfos = database.getServer().getServerInfo().getBrokerInfos();
BrokerInfoList bis = brokerInfos == null ? null : brokerInfos.getBorkerInfoList();
if (bis != null) {
List<BrokerInfo> brokerInfoList = bis.getBrokerInfoList();
for (BrokerInfo brokerInfo : brokerInfoList) {
if (StringUtil.isEmpty(brokerInfo.getPort())) {
continue;
}
String status = "";
if (!StringUtil.isEqualIgnoreCase(brokerInfos.getBrokerstatus(), "ON")) {
status = "OFF";
} else {
status = !StringUtil.isEqualIgnoreCase(brokerInfo.getState(), "ON") ? "OFF" : "ON";
}
String text = brokerInfo.getName() + "[" + brokerInfo.getPort() + "/" + status + "]";
brokerPortCombo.add(text);
brokerPortCombo.setData(brokerInfo.getPort(), text);
brokerPortCombo.setData(text, brokerInfo);
}
}
Label charSetLbl = new Label(brokerGroup, SWT.CHECK);
charSetLbl.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
charSetLbl.setText(com.cubrid.common.ui.query.Messages.lblCharSet);
charsetCombo = new Combo(brokerGroup, SWT.BORDER);
charsetCombo.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 1, 1, -1, -1));
Button testConnectionButton = new Button(brokerGroup, SWT.None);
testConnectionButton.setText(com.cubrid.common.ui.query.Messages.btnTestConnection);
testConnectionButton.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
testConnectionButton.addSelectionListener(new SelectionListener() {
public void widgetSelected(SelectionEvent e) {
widgetDefaultSelected(e);
}
public void widgetDefaultSelected(SelectionEvent e) {
final String dbUser = userNameText.getText();
final String dbPassword = passwordText.getText();
final DatabaseInfo dbInfo = database.getDatabaseInfo();
final String brokerIP = brokerIpText.getText();
final String brokerPort = getBrokerPort();
final String dbName = dbInfo.getDbName();
final ServerInfo serverInfo = dbInfo.getServerInfo();
final String charset = dbInfo.getCharSet();
final String driverVersion = serverInfo.getJdbcDriverVersion();
// advanced jdbc settings
final String jdbcAttrs = attrText.getText();
final boolean isShard = dbInfo.isShard();
TaskExecutor taskExcutor = new ConnectDatabaseExecutor(brokerIP, brokerPort, dbName, dbUser, dbPassword, charset, jdbcAttrs, driverVersion, false, isShard);
new ExecTaskWithProgress(taskExcutor).exec();
if (taskExcutor.isSuccess()) {
CommonUITool.openInformationBox(Messages.titleSuccess, Messages.msgTestConnSuccess);
}
}
});
}
Group advancedOptionGroup = new Group(composite, SWT.NONE);
{
advancedOptionGroup.setText(Messages.grpAdvancedJDBC);
advancedOptionGroup.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 5, 1, -1, -1));
GridLayout brokerInfoGroupLayout = new GridLayout();
brokerInfoGroupLayout.numColumns = 3;
advancedOptionGroup.setLayout(brokerInfoGroupLayout);
// JDBC attributes
Label attrLabel = new Label(advancedOptionGroup, SWT.LEFT);
attrLabel.setText(com.cubrid.common.ui.common.Messages.lblJdbcAttr);
attrLabel.setLayoutData(CommonUITool.createGridData(1, 1, -1, -1));
attrText = new Text(advancedOptionGroup, SWT.LEFT | SWT.BORDER);
attrText.setEditable(false);
attrText.setLayoutData(CommonUITool.createGridData(GridData.FILL_HORIZONTAL, 1, 1, -1, -1));
Button btnAttr = new Button(advancedOptionGroup, SWT.NONE);
{
btnAttr.setText(com.cubrid.common.ui.common.Messages.btnJdbcAttr);
btnAttr.setLayoutData(CommonUITool.createGridData(1, 1, 80, -1));
btnAttr.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) {
JdbcOptionDialog dialog = new JdbcOptionDialog(getShell(), attrText.getText());
if (IDialogConstants.OK_ID == dialog.open()) {
String jdbcOptions = dialog.getJdbcOptions();
attrText.setText(StringUtil.nvl(jdbcOptions));
}
}
});
}
}
if (database != null && database.getDatabaseInfo() != null) {
String jdbcAttrs = database.getDatabaseInfo().getJdbcAttrs();
attrText.setText(StringUtil.nvl(jdbcAttrs));
String brokerIp = QueryOptions.getBrokerIp(database.getDatabaseInfo());
if (StringUtil.isEmpty(brokerIp)) {
brokerIp = database.getServer().getHostAddress();
}
if (brokerIp != null) {
brokerIpText.setText(brokerIp);
}
String brokerPort = QueryOptions.getBrokerPort(database.getDatabaseInfo());
brokerPort = (String) brokerPortCombo.getData(brokerPort);
if (brokerPort != null) {
brokerPortCombo.setText(brokerPort);
}
String charset = QueryOptions.getCharset(database.getDatabaseInfo());
charsetCombo.setItems(QueryOptions.getAllCharset(charset));
if (charset != null && charset.trim().length() > 0) {
charsetCombo.setText(charset);
} else {
charsetCombo.select(0);
}
}
setTitle(Messages.titleLoginDbDialog);
setMessage(Messages.msgLoginDbDialog);
return parentComp;
}
Aggregations