Examples with IXMLMemento com.cubrid.cubridmanager.core.common.xml.IXMLMemento used on opensource projects

Example 51 with IXMLMemento

use of com.cubrid.cubridmanager.core.common.xml.IXMLMemento in project cubrid-manager by CUBRID.

the class CQBDBNodePersistManager method parseDatabaseFromXML.

public List<CubridDatabase> parseDatabaseFromXML(File file) {
    // FIXME extract?
    List<CubridDatabase> list = new ArrayList<CubridDatabase>();
    FileInputStream fis = null;
    try {
        fis = new FileInputStream(file);
        IXMLMemento xmlContent = XMLMemento.loadMemento(fis);
        IXMLMemento[] children = xmlContent == null ? null : xmlContent.getChildren("database");
        for (int i = 0; children != null && i < children.length; i++) {
            String name = children[i].getString("name");
            String dbName = children[i].getString("dbName");
            String brokerIp = children[i].getString("brokerIp");
            String brokerPort = children[i].getString("brokerPort");
            String charset = children[i].getString("charset");
            String jdbcAttrs = children[i].getString("jdbcAttrs");
            String dbUser = children[i].getString("dbUser");
            String dbPassword = children[i].getString("dbPassword");
            boolean savePassword = children[i].getBoolean("savePassword");
            String jdbcDriver = children[i].getString("jdbcDriver");
            // [TOOLS-2425]Support shard broker
            Boolean isShardObj = children[i].getBoolean("isShard");
            boolean isShard = isShardObj == null ? false : isShardObj;
            String shardQueryTypeStr = children[i].getString("shardQueryType");
            int shardQueryType = StringUtil.intValue(shardQueryTypeStr, 0);
            ServerInfo serverInfo = new ServerInfo();
            serverInfo.setServerName(name);
            serverInfo.setHostAddress(brokerIp);
            serverInfo.setHostMonPort(Integer.parseInt(brokerPort));
            serverInfo.setHostJSPort(Integer.parseInt(brokerPort) + 1);
            serverInfo.setUserName(dbName + "@" + brokerIp);
            serverInfo.setJdbcDriverVersion(jdbcDriver);
            CubridServer server = new CubridServer(name, name, null, null);
            server.setServerInfo(serverInfo);
            server.setType(NodeType.SERVER);
            DatabaseInfo dbInfo = new DatabaseInfo(dbName, serverInfo);
            dbInfo.setBrokerIP(brokerIp);
            dbInfo.setBrokerPort(brokerPort);
            dbInfo.setCharSet(charset);
            dbInfo.setJdbcAttrs(jdbcAttrs);
            dbInfo.setRunningType(DbRunningType.CS);
            // [TOOLS-2425]Support shard broker
            dbInfo.setShard(isShard);
            dbInfo.setShardQueryType(shardQueryType);
            String decDbPassword = null;
            if (dbPassword != null && dbPassword.trim().length() > 0) {
                decDbPassword = CipherUtils.decrypt(dbPassword);
            }
            DbUserInfo dbUserInfo = new DbUserInfo(dbName, dbUser, dbPassword, decDbPassword, false);
            dbInfo.setAuthLoginedDbUserInfo(dbUserInfo);
            String dbId = name + ICubridNodeLoader.NODE_SEPARATOR + name;
            DatabaseEditorConfig editorConfig = null;
            IXMLMemento editorConfigElement = children[i].getChild("editorConfig");
            if (editorConfigElement != null) {
                editorConfig = new DatabaseEditorConfig();
                String strBGPos = editorConfigElement.getString("purpose-code");
                if (strBGPos == null) {
                    strBGPos = "0";
                }
                int bgPos = StringUtil.intValue(strBGPos, 0);
                RGB background = EditorConstance.getRGBByPos(bgPos);
                editorConfig.setBackGround(background);
                editorConfig.setDatabaseComment(editorConfigElement.getString("database-comment"));
            }
            CubridDatabase database = new CubridDatabase(dbId, name);
            database.setServer(server);
            database.setStartAndLoginIconPath("icons/navigator/database_start_connected.png");
            database.setStartAndLogoutIconPath("icons/navigator/database_start_disconnected.png");
            database.setDatabaseInfo(dbInfo);
            CubridNodeLoader loader = new CQBDbConnectionLoader();
            loader.setLevel(ICubridNodeLoader.FIRST_LEVEL);
            database.setLoader(loader);
            database.setAutoSavePassword(savePassword);
            /*Save DatabaseEditorConfig to database object*/
            if (editorConfig != null) {
                database.setData(CubridDatabase.DATA_KEY_EDITOR_CONFIG, editorConfig);
            }
            list.add(database);
        }
    } catch (Exception e) {
        LOGGER.error(e.getMessage());
    } finally {
        FileUtil.close(fis);
    }
    return list;
}

Example 52 with IXMLMemento

use of com.cubrid.cubridmanager.core.common.xml.IXMLMemento in project cubrid-manager by CUBRID.

the class CQBDBNodePersistManager method saveServer.

public void saveServer(List<CubridDatabase> servers, String path) {
    synchronized (this) {
        XMLMemento memento = XMLMemento.createWriteRoot("databases");
        Iterator<CubridDatabase> iterator = servers.iterator();
        while (iterator.hasNext()) {
            CubridDatabase db = (CubridDatabase) iterator.next();
            DatabaseInfo dbInfo = db.getDatabaseInfo();
            IXMLMemento child = memento.createChild("database");
            child.putString("name", db.getLabel());
            child.putString("dbName", dbInfo.getDbName());
            child.putString("brokerPort", dbInfo.getBrokerPort());
            child.putString("brokerIp", dbInfo.getBrokerIP());
            child.putString("charset", dbInfo.getCharSet());
            child.putString("jdbcAttrs", dbInfo.getJdbcAttrs());
            child.putString("dbUser", db.getUserName());
            child.putBoolean("savePassword", false);
            child.putString("jdbcDriver", db.getServer().getJdbcDriverVersion());
            /*Save the database editor config*/
            DatabaseEditorConfig config = QueryOptions.getEditorConfig(db, false);
            if (config != null) {
                IXMLMemento editorConfigChild = child.createChild("editorConfig");
                editorConfigChild.putString("database-comment", config.getDatabaseComment() == null ? "" : config.getDatabaseComment());
                if (config.getBackGround() != null) {
                    RGB background = config.getBackGround();
                    int bgPos = EditorConstance.getBGPos(background);
                    editorConfigChild.putInteger("purpose-code", bgPos);
                }
            }
        }
        FileOutputStream fout = null;
        try {
            fout = new FileOutputStream(path);
            fout.write(memento.getContents());
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                fout.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

Example 53 with IXMLMemento

use of com.cubrid.cubridmanager.core.common.xml.IXMLMemento in project cubrid-manager by CUBRID.

the class CQBDBNodePersistManager method loadDatabases.

/**
	 *
	 * Load added host from plugin preference
	 *
	 */
protected void loadDatabases() {
    synchronized (this) {
        IXMLMemento memento = PersistUtils.getXMLMemento(ApplicationUtil.CQB_UI_PLUGIN_ID, DATABASE_XML_CONTENT);
        loadDatabases(memento, false, null);
    }
}

Example 54 with IXMLMemento

use of com.cubrid.cubridmanager.core.common.xml.IXMLMemento in project cubrid-manager by CUBRID.

the class CQBDBNodePersistManager method loadDatabases.

/**
	 *
	 * Load added host from file preference
	 *
	 * @param workspacePath String
	 * @return boolean whether imported
	 *
	 */
public boolean loadDatabases(String workspacePath) {
    synchronized (this) {
        String settingPath = workspacePath + File.separator + ".metadata" + File.separator + ".plugins" + File.separator + "org.eclipse.core.runtime" + File.separator + ".settings" + File.separator;
        String serverPath = settingPath + File.separator + "com.cubrid.cubridquery.ui.prefs";
        PreferenceStore preference = new PreferenceStore(serverPath);
        int size = databaseList.size();
        try {
            preference.load();
            String xmlString = preference.getString(DATABASE_XML_CONTENT);
            if (xmlString == null || xmlString.trim().length() == 0) {
                return false;
            }
            ByteArrayInputStream in = new ByteArrayInputStream(xmlString.getBytes("UTF-8"));
            IXMLMemento memento = XMLMemento.loadMemento(in);
            loadDatabases(memento, true, settingPath);
        } catch (IOException e) {
            LOGGER.error(e.getMessage());
        }
        boolean isImported = size != databaseList.size();
        if (isImported) {
            saveDatabases();
        }
        return isImported;
    }
}