Examples with ProductPackageNotExist SQLDatabase.SQLDatabaseException.ProductPackageNotExist used on opensource projects

Example 1 with ProductPackageNotExist

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

the class CommandExecuter method removeProductPackageFromStoreCommand.

private void removeProductPackageFromStoreCommand(SQLDatabaseConnection c) {
    ProductPackage productPackage = null;
    log.info("Remove Product Package From Store command called");
    try {
        productPackage = Serialization.deserialize(inCommandWrapper.getData(), ProductPackage.class);
    } catch (java.lang.RuntimeException e) {
        log.fatal("Failed to parse data for Remove Product Package From Store command");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        return;
    }
    if (!productPackage.isValid()) {
        log.info("Remove Product Package From Store command failed, product package is invalid");
        outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_INVALID_PARAMETER);
    } else {
        try {
            if (productPackage.getLocation().getPlaceInMarket().equals(PlaceInMarket.STORE))
                c.removeProductPackageFromShelves(inCommandWrapper.getSenderID(), productPackage);
            else
                c.removeProductPackageFromWarehouse(inCommandWrapper.getSenderID(), productPackage);
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_OK);
        } catch (CriticalError e) {
            log.fatal("Remove Product Package From Store command failed, critical error occured from SQL Database connection");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_ERR);
        } catch (ClientNotConnected e) {
            log.info("Remove Product Package From Store command failed, username dosen't login to the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED);
        } catch (ProductNotExistInCatalog e) {
            log.info("Remove Product Package From Store command failed, product dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST);
        } catch (ProductPackageAmountNotMatch e) {
            log.info("Remove Product Package From Store command failed, try to place more than available");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_AMOUNT_BIGGER_THEN_AVAILABLE);
        } catch (ProductPackageNotExist e) {
            log.info("Remove Product Package From Store command failed, package dosen't exist in the system");
            outCommandWrapper = new CommandWrapper(ResultDescriptor.SM_PRODUCT_PACKAGE_DOES_NOT_EXIST);
        }
        log.info("Remove Product Package From Store with product package barcode " + productPackage.getSmartCode().getBarcode() + " and amount " + productPackage.getAmount() + " finished");
    }
}

Example 2 with ProductPackageNotExist

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

the class PlaceProductPackageOnShelvesTest method placeProductPackageOnShelvesCriticalErrorTest.

@Test
public void placeProductPackageOnShelvesCriticalErrorTest() {
    int senderID = 1;
    ProductPackage productPackage = new ProductPackage(new SmartCode(1, null), 1, new Location(0, 0, PlaceInMarket.WAREHOUSE));
    String command = new CommandWrapper(senderID, CommandDescriptor.PLACE_PRODUCT_PACKAGE_ON_SHELVES, new Gson().toJson(productPackage, ProductPackage.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doThrow(new CriticalError()).when(sqlDatabaseConnection).placeProductPackageOnShelves(senderID, productPackage);
    } catch (ClientNotConnected | ProductNotExistInCatalog | ProductPackageAmountNotMatch | ProductPackageNotExist e) {
        fail();
    } catch (CriticalError __) {
    /* Success */
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_ERR, out.getResultDescriptor());
}

Example 3 with ProductPackageNotExist

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

the class PlaceProductPackageOnShelvesTest method placeProductPackageOnShelvesClientNotConnectedTest.

@Test
public void placeProductPackageOnShelvesClientNotConnectedTest() {
    int senderID = 1;
    ProductPackage productPackage = new ProductPackage(new SmartCode(1, null), 1, new Location(0, 0, PlaceInMarket.WAREHOUSE));
    String command = new CommandWrapper(senderID, CommandDescriptor.PLACE_PRODUCT_PACKAGE_ON_SHELVES, new Gson().toJson(productPackage, ProductPackage.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doThrow(new ClientNotConnected()).when(sqlDatabaseConnection).placeProductPackageOnShelves(senderID, productPackage);
    } catch (CriticalError | ProductNotExistInCatalog | ProductPackageAmountNotMatch | ProductPackageNotExist e) {
        fail();
    } catch (ClientNotConnected __) {
    /* Success */
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_SENDER_IS_NOT_CONNECTED, out.getResultDescriptor());
}

Example 4 with ProductPackageNotExist

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

the class PlaceProductPackageOnShelvesTest method placeProductPackageOnShelvesProductNotExistInCatalogTest.

@Test
public void placeProductPackageOnShelvesProductNotExistInCatalogTest() {
    int senderID = 1;
    ProductPackage productPackage = new ProductPackage(new SmartCode(1, null), 1, new Location(0, 0, PlaceInMarket.WAREHOUSE));
    String command = new CommandWrapper(senderID, CommandDescriptor.PLACE_PRODUCT_PACKAGE_ON_SHELVES, new Gson().toJson(productPackage, ProductPackage.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doThrow(new ProductNotExistInCatalog()).when(sqlDatabaseConnection).placeProductPackageOnShelves(senderID, productPackage);
    } catch (CriticalError | ClientNotConnected | ProductPackageAmountNotMatch | ProductPackageNotExist e) {
        fail();
    } catch (ProductNotExistInCatalog __) {
    /* Success */
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_CATALOG_PRODUCT_DOES_NOT_EXIST, out.getResultDescriptor());
}

Example 5 with ProductPackageNotExist

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

the class PlaceProductPackageOnShelvesTest method placeProductPackageOnShelvesSuccessfulTest.

@Test
public void placeProductPackageOnShelvesSuccessfulTest() {
    int senderID = 1;
    ProductPackage productPackage = new ProductPackage(new SmartCode(1, null), 1, new Location(0, 0, PlaceInMarket.WAREHOUSE));
    String command = new CommandWrapper(senderID, CommandDescriptor.PLACE_PRODUCT_PACKAGE_ON_SHELVES, new Gson().toJson(productPackage, ProductPackage.class)).serialize();
    CommandExecuter commandExecuter = new CommandExecuter(command);
    CommandWrapper out;
    try {
        Mockito.doNothing().when(sqlDatabaseConnection).placeProductPackageOnShelves(senderID, productPackage);
    } catch (CriticalError | ClientNotConnected | ProductNotExistInCatalog | ProductPackageAmountNotMatch | ProductPackageNotExist e) {
        fail();
    }
    out = commandExecuter.execute(sqlDatabaseConnection);
    assertEquals(ResultDescriptor.SM_OK, out.getResultDescriptor());
}