@Test public void mysqlParse3() { DatabaseInfo dbInfo = jdbcUrlParser.parse( "jdbc:mysql://61.74.71.31/log?useUnicode=yes&characterEncoding=UTF-8"); Assert.assertEquals(dbInfo.getType(), MySqlConstants.MYSQL); Assert.assertEquals(dbInfo.getHost().get(0), "61.74.71.31"); Assert.assertEquals(dbInfo.getDatabaseId(), "log"); Assert.assertEquals(dbInfo.getUrl(), "jdbc:mysql://61.74.71.31/log"); logger.info(dbInfo.toString()); }
@Test public void mysqlParseCookierunMaster() { DatabaseInfo dbInfo = jdbcUrlParser.parse( "jdbc:mysql://10.115.8.209:5605/db_cookierun?useUnicode=true&characterEncoding=UTF-8&noAccessToProcedureBodies=true&autoDeserialize=true&elideSetAutoCommits=true&sessionVariables=time_zone='%2B09:00',tx_isolation='READ-COMMITTED'"); Assert.assertEquals(dbInfo.getType(), MySqlConstants.MYSQL); Assert.assertEquals(dbInfo.getHost().get(0), "10.115.8.209:5605"); Assert.assertEquals(dbInfo.getDatabaseId(), "db_cookierun"); Assert.assertEquals(dbInfo.getUrl(), "jdbc:mysql://10.115.8.209:5605/db_cookierun"); logger.info(dbInfo.toString()); }
@Test public void mysqlParse2() { DatabaseInfo dbInfo = jdbcUrlParser.parse("jdbc:mysql://10.98.133.22:3306/test_lucy_db"); Assert.assertEquals(dbInfo.getType(), MySqlConstants.MYSQL); Assert.assertEquals(dbInfo.getHost().get(0), "10.98.133.22:3306"); Assert.assertEquals(dbInfo.getDatabaseId(), "test_lucy_db"); Assert.assertEquals(dbInfo.getUrl(), "jdbc:mysql://10.98.133.22:3306/test_lucy_db"); logger.info(dbInfo.toString()); logger.info(dbInfo.getMultipleHost()); }