PatchDebitor

2

tests

0

failures

0

ignored

2.834s

duration

100%

successful

Tests

Test Duration Result
globalAdmin_withoutAssumedRole_canPatchArbitraryDebitor() 1.356s passed
theContactAdmin_canNotPatchARelatedDebitor() 1.478s passed

Standard output

ContextBasedTestWithCleanup.retrieveInitialTestData
theContactAdmin_canNotPatchARelatedDebitor(): TOTAL OBJECT COUNT (initial): 210 -> 210
2026-08-10T15:05:31.711Z  WARN 371 --- [o-auto-1-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: P0001
2026-08-10T15:05:31.713Z ERROR 371 --- [o-auto-1-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: [403] Subject {36fe4af6-c0dc-4b4f-aa5e-358f35188fde} is not allowed to update hs_office.debitor uuid 978651c8-48cf-4fa0-84d2-8149fb083e57
  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 15:05:31 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "timestamp": "2026-08-10 03:05:31",
    "path": "",
    "statusCode": 403,
    "statusPhrase": "Forbidden",
    "message": "ERROR: [403] Subject {36fe4af6-c0dc-4b4f-aa5e-358f35188fde} is not allowed to update hs_office.debitor uuid 978651c8-48cf-4fa0-84d2-8149fb083e57"
}
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
2026-08-10T15:05:31.769Z  WARN 371 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2026-08-10T15:05:31.770Z ERROR 371 --- [    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)=(556a99d3-c4c9-439a-a117-b093ef988995) is still referenced from table "debitor".
DELETING leaked hs_office.relation#556a99d3-c4c9-439a-a117-b093ef988995 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)=(556a99d3-c4c9-439a-a117-b093ef988995) is still referenced from table "debitor".] [n/a]
DELETING leaked hs_office.debitor#978651c8-48cf-4fa0-84d2-8149fb083e57 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 15:05:33 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "uuid": "bc62648d-3c38-419e-973c-790c962a4278",
    "debitorRel": {
        "uuid": "c17c4404-89b0-4813-9aa7-e6c1ebb18dc0",
        "anchor": {
            "uuid": "9100db5a-8c6a-4e35-8f32-d53c00c5adf2",
            "personType": "LEGAL_PERSON",
            "tradeName": "Fourth eG",
            "salutation": null,
            "title": null,
            "givenName": null,
            "familyName": null
        },
        "holder": {
            "uuid": "9100db5a-8c6a-4e35-8f32-d53c00c5adf2",
            "personType": "LEGAL_PERSON",
            "tradeName": "Fourth eG",
            "salutation": null,
            "title": null,
            "givenName": null,
            "familyName": null
        },
        "type": "DEBITOR",
        "mark": null,
        "contact": {
            "uuid": "cc8c6f18-2b09-4d1c-ab71-63a85cbb7e6c",
            "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": "c76fff7f-a546-4ae6-8889-d8a9ff6f6014",
        "partnerNumber": "P-10004",
        "partnerRel": {
            "uuid": "f35a3577-1ea6-4350-8d8a-b30252b3c5bc",
            "anchor": {
                "uuid": "fe35fd05-1333-4976-bf54-a56e4400148a",
                "personType": "LEGAL_PERSON",
                "tradeName": "Hostsharing eG",
                "salutation": null,
                "title": null,
                "givenName": null,
                "familyName": null
            },
            "holder": {
                "uuid": "9100db5a-8c6a-4e35-8f32-d53c00c5adf2",
                "personType": "LEGAL_PERSON",
                "tradeName": "Fourth eG",
                "salutation": null,
                "title": null,
                "givenName": null,
                "familyName": null
            },
            "type": "PARTNER",
            "mark": null,
            "contact": {
                "uuid": "fb20a4af-4179-4ca3-a535-e3d0d1255290",
                "caption": "fourth contact",
                "postalAddress": {
                    "country": "Germany"
                },
                "emailAddresses": {
                    "main": "contact-admin@fourthcontact.example.com"
                },
                "phoneNumbers": {
                    "phone_office": "+49 123 1234567"
                }
            }
        },
        "details": {
            "uuid": "1a825860-61a8-4e1d-8257-9539069d16ea",
            "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-10T15:05:33.135Z  WARN 371 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2026-08-10T15:05:33.135Z ERROR 371 --- [    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)=(c17c4404-89b0-4813-9aa7-e6c1ebb18dc0) is still referenced from table "debitor".
DELETING leaked hs_office.relation#c17c4404-89b0-4813-9aa7-e6c1ebb18dc0 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)=(c17c4404-89b0-4813-9aa7-e6c1ebb18dc0) is still referenced from table "debitor".] [n/a]
DELETING leaked hs_office.debitor#bc62648d-3c38-419e-973c-790c962a4278 SUCCEEDED
globalAdmin_withoutAssumedRole_canPatchArbitraryDebitor(): TOTAL OBJECT COUNT (after): 210 -> 210