How to use loadFromResultset method of org.cerberus.crud.dao.impl.TestCaseStepActionControlExecutionDAO class

Best Cerberus-source code snippet using org.cerberus.crud.dao.impl.TestCaseStepActionControlExecutionDAO.loadFromResultset

Source:TestCaseStepActionControlExecutionDAO.java

...228                ResultSet resultSet = preStat.executeQuery();229                try {230                    result = new ArrayList<TestCaseStepActionControlExecution>();231                    while (resultSet.next()) {232                        result.add(this.loadFromResultset(resultSet));233                    }234                } catch (SQLException exception) {235                    LOG.warn("Unable to execute query : " + exception.toString());236                } finally {237                    resultSet.close();238                }239            } catch (SQLException exception) {240                LOG.warn("Unable to execute query : " + exception.toString());241            } finally {242                preStat.close();243            }244        } catch (SQLException exception) {245            LOG.warn("Unable to execute query : " + exception.toString());246        } finally {247            try {248                if (connection != null) {249                    connection.close();250                }251            } catch (SQLException e) {252                LOG.warn(e.toString());253            }254        }255        return result;256    }257    @Override258    public AnswerList readByVarious1(long executionId, String test, String testCase, int step, int index, int sequence) {259        MessageEvent msg;260        AnswerList answer = new AnswerList();261        List<TestCaseStepActionControlExecution> list = new ArrayList<TestCaseStepActionControlExecution>();262        StringBuilder query = new StringBuilder();263        query.append("SELECT * FROM testcasestepactioncontrolexecution a ");264        query.append("where id = ? and test = ? and testcase = ? and step = ? and `index` = ? ");265        query.append("and sequence = ?");266        // Debug message on SQL.267        if (LOG.isDebugEnabled()) {268            LOG.debug("SQL : " + query.toString());269        }270        Connection connection = this.databaseSpring.connect();271        try {272            PreparedStatement preStat = connection.prepareStatement(query.toString());273            try {274                preStat.setLong(1, executionId);275                preStat.setString(2, test);276                preStat.setString(3, testCase);277                preStat.setInt(4, step);278                preStat.setInt(5, index);279                preStat.setInt(6, sequence);280                ResultSet resultSet = preStat.executeQuery();281                try {282                    while (resultSet.next()) {283                        list.add(this.loadFromResultset(resultSet));284                    }285                    if (list.isEmpty()) {286                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);287                    } else {288                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);289                    }290                } catch (SQLException exception) {291                    LOG.error("Unable to execute query : " + exception.toString());292                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);293                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));294                    list.clear();295                } finally {296                    if (resultSet != null) {297                        resultSet.close();298                    }299                }300            } catch (SQLException exception) {301                LOG.error("Unable to execute query : " + exception.toString());302                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);303                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));304            } finally {305                if (preStat != null) {306                    preStat.close();307                }308            }309        } catch (SQLException exception) {310            LOG.error("Unable to execute query : " + exception.toString());311            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);312            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));313        } finally {314            try {315                if (connection != null) {316                    connection.close();317                }318            } catch (SQLException exception) {319                LOG.warn("Unable to close connection : " + exception.toString());320            }321        }322        answer.setTotalRows(list.size());323        answer.setDataList(list);324        answer.setResultMessage(msg);325        return answer;326    }327    @Override328    public AnswerItem readByKey(long executionId, String test, String testCase, int step, int index, int sequence, int controlSequence) {329        MessageEvent msg;330        AnswerItem answer = new AnswerItem();331        TestCaseStepActionControlExecution tcsa = null;332        StringBuilder query = new StringBuilder();333        query.append("SELECT * FROM testcasestepactioncontrolexecution a ");334        query.append("where id = ? and test = ? and testcase = ? and step = ? and `index` = ? and controlSequence = ?");335        query.append("and sequence = ?");336        // Debug message on SQL.337        if (LOG.isDebugEnabled()) {338            LOG.debug("SQL : " + query.toString());339        }340        Connection connection = this.databaseSpring.connect();341        try {342            PreparedStatement preStat = connection.prepareStatement(query.toString());343            try {344                preStat.setLong(1, executionId);345                preStat.setString(2, test);346                preStat.setString(3, testCase);347                preStat.setInt(4, step);348                preStat.setInt(5, index);349                preStat.setInt(6, sequence);350                preStat.setInt(7, controlSequence);351                ResultSet resultSet = preStat.executeQuery();352                try {353                    while (resultSet.next()) {354                        tcsa = this.loadFromResultset(resultSet);355                    }356                    if (tcsa == null) {357                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);358                    } else {359                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);360                    }361                } catch (SQLException exception) {362                    LOG.error("Unable to execute query : " + exception.toString());363                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);364                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));365                } finally {366                    if (resultSet != null) {367                        resultSet.close();368                    }369                }370            } catch (SQLException exception) {371                LOG.error("Unable to execute query : " + exception.toString());372                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);373                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));374            } finally {375                if (preStat != null) {376                    preStat.close();377                }378            }379        } catch (SQLException exception) {380            LOG.error("Unable to execute query : " + exception.toString());381            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);382            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));383        } finally {384            try {385                if (connection != null) {386                    connection.close();387                }388            } catch (SQLException exception) {389                LOG.warn("Unable to close connection : " + exception.toString());390            }391        }392        answer.setItem(tcsa);393        answer.setResultMessage(msg);394        return answer;395    }396    @Override397    public TestCaseStepActionControlExecution loadFromResultset(ResultSet resultSet) throws SQLException {398        long id = resultSet.getInt("id");399        String test = resultSet.getString("test");400        String testCase = resultSet.getString("testcase");401        int step = resultSet.getInt("step");402        int index = resultSet.getInt("index");403        int sequence = resultSet.getInt("sequence");404        int controlSequence = resultSet.getInt("controlSequence");405        int sort = resultSet.getInt("sort");406        String returnCode = resultSet.getString("returncode");407        String returnMessage = resultSet.getString("returnmessage");408        String conditionOper = resultSet.getString("conditionOper");409        String conditionVal1Init = resultSet.getString("conditionVal1Init");410        String conditionVal2Init = resultSet.getString("conditionVal2Init");411        String conditionVal1 = resultSet.getString("conditionVal1");...

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.