DeleteByUuid

3

tests

0

failures

0

ignored

5.189s

duration

100%

successful

Tests

Test Duration Result
deletingABookingItemAlsoDeletesRelatedRolesAndGrants() 2.544s passed
globalAdmin_withoutAssumedRole_canDeleteAnyBookingItem() 1.337s passed
nonGlobalAdmin_canNotDeleteTheirRelatedBookingItem() 1.308s passed

Standard output

2026-08-10T16:29:58.251Z  INFO 374 --- [    Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.booking.item.HsBookingItemRepositoryIntegrationTest$DeleteByUuid]: DeleteByUuid does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T16:29:58.298Z  INFO 374 --- [    Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.booking.item.HsBookingItemRepositoryIntegrationTest$DeleteByUuid
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
deletingABookingItemAlsoDeletesRelatedRolesAndGrants(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,hbpre1_0.version from hs_booking.project hbpre1_0 where hbpre1_0.caption=?
Hibernate: select hbde1_0.uuid,hbde1_0.debitornumber,hbde1_0.defaultprefix from hs_booking.debitor_xv hbde1_0 where hbde1_0.uuid=?
toCleanup(class net.hostsharing.hsadminng.hs.booking.item.HsBookingItemRbacEntity, bb580c93-0ad3-4b9f-b844-e9aa84202cbe
Hibernate: insert into hs_booking.item_rv (caption,parentitemuuid,projectuuid,resources,type,validity,version,uuid) values (?,?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
Hibernate: select sbi1_0.parentitemuuid,sbi1_0.uuid,sbi1_0.caption,sbi1_0.projectuuid,sbi1_0.resources,sbi1_0.type,sbi1_0.validity,sbi1_0.version from hs_booking.item sbi1_0 where sbi1_0.parentitemuuid=?
Hibernate: delete from hs_booking.item_rv where uuid=? and version=?
Hibernate: select rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: DELETE FROM hs_booking.item WHERE uuid=?
DELETING temporary HsBookingItemRbacEntity#bb580c93-0ad3-4b9f-b844-e9aa84202cbe deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
deletingABookingItemAlsoDeletesRelatedRolesAndGrants(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdmin_withoutAssumedRole_canDeleteAnyBookingItem(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,hbpre1_0.version from hs_booking.project hbpre1_0 where hbpre1_0.caption=?
Hibernate: select hbde1_0.uuid,hbde1_0.debitornumber,hbde1_0.defaultprefix from hs_booking.debitor_xv hbde1_0 where hbde1_0.uuid=?
toCleanup(class net.hostsharing.hsadminng.hs.booking.item.HsBookingItemRbacEntity, b145443b-737c-4dca-b117-0247abab540b
Hibernate: insert into hs_booking.item_rv (caption,parentitemuuid,projectuuid,resources,type,validity,version,uuid) values (?,?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
Hibernate: select sbi1_0.parentitemuuid,sbi1_0.uuid,sbi1_0.caption,sbi1_0.projectuuid,sbi1_0.resources,sbi1_0.type,sbi1_0.validity,sbi1_0.version from hs_booking.item sbi1_0 where sbi1_0.parentitemuuid=?
Hibernate: delete from hs_booking.item_rv where uuid=? and version=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: DELETE FROM hs_booking.item WHERE uuid=?
DELETING temporary HsBookingItemRbacEntity#b145443b-737c-4dca-b117-0247abab540b deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdmin_withoutAssumedRole_canDeleteAnyBookingItem(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
nonGlobalAdmin_canNotDeleteTheirRelatedBookingItem(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,hbpre1_0.version from hs_booking.project hbpre1_0 where hbpre1_0.caption=?
Hibernate: select hbde1_0.uuid,hbde1_0.debitornumber,hbde1_0.defaultprefix from hs_booking.debitor_xv hbde1_0 where hbde1_0.uuid=?
toCleanup(class net.hostsharing.hsadminng.hs.booking.item.HsBookingItemRbacEntity, aeab819c-d9c4-496e-b5cb-3a269ec15ac7
Hibernate: insert into hs_booking.item_rv (caption,parentitemuuid,projectuuid,resources,type,validity,version,uuid) values (?,?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
Hibernate: select sbi1_0.parentitemuuid,sbi1_0.uuid,sbi1_0.caption,sbi1_0.projectuuid,sbi1_0.resources,sbi1_0.type,sbi1_0.validity,sbi1_0.version from hs_booking.item sbi1_0 where sbi1_0.parentitemuuid=?
Hibernate: delete from hs_booking.item_rv where uuid=? and version=?
2026-08-10T16:30:03.068Z  WARN 374 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: P0001
2026-08-10T16:30:03.068Z ERROR 374 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: [403] Subject {05c0576f-a490-4d05-9ea0-e16c8956617d} is not allowed to delete hs_booking.item uuid aeab819c-d9c4-496e-b5cb-3a269ec15ac7
  Where: PL/pgSQL function hs_booking.item_instead_of_delete_tf() line 7 at RAISE
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item_rv hbire1_0 where hbire1_0.uuid=?
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: DELETE FROM hs_booking.item WHERE uuid=?
DELETING temporary HsBookingItemRbacEntity#aeab819c-d9c4-496e-b5cb-3a269ec15ac7 deleted 1 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
nonGlobalAdmin_canNotDeleteTheirRelatedBookingItem(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0