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

Example 46 with Answer

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

the class SqlLibraryDAO method update.

@Override
public Answer update(SqlLibrary object) {
    MessageEvent msg = null;
    final String query = "UPDATE sqllibrary SET Type = ?, `Database` = ?, `Script` = ?, Description = ? WHERE Name = ?";
    // 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.getType());
            preStat.setString(2, object.getDatabase());
            preStat.setString(3, object.getScript());
            preStat.setString(4, object.getDescription());
            preStat.setString(5, object.getName());
            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 47 with Answer

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

the class TagDAO method update.

@Override
public Answer update(String tag, Tag object) {
    MessageEvent msg = null;
    String query = "UPDATE tag SET tag = ?, description = ?, dateModif = NOW(), usrModif= ?";
    if (!StringUtil.isNullOrEmpty(object.getCampaign())) {
        query += ", campaign = ?";
    }
    query += "  WHERE Tag = ?";
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query);
        LOG.debug("SQL.param.tag : " + object.getTag());
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            int i = 1;
            preStat.setString(i++, object.getTag());
            preStat.setString(i++, object.getDescription());
            if (!StringUtil.isNullOrEmpty(object.getCampaign())) {
                preStat.setString(i++, object.getCampaign());
            }
            preStat.setString(i++, object.getUsrModif());
            preStat.setString(i++, tag);
            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 48 with Answer

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

the class TestDAO method update.

@Override
public Answer update(String keyTest, Test test) {
    MessageEvent msg = null;
    final String query = "UPDATE test SET test = ?, description = ?, active = ?, automated = ? WHERE test = ?";
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query);
        LOG.debug("SQL.param.test : " + keyTest);
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            int i = 1;
            preStat.setString(i++, test.getTest());
            preStat.setString(i++, test.getDescription());
            preStat.setString(i++, test.getActive());
            preStat.setString(i++, test.getAutomated());
            preStat.setString(i++, keyTest);
            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 49 with Answer

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

the class TestDataLibDAO method update.

@Override
public Answer update(TestDataLib testDataLib) {
    Answer answer = new Answer();
    MessageEvent msg;
    String query = "UPDATE testdatalib SET `name`=?, `type`=?, `group`= ?, `system`=?, `environment`=?, `country`=?, `database`= ? , `script`= ? , " + "`databaseUrl`= ? , `servicepath`= ? , `method`= ? , `envelope`= ? , `DatabaseCsv` = ? , `csvUrl` = ? ,`separator`= ?,  `description`= ? , `LastModifier`= ?, `LastModified` = NOW() ";
    if ((testDataLib.getService() != null) && (!testDataLib.getService().equals(""))) {
        query += " ,`service` = ? ";
    } else {
        query += " ,`service` = null ";
    }
    query += "WHERE `TestDataLibID`= ?";
    // Debug message on SQL.
    if (LOG.isDebugEnabled()) {
        LOG.debug("SQL : " + query);
        LOG.debug("SQL.param.service : " + testDataLib.getService());
        LOG.debug("SQL.param.servicePath : " + testDataLib.getServicePath());
    }
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            int i = 1;
            preStat.setString(i++, testDataLib.getName());
            preStat.setString(i++, testDataLib.getType());
            preStat.setString(i++, testDataLib.getGroup());
            preStat.setString(i++, testDataLib.getSystem());
            preStat.setString(i++, testDataLib.getEnvironment());
            preStat.setString(i++, testDataLib.getCountry());
            preStat.setString(i++, testDataLib.getDatabase());
            preStat.setString(i++, testDataLib.getScript());
            preStat.setString(i++, testDataLib.getDatabaseUrl());
            preStat.setString(i++, testDataLib.getServicePath());
            preStat.setString(i++, testDataLib.getMethod());
            preStat.setString(i++, testDataLib.getEnvelope());
            preStat.setString(i++, testDataLib.getDatabaseCsv());
            preStat.setString(i++, testDataLib.getCsvUrl());
            preStat.setString(i++, testDataLib.getSeparator());
            preStat.setString(i++, testDataLib.getDescription());
            preStat.setString(i++, testDataLib.getLastModifier());
            if ((testDataLib.getService() != null) && (!testDataLib.getService().equals(""))) {
                preStat.setString(i++, testDataLib.getService());
            }
            preStat.setInt(i++, testDataLib.getTestDataLibID());
            int rowsUpdated = 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());
            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%", "Test data lib ").replace("%OPERATION%", "UPDATE").replace("%REASON%", exception.toString()));
            } else {
                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);
                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));
            }
        } finally {
            if (preStat != null) {
                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 (!this.databaseSpring.isOnTransaction()) {
                if (connection != null) {
                    connection.close();
                }
            }
        } catch (SQLException ex) {
            LOG.warn("Unable to close connection : " + ex.toString());
        }
    }
    answer.setResultMessage(msg);
    return answer;
}

Example 50 with Answer

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

the class TestDataLibDAO method delete.

@Override
public Answer delete(TestDataLib testDataLib) {
    Answer ans = new Answer();
    MessageEvent msg;
    StringBuilder query = new StringBuilder();
    query.append("DELETE FROM testdatalib WHERE testdatalibid = ?");
    // 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.setInt(1, testDataLib.getTestDataLibID());
            int rowsDeleted = preStat.executeUpdate();
            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);
            msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "DELETE"));
        } 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 {
            if (preStat != null) {
                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 (!this.databaseSpring.isOnTransaction()) {
                if (connection != null) {
                    connection.close();
                }
            }
        } catch (SQLException ex) {
            LOG.warn("Unable to close connection : " + ex.toString());
        }
    }
    ans.setResultMessage(msg);
    return ans;
}