add audit journal log for hs_office_person

Michael Hoennig

2022-10-13 472734a516da10b5262b9f47ee104ba953c30b50

add audit journal log for hs_office_person

 src/main/resources/db/changelog/210-hs-office-person.sql

@@ -17,3 +17,11 @@
    familyName     varchar(48)
);
--//


-- ============================================================================
--changeset hs-office-person-MAIN-TABLE-JOURNAL:1 endDelimiter:--//
-- ----------------------------------------------------------------------------

call create_journal('hs_office_person');
--//

 src/test/java/net/hostsharing/hsadminng/hs/office/person/HsOfficePersonRepositoryIntegrationTest.java

@@ -20,6 +20,7 @@

import javax.persistence.EntityManager;
import javax.servlet.http.HttpServletRequest;
import java.util.Arrays;
import java.util.List;
import java.util.function.Supplier;

@@ -265,6 +266,24 @@
        }
    }

    @Test
    public void auditJournalLogIsAvailable() {
        // given
        final var query = em.createNativeQuery("""
                select c.currenttask, j.targettable, j.targetop
                    from tx_journal j
                    join tx_context c on j.txid = c.txid
                    where targettable = 'hs_office_person';
                    """);

        // when
        @SuppressWarnings("unchecked") final List<Object[]> customerLogEntries = query.getResultList();

        // then
        assertThat(customerLogEntries).map(Arrays::toString)
                .contains("[creating RBAC test person First GmbH, hs_office_person, INSERT]");
    }

    @AfterEach
    void cleanup() {
        context("superuser-alex@hostsharing.net", null);