Examples with ServerInfo com.cubrid.cubridmanager.core.common.model.ServerInfo used on opensource projects

Example 6 with ServerInfo

use of com.cubrid.cubridmanager.core.common.model.ServerInfo in project cubrid-manager by CUBRID.

the class SqlFormattingStrategy method format.

/**
	 * Format the SQL content
	 *
	 * @param content String
	 * @return String
	 */
public String format(String content) {
    if (StringUtil.isEmpty(content)) {
        return "";
    }
    ServerInfo serverInfo = databaseProvider == null ? null : databaseProvider.getServerInfo();
    boolean isLowerCase = QueryOptions.getKeywordLowercase(serverInfo);
    SqlFormatOptions options = new SqlFormatOptions();
    options.setUpperCaseKeyword(!isLowerCase);
    SqlFormatManager formattingManager = new SqlFormatManager();
    return formattingManager.format(content, options);
}

Example 7 with ServerInfo

use of com.cubrid.cubridmanager.core.common.model.ServerInfo in project cubrid-manager by CUBRID.

the class FunctionsSupportedInfoProviderTest method testIsSupportNewHAConfFile.

/**
	 * Test method for
	 * {@link com.cubrid.common.core.util.CompatibleUtil#isSupportNewHAConfFile(ServerInfo)}
	 * .
	 */
public void testIsSupportNewHAConfFile() {
    EnvInfo envInfo = new EnvInfo();
    envInfo.setServerVersion("CUBRID 2008 R2.0(8.3.0.1150)");
    ServerInfo serverInfo = new ServerInfo();
    serverInfo.setConnected(true);
    serverInfo.setEnvInfo(envInfo);
    boolean support = CompatibleUtil.isSupportNewHAConfFile(serverInfo);
    assertFalse(support);
    envInfo.setServerVersion("CUBRID 2008 R2.0(8.4.0.1150)");
    envInfo.setOsInfo(FileUtil.OsInfoType.NT.toString());
    support = CompatibleUtil.isSupportNewHAConfFile(serverInfo);
    assertFalse(support);
    support = CompatibleUtil.isSupportNewHAConfFile(null);
    assertFalse(support);
}

Example 8 with ServerInfo

use of com.cubrid.cubridmanager.core.common.model.ServerInfo in project cubrid-manager by CUBRID.

the class SetupEnvTestCase method setupDatabaseInfo.

/**
	 * Setup database 8.4.0
	 *
	 */
private void setupDatabaseInfo() {
    serverInfo = new ServerInfo();
    serverInfo.setHostAddress(host);
    serverInfo.setHostMonPort(monport);
    serverInfo.setHostJSPort(jpport);
    serverInfo.setUserName(userName);
    serverInfo.setUserPassword(passwd);
    serverInfo.setJdbcDriverVersion(serverVersion);
    ServerManager.getInstance().addServer(host, monport, userName, serverInfo);
    MonitoringTask monTask = new MonitoringTask(serverInfo);
    serverInfo = monTask.connectServer(serverVersion, 1000);
    // get the latest token
    token = serverInfo.getHostToken();
    //get evnInfo
    if (envInfo == null) {
        GetEnvInfoTask envTask = new GetEnvInfoTask(serverInfo);
        envTask.loadEnvInfo();
        envTask.execute();
        envInfo = envTask.loadEnvInfo();
        serverInfo.setEnvInfo(envInfo);
    }
    assertNotNull(envInfo);
    serverPath = envInfo.getRootDir();
    dbRootDir = envInfo.getDatabaseDir();
    //get server type
    GetCMConfParameterTask getCMConfParameterTask = new GetCMConfParameterTask(serverInfo);
    getCMConfParameterTask.execute();
    assertEquals(null, getCMConfParameterTask.getErrorMsg());
    Map<String, String> confParameters = getCMConfParameterTask.getConfParameters();
    ServerType serverType = ServerType.BOTH;
    if (confParameters != null) {
        String target = confParameters.get(ConfConstants.CM_TARGET);
        if (target != null) {
            if (target.indexOf("broker") >= 0 && target.indexOf("server") >= 0) {
                serverType = ServerType.BOTH;
            } else if (target.indexOf("broker") >= 0) {
                serverType = ServerType.BROKER;
            } else if (target.indexOf("server") >= 0) {
                serverType = ServerType.DATABASE;
            }
        }
    }
    if (serverInfo != null) {
        serverInfo.setServerType(serverType);
    }
    //Get database list task
    if (serverType == ServerType.DATABASE || serverType == ServerType.BOTH) {
        final GetDatabaseListTask getDatabaseListTask = new GetDatabaseListTask(serverInfo);
        getDatabaseListTask.execute();
        assertEquals(null, getDatabaseListTask.getErrorMsg());
        List<DatabaseInfo> databaseInfoList = getDatabaseListTask.loadDatabaseInfo();
        for (DatabaseInfo dbInfo : databaseInfoList) {
            if (dbInfo.getDbName().equals(testDbName)) {
                databaseInfo = dbInfo;
                break;
            }
        }
        if (databaseInfo == null) {
            return;
        }
    }
    //get CubridManager user list task
    GetCMUserListTask getUserInfoTask = new GetCMUserListTask(serverInfo);
    getUserInfoTask.execute();
    assertEquals(null, getUserInfoTask.getErrorMsg());
    List<ServerUserInfo> serverUserInfoList = getUserInfoTask.getServerUserInfoList();
    for (int i = 0; serverUserInfoList != null && i < serverUserInfoList.size(); i++) {
        ServerUserInfo userInfo = serverUserInfoList.get(i);
        if (userInfo != null && userInfo.getUserName().equals(serverInfo.getUserName())) {
            serverInfo.setLoginedUserInfo(userInfo);
            break;
        }
    }
    List<DatabaseInfo> databaseInfoList = serverInfo.getLoginedUserInfo().getDatabaseInfoList();
    String dbDir = databaseInfo.getDbDir();
    DbRunningType type = databaseInfo.getRunningType();
    for (int i = 0; databaseInfoList != null && i < databaseInfoList.size(); i++) {
        if (testDbName.equalsIgnoreCase(databaseInfoList.get(i).getDbName())) {
            databaseInfo = databaseInfoList.get(i);
            databaseInfo.setDbDir(dbDir);
            databaseInfo.setBrokerIP(host);
            databaseInfo.setBrokerPort(port);
            databaseInfo.setCharSet(charset);
            databaseInfo.setRunningType(type);
            break;
        }
    }
    //get CUBRID conf parameter
    GetCubridConfParameterTask getCubridConfParameterTask = new GetCubridConfParameterTask(serverInfo);
    getCubridConfParameterTask.execute();
    assertEquals(null, getCubridConfParameterTask.getErrorMsg());
    Map<String, Map<String, String>> confParas = getCubridConfParameterTask.getConfParameters();
    if (serverInfo != null) {
        serverInfo.setCubridConfParaMap(confParas);
    }
    //get broker Info
    GetBrokerConfParameterTask getBrokerConfParameterTask = new GetBrokerConfParameterTask(serverInfo);
    getBrokerConfParameterTask.execute();
    assertEquals(null, getBrokerConfParameterTask.getErrorMsg());
    confParas = getBrokerConfParameterTask.getConfParameters();
    if (serverInfo != null) {
        serverInfo.setBrokerConfParaMap(confParas);
    }
    //Set JDBC driver
    String filePath = this.getFilePathInPlugin("/lib/JDBC-8.3.0.1004-cubrid.jar");
    if (filePath != null) {
        String version = JdbcClassLoaderFactory.validateJdbcFile(filePath);
        if (version != null) {
            JdbcClassLoaderFactory.registerClassLoader(filePath);
            serverInfo.setJdbcDriverVersion(version);
        }
    }
    filePath = this.getFilePathInPlugin("/lib/JDBC-8.3.1.0173-cubrid.jar");
    if (filePath != null) {
        String version = JdbcClassLoaderFactory.validateJdbcFile(filePath);
        if (version != null) {
            JdbcClassLoaderFactory.registerClassLoader(filePath);
            serverInfo.setJdbcDriverVersion(version);
        }
    }
    filePath = this.getFilePathInPlugin("/lib/JDBC-8.4.0.0196-cubrid.jar");
    if (filePath != null) {
        String version = JdbcClassLoaderFactory.validateJdbcFile(filePath);
        if (version != null) {
            JdbcClassLoaderFactory.registerClassLoader(filePath);
            serverInfo.setJdbcDriverVersion(version);
        }
    }
}

Example 9 with ServerInfo

use of com.cubrid.cubridmanager.core.common.model.ServerInfo in project cubrid-manager by CUBRID.

the class SetupEnvTestCase method setupDatabaseInfo930.

/**
	 * Setup database 9.3.0
	 *
	 */
private void setupDatabaseInfo930() throws Exception {
    serverInfo930 = new ServerInfo();
    serverInfo930.setHostAddress(host930);
    serverInfo930.setHostMonPort(monport930);
    serverInfo930.setHostJSPort(jpport930);
    serverInfo930.setUserName(userName930);
    serverInfo930.setUserPassword(passwd930);
    serverInfo930.setJdbcDriverVersion(serverVersion930);
    ServerManager.getInstance().addServer(host930, monport930, userName930, serverInfo930);
    MonitoringTask monTask = new MonitoringTask(serverInfo930);
    serverInfo930 = monTask.connectServer(serverVersion930, 1000);
    // get the latest token
    token930 = serverInfo930.getHostToken();
    //get evnInfo
    if (envInfo930 == null) {
        GetEnvInfoTask envTask = new GetEnvInfoTask(serverInfo930);
        envTask.loadEnvInfo();
        envTask.execute();
        envInfo930 = envTask.loadEnvInfo();
        serverInfo930.setEnvInfo(envInfo930);
    }
    assertNotNull(envInfo930);
    serverPath930 = envInfo930.getRootDir();
    dbRootDir930 = envInfo930.getDatabaseDir();
    //get server type
    GetCMConfParameterTask getCMConfParameterTask = new GetCMConfParameterTask(serverInfo930);
    getCMConfParameterTask.execute();
    assertEquals(null, getCMConfParameterTask.getErrorMsg());
    Map<String, String> confParameters = getCMConfParameterTask.getConfParameters();
    ServerType serverType = ServerType.BOTH;
    if (confParameters != null) {
        String target = confParameters.get(ConfConstants.CM_TARGET);
        if (target != null) {
            if (target.indexOf("broker") >= 0 && target.indexOf("server") >= 0) {
                serverType = ServerType.BOTH;
            } else if (target.indexOf("broker") >= 0) {
                serverType = ServerType.BROKER;
            } else if (target.indexOf("server") >= 0) {
                serverType = ServerType.DATABASE;
            }
        }
    }
    if (serverInfo930 != null) {
        serverInfo930.setServerType(serverType);
    }
    //Get database list task
    if (serverType == ServerType.DATABASE || serverType == ServerType.BOTH) {
        final GetDatabaseListTask getDatabaseListTask = new GetDatabaseListTask(serverInfo930);
        getDatabaseListTask.execute();
        assertEquals(null, getDatabaseListTask.getErrorMsg());
        List<DatabaseInfo> databaseInfoList = getDatabaseListTask.loadDatabaseInfo();
        for (DatabaseInfo dbInfo : databaseInfoList) {
            if (dbInfo.getDbName().equals(testDbName930)) {
                databaseInfo930 = dbInfo;
                break;
            }
        }
        if (databaseInfo930 == null) {
            return;
        }
    }
    //get CubridManager user list task
    GetCMUserListTask getUserInfoTask = new GetCMUserListTask(serverInfo930);
    getUserInfoTask.execute();
    assertEquals(null, getUserInfoTask.getErrorMsg());
    List<ServerUserInfo> serverUserInfoList = getUserInfoTask.getServerUserInfoList();
    for (int i = 0; serverUserInfoList != null && i < serverUserInfoList.size(); i++) {
        ServerUserInfo userInfo = serverUserInfoList.get(i);
        if (userInfo != null && userInfo.getUserName().equals(serverInfo930.getUserName())) {
            serverInfo930.setLoginedUserInfo(userInfo);
            break;
        }
    }
    List<DatabaseInfo> databaseInfoList = serverInfo930.getLoginedUserInfo().getDatabaseInfoList();
    String dbDir = databaseInfo930.getDbDir();
    DbRunningType type = databaseInfo930.getRunningType();
    for (int i = 0; databaseInfoList != null && i < databaseInfoList.size(); i++) {
        if (testDbName930.equalsIgnoreCase(databaseInfoList.get(i).getDbName())) {
            databaseInfo930 = databaseInfoList.get(i);
            databaseInfo930.setDbDir(dbDir);
            databaseInfo930.setBrokerIP(host930);
            databaseInfo930.setBrokerPort(port930);
            databaseInfo930.setCharSet(charset930);
            databaseInfo930.setRunningType(type);
            break;
        }
    }
    //get CUBRID conf parameter
    GetCubridConfParameterTask getCubridConfParameterTask = new GetCubridConfParameterTask(serverInfo930);
    getCubridConfParameterTask.execute();
    assertEquals(null, getCubridConfParameterTask.getErrorMsg());
    Map<String, Map<String, String>> confParas = getCubridConfParameterTask.getConfParameters();
    if (serverInfo930 != null) {
        serverInfo930.setCubridConfParaMap(confParas);
    }
    //get broker Info
    GetBrokerConfParameterTask getBrokerConfParameterTask = new GetBrokerConfParameterTask(serverInfo930);
    getBrokerConfParameterTask.execute();
    assertEquals(null, getBrokerConfParameterTask.getErrorMsg());
    confParas = getBrokerConfParameterTask.getConfParameters();
    if (serverInfo930 != null) {
        serverInfo930.setBrokerConfParaMap(confParas);
    }
    //Set JDBC driver
    String filePath = this.getFilePathInPlugin("/lib/JDBC-9.2.0.0155-cubrid.jar");
    if (filePath != null) {
        String version = JdbcClassLoaderFactory.validateJdbcFile(filePath);
        if (version != null) {
            JdbcClassLoaderFactory.registerClassLoader(filePath);
            serverInfo930.setJdbcDriverVersion(version);
        }
    }
}

Example 10 with ServerInfo

use of com.cubrid.cubridmanager.core.common.model.ServerInfo in project cubrid-manager by CUBRID.

the class JDBCConnectionManagerTest method testShardBroker.

public void testShardBroker() {
    assertTrue(JDBCConnectionManager.testShardBroker(databaseInfo, 1));
    assertFalse(JDBCConnectionManager.testShardBroker(new DatabaseInfo("", new ServerInfo()), 1));
}