CreateRelationWithMark

3

tests

0

failures

0

ignored

3.871s

duration

100%

successful

Tests

Test Duration Result
globalAdmin_canCreateRelationWithNewMark() 1.282s passed
normalUser_canCreateRelationWithExistingMark() 1.291s passed
normalUser_cannotCreateRelationWithNewMark() 1.298s passed

Standard output

2026-08-10T13:36:09.746Z  INFO 368 --- [    Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRepositoryIntegrationTest$CreateRelationWithMark]: CreateRelationWithMark does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T13:36:09.757Z  INFO 368 --- [    Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRepositoryIntegrationTest$CreateRelationWithMark
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
normalUser_cannotCreateRelationWithNewMark(): 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 hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
2026-08-10T13:36:10.639Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: P0001
2026-08-10T13:36:10.639Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: [403] new mark "brand-new-list" for relation-type SUBSCRIBER may only be introduced by a global admin
  Where: PL/pgSQL function hs_office.relation_enforce_new_mark_by_global_admin() line 20 at RAISE
SQL statement "insert
            into hs_office.relation (uuid, version, anchoruuid, holderuuid, contactuuid, type, mark)
            values (new.uuid, new.version, new.anchoruuid, new.holderuuid, new.contactuuid, new.type, new.mark)
            returning *"
PL/pgSQL function hs_office.relation_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
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: 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
normalUser_cannotCreateRelationWithNewMark(): 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_canCreateRelationWithNewMark(): 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 hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRbacEntity, 85752d7e-a6c6-414f-b30c-2320f1857154
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
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_office.relation WHERE uuid=?
DELETING temporary HsOfficeRelationRbacEntity#85752d7e-a6c6-414f-b30c-2320f1857154 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_canCreateRelationWithNewMark(): 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
normalUser_canCreateRelationWithExistingMark(): 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 hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRbacEntity, 1baf762d-e807-4b4a-bbf1-20c0257f35d0
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
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_office.relation WHERE uuid=?
DELETING temporary HsOfficeRelationRbacEntity#1baf762d-e807-4b4a-bbf1-20c0257f35d0 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
normalUser_canCreateRelationWithExistingMark(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0