Script that is a able to dump HSDB (legacy) data to csv files.
Dump of "office" module data already implemented.

@@ -42,0 +58,4 @@
+
+	./gradlew importOfficeData
+}
+alias import-office-data=importOfficeData

@@ -59,2 +60,4 @@
     private Range<LocalDate> validity;
 
+    @Column(name = "membership_fee_billable")
+    private boolean membershipFeeBillable;

@@ -10,3 +9,1 @@
-                - JOINT_AGENT       # e.g. heir
-                - ACCOUNTING_CONTACT
-                - TECHNICAL_CONTACT
+                - REPRESENTATIVE

@@ -21,2 +21,4 @@
 liquibase:
     contexts: dev
+
+hsadminng:

@@ -17,0 +16,4 @@
+    vatBusiness             boolean not null,
+    vatReverseCharge        boolean not null,
+    refundBankAccountUuid   uuid references hs_office_bankaccount(uuid),
+    defaultPrefix           char(3) not null

@@ -186,2 +188,4 @@
         partnerUuid = new.partnerUuid,
+        billable = new.billable,
         billingContactUuid = new.billingContactUuid,
+        debitorNumberSuffix = new.debitorNumberSuffix,

@@ -191,1 +195,3 @@
-        vatBusiness = new.vatBusiness
+        vatBusiness = new.vatBusiness,
+        vatreversecharge = new.vatreversecharge,
+        defaultPrefix = new.defaultPrefix

@@ -8,14 +8,17 @@
 /*
     Creates a single membership test record.
  */
+-- create or replace procedure createHsOfficeMembershipTestData( forPartnerTradeName varchar, forMainDebitorNumber integer )

@@ -18,1 +15,3 @@
-    newMemberNumber numeric;
+    currentTask         varchar;
+    idName              varchar;
+--     forDebitorNumberPrefix integer;

@@ -26,3 +29,3 @@
                       join hs_office_person person on person.uuid = partner.personUuid
                      where person.tradeName = forPartnerTradeName into relatedPartner;
-    select d.* from hs_office_debitor d where d.debitorNumber = forMainDebitorNumber into relatedDebitor;
+--     forDebitorNumberPrefix := forMainDebitorNumber/ 100;

@@ -33,6 +39,7 @@ begin
     raise notice '- using debitor (%): %', relatedDebitor.uuid, relatedDebitor;
     insert
         into hs_office_membership (uuid, partneruuid, maindebitoruuid, membernumber, validity, reasonfortermination)
+        -- values (uuid_generate_v4(), relatedPartner.uuid, relatedDebitor.uuid, forDebitorNumberPrefix, daterange('20221001' , null, '[]'), 'NONE');

@@ -50,1 +56,4 @@
+        call createHsOfficeMembershipTestData('Third OHG', 13);
     end;
+--     begin
+--         call createHsOfficeMembershipTestData('First GmbH', 1000100);

@@ -100,0 +127,4 @@
+                        HsOfficeDebitorEntity::setVatReverseCharge)
+                        .notNullable(),
+                new SimpleProperty<>(
+                        "personType",

@@ -103,0 +134,4 @@
+                        .notNullable(),
+                new SimpleProperty<>(
+                        "personType",
+                        HsOfficeDebitorPatchResource::setVatReverseCharge,

@@ -294,6 +297,7 @@ class HsOfficePartnerControllerAcceptanceTest {
                     .contentType(ContentType.JSON)
                     .body("""
                                {
+                                   "debitorNumerPrefix": "12345",

@@ -37,6 +39,14 @@ class RbacRoleControllerAcceptanceTest {
     @Autowired
     RbacRoleRepository rbacRoleRepository;
 
+    @Value("${HSADMINNG_POSTGRES_RESTRICTED_USERNAME}")

@@ -42,6 +43,14 @@ class RbacUserControllerAcceptanceTest {
     @Autowired
     RbacUserRepository rbacUserRepository;
 
+    @Value("${HSADMINNG_POSTGRES_RESTRICTED_USERNAME}")

@@ -27,3 +30,3 @@
 
     private static Stringify<HsOfficeCoopAssetsTransactionEntity> stringify = stringify(HsOfficeCoopAssetsTransactionEntity.class)
-            .withProp(e -> e.getMembership().getMemberNumber())
+            .withProp(e -> ofNullable(e.getMembership()).map(HsOfficeMembershipEntity::getMemberNumber).orElse(null))