Examples with Answer org.cerberus.util.answer.Answer used on opensource projects

Example 6 with Answer

use of org.cerberus.util.answer.Answer in project cerberus-source by cerberustesting.

the class CampaignParameterDAO method update.

@Override
public Answer update(CampaignParameter object) {
    Answer ans = new Answer();
    MessageEvent msg = null;
    String query = "UPDATE `campaignparameter` SET `value` = ? WHERE `campaign` = ? AND `parameter` = ?";
    try (Connection connection = databaseSpring.connect();
        PreparedStatement preStat = connection.prepareStatement(query)) {
        // Prepare and execute query
        preStat.setString(1, object.getValue());
        preStat.setString(2, object.getCampaign());
        preStat.setString(3, object.getParameter());
        preStat.executeUpdate();
        // Set the final message
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK).resolveDescription("ITEM", OBJECT_NAME).resolveDescription("OPERATION", "UPDATE");
    } catch (Exception e) {
        LOG.warn("Unable to create campaign parameter: " + e.getMessage());
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED).resolveDescription("DESCRIPTION", e.toString());
    } finally {
        ans.setResultMessage(msg);
    }
    return ans;
}

Example 7 with Answer

use of org.cerberus.util.answer.Answer in project cerberus-source by cerberustesting.

the class CampaignParameterDAO method create.

@Override
public Answer create(CampaignParameter object) {
    Answer ans = new Answer();
    MessageEvent msg = null;
    try (Connection connection = databaseSpring.connect();
        PreparedStatement preStat = connection.prepareStatement(Query.CREATE)) {
        // Prepare and execute query
        preStat.setString(1, object.getCampaign());
        preStat.setString(2, object.getParameter());
        preStat.setString(3, object.getValue());
        preStat.executeUpdate();
        // Set the final message
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK).resolveDescription("ITEM", OBJECT_NAME).resolveDescription("OPERATION", "CREATE");
    } catch (Exception e) {
        LOG.warn("Unable to create campaign content: " + e.getMessage());
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED).resolveDescription("DESCRIPTION", e.toString());
    } finally {
        ans.setResultMessage(msg);
    }
    return ans;
}

Example 8 with Answer

use of org.cerberus.util.answer.Answer in project cerberus-source by cerberustesting.

the class CountryEnvDeployTypeDAO method update.

@Override
public Answer update(CountryEnvDeployType object) {
    // Function is implemented for futur use and in order to keep standard uptodate on that class but today all rows are the key so no updates are possible.
    MessageEvent msg = null;
    final String query = "UPDATE `countryenvdeploytype` SET 1=1 WHERE `system`=? and `country`=? and `environment`=? and `deploytype`=? and `jenkinsagent`=? ";
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query);
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            preStat.setString(1, object.getSystem());
            preStat.setString(2, object.getCountry());
            preStat.setString(3, object.getEnvironment());
            preStat.setString(4, object.getDeployType());
            preStat.setString(5, object.getJenkinsAgent());
            preStat.executeUpdate();
            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);
            msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "UPDATE"));
        } catch (SQLException exception) {
            LOG.error("Unable to execute query : " + exception.toString());
            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.error("Unable to execute query : " + exception.toString());
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to close connection : " + exception.toString());
        }
    }
    return new Answer(msg);
}

Example 9 with Answer

use of org.cerberus.util.answer.Answer in project cerberus-source by cerberustesting.

the class CountryEnvLinkDAO method create.

@Override
public Answer create(CountryEnvLink object) {
    MessageEvent msg = null;
    StringBuilder query = new StringBuilder();
    query.append("INSERT INTO countryenvlink (`system`, `country`, `environment`, `systemLink`, `countryLink`, `environmentLink`) ");
    query.append("VALUES (?,?,?,?,?,?)");
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query.toString());
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query.toString());
        try {
            preStat.setString(1, object.getSystem());
            preStat.setString(2, object.getCountry());
            preStat.setString(3, object.getEnvironment());
            preStat.setString(4, object.getSystemLink());
            preStat.setString(5, object.getCountryLink());
            preStat.setString(6, object.getEnvironmentLink());
            preStat.executeUpdate();
            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);
            msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT"));
        } catch (SQLException exception) {
            LOG.error("Unable to execute query : " + exception.toString());
            if (exception.getSQLState().equals(SQL_DUPLICATED_CODE)) {
                // 23000 is the sql state for duplicate entries
                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_DUPLICATE);
                msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT").replace("%REASON%", exception.toString()));
            } else {
                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
            }
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.error("Unable to execute query : " + exception.toString());
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException exception) {
            LOG.error("Unable to close connection : " + exception.toString());
        }
    }
    return new Answer(msg);
}

Example 10 with Answer

use of org.cerberus.util.answer.Answer in project cerberus-source by cerberustesting.

the class CountryEnvParamDAO method create.

@Override
public Answer create(CountryEnvParam cep) {
    MessageEvent msg = null;
    StringBuilder query = new StringBuilder();
    query.append("INSERT INTO `countryenvparam`  (`system`, `country`, `environment`, `build`, `revision`,`chain`, `distriblist`, `eMailBodyRevision`, `type`,`eMailBodyChain`, ");
    query.append("`eMailBodyDisableEnvironment`,  `active`, `maintenanceact`, `maintenancestr`, `maintenanceend`, `description`) ");
    query.append("VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query.toString());
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query.toString());
        try {
            preStat.setString(1, cep.getSystem());
            preStat.setString(2, cep.getCountry());
            preStat.setString(3, cep.getEnvironment());
            preStat.setString(4, cep.getBuild());
            preStat.setString(5, cep.getRevision());
            preStat.setString(6, cep.getChain());
            preStat.setString(7, cep.getDistribList());
            preStat.setString(8, cep.geteMailBodyRevision());
            preStat.setString(9, cep.getType());
            preStat.setString(10, cep.geteMailBodyChain());
            preStat.setString(11, cep.geteMailBodyDisableEnvironment());
            if (cep.isActive()) {
                preStat.setString(12, "Y");
            } else {
                preStat.setString(12, "N");
            }
            if (cep.isMaintenanceAct()) {
                preStat.setString(13, "Y");
            } else {
                preStat.setString(13, "N");
            }
            preStat.setString(14, cep.getMaintenanceStr());
            preStat.setString(15, cep.getMaintenanceEnd());
            preStat.setString(16, cep.getDescription());
            preStat.executeUpdate();
            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);
            msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT"));
        } catch (SQLException exception) {
            LOG.error("Unable to execute query : " + exception.toString());
            if (exception.getSQLState().equals(SQL_DUPLICATED_CODE)) {
                // 23000 is the sql state for duplicate entries
                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_DUPLICATE);
                msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT").replace("%REASON%", exception.toString()));
            } else {
                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
            }
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.error("Unable to execute query : " + exception.toString());
        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to close connection : " + exception.toString());
        }
    }
    return new Answer(msg);
}