Examples with SQLDatabaseException SQLDatabase.SQLDatabaseException used on opensource projects

Example 11 with SQLDatabaseException

use of SQLDatabase.SQLDatabaseException in project SmartCity-Market by TechnionYP5777.

the class SQLDatabaseConnection method setSecurityQACustomer.

@Override
public void setSecurityQACustomer(String username, ForgotPasswordData d) throws CriticalError, ClientNotExist {
    log.debug("SQL Public setSecurityQACustomer: Customer: " + username + " sets security Q&A.");
    if (!isCustomerExist(username)) {
        log.debug("SQL Public setSecurityQACustomer: no such customer with username: " + username);
        throw new ClientNotExist();
    }
    try {
        // START transaction
        connectionStartTransaction();
        //Write part of transaction
        //updating security question and answer
        assignSecurityQAToRegisteredClient(new CustomersTable(), username, d);
        log.debug("SQL Public setSecurityQACustomer: Success setting ecurity Q&A for username: " + username);
        // END transaction
        connectionCommitTransaction();
    } catch (SQLDatabaseException e) {
        connectionRollbackTransaction();
        throw e;
    } finally {
        connectionEndTransaction();
    }
}

Example 12 with SQLDatabaseException

use of SQLDatabase.SQLDatabaseException in project SmartCity-Market by TechnionYP5777.

the class SQLDatabaseConnection method setPasswordCustomer.

@Override
public void setPasswordCustomer(String username, String newPassword) throws CriticalError, ClientNotExist {
    log.debug("SQL Public setPasswordCustomer: Customer: " + username + " sets password.");
    if (!isCustomerExist(username)) {
        log.debug("SQL Public setPasswordCustomer: no such customer with username: " + username);
        throw new ClientNotExist();
    }
    try {
        // START transaction
        connectionStartTransaction();
        //Write part of transaction
        //updating password
        assignPasswordToRegisteredClient(new CustomersTable(), username, newPassword);
        log.debug("SQL Public setPasswordCustomer: Success setting password for username: " + username);
        // END transaction
        connectionCommitTransaction();
    } catch (SQLDatabaseException e) {
        connectionRollbackTransaction();
        throw e;
    } finally {
        connectionEndTransaction();
    }
}

Example 13 with SQLDatabaseException

use of SQLDatabase.SQLDatabaseException in project SmartCity-Market by TechnionYP5777.

the class SQLDatabaseConnection method removeWorker.

@Override
public void removeWorker(Integer sessionID, String username) throws CriticalError, ClientNotExist, ClientNotConnected {
    log.debug("SQL Public removeWorker: Remove worker with username: " + username);
    validateSessionEstablished(sessionID);
    if (!isWorkerExist(username)) {
        log.debug("SQL Public removeWorker: no such worker with username: " + username);
        throw new ClientNotExist();
    }
    //validate not deleting the admin
    if (getWorkerTypeByUsername(username) == CLIENT_TYPE.MANAGER) {
        log.debug("SQL Public removeWorker: cant remove the manager!");
        throw new CriticalError();
    }
    try {
        // START transaction
        connectionStartTransaction();
        //Read part of transaction
        Integer workerSessionID = getSessionByUsernameOfRegisteredClient(new WorkersTable(), username);
        //Write part of transaction
        if (workerSessionID != null) {
            log.debug("SQL Public removeWorker: user " + username + " connected! doing logout first");
            logoutAsWorker(workerSessionID, username);
        }
        log.debug("SQL Public removeWorker: remove user " + username + " from workers table");
        removeRegisteredClient(new WorkersTable(), username);
        log.debug("SQL Public removeWorker: Success removing username: " + username);
        // END transaction
        connectionCommitTransaction();
    } catch (SQLDatabaseException e) {
        log.debug("SQL Public removeCustomer: known error occured:" + e.getMessage());
        connectionRollbackTransaction();
        throw e;
    } catch (SQLException e) {
        log.fatal("SQL Public removeCustomer: SQL error occured:" + e.getMessage());
        connectionRollbackTransaction();
        throw new CriticalError();
    } finally {
        connectionEndTransaction();
    }
}

Example 14 with SQLDatabaseException

use of SQLDatabase.SQLDatabaseException in project SmartCity-Market by TechnionYP5777.

the class SQLDatabaseConnection method getCustomerProfile.

@Override
public String getCustomerProfile(String username) throws CriticalError, ClientNotExist {
    log.debug("SQL Public getCustomerProfile: Customer get profile: for username: " + username);
    //case of guest login
    boolean isGuest = ClientServerDefs.anonymousCustomerUsername.equals(username);
    if (isGuest)
        return Serialization.serialize(new CustomerProfile(username));
    //case of registered client
    if (!isCustomerExist(username)) {
        log.debug("SQL Public getCustomerProfile: no such customer with username: " + username);
        throw new ClientNotExist();
    }
    PreparedStatement selectCustomerStatement = null, selectCustomerIngredientsStatement = null;
    ResultSet selectCustomerResult = null, selectCustomerIngredientsResult = null;
    try {
        String selectCustomerQuery = generateSelectQuery1Table(CustomersTable.customertable, BinaryCondition.equalTo(CustomersTable.customerusernameCol, PARAM_MARK));
        String selectCustomerIngredientsQuery = generateSelectInnerJoinWithQuery2Tables(CustomersIngredientsTable.table, IngredientsTable.table, CustomersIngredientsTable.ingredientIDCol, CustomersIngredientsTable.customerUsernameCol, BinaryCondition.equalTo(CustomersIngredientsTable.customerUsernameCol, PARAM_MARK));
        selectCustomerStatement = getParameterizedQuery(selectCustomerQuery + "", username);
        selectCustomerIngredientsStatement = getParameterizedQuery(selectCustomerIngredientsQuery + "", username);
        selectCustomerResult = selectCustomerStatement.executeQuery();
        selectCustomerResult.first();
        selectCustomerIngredientsResult = selectCustomerIngredientsStatement.executeQuery();
        String result = SQLJsonGenerator.CostumerProfileToJson(selectCustomerResult, selectCustomerIngredientsResult);
        log.debug("SQL Public setCustomerProfile: Success getting profile for username: " + username);
        return result;
    } catch (SQLDatabaseException e) {
        throw e;
    } catch (SQLException e) {
        throw new CriticalError();
    } finally {
        closeResources(selectCustomerStatement, selectCustomerIngredientsStatement, selectCustomerResult, selectCustomerIngredientsResult);
    }
}

Example 15 with SQLDatabaseException

use of SQLDatabase.SQLDatabaseException in project SmartCity-Market by TechnionYP5777.

the class SQLDatabaseConnection method setPasswordWorker.

@Override
public void setPasswordWorker(String username, String newPassword) throws CriticalError, ClientNotExist {
    log.debug("SQL Public setPasswordWorker: Worker: " + username + " sets password.");
    if (!isWorkerExist(username)) {
        log.debug("SQL Public setPasswordWorker: no such worker with username: " + username);
        throw new ClientNotExist();
    }
    try {
        // START transaction
        connectionStartTransaction();
        //Write part of transaction
        //updating password
        assignPasswordToRegisteredClient(new WorkersTable(), username, newPassword);
        log.debug("SQL Public setPasswordWorker: Success setting password for username: " + username);
        // END transaction
        connectionCommitTransaction();
    } catch (SQLDatabaseException e) {
        connectionRollbackTransaction();
        throw e;
    } finally {
        connectionEndTransaction();
    }
}