How to use isNull method of org.cerberus.util.StringUtil class

Best Cerberus-source code snippet using org.cerberus.util.StringUtil.isNull

Source:TestCaseExecutionDAO.java Github

copy

Full Screen

...284 //SQL_CALC_FOUND_ROWS allows to retrieve the total number of columns by disrearding the limit clauses that 285 //were applied -- used for pagination p286 query.append("select * from testcaseexecution exe ");287 searchSQL.append(" where 1=1 ");288 if (!StringUtil.isNullOrEmpty(application)) {289 searchSQL.append(" and (`application` = ? )");290 }291 query.append(searchSQL);292 query.append(" order by id DESC limit 1 ");293 // Debug message on SQL.294 if (LOG.isDebugEnabled()) {295 LOG.debug("SQL : " + query);296 }297 Connection connection = this.databaseSpring.connect();298 try {299 PreparedStatement preStat = connection.prepareStatement(query.toString());300 try {301 int i = 1;302 if (!StringUtil.isNullOrEmpty(application)) {303 preStat.setString(i++, application);304 }305 ResultSet resultSet = preStat.executeQuery();306 try {307 if (resultSet.first()) {308 result = loadFromResultSet(resultSet);309 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);310 msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "SELECT"));311 ans.setItem(result);312 } else {313 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);314 }315 } catch (SQLException exception) {316 LOG.error("Unable to execute query : " + exception.toString());317 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);318 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));319 } finally {320 resultSet.close();321 }322 } catch (SQLException exception) {323 LOG.error("Unable to execute query : " + exception.toString());324 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);325 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));326 } finally {327 preStat.close();328 }329 } catch (SQLException exception) {330 LOG.error("Unable to execute query : " + exception.toString());331 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);332 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));333 } finally {334 try {335 if (connection != null) {336 connection.close();337 }338 } catch (SQLException exception) {339 LOG.warn("Unable to close connection : " + exception.toString());340 }341 }342 //sets the message343 ans.setResultMessage(msg);344 return ans;345 }346 @Override347 public TestCaseExecution findLastTCExecutionByCriteria(String test, String testcase, String environment, String country,348 String build, String revision) throws CerberusException {349 TestCaseExecution result = null;350 final String query = new StringBuffer("SELECT exe.* FROM testcaseexecution exe ")351 .append("WHERE exe.test = ? AND exe.testcase = ? AND exe.environment = ? ")352 .append("AND exe.country = ? AND exe.build = ? AND exe.revision = ? ")353 .append("ORDER BY exe.id DESC").toString();354 try (Connection connection = this.databaseSpring.connect();355 PreparedStatement preStat = connection.prepareStatement(query);) {356 preStat.setString(1, test);357 preStat.setString(2, testcase);358 preStat.setString(3, environment);359 preStat.setString(4, country);360 preStat.setString(5, build);361 preStat.setString(6, revision);362 try (ResultSet resultSet = preStat.executeQuery();) {363 if (resultSet.first()) {364 result = this.loadFromResultSet(resultSet);365 } else {366 throw new CerberusException(new MessageGeneral(MessageGeneralEnum.NO_DATA_FOUND));367 }368 } catch (SQLException exception) {369 LOG.error("Unable to execute query : " + exception.toString());370 }371 } catch (SQLException exception) {372 LOG.error("Unable to execute query : " + exception.toString());373 }374 return result;375 }376 @Override377 public TestCaseExecution findLastTCExecutionByCriteria(String test, String testCase, String environment, String country,378 String build, String revision, String browser, String browserVersion,379 String ip, String port, String tag) {380 TestCaseExecution result = null;381 final String query = new StringBuffer("SELECT exe.* FROM testcaseexecution exe ")382 .append("WHERE exe.test = ? AND exe.testcase = ? ")383 .append("AND exe.environment LIKE ? AND exe.country = ? AND exe.build LIKE ? ")384 .append("AND exe.revision LIKE ? AND exe.browser = ? AND exe.browserfullversion LIKE ? ")385 .append("AND exe.ip LIKE ? AND exe.port LIKE ? AND exe.tag LIKE ? ")386 .append("ORDER BY exe.id DESC").toString();387 try (Connection connection = this.databaseSpring.connect();388 PreparedStatement preStat = connection.prepareStatement(query);) {389 preStat.setString(1, test);390 preStat.setString(2, testCase);391 preStat.setString(3, ParameterParserUtil.wildcardIfEmpty(environment));392 preStat.setString(4, country);393 preStat.setString(5, ParameterParserUtil.wildcardIfEmpty(build));394 preStat.setString(6, ParameterParserUtil.wildcardIfEmpty(revision));395 preStat.setString(7, browser);396 preStat.setString(8, ParameterParserUtil.wildcardIfEmpty(browserVersion));397 preStat.setString(9, ParameterParserUtil.wildcardIfEmpty(ip));398 preStat.setString(10, ParameterParserUtil.wildcardIfEmpty(port));399 preStat.setString(11, ParameterParserUtil.wildcardIfEmpty(tag));400 try (ResultSet resultSet = preStat.executeQuery();) {401 if (resultSet.first()) {402 result = this.loadFromResultSet(resultSet);403 }404 } catch (SQLException exception) {405 LOG.error("Unable to execute query : " + exception.toString());406 }407 } catch (SQLException exception) {408 LOG.error("Unable to execute query : " + exception.toString());409 }410 return result;411 }412 @Override413 public List<TestCaseExecution> findExecutionbyCriteria1(String dateLimit, String test, String testCase, String application, String country, String environment, String controlStatus, String status) throws CerberusException {414 List<TestCaseExecution> myTestCaseExecutions = null;415 TestCaseExecution Execution;416 boolean throwException = false;417 final String query = new StringBuffer("SELECT exe.*, tec.*, app.* FROM testcaseexecution exe ")418 .append("LEFT JOIN testcase tec ON exe.test = tec.test AND exe.testcase = tec.testcase ")419 .append("LEFT JOIN application app ON exe.application = app.application ")420 .append("WHERE exe.start > ? AND exe.test LIKE ? AND exe.testcase LIKE ? AND exe.environment LIKE ? ")421 .append("AND exe.country LIKE ? AND exe.application LIKE ? AND exe.controlstatus LIKE ? ")422 .append("AND exe.status LIKE ?").toString();423 try (Connection connection = this.databaseSpring.connect();424 PreparedStatement preStat = connection.prepareStatement(query);) {425 preStat.setString(1, dateLimit);426 preStat.setString(2, test);427 preStat.setString(3, testCase);428 preStat.setString(4, environment);429 preStat.setString(5, country);430 preStat.setString(6, application);431 preStat.setString(7, controlStatus);432 preStat.setString(8, status);433 try (ResultSet resultSet = preStat.executeQuery();) {434 if (!(resultSet.first())) {435 throwException = true;436 } else {437 myTestCaseExecutions = new ArrayList<TestCaseExecution>();438 do {439 Execution = this.loadWithDependenciesFromResultSet(resultSet);440 myTestCaseExecutions.add(Execution);441 } while (resultSet.next());442 }443 } catch (SQLException exception) {444 LOG.error("Unable to execute query : " + exception.toString());445 }446 } catch (Exception exception) {447 LOG.error("Unable to execute query : " + exception.toString());448 }449 if (throwException) {450 throw new CerberusException(new MessageGeneral(MessageGeneralEnum.EXECUTION_FA));451 }452 return myTestCaseExecutions;453 }454 @Override455 public TestCaseExecution findTCExecutionByKey(long id) throws CerberusException {456 TestCaseExecution result = null;457 final String query = "SELECT * FROM testcaseexecution exe, application app WHERE exe.application = app.application AND ID = ?";458 // Debug message on SQL.459 if (LOG.isDebugEnabled()) {460 LOG.debug("SQL : " + query);461 }462 try (Connection connection = this.databaseSpring.connect();463 PreparedStatement preStat = connection.prepareStatement(query);) {464 preStat.setLong(1, id);465 try (ResultSet resultSet = preStat.executeQuery();) {466 if (resultSet.first()) {467 result = this.loadTestCaseExecutionAndApplicationFromResultSet(resultSet);468 }469 } catch (SQLException exception) {470 LOG.error("Unable to execute query : " + exception.toString());471 }472 } catch (SQLException exception) {473 LOG.error("Unable to execute query : " + exception.toString());474 }475 return result;476 }477 @Override478 public TestCaseExecution findLastTestCaseExecutionNotPE(String test, String testCase) throws CerberusException {479 TestCaseExecution result = null;480 StringBuilder query = new StringBuilder();481 query.append("SELECT exe.* FROM `testcaseexecution` exe ");482 query.append(" WHERE Test = ? and TestCase= ? and ID = ");483 query.append(" (SELECT MAX(ID) from `testcaseexecution` ");484 query.append("WHERE Test= ? and TestCase= ? and ControlStatus!='PE')");485 try (Connection connection = this.databaseSpring.connect();486 PreparedStatement preStat = connection.prepareStatement(query.toString());) {487 preStat.setString(1, test);488 preStat.setString(2, testCase);489 preStat.setString(3, test);490 preStat.setString(4, testCase);491 try (ResultSet resultSet = preStat.executeQuery();) {492 if (resultSet.first()) {493 result = loadFromResultSet(resultSet);494 }495 } catch (SQLException exception) {496 LOG.error("Unable to execute query : " + exception.toString());497 }498 } catch (SQLException exception) {499 LOG.error("Unable to execute query : " + exception.toString());500 }501 return result;502 }503 @Override504 public TestCaseExecution findLastTCExecutionInGroup(String test, String testCase, String environment, String country,505 String build, String revision, String browser, String browserVersion,506 String ip, String port, String tag) {507 TestCaseExecution result = null;508 StringBuilder query = new StringBuilder();509 query.append("SELECT exe.* FROM testcaseexecution exe ")510 .append("WHERE exe.test = ? AND exe.testcase = ? AND exe.country = ? AND exe.browser = ? ");511 if (!StringUtil.isNull(environment)) {512 query.append("AND exe.environment IN (");513 query.append(environment);514 query.append(") ");515 }516 if (!StringUtil.isNull(build)) {517 query.append("AND exe.build IN (");518 query.append(build);519 query.append(") ");520 }521 if (!StringUtil.isNull(revision)) {522 query.append("AND exe.revision IN (");523 query.append(revision);524 query.append(") ");525 }526 if (!StringUtil.isNull(browserVersion)) {527 query.append("AND exe.browserfullversion LIKE ? ");528 }529 if (!StringUtil.isNull(ip)) {530 query.append("AND exe.ip LIKE ? ");531 }532 if (!StringUtil.isNull(port)) {533 query.append("AND exe.port LIKE ? ");534 }535 if (!StringUtil.isNull(tag)) {536 query.append("AND exe.tag LIKE ? ");537 }538 query.append("ORDER BY exe.id DESC");539 try (Connection connection = this.databaseSpring.connect();540 PreparedStatement preStat = connection.prepareStatement(query.toString());) {541 preStat.setString(1, test);542 preStat.setString(2, testCase);543 preStat.setString(3, country);544 preStat.setString(4, browser);545 int i = 5;546 if (!StringUtil.isNull(browserVersion)) {547 preStat.setString(i, browserVersion);548 i++;549 }550 if (!StringUtil.isNull(ip)) {551 preStat.setString(i, ip);552 i++;553 }554 if (!StringUtil.isNull(port)) {555 preStat.setString(i, port);556 i++;557 }558 if (!StringUtil.isNull(tag)) {559 preStat.setString(i, tag);560 }561 try (ResultSet resultSet = preStat.executeQuery();) {562 if (resultSet.first()) {563 result = this.loadFromResultSet(resultSet);564 }565 } catch (SQLException exception) {566 LOG.error("Unable to execute query : " + exception.toString());567 }568 } catch (SQLException exception) {569 LOG.error("Unable to execute query : " + exception.toString());570 }571 return result;572 }573 @Override574 public List<String> findDistinctTag(boolean withUUIDTag) throws CerberusException {575 List<String> list = null;576 StringBuilder query = new StringBuilder();577 query.append("select distinct tag from testcaseexecution exe ")578 .append("where tag != '' ");579 if (!withUUIDTag) {580 query.append(" and length(tag) != length('c3888898-c65a-11e3-9b3e-0000004047e0')");581 }582 query.append(" UNION select distinct tag from testcaseexecutionqueue where tag !='' ");583 Connection connection = this.databaseSpring.connect();584 try {585 PreparedStatement preStat = connection.prepareStatement(query.toString());586 try {587 ResultSet resultSet = preStat.executeQuery();588 try {589 list = new ArrayList<String>();590 while (resultSet.next()) {591 list.add(resultSet.getString("tag"));592 }593 } catch (SQLException exception) {594 LOG.error("Unable to execute query : " + exception.toString());595 } finally {596 resultSet.close();597 }598 } catch (SQLException exception) {599 LOG.error("Unable to execute query : " + exception.toString());600 } finally {601 preStat.close();602 }603 } catch (SQLException exception) {604 LOG.error("Unable to execute query : " + exception.toString());605 } finally {606 try {607 if (connection != null) {608 connection.close();609 }610 } catch (SQLException e) {611 LOG.warn(e.toString());612 }613 }614 return list;615 }616 @Override617 public AnswerList findTagList(int tagnumber) {618 AnswerList response = new AnswerList();619 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);620 List<String> list = null;621 StringBuilder query = new StringBuilder();622 query.append("SELECT DISTINCT exe.tag FROM testcaseexecution exe WHERE tag != ''");623 if (tagnumber != 0) {624 query.append("ORDER BY id desc LIMIT ");625 query.append(tagnumber);626 }627 query.append(";");628 Connection connection = this.databaseSpring.connect();629 try {630 PreparedStatement preStat = connection.prepareStatement(query.toString());631 try {632 ResultSet resultSet = preStat.executeQuery();633 try {634 list = new ArrayList<String>();635 while (resultSet.next()) {636 list.add(resultSet.getString("exe.tag"));637 }638 msg.setDescription(msg.getDescription().replace("%ITEM%", "TagList").replace("%OPERATION%", "SELECT"));639 } catch (SQLException exception) {640 LOG.error("Unable to execute query : " + exception.toString());641 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);642 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));643 } finally {644 resultSet.close();645 }646 } catch (SQLException exception) {647 LOG.error("Unable to execute query : " + exception.toString());648 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);649 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));650 } finally {651 preStat.close();652 }653 } catch (SQLException exception) {654 LOG.error("Unable to execute query : " + exception.toString());655 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);656 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));657 } finally {658 try {659 if (connection != null) {660 connection.close();661 }662 } catch (SQLException e) {663 LOG.warn(e.toString());664 }665 }666 response.setResultMessage(msg);667 response.setDataList(list);668 return response;669 }670 @Override671 public void setTagToExecution(long id, String tag) throws CerberusException {672 boolean throwEx = false;673 final String query = "UPDATE testcaseexecution exe SET exe.tag = ? WHERE exe.id = ?";674 Connection connection = this.databaseSpring.connect();675 try {676 PreparedStatement preStat = connection.prepareStatement(query);677 try {678 preStat.setString(1, tag);679 preStat.setLong(2, id);680 preStat.executeUpdate();681 } catch (SQLException exception) {682 LOG.error("Unable to execute query : " + exception.toString());683 throwEx = true;684 } finally {685 preStat.close();686 }687 } catch (SQLException exception) {688 LOG.error("Unable to execute query : " + exception.toString());689 } finally {690 try {691 if (connection != null) {692 connection.close();693 }694 } catch (SQLException e) {695 LOG.warn(e.toString());696 }697 }698 if (throwEx) {699 throw new CerberusException(new MessageGeneral(MessageGeneralEnum.CANNOT_UPDATE_TABLE));700 }701 }702 @Override703 public AnswerList readByTagByCriteria(String tag, int start, int amount, String sort, String searchTerm, Map<String, List<String>> individualSearch) throws CerberusException {704 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);705 AnswerList answer = new AnswerList();706 List<String> individalColumnSearchValues = new ArrayList<String>();707 final StringBuffer query = new StringBuffer();708 query.append("SELECT * FROM testcaseexecution exe ");709 query.append("left join testcase tec on exe.Test = tec.Test and exe.TestCase = tec.TestCase ");710 query.append("left join application app on tec.application = app.application ");711 query.append("where exe.ID IN ");712 query.append("(select MAX(exe.ID) from testcaseexecution exe ");713 query.append("where 1=1 ");714 if (!StringUtil.isNullOrEmpty(tag)) {715 query.append("and exe.tag = ? ");716 }717 query.append("group by exe.test, exe.testcase, exe.Environment, exe.Browser, exe.Country) ");718 if (!StringUtil.isNullOrEmpty(searchTerm)) {719 query.append("and (exe.`test` like ? ");720 query.append(" or exe.`testCase` like ? ");721 query.append(" or exe.`application` like ? ");722 query.append(" or tec.`bugid` like ? ");723 query.append(" or tec.`priority` like ? ");724 query.append(" or tec.`description` like ? )");725 }726 if (individualSearch != null && !individualSearch.isEmpty()) {727 query.append(" and ( 1=1 ");728 for (Map.Entry<String, List<String>> entry : individualSearch.entrySet()) {729 query.append(" and ");730 query.append(SqlUtil.getInSQLClauseForPreparedStatement(entry.getKey(), entry.getValue()));731 individalColumnSearchValues.addAll(entry.getValue());732 }733 query.append(" ) ");734 }735 if (!StringUtil.isNullOrEmpty(sort)) {736 query.append(" order by ").append(sort);737 }738 if ((amount <= 0) || (amount >= MAX_ROW_SELECTED)) {739 query.append(" limit ").append(start).append(" , ").append(MAX_ROW_SELECTED);740 } else {741 query.append(" limit ").append(start).append(" , ").append(amount);742 }743 // Debug message on SQL.744 if (LOG.isDebugEnabled()) {745 LOG.debug("SQL : " + query.toString());746 LOG.debug("SQL.param.tag : " + tag);747 }748 List<TestCaseExecution> testCaseExecutionList = new ArrayList<TestCaseExecution>();749 Connection connection = this.databaseSpring.connect();750 try {751 PreparedStatement preStat = connection.prepareStatement(query.toString());752 int i = 1;753 if (!StringUtil.isNullOrEmpty(tag)) {754 preStat.setString(i++, tag);755 }756 if (!Strings.isNullOrEmpty(searchTerm)) {757 preStat.setString(i++, "%" + searchTerm + "%");758 preStat.setString(i++, "%" + searchTerm + "%");759 preStat.setString(i++, "%" + searchTerm + "%");760 preStat.setString(i++, "%" + searchTerm + "%");761 preStat.setString(i++, "%" + searchTerm + "%");762 preStat.setString(i++, "%" + searchTerm + "%");763 }764 for (String individualColumnSearchValue : individalColumnSearchValues) {765 preStat.setString(i++, individualColumnSearchValue);766 }767 try {768 ResultSet resultSet = preStat.executeQuery();769 try {770 while (resultSet.next()) {771 testCaseExecutionList.add(this.loadWithDependenciesFromResultSet(resultSet));772 }773 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));774// answer = new AnswerList(testCaseExecutionList, testCaseExecutionList.size());775 answer.setTotalRows(testCaseExecutionList.size());776 } catch (SQLException exception) {777 LOG.warn("Unable to execute query : " + exception.toString());778 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);779 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));780 testCaseExecutionList = null;781 } finally {782 resultSet.close();783 }784 } catch (SQLException exception) {785 LOG.warn("Unable to execute query : " + exception.toString());786 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);787 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));788 testCaseExecutionList = null;789 } finally {790 preStat.close();791 }792 } catch (SQLException exception) {793 LOG.warn("Unable to execute query : " + exception.toString());794 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);795 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));796 testCaseExecutionList = null;797 } finally {798 try {799 if (connection != null) {800 connection.close();801 }802 } catch (SQLException e) {803 LOG.warn(e.toString());804 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);805 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));806 }807 }808 answer.setResultMessage(msg);809 answer.setDataList(testCaseExecutionList);810 return answer;811 }812 @Override813 public AnswerList readByTag(String tag) throws CerberusException {814 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);815 AnswerList answer = new AnswerList();816 final StringBuffer query = new StringBuffer();817 query.append("SELECT * FROM testcaseexecution exe ");818 query.append("left join testcase tec on exe.Test = tec.Test and exe.TestCase = tec.TestCase ");819 query.append("left join application as app on tec.application = app.application ");820 query.append("where 1=1 and exe.tag = ? ");821 // Debug message on SQL.822 if (LOG.isDebugEnabled()) {823 LOG.debug("SQL : " + query.toString());824 LOG.debug("SQL.param.tag : " + tag);825 }826 List<TestCaseExecution> testCaseExecutionList = new ArrayList<TestCaseExecution>();827 Connection connection = this.databaseSpring.connect();828 try {829 PreparedStatement preStat = connection.prepareStatement(query.toString());830 preStat.setString(1, tag);831 try {832 ResultSet resultSet = preStat.executeQuery();833 try {834 while (resultSet.next()) {835 testCaseExecutionList.add(this.loadWithDependenciesFromResultSet(resultSet));836 }837 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));838 answer.setTotalRows(testCaseExecutionList.size());839 } catch (SQLException exception) {840 LOG.warn("Unable to execute query : " + exception.toString());841 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);842 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));843 testCaseExecutionList = null;844 } finally {845 resultSet.close();846 }847 } catch (SQLException exception) {848 LOG.warn("Unable to execute query : " + exception.toString());849 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);850 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));851 testCaseExecutionList = null;852 } finally {853 preStat.close();854 }855 } catch (SQLException exception) {856 LOG.warn("Unable to execute query : " + exception.toString());857 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);858 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));859 testCaseExecutionList = null;860 } finally {861 try {862 if (connection != null) {863 connection.close();864 }865 } catch (SQLException e) {866 LOG.warn(e.toString());867 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);868 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));869 }870 }871 answer.setResultMessage(msg);872 answer.setDataList(testCaseExecutionList);873 return answer;874 }875 @Override876 public AnswerList readByCriteria(int start, int amount, String sort, String searchTerm, Map<String, List<String>> individualSearch, List<String> individualLike) throws CerberusException {877 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);878 AnswerList answer = new AnswerList();879 List<String> individalColumnSearchValues = new ArrayList<String>();880 final StringBuffer query = new StringBuffer();881 query.append("SELECT * FROM testcaseexecution exe ");882 query.append("where exe.`start`> '").append(DateUtil.getMySQLTimestampTodayDeltaMinutes(-360000)).append("' ");883 if (!StringUtil.isNullOrEmpty(searchTerm)) {884 query.append("and (exe.`id` like ? ");885 query.append(" or exe.`test` like ? ");886 query.append(" or exe.`testCase` like ? ");887 query.append(" or exe.`build` like ? ");888 query.append(" or exe.`revision` like ? ");889 query.append(" or exe.`environment` like ? ");890 query.append(" or exe.`country` like ? ");891 query.append(" or exe.`browser` like ? ");892 query.append(" or exe.`version` like ? ");893 query.append(" or exe.`platform` like ? ");894 query.append(" or exe.`browserfullversion` like ? ");895 query.append(" or exe.`start` like ? ");896 query.append(" or exe.`end` like ? ");897 query.append(" or exe.`controlstatus` like ? ");898 query.append(" or exe.`controlmessage` like ? ");899 query.append(" or exe.`application` like ? ");900 query.append(" or exe.`ip` like ? ");901 query.append(" or exe.`url` like ? ");902 query.append(" or exe.`port` like ? ");903 query.append(" or exe.`tag` like ? ");904 query.append(" or exe.`end` like ? ");905 query.append(" or exe.`status` like ? ");906 query.append(" or exe.`crbversion` like ? ");907 query.append(" or exe.`executor` like ? ");908 query.append(" or exe.`screensize` like ? ");909 query.append(" or exe.`userAgent` like ? )");910 }911 if (individualSearch != null && !individualSearch.isEmpty()) {912 query.append(" and ( 1=1 ");913 for (Map.Entry<String, List<String>> entry : individualSearch.entrySet()) {914 query.append(" and ");915 query.append(SqlUtil.getInSQLClauseForPreparedStatement(entry.getKey(), entry.getValue()));916 individalColumnSearchValues.addAll(entry.getValue());917 }918 query.append(" ) ");919 }920 if (!StringUtil.isNullOrEmpty(sort)) {921 query.append(" order by ").append(sort);922 }923 if ((amount <= 0) || (amount >= MAX_ROW_SELECTED)) {924 query.append(" limit ").append(start).append(" , ").append(MAX_ROW_SELECTED);925 } else {926 query.append(" limit ").append(start).append(" , ").append(amount);927 }928 // Debug message on SQL.929 if (LOG.isDebugEnabled()) {930 LOG.debug("SQL : " + query.toString());931 }932 List<TestCaseExecution> testCaseExecutionList = new ArrayList<TestCaseExecution>();933 Connection connection = this.databaseSpring.connect();934 try {935 PreparedStatement preStat = connection.prepareStatement(query.toString());936 int i = 1;937 if (!Strings.isNullOrEmpty(searchTerm)) {938 preStat.setString(i++, "%" + searchTerm + "%");939 preStat.setString(i++, "%" + searchTerm + "%");940 preStat.setString(i++, "%" + searchTerm + "%");941 preStat.setString(i++, "%" + searchTerm + "%");942 preStat.setString(i++, "%" + searchTerm + "%");943 preStat.setString(i++, "%" + searchTerm + "%");944 preStat.setString(i++, "%" + searchTerm + "%");945 preStat.setString(i++, "%" + searchTerm + "%");946 preStat.setString(i++, "%" + searchTerm + "%");947 preStat.setString(i++, "%" + searchTerm + "%");948 preStat.setString(i++, "%" + searchTerm + "%");949 preStat.setString(i++, "%" + searchTerm + "%");950 preStat.setString(i++, "%" + searchTerm + "%");951 preStat.setString(i++, "%" + searchTerm + "%");952 preStat.setString(i++, "%" + searchTerm + "%");953 preStat.setString(i++, "%" + searchTerm + "%");954 preStat.setString(i++, "%" + searchTerm + "%");955 preStat.setString(i++, "%" + searchTerm + "%");956 preStat.setString(i++, "%" + searchTerm + "%");957 preStat.setString(i++, "%" + searchTerm + "%");958 preStat.setString(i++, "%" + searchTerm + "%");959 preStat.setString(i++, "%" + searchTerm + "%");960 preStat.setString(i++, "%" + searchTerm + "%");961 preStat.setString(i++, "%" + searchTerm + "%");962 preStat.setString(i++, "%" + searchTerm + "%");963 preStat.setString(i++, "%" + searchTerm + "%");964 }965 for (String individualColumnSearchValue : individalColumnSearchValues) {966 preStat.setString(i++, individualColumnSearchValue);967 }968 try {969 ResultSet resultSet = preStat.executeQuery();970 try {971 while (resultSet.next()) {972 testCaseExecutionList.add(this.loadFromResultSet(resultSet));973 }974 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));975// answer = new AnswerList(testCaseExecutionList, testCaseExecutionList.size());976 answer.setTotalRows(testCaseExecutionList.size());977 } catch (SQLException exception) {978 LOG.warn("Unable to execute query : " + exception.toString());979 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);980 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));981 testCaseExecutionList = null;982 } finally {983 resultSet.close();984 }985 } catch (SQLException exception) {986 LOG.warn("Unable to execute query : " + exception.toString());987 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);988 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));989 testCaseExecutionList = null;990 } finally {991 preStat.close();992 }993 } catch (SQLException exception) {994 LOG.warn("Unable to execute query : " + exception.toString());995 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);996 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));997 testCaseExecutionList = null;998 } finally {999 try {1000 if (connection != null) {1001 connection.close();1002 }1003 } catch (SQLException e) {1004 LOG.warn(e.toString());1005 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1006 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1007 }1008 }1009 answer.setResultMessage(msg);1010 answer.setDataList(testCaseExecutionList);1011 return answer;1012 }1013 @Override1014 public AnswerList readDistinctEnvCoutnryBrowserByTag(String tag) {1015 AnswerList answer = new AnswerList();1016 StringBuilder query = new StringBuilder();1017 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);1018 query.append("SELECT exe.* FROM testcaseexecution exe WHERE exe.tag = ? GROUP BY exe.Environment, exe.Country, exe.Browser, exe.ControlStatus");1019 Connection connection = this.databaseSpring.connect();1020 List<TestCaseExecution> testCaseExecutionList = new ArrayList<TestCaseExecution>();1021 try {1022 PreparedStatement preStat = connection.prepareStatement(query.toString());1023 preStat.setString(1, tag);1024 try {1025 ResultSet resultSet = preStat.executeQuery();1026 try {1027 while (resultSet.next()) {1028 testCaseExecutionList.add(this.loadFromResultSet(resultSet));1029 }1030 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));1031 answer = new AnswerList(testCaseExecutionList, testCaseExecutionList.size());1032 } catch (SQLException exception) {1033 LOG.warn("Unable to execute query : " + exception.toString());1034 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1035 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1036 testCaseExecutionList = null;1037 } finally {1038 if (resultSet != null) {1039 resultSet.close();1040 }1041 }1042 } catch (SQLException ex) {1043 LOG.warn("Unable to execute query : " + ex.toString());1044 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1045 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1046 testCaseExecutionList = null;1047 } finally {1048 if (preStat != null) {1049 preStat.close();1050 }1051 }1052 } catch (SQLException ex) {1053 LOG.warn(ex.toString());1054 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1055 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1056 } finally {1057 try {1058 if (connection != null) {1059 connection.close();1060 }1061 } catch (SQLException ex) {1062 LOG.warn("Unable to execute query : " + ex.toString());1063 }1064 }1065 answer.setResultMessage(msg);1066 return answer;1067 }1068 @Override1069 public AnswerList readDistinctColumnByTag(String tag, boolean env, boolean country, boolean browser, boolean app) {1070 AnswerList answer = new AnswerList();1071 StringBuilder query = new StringBuilder();1072 StringBuilder distinct = new StringBuilder();1073 int prev = 0;1074 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);1075 if (!(!env && !country && !app && !browser)) {1076 if (env) {1077 distinct.append("Environment");1078 prev++;1079 }1080 if (country) {1081 if (prev != 0) {1082 prev = 0;1083 distinct.append(",");1084 }1085 distinct.append("Country");1086 prev++;1087 }1088 if (browser) {1089 if (prev != 0) {1090 prev = 0;1091 distinct.append(",");1092 }1093 distinct.append("Browser");1094 prev++;1095 }1096 if (app) {1097 if (prev != 0) {1098 prev = 0;1099 distinct.append(",");1100 }1101 distinct.append("Application");1102 }1103 query.append("SELECT ");1104 query.append(distinct.toString());1105 query.append(" FROM testcaseexecution exe WHERE exe.tag = ? GROUP BY ");1106 query.append(distinct.toString());1107 } else {1108 //If there is no distinct, select nothing1109 query.append("SELECT * FROM testcaseexecution exe WHERE 1 = 0 AND exe.tag = ?");1110 }1111 Connection connection = this.databaseSpring.connect();1112 List<TestCaseExecution> column = new ArrayList<TestCaseExecution>();1113 try {1114 PreparedStatement preStat = connection.prepareStatement(query.toString());1115 preStat.setString(1, tag);1116 try {1117 ResultSet resultSet = preStat.executeQuery();1118 try {1119 while (resultSet.next()) {1120 TestCaseExecution tmp = new TestCaseExecution();1121 if (env) {1122 tmp.setEnvironment(resultSet.getString("Environment"));1123 } else {1124 tmp.setEnvironment("");1125 }1126 if (country) {1127 tmp.setCountry(resultSet.getString("Country"));1128 } else {1129 tmp.setCountry("");1130 }1131 if (browser) {1132 tmp.setBrowser(resultSet.getString("Browser"));1133 } else {1134 tmp.setBrowser("");1135 }1136 if (app) {1137 tmp.setApplication(resultSet.getString("Application"));1138 } else {1139 tmp.setApplication("");1140 }1141 column.add(tmp);1142 }1143 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));1144 answer = new AnswerList(column, column.size());1145 } catch (SQLException exception) {1146 LOG.warn("Unable to execute query : " + exception.toString());1147 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1148 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1149 column = null;1150 } finally {1151 if (resultSet != null) {1152 resultSet.close();1153 }1154 }1155 } catch (SQLException ex) {1156 LOG.warn("Unable to execute query : " + ex.toString());1157 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1158 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1159 column = null;1160 } finally {1161 if (preStat != null) {1162 preStat.close();1163 }1164 }1165 } catch (SQLException ex) {1166 LOG.warn(ex.toString());1167 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1168 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1169 } finally {1170 try {1171 if (connection != null) {1172 connection.close();1173 }1174 } catch (SQLException ex) {1175 LOG.warn("Unable to execute query : " + ex.toString());1176 }1177 }1178 answer.setResultMessage(msg);1179 return answer;1180 }1181 @Override1182 public AnswerList readBySystemByVarious(String system, List<String> testList, List<String> applicationList, List<String> projectList, List<String> tcstatusList,1183 List<String> groupList, List<String> tcactiveList, List<String> priorityList, List<String> targetsprintList, List<String> targetrevisionList,1184 List<String> creatorList, List<String> implementerList, List<String> buildList, List<String> revisionList, List<String> environmentList,1185 List<String> countryList, List<String> browserList, List<String> tcestatusList, String ip, String port, String tag, String browserversion,1186 String comment, String bugid, String ticket) {1187 AnswerList answer = new AnswerList();1188 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);1189 List<TestCaseExecution> tceList = new ArrayList<TestCaseExecution>();1190 List<String> whereClauses = new LinkedList<String>();1191 StringBuilder query = new StringBuilder();1192 int paramNumber = 0;1193 query.append(" select t.ID as statusExecutionID, t.* from ( ");1194 query.append(" select exe.*, tec.*, app.* ");1195 query.append(" from testcaseexecution exe ");1196 query.append(" inner join testcase tec on exe.test = tec.test and exe.testcase = tec.testcase ");1197 query.append(" inner join application app on exe.application = app.application ");1198 String testClause = SqlUtil.generateInClause("exe.test", testList);1199 if (!StringUtil.isNullOrEmpty(testClause)) {1200 whereClauses.add(testClause);1201 }1202 String applicationClause = SqlUtil.generateInClause("exe.application", applicationList);1203 if (!StringUtil.isNullOrEmpty(applicationClause)) {1204 whereClauses.add(applicationClause);1205 }1206 String projectClause = SqlUtil.generateInClause("tec.project", projectList);1207 if (!StringUtil.isNullOrEmpty(projectClause)) {1208 whereClauses.add(projectClause);1209 }1210 //test case status: working, fully_implemented, ...1211 String tcsClause = SqlUtil.generateInClause("exe.status", tcstatusList);1212 if (!StringUtil.isNullOrEmpty(tcsClause)) {1213 whereClauses.add(tcsClause);1214 }1215 //group 1216 String groupClause = SqlUtil.generateInClause("tec.group", groupList);1217 if (!StringUtil.isNullOrEmpty(groupClause)) {1218 whereClauses.add(groupClause);1219 }1220 //test case active1221 String tcactiveClause = SqlUtil.generateInClause("tec.tcactive", tcactiveList);1222 if (!StringUtil.isNullOrEmpty(tcactiveClause)) {1223 whereClauses.add(tcactiveClause);1224 }1225 //test case active1226 String priorityClause = SqlUtil.generateInClause("tec.Priority", priorityList);1227 if (!StringUtil.isNullOrEmpty(priorityClause)) {1228 whereClauses.add(priorityClause);1229 }1230 //target sprint1231 String targetsprintClause = SqlUtil.generateInClause("tec.TargetBuild", targetsprintList);1232 if (!StringUtil.isNullOrEmpty(targetsprintClause)) {1233 whereClauses.add(targetsprintClause);1234 }1235 //target revision1236 String targetrevisionClause = SqlUtil.generateInClause("tec.TargetRev", targetrevisionList);1237 if (!StringUtil.isNullOrEmpty(targetrevisionClause)) {1238 whereClauses.add(targetrevisionClause);1239 }1240 //creator1241 String creatorClause = SqlUtil.generateInClause("tec.UsrCreated", creatorList);1242 if (!StringUtil.isNullOrEmpty(creatorClause)) {1243 whereClauses.add(creatorClause);1244 }1245 //implementer1246 String implementerClause = SqlUtil.generateInClause("tec.Implementer", implementerList);1247 if (!StringUtil.isNullOrEmpty(implementerClause)) {1248 whereClauses.add(implementerClause);1249 }1250 //build1251 String buildClause = SqlUtil.generateInClause("exe.Build", buildList);1252 if (!StringUtil.isNullOrEmpty(buildClause)) {1253 whereClauses.add(buildClause);1254 }1255 //revision1256 String revisionClause = SqlUtil.generateInClause("exe.Revision", revisionList);1257 if (!StringUtil.isNullOrEmpty(revisionClause)) {1258 whereClauses.add(revisionClause);1259 }1260 //environment1261 String environmentClause = SqlUtil.generateInClause("exe.Environment", environmentList);1262 if (!StringUtil.isNullOrEmpty(environmentClause)) {1263 whereClauses.add(environmentClause);1264 }1265 //country1266 String countryClause = SqlUtil.generateInClause("exe.Country", countryList);1267 if (!StringUtil.isNullOrEmpty(countryClause)) {1268 whereClauses.add(countryClause);1269 }1270 //browser1271 String browserClause = SqlUtil.generateInClause("exe.Browser", browserList);1272 if (!StringUtil.isNullOrEmpty(browserClause)) {1273 whereClauses.add(browserClause);1274 }1275 //test case execution1276 String tcestatusClause = SqlUtil.generateInClause("exe.ControlStatus", tcestatusList);1277 if (!StringUtil.isNullOrEmpty(tcestatusClause)) {1278 whereClauses.add(tcestatusClause);1279 }1280 if (!StringUtil.isNullOrEmpty(system)) {1281 whereClauses.add(" app.system like ? ");1282 }1283 if (!StringUtil.isNullOrEmpty(ip)) {1284 whereClauses.add(" exe.IP like ? ");1285 }1286 if (!StringUtil.isNullOrEmpty(port)) {1287 whereClauses.add(" exe.port like ? ");1288 }1289 if (!StringUtil.isNullOrEmpty(tag)) {1290 whereClauses.add(" exe.tag like ? ");1291 }1292 if (!StringUtil.isNullOrEmpty(browserversion)) {1293 whereClauses.add(" exe.browserfullversion like ? ");1294 }1295 if (!StringUtil.isNullOrEmpty(comment)) {1296 whereClauses.add(" exe.comment like ? ");1297 }1298 if (!StringUtil.isNullOrEmpty(bugid)) {1299 whereClauses.add(" tec.BugID like ? ");1300 }1301 if (!StringUtil.isNullOrEmpty(ticket)) {1302 whereClauses.add(" tec.Ticket like ? ");1303 }1304 if (whereClauses.size() > 0) {1305 query.append("where ");1306 String joined = StringUtils.join(whereClauses, " and ");1307 query.append(joined);1308 }1309 query.append(" order by exe.ID desc ");1310 query.append(" ) as t group by t.test, t.testcase, t.environment, t.browser, t.country");1311 Connection connection = this.databaseSpring.connect();1312 try {1313 PreparedStatement preStat = connection.prepareStatement(query.toString());1314 if (testList != null) {1315 for (String param : testList) {1316 preStat.setString(++paramNumber, param);1317 }1318 }1319 if (applicationList != null) {1320 for (String param : applicationList) {1321 preStat.setString(++paramNumber, param);1322 }1323 }1324 if (projectList != null) {1325 for (String param : projectList) {1326 preStat.setString(++paramNumber, param);1327 }1328 }1329 if (tcstatusList != null) {1330 for (String param : tcstatusList) {1331 preStat.setString(++paramNumber, param);1332 }1333 }1334 if (groupList != null) {1335 for (String param : groupList) {1336 preStat.setString(++paramNumber, param);1337 }1338 }1339 if (tcactiveList != null) {1340 for (String param : tcactiveList) {1341 preStat.setString(++paramNumber, param);1342 }1343 }1344 if (priorityList != null) {1345 for (String param : priorityList) {1346 preStat.setString(++paramNumber, param);1347 }1348 }1349 if (targetsprintList != null) {1350 for (String param : targetsprintList) {1351 preStat.setString(++paramNumber, param);1352 }1353 }1354 if (targetrevisionList != null) {1355 for (String param : targetrevisionList) {1356 preStat.setString(++paramNumber, param);1357 }1358 }1359 if (creatorList != null) {1360 for (String param : creatorList) {1361 preStat.setString(++paramNumber, param);1362 }1363 }1364 if (implementerList != null) {1365 for (String param : implementerList) {1366 preStat.setString(++paramNumber, param);1367 }1368 }1369 if (buildList != null) {1370 for (String param : buildList) {1371 preStat.setString(++paramNumber, param);1372 }1373 }1374 if (revisionList != null) {1375 for (String param : revisionList) {1376 preStat.setString(++paramNumber, param);1377 }1378 }1379 //environment1380 if (environmentList != null) {1381 for (String param : environmentList) {1382 preStat.setString(++paramNumber, param);1383 }1384 }1385 //country1386 if (countryList != null) {1387 for (String param : countryList) {1388 preStat.setString(++paramNumber, param);1389 }1390 }1391 //browser 1392 if (browserList != null) {1393 for (String param : browserList) {1394 preStat.setString(++paramNumber, param);1395 }1396 }1397 //controlstatus1398 if (tcestatusList != null) {1399 for (String param : tcestatusList) {1400 preStat.setString(++paramNumber, param);1401 }1402 }1403 if (!StringUtil.isNullOrEmpty(system)) {1404 preStat.setString(++paramNumber, system);1405 }1406 if (!StringUtil.isNullOrEmpty(ip)) {1407 preStat.setString(++paramNumber, "%" + ip + "%");1408 }1409 if (!StringUtil.isNullOrEmpty(port)) {1410 preStat.setString(++paramNumber, "%" + port + "%");1411 }1412 if (!StringUtil.isNullOrEmpty(tag)) {1413 preStat.setString(++paramNumber, "%" + tag + "%");1414 }1415 if (!StringUtil.isNullOrEmpty(browserversion)) {1416 preStat.setString(++paramNumber, "%" + browserversion + "%");1417 }1418 if (!StringUtil.isNullOrEmpty(comment)) {1419 preStat.setString(++paramNumber, "%" + comment + "%");1420 }1421 if (!StringUtil.isNullOrEmpty(bugid)) {1422 preStat.setString(++paramNumber, "%" + bugid + "%");1423 }1424 if (!StringUtil.isNullOrEmpty(ticket)) {1425 preStat.setString(++paramNumber, "%" + ticket + "%");1426 }1427 try {1428 ResultSet resultSet = preStat.executeQuery();1429 try {1430 while (resultSet.next()) {1431 tceList.add(loadWithDependenciesFromResultSet(resultSet));1432 }1433 if (tceList.isEmpty()) {1434 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);1435 } else {1436 msg.setDescription(msg.getDescription().replace("%ITEM%", "TestCaseExecution").replace("%OPERATION%", "SELECT"));1437 }1438 } catch (SQLException exception) {1439 LOG.warn("Unable to execute query : " + exception.toString());1440 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1441 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1442 tceList.clear();1443 } finally {1444 if (resultSet != null) {1445 resultSet.close();1446 }1447 }1448 } catch (SQLException ex) {1449 LOG.warn("Unable to execute query : " + ex.toString());1450 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1451 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1452 } finally {1453 if (preStat != null) {1454 preStat.close();1455 }1456 }1457 } catch (SQLException ex) {1458 LOG.warn(ex.toString());1459 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1460 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Unable to retrieve the list of entries!"));1461 } finally {1462 try {1463 if (connection != null) {1464 connection.close();1465 }1466 } catch (SQLException ex) {1467 LOG.warn("Unable to execute query : " + ex.toString());1468 }1469 }1470 answer.setTotalRows(tceList.size());1471 answer.setDataList(tceList);1472 answer.setResultMessage(msg);1473 return answer;1474 }1475 @Override1476 public AnswerItem readByKey(long executionId) {1477 AnswerItem ans = new AnswerItem();1478 TestCaseExecution result = null;1479 final String query = "SELECT * FROM `testcaseexecution` exe WHERE exe.`id` = ?";1480 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1481 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));1482 Connection connection = this.databaseSpring.connect();1483 try {1484 PreparedStatement preStat = connection.prepareStatement(query);1485 try {1486 preStat.setLong(1, executionId);1487 ResultSet resultSet = preStat.executeQuery();1488 try {1489 if (resultSet.first()) {1490 result = loadFromResultSet(resultSet);1491 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);1492 msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "SELECT"));1493 ans.setItem(result);1494 } else {1495 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);1496 }1497 } catch (SQLException exception) {1498 LOG.error("Unable to execute query : " + exception.toString());1499 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1500 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));1501 } finally {1502 resultSet.close();1503 }1504 } catch (SQLException exception) {1505 LOG.error("Unable to execute query : " + exception.toString());1506 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1507 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));1508 } finally {1509 preStat.close();1510 }1511 } catch (SQLException exception) {1512 LOG.error("Unable to execute query : " + exception.toString());1513 msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1514 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));1515 } finally {1516 try {1517 if (connection != null) {1518 connection.close();1519 }1520 } catch (SQLException exception) {1521 LOG.warn("Unable to close connection : " + exception.toString());1522 }1523 }1524 //sets the message1525 ans.setResultMessage(msg);1526 return ans;1527 }1528 @Override1529 public TestCaseExecution loadFromResultSet(ResultSet resultSet) throws SQLException {1530 long id = ParameterParserUtil.parseLongParam(resultSet.getString("exe.ID"), 0);1531 String test = ParameterParserUtil.parseStringParam(resultSet.getString("exe.test"), "");1532 String testcase = ParameterParserUtil.parseStringParam(resultSet.getString("exe.testcase"), "");1533 String description = ParameterParserUtil.parseStringParam(resultSet.getString("exe.description"), "");1534 String build = ParameterParserUtil.parseStringParam(resultSet.getString("exe.build"), "");1535 String revision = ParameterParserUtil.parseStringParam(resultSet.getString("exe.revision"), "");1536 String environment = ParameterParserUtil.parseStringParam(resultSet.getString("exe.environment"), "");1537 String environmentData = ParameterParserUtil.parseStringParam(resultSet.getString("exe.environmentData"), "");1538 String country = ParameterParserUtil.parseStringParam(resultSet.getString("exe.country"), "");1539 String browser = ParameterParserUtil.parseStringParam(resultSet.getString("exe.browser"), "");1540 String version = ParameterParserUtil.parseStringParam(resultSet.getString("exe.version"), "");1541 String platform = ParameterParserUtil.parseStringParam(resultSet.getString("exe.platform"), "");1542 String browserFullVersion = ParameterParserUtil.parseStringParam(resultSet.getString("exe.browserFullVersion"), "");1543 long start = ParameterParserUtil.parseLongParam(String.valueOf(resultSet.getTimestamp("exe.start").getTime()), 0);1544 long end = ParameterParserUtil.parseLongParam(String.valueOf(resultSet.getTimestamp("exe.end").getTime()), 0);1545 String controlStatus = ParameterParserUtil.parseStringParam(resultSet.getString("exe.controlStatus"), "");1546 String controlMessage = ParameterParserUtil.parseStringParam(resultSet.getString("exe.controlMessage"), "");1547 String application = ParameterParserUtil.parseStringParam(resultSet.getString("exe.application"), "");1548 String ip = ParameterParserUtil.parseStringParam(resultSet.getString("exe.ip"), ""); // Host the Selenium IP1549 String url = ParameterParserUtil.parseStringParam(resultSet.getString("exe.url"), "");1550 String port = ParameterParserUtil.parseStringParam(resultSet.getString("exe.port"), ""); // host the Selenium Port1551 String tag = ParameterParserUtil.parseStringParam(resultSet.getString("exe.tag"), "");1552 String status = ParameterParserUtil.parseStringParam(resultSet.getString("exe.status"), "");1553 String crbVersion = ParameterParserUtil.parseStringParam(resultSet.getString("exe.crbVersion"), "");1554 String executor = ParameterParserUtil.parseStringParam(resultSet.getString("exe.executor"), "");1555 String screenSize = ParameterParserUtil.parseStringParam(resultSet.getString("exe.screensize"), "");1556 String conditionOper = ParameterParserUtil.parseStringParam(resultSet.getString("exe.conditionOper"), "");1557 String conditionVal1 = ParameterParserUtil.parseStringParam(resultSet.getString("exe.conditionVal1"), "");1558 String conditionVal1Init = ParameterParserUtil.parseStringParam(resultSet.getString("exe.conditionVal1Init"), "");1559 String conditionVal2 = ParameterParserUtil.parseStringParam(resultSet.getString("exe.conditionVal2"), "");1560 String conditionVal2Init = ParameterParserUtil.parseStringParam(resultSet.getString("exe.conditionVal2Init"), "");1561 String manualExecution = ParameterParserUtil.parseStringParam(resultSet.getString("exe.manualExecution"), "N");1562 String userAgent = ParameterParserUtil.parseStringParam(resultSet.getString("exe.userAgent"), "");1563 String system = ParameterParserUtil.parseStringParam(resultSet.getString("exe.system"), "");1564 String robotDecli = ParameterParserUtil.parseStringParam(resultSet.getString("exe.robotdecli"), "");1565 long queueId = ParameterParserUtil.parseLongParam(resultSet.getString("exe.queueId"), 0);1566 int testCaseVersion = ParameterParserUtil.parseIntegerParam(resultSet.getInt("exe.testCaseVersion"), 0);1567 TestCaseExecution result = factoryTCExecution.create(id, test, testcase, description, build, revision, environment,1568 country, browser, version, platform, browserFullVersion, start, end, controlStatus, controlMessage, application, null, ip, url,1569 port, tag, 0, 0, 0, 0, true, "", "", status, crbVersion, null, null, null,1570 false, null, null, null, environmentData, null, null, null, null, executor, 0, screenSize, null,1571 conditionOper, conditionVal1Init, conditionVal2Init, conditionVal1, conditionVal2, manualExecution, userAgent, testCaseVersion, system, robotDecli);1572 result.setQueueID(queueId);1573 return result;1574 }1575 private TestCaseExecution loadWithDependenciesFromResultSet(ResultSet resultSet) throws SQLException {1576 TestCaseExecution testCaseExecution = new TestCaseExecution();1577 testCaseExecution = this.loadFromResultSet(resultSet);1578 testCaseExecution.setTestCaseObj(testCaseDAO.loadFromResultSet(resultSet));1579 testCaseExecution.setApplicationObj(applicationDAO.loadFromResultSet(resultSet));1580 return testCaseExecution;1581 }1582 private TestCaseExecution loadWithTestCaseFromResultSet(ResultSet resultSet) throws SQLException {1583 TestCaseExecution testCaseExecution = new TestCaseExecution();1584 testCaseExecution = this.loadFromResultSet(resultSet);1585 testCaseExecution.setTestCaseObj(testCaseDAO.loadFromResultSet(resultSet));1586 return testCaseExecution;1587 }1588 private TestCaseExecution loadTestCaseExecutionAndApplicationFromResultSet(ResultSet resultSet) throws SQLException {1589 TestCaseExecution testCaseExecution = new TestCaseExecution();1590 testCaseExecution = this.loadFromResultSet(resultSet);1591 testCaseExecution.setApplicationObj(applicationDAO.loadFromResultSet(resultSet));1592 return testCaseExecution;1593 }1594 @Override1595 public AnswerList<List<String>> readDistinctValuesByCriteria(String system, String test, String searchParameter, Map<String, List<String>> individualSearch, String columnName) {1596 AnswerList answer = new AnswerList();1597 MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1598 msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));1599 List<String> distinctValues = new ArrayList<>();1600 List<String> individalColumnSearchValues = new ArrayList<String>();1601 final StringBuffer query = new StringBuffer();1602 query.append("SELECT distinct ");1603 query.append(columnName);1604 query.append(" as distinctValues FROM testcaseexecution exe ");1605 query.append("where exe.`start`> '").append(DateUtil.getMySQLTimestampTodayDeltaMinutes(-360000)).append("' ");1606 if (!StringUtil.isNullOrEmpty(searchParameter)) {1607 query.append("and (exe.`id` like ? ");1608 query.append(" or exe.`test` like ? ");1609 query.append(" or exe.`testCase` like ? ");1610 query.append(" or exe.`build` like ? ");1611 query.append(" or exe.`revision` like ? ");1612 query.append(" or exe.`environment` like ? ");1613 query.append(" or exe.`country` like ? ");1614 query.append(" or exe.`browser` like ? ");1615 query.append(" or exe.`version` like ? ");1616 query.append(" or exe.`platform` like ? ");1617 query.append(" or exe.`browserfullversion` like ? ");1618 query.append(" or exe.`start` like ? ");1619 query.append(" or exe.`end` like ? ");1620 query.append(" or exe.`controlstatus` like ? ");1621 query.append(" or exe.`controlmessage` like ? ");1622 query.append(" or exe.`application` like ? ");1623 query.append(" or exe.`ip` like ? ");1624 query.append(" or exe.`url` like ? ");1625 query.append(" or exe.`port` like ? ");1626 query.append(" or exe.`tag` like ? ");1627 query.append(" or exe.`finished` like ? ");1628 query.append(" or exe.`status` like ? ");1629 query.append(" or exe.`crbversion` like ? ");1630 query.append(" or exe.`executor` like ? ");1631 query.append(" or exe.`screensize` like ? )");1632 }1633 if (individualSearch != null && !individualSearch.isEmpty()) {1634 query.append(" and ( 1=1 ");1635 for (Map.Entry<String, List<String>> entry : individualSearch.entrySet()) {1636 query.append(" and ");1637 query.append(SqlUtil.getInSQLClauseForPreparedStatement(entry.getKey(), entry.getValue()));1638 individalColumnSearchValues.addAll(entry.getValue());1639 }1640 query.append(" ) ");1641 }1642 query.append(" order by ").append(columnName).append(" asc");1643 // Debug message on SQL.1644 if (LOG.isDebugEnabled()) {1645 LOG.debug("SQL : " + query.toString());1646 }1647 try (Connection connection = databaseSpring.connect();1648 PreparedStatement preStat = connection.prepareStatement(query.toString());1649 Statement stm = connection.createStatement();) {1650 int i = 1;1651 if (!Strings.isNullOrEmpty(searchParameter)) {1652 preStat.setString(i++, "%" + searchParameter + "%");1653 preStat.setString(i++, "%" + searchParameter + "%");1654 preStat.setString(i++, "%" + searchParameter + "%");1655 preStat.setString(i++, "%" + searchParameter + "%");1656 preStat.setString(i++, "%" + searchParameter + "%");1657 preStat.setString(i++, "%" + searchParameter + "%");1658 preStat.setString(i++, "%" + searchParameter + "%");1659 preStat.setString(i++, "%" + searchParameter + "%");1660 preStat.setString(i++, "%" + searchParameter + "%");1661 preStat.setString(i++, "%" + searchParameter + "%");1662 preStat.setString(i++, "%" + searchParameter + "%");1663 preStat.setString(i++, "%" + searchParameter + "%");1664 preStat.setString(i++, "%" + searchParameter + "%");1665 preStat.setString(i++, "%" + searchParameter + "%");...

Full Screen

Full Screen

isNull

Using AI Code Generation

copy

Full Screen

1if (StringUtil.isNull(myString)) {2}3if (StringUtil.isNotNull(myString)) {4}5if (StringUtil.isBlank(myString)) {6}7if (StringUtil.isNotBlank(myString)) {8}9if (StringUtil.isNumeric(myString)) {10}11if (StringUtil.isNotNumeric(myString)) {12}13if (StringUtil.isAlpha(myString)) {14}15if (StringUtil.isNotAlpha(myString)) {16}17if (StringUtil.isAlphaNumeric(myString)) {18}19if (StringUtil.isNotAlphaNumeric(myString)) {20}21if (StringUtil.isAlphaNumericSpace(myString)) {22}23if (StringUtil.isNotAlphaNumericSpace(myString)) {24}25if (StringUtil.isAlphaNumericSpaceUnderscore(myString)) {26}27if (StringUtil.isNotAlphaNumericSpaceUnderscore(myString)) {28}

Full Screen

Full Screen

isNull

Using AI Code Generation

copy

Full Screen

1if (StringUtil.isNull("test")) {2} else {3}4if (StringUtil.isNotNull("test")) {5} else {6}7if (StringUtil.isNull("test")) {8} else {9}10if (StringUtil.isNotNull("test")) {11} else {12}13if (StringUtil.isNull("test")) {14} else {15}16if (StringUtil.isNotNull("test")) {17} else {18}

Full Screen

Full Screen

isNull

Using AI Code Generation

copy

Full Screen

1if (!StringUtil.isNull(myString)) {2}3if (!StringUtil.isNull(myObject)) {4}5if (!StringUtil.isNull(myArray)) {6}7if (!StringUtil.isNull(myList)) {8}9if (!StringUtil.isNull(myMap)) {10}11if (!StringUtil.isNull(mySet)) {12}13if (!StringUtil.isNull(myCollection)) {14}15if (!StringUtil.isNull(myFile)) {16}17if (!StringUtil.isNull(myJsonElement)) {18}19if (!StringUtil.isNull(myJsonArray)) {20}21if (!StringUtil.isNull(myJsonObject)) {22}23if (!StringUtil.isNull(myJsonPrimitive)) {24}25if (!StringUtil.isNull(myJsonString)) {26}27if (!StringUtil.isNull(myJsonNull)) {28}29if (!StringUtil.isNull(myJsonArray)) {30}31if (!StringUtil.isNull(myJsonObject)) {32}33if (!StringUtil.isNull(myJsonPrimitive)) {34}35if (!StringUtil.isNull(myJsonString)) {

Full Screen

Full Screen

isNull

Using AI Code Generation

copy

Full Screen

1if (StringUtil.isNull(parameter)) {2}3if (StringUtil.isNotNull(parameter)) {4}5if (StringUtil.isBlank(parameter)) {6}7if (StringUtil.isNotBlank(parameter)) {8}9if (StringUtil.isNumeric(parameter)) {10}11if (StringUtil.isNotNumeric(parameter)) {12}13if (StringUtil.isAlpha(parameter)) {14}15if (StringUtil.isNotAlpha(parameter)) {16}17if (StringUtil.isAlphaNumeric(parameter)) {18}19if (StringUtil.isNotAlphaNumeric(parameter)) {20}21if (StringUtil.isAlphaNumericWithUnderscore(parameter)) {22}

Full Screen

Full Screen

isNull

Using AI Code Generation

copy

Full Screen

1import org.cerberus.util.StringUtil;2String s = StringUtil.isNull("test", "default");3System.out.println(s);4import org.cerberus.util.StringUtil;5String s = StringUtil.isNull(null, "default");6System.out.println(s);7import org.cerberus.util.StringUtil;8String s = StringUtil.isNull(null, null);9System.out.println(s);10import org.cerberus.util.StringUtil;11String s = StringUtil.isNull("", "default");12System.out.println(s);13import org.cerberus.util.StringUtil;14String s = StringUtil.isNull("", null);15System.out.println(s);16import org.cerberus.util.StringUtil;17String s = StringUtil.isNull("", "");18System.out.println(s);19import org.cerberus.util.StringUtil;20String s = StringUtil.isNull(" ", "default");21System.out.println(s);22import org.cerberus.util.StringUtil;23String s = StringUtil.isNull(" ", null);24System.out.println(s);25import org.cerberus.util.StringUtil;26String s = StringUtil.isNull(" ", "");27System.out.println(s);28import org.cerberus.util.StringUtil;29String s = StringUtil.isNull(" ", " ");30System.out.println(s);

Full Screen

Full Screen

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.

LambdaTest Learning Hubs:

YouTube

You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.

Try LambdaTest Now !!

Get 100 minutes of automation test minutes FREE!!

Next-Gen App & Browser Testing Cloud

Was this article helpful?

Helpful

NotHelpful