@Test
  public void testFindAll() throws Exception {

    logger.debug("\nSTARTED testFindAll()\n");
    int rowCount = countRowsInTable("audb.allagamenti_osserv");

    if (rowCount > 0) {

      Result<List<AllagamentiOsserv>> allItems = allagamentiOsservService.findAll(TEST_USER_ID);
      assertTrue(
          "AllagamentiOsserv.findAll list not equal to row count of table audb.allagamenti_osserv",
          rowCount == allItems.getData().size());

    } else {
      throw new IllegalStateException("INVALID TESTING SCENARIO: AllagamentiOsserv table is empty");
    }
    logger.debug("\nFINISHED testFindAll()\n");
  }
  @Test
  public void testFind() throws Exception {

    logger.debug("\nSTARTED testFind()\n");
    Result<List<AllagamentiOsserv>> allItems = allagamentiOsservService.findAll(TEST_USER_ID);

    logger.debug(allItems.getMsg());

    assertTrue(allItems.getData().size() > 0);

    // get the first item in the list
    AllagamentiOsserv a1 = allItems.getData().get(0);

    int id = a1.getId();

    Result<AllagamentiOsserv> c2 = allagamentiOsservService.find(id, TEST_USER_ID);

    assertTrue(a1.equals(c2.getData()));
    logger.debug("\nFINISHED testFind()\n");
  }
  @Test
  public void testUpdate() throws Exception {

    logger.debug("\nSTARTED testUpdate()\n");
    final String NEW_NOTE = "Update AllagamentiOsserv notes test";

    Result<List<AllagamentiOsserv>> list = allagamentiOsservService.findAll(TEST_USER_ID);
    AllagamentiOsserv a = list.getData().get(0);
    // c.setCompanyName(NEW_NAME);

    allagamentiOsservService.store(
        a.getIdAllagamentoOsserv(),
        a.getIndirizzo(),
        Date.from(Instant.now()),
        Date.from(Instant.now()),
        74001,
        1,
        1,
        1,
        NEW_NOTE,
        //                TEST_USER_ID,
        //                Date.from(Instant.now()),
        //                TEST_USER_ID,
        //                Date.from(Instant.now()),
        1,
        12.457256,
        41.902232,
        TEST_USER_ID);

    Result<AllagamentiOsserv> list2 =
        allagamentiOsservService.find(a.getIdAllagamentoOsserv(), TEST_USER_ID);

    assertTrue(list2.getData().getNoteAllagamento().equals(NEW_NOTE));

    logger.debug("\nFINISHED testUpdate()\n");
  }