PatchDebitor

2

tests

0

failures

0

ignored

2.888s

duration

100%

successful

Tests

Test Duration Result
globalAdmin_withoutAssumedRole_canPatchArbitraryDebitor() 1.429s passed
theContactAdmin_canNotPatchARelatedDebitor() 1.459s passed

Standard output

ContextBasedTestWithCleanup.retrieveInitialTestData
theContactAdmin_canNotPatchARelatedDebitor(): TOTAL OBJECT COUNT (initial): 210 -> 210
2026-08-10T16:31:23.035Z  WARN 382 --- [o-auto-1-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: P0001
2026-08-10T16:31:23.036Z ERROR 382 --- [o-auto-1-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: [403] Subject {49ed3242-8186-4ae6-b8c2-fad88f6f9b65} is not allowed to update hs_office.debitor uuid 3cf3ff9c-f34b-408b-b8a3-46d3e2406a10
  Where: PL/pgSQL function hs_office.debitor_instead_of_update_tf() line 18 at RAISE
HTTP/1.1 403 
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
X-Content-Type-Options: nosniff
X-XSS-Protection: 0
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: 0
X-Frame-Options: DENY
Content-Type: application/json
Transfer-Encoding: chunked
Date: Mon, 10 Aug 2026 16:31:23 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "timestamp": "2026-08-10 04:31:23",
    "path": "",
    "statusCode": 403,
    "statusPhrase": "Forbidden",
    "message": "ERROR: [403] Subject {49ed3242-8186-4ae6-b8c2-fad88f6f9b65} is not allowed to update hs_office.debitor uuid 3cf3ff9c-f34b-408b-b8a3-46d3e2406a10"
}
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
2026-08-10T16:31:23.103Z  WARN 382 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2026-08-10T16:31:23.104Z ERROR 382 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: update or delete on table "relation" violates foreign key constraint "debitor_debitorreluuid_fkey" on table "debitor"
  Detail: Key (uuid)=(38e61a6d-962f-4fcb-b17e-2a6cbcc9bfb7) is still referenced from table "debitor".
DELETING leaked hs_office.relation#38e61a6d-962f-4fcb-b17e-2a6cbcc9bfb7 FAILED org.hibernate.exception.ConstraintViolationException: JDBC exception executing SQL [DELETE FROM hs_office.relation WHERE uuid=?] [ERROR: update or delete on table "relation" violates foreign key constraint "debitor_debitorreluuid_fkey" on table "debitor"
  Detail: Key (uuid)=(38e61a6d-962f-4fcb-b17e-2a6cbcc9bfb7) is still referenced from table "debitor".] [n/a]
DELETING leaked hs_office.debitor#3cf3ff9c-f34b-408b-b8a3-46d3e2406a10 SUCCEEDED
theContactAdmin_canNotPatchARelatedDebitor(): TOTAL OBJECT COUNT (after): 210 -> 210
ContextBasedTestWithCleanup.retrieveInitialTestData
globalAdmin_withoutAssumedRole_canPatchArbitraryDebitor(): TOTAL OBJECT COUNT (initial): 210 -> 210
HTTP/1.1 200 
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
X-Content-Type-Options: nosniff
X-XSS-Protection: 0
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: 0
X-Frame-Options: DENY
Content-Type: application/json
Transfer-Encoding: chunked
Date: Mon, 10 Aug 2026 16:31:24 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "uuid": "1f5c0acb-6958-4788-8db7-8026f410d9d0",
    "debitorRel": {
        "uuid": "424f248c-7bd2-4c0b-8ddc-9398880367ed",
        "anchor": {
            "uuid": "51e1eada-c81f-40c0-9e0c-007cb423e399",
            "personType": "LEGAL_PERSON",
            "tradeName": "Fourth eG",
            "salutation": null,
            "title": null,
            "givenName": null,
            "familyName": null
        },
        "holder": {
            "uuid": "51e1eada-c81f-40c0-9e0c-007cb423e399",
            "personType": "LEGAL_PERSON",
            "tradeName": "Fourth eG",
            "salutation": null,
            "title": null,
            "givenName": null,
            "familyName": null
        },
        "type": "DEBITOR",
        "mark": null,
        "contact": {
            "uuid": "6979b9fa-38a7-4541-bd01-e321635b268d",
            "caption": "tenth contact",
            "postalAddress": {
                "country": "Germany"
            },
            "emailAddresses": {
                "main": "contact-admin@tenthcontact.example.com"
            },
            "phoneNumbers": {
                "phone_office": "+49 123 1234567"
            }
        }
    },
    "debitorNumber": "D-1000494",
    "debitorNumberSuffix": "94",
    "partner": {
        "uuid": "af047ad7-32f5-43bf-aaaa-e8b232cb1aa6",
        "partnerNumber": "P-10004",
        "partnerRel": {
            "uuid": "8b6a0fc0-27e0-4361-924b-a70c838f41b0",
            "anchor": {
                "uuid": "dec68a50-b2c0-4351-a344-f986596b8acb",
                "personType": "LEGAL_PERSON",
                "tradeName": "Hostsharing eG",
                "salutation": null,
                "title": null,
                "givenName": null,
                "familyName": null
            },
            "holder": {
                "uuid": "51e1eada-c81f-40c0-9e0c-007cb423e399",
                "personType": "LEGAL_PERSON",
                "tradeName": "Fourth eG",
                "salutation": null,
                "title": null,
                "givenName": null,
                "familyName": null
            },
            "type": "PARTNER",
            "mark": null,
            "contact": {
                "uuid": "68d38f2a-96db-4dda-a4e2-d92aaefced7b",
                "caption": "fourth contact",
                "postalAddress": {
                    "country": "Germany"
                },
                "emailAddresses": {
                    "main": "contact-admin@fourthcontact.example.com"
                },
                "phoneNumbers": {
                    "phone_office": "+49 123 1234567"
                }
            }
        },
        "details": {
            "uuid": "29238b74-b51f-475b-89ce-e1765dc84d5a",
            "registrationOffice": "Hamburg",
            "registrationNumber": "RegNo123456789",
            "birthName": null,
            "birthPlace": null,
            "birthday": null,
            "dateOfDeath": null
        }
    },
    "billable": true,
    "vatId": "VAT222222",
    "vatCountryCode": "AA",
    "vatBusiness": true,
    "vatReverseCharge": false,
    "refundBankAccount": null,
    "defaultPrefix": "for"
}
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
2026-08-10T16:31:24.543Z  WARN 382 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2026-08-10T16:31:24.544Z ERROR 382 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: update or delete on table "relation" violates foreign key constraint "debitor_debitorreluuid_fkey" on table "debitor"
  Detail: Key (uuid)=(424f248c-7bd2-4c0b-8ddc-9398880367ed) is still referenced from table "debitor".
DELETING leaked hs_office.relation#424f248c-7bd2-4c0b-8ddc-9398880367ed FAILED org.hibernate.exception.ConstraintViolationException: JDBC exception executing SQL [DELETE FROM hs_office.relation WHERE uuid=?] [ERROR: update or delete on table "relation" violates foreign key constraint "debitor_debitorreluuid_fkey" on table "debitor"
  Detail: Key (uuid)=(424f248c-7bd2-4c0b-8ddc-9398880367ed) is still referenced from table "debitor".] [n/a]
DELETING leaked hs_office.debitor#1f5c0acb-6958-4788-8db7-8026f410d9d0 SUCCEEDED
globalAdmin_withoutAssumedRole_canPatchArbitraryDebitor(): TOTAL OBJECT COUNT (after): 210 -> 210