Step definitions for specifying authority relationships
# language: en @integratie @stap-documentatie @skip-verify Feature: Step definitions for specifying authority relationships Background: Given table 'lo3_pl' contains no rows And table 'lo3_pl_persoon' contains no rows Scenario: '{naam}' was born as a foundling {relatieve datum} Given the person 'Theo' with citizen service number '000000036' * is a minor And 'Theo' was born as a foundling 3 years ago When the SQL statements generated from the Given steps have been executed Then person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 1 | P | 0 | 0 | 000000036 | Theo | 3 jaar geleden | | 6030 | 1AA0100 | | | 1 | 1 | 0 | 0 | | . | | V | | 1AA0100 | 3 jaar geleden | | 1 | 2 | 0 | 0 | | | | | | 1AA0100 | | Scenario: is registered with a temporary place of residence in the Netherlands Given the person 'Tosca' with citizen service number '000000012' * is registered with a temporary place of residence in the Netherlands When the SQL statements generated from the Given steps have been executed Then person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Tosca | 6030 | 1AA0100 | And person 'Tosca' has the following rows in table 'lo3_pl_tijdelijke_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | inschrijving_datum | | 1 | 0 | 0518 | gisteren - 1 jaar | Scenario: the registered partnership of '{naam1}' and '{naam2}' was dissolved {relatieve datum} Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And 'Arjan' and 'Tosca' entered into a registered partnership 7 years ago And the registered partnership of 'Arjan' and 'Tosca' was dissolved 2 years ago When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | relatie_start_datum | relatie_start_plaats | relatie_start_land_code | relatie_eind_datum | relatie_eind_plaats | relatie_eind_land_code | verbintenis_soort | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | 1AA0100 | | | | | | | | | 1 | R | 0 | 1 | 000000024 | Tosca | | | 7 jaar geleden | 518 | 6030 | | | | P | | 1 | R | 0 | 0 | 000000024 | Tosca | | | | | | 2 jaar geleden | 518 | 6030 | P | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | relatie_start_datum | relatie_start_plaats | relatie_start_land_code | relatie_eind_datum | relatie_eind_plaats | relatie_eind_land_code | verbintenis_soort | | 2 | P | 0 | 0 | 000000024 | Tosca | 6030 | 1AA0100 | | | | | | | | | 2 | R | 0 | 1 | 000000012 | Arjan | | | 7 jaar geleden | 518 | 6030 | | | | P | | 2 | R | 0 | 0 | 000000012 | Arjan | | | | | | 2 jaar geleden | 518 | 6030 | P | Scenario: has '{naam}' as parent from the date of birth # this step is completely identical to step "heeft '{naam}' als ouder" # the addition is only meant to stress to the reader that the parent is named on the birth certificate and that the family-law relationship equals the date of birth Given the person 'Arjan' with citizen service number '000000012' And the person 'Theo' with citizen service number '000000036' * has 'Arjan' as parent from the date of birth When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 2 | P | 0 | 0 | 000000036 | Theo | 6030 | 1AA0100 | | | 2 | 1 | 0 | 0 | 000000012 | Arjan | | 1AA0100 | gisteren - 17 jaar | Scenario: has '{naam1}' and '{naam2}' as parents from the date of birth # this step is completely identical to step "heeft '{naam1}' en '{naam2}' als ouders" # the addition is only meant to stress to the reader that the parent is named on the birth certificate and that the family-law relationship equals the date of birth Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' * has 'Arjan' and 'Tosca' as parents from the date of birth When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 2 | P | 0 | 0 | 000000024 | Tosca | 6030 | 1AA0100 | | 2 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | 6030 | 1AA0100 | | | 3 | 1 | 0 | 0 | 000000012 | Arjan | | 1AA0100 | gisteren - 17 jaar | | 3 | 2 | 0 | 0 | 000000024 | Tosca | | 1AA0100 | gisteren - 17 jaar | Scenario: '{naam}' was adopted {relatieve datum} by '{naam}' # the kind of parent (persoon_type '1' or '2') is the first place available # if there is no parent 1 yet, the adoptive parent becomes parent 1 Given the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' And 'Theo' was adopted by 'Tosca' 3 years ago When the SQL statements generated from the Given steps have been executed Then person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000024 | Tosca | 6030 | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | 1AQ0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 2 | P | 0 | 0 | 000000036 | Theo | 6029 | 1AQ0100 | | | 2 | 1 | 0 | 0 | 000000024 | Tosca | | 1AQ0100 | 3 jaar geleden | Scenario: adoption alongside another parent: '{naam}' was adopted {relatieve datum} by '{naam}' # the kind of parent (persoon_type '1' or '2') is the first place available # if parent 1 already exists and parent 1 has geslachts_naam with a value other than '.', the adoptive parent becomes parent 2 Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' * has 'Tosca' as parent And 'Theo' was adopted by 'Arjan' 3 years ago When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | 1AQ0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 2 | P | 0 | 0 | 000000024 | Tosca | 6030 | 1AA0100 | | 2 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | 4 jaar geleden | | 6030 | 1AQ0100 | | | 3 | 1 | 0 | 0 | 000000024 | Tosca | | | | 1AA0100 | gisteren - 17 jaar | | 3 | 2 | 0 | 0 | 000000012 | Arjan | | | | 1AQ0100 | 3 jaar geleden | Scenario: adoption replaces a period parent: '{naam}' was adopted {relatieve datum} by '{naam}' # the kind of parent (persoon_type '1' or '2') is the first place available # if parent 1 has geslachts_naam empty, or if parent 1 has geslachts_naam '.', the adoptive parent becomes parent 1 Given the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' And 'Theo' was born as a foundling 4 years ago And 'Theo' was adopted by 'Tosca' 3 years ago When the SQL statements generated from the Given steps have been executed Then person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | geslachts_aand | akte_nr | | 1 | P | 0 | 0 | 000000024 | Tosca | 6030 | V | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | | 1AQ0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 2 | P | 0 | 0 | 000000036 | Theo | 4 jaar geleden | | 6030 | 1AQ0100 | | | 2 | 1 | 0 | 0 | 000000024 | Tosca | | | | 1AQ0100 | 3 jaar geleden | | 2 | 1 | 0 | 1 | | . | | V | | 1AA0100 | 4 jaar geleden | | 2 | 2 | 0 | 0 | | | | | | 1AA0100 | | Scenario: carrying over data of parent and child: '{naam}' was adopted {relatieve datum} by '{naam}' Given the person 'Tosca' with citizen service number '000000024' * is of full age * is a woman And the person 'Theo' with citizen service number '000000036' * was born 5 years ago And 'Theo' was adopted by 'Tosca' 3 years ago When the SQL statements generated from the Given steps have been executed Then person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | | 1 | P | 0 | 0 | 000000024 | Tosca | gisteren - 45 jaar | 6030 | V | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | 5 jaar geleden | | | 1AQ0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 2 | P | 0 | 0 | 000000036 | Theo | 5 jaar geleden | | 6029 | 1AQ0100 | | | 2 | 1 | 0 | 0 | 000000024 | Tosca | gisteren - 45 jaar | V | | 1AQ0100 | 3 jaar geleden | Scenario Outline: '{naam}' was <datum stapdefinitie> adopted by '{naam}' and '{naam}' Given the person 'Arjan' with citizen service number '000000012' * is a man And the person 'Tosca' with citizen service number '000000024' * is a woman And the person 'Theo' with citizen service number '000000036' * is a minor * was born in Germany And 'Theo' was <datum in stap> adopted by 'Tosca' and 'Arjan' When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | geslachts_aand | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | M | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | | 1AQ0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | geslachts_aand | akte_nr | | 2 | P | 0 | 0 | 000000024 | Tosca | 6030 | V | 1AA0100 | | 2 | K | 0 | 0 | 000000036 | Theo | | | 1AQ0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | | 6029 | 1AQ0100 | | | 3 | 1 | 0 | 0 | 000000024 | Tosca | | V | | 1AQ0100 | <datum familierechtelijke betrekking> | | 3 | 2 | 0 | 0 | 000000012 | Arjan | | M | | 1AQ0100 | <datum familierechtelijke betrekking> | Examples: | datum stapdefinitie | datum in stap | datum familierechtelijke betrekking | | op {datum} | op 30-11-2019 | 20191130 | | {relatieve datum} | 2 jaar geleden | 2 jaar geleden | | {relatieve datum} | gisteren - 10 jaar | gisteren - 10 jaar | Scenario: '{naam}' was adopted abroad by '{naam}' and '{naam}' on {datum} with document '{document beschrijving}' Given the person 'Arjan' with citizen service number '000000012' * is of full age * is a man And the person 'Tosca' with citizen service number '000000024' * is of full age * is a woman And the person 'Theo' with citizen service number '000000036' * is a minor * was born in Germany And 'Theo' was adopted abroad by 'Tosca' and 'Arjan' on 30-11-2019 with document 'ad akte 6029' When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | doc_beschrijving | | 1 | P | 0 | 0 | 000000012 | Arjan | gisteren - 45 jaar | 6030 | M | 1AA0100 | | | 1 | K | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | | | | ad akte 6029 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | doc_beschrijving | | 2 | P | 0 | 0 | 000000024 | Arjan | gisteren - 45 jaar | 6030 | V | 1AA0100 | | | 2 | K | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | | | | ad akte 6029 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geslachts_aand | geboorte_land_code | doc_beschrijving | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | | 6029 | ad akte 6029 | | | 3 | 1 | 0 | 0 | 000000024 | Tosca | gisteren - 45 jaar | V | | ad akte 6029 | 20191130 | | 3 | 2 | 0 | 0 | 000000012 | Arjan | gisteren - 45 jaar | M | | ad akte 6029 | 20191130 | Scenario: '{naam}' has denied being the father of '{naam}' Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' * is a minor * has 'Arjan' and 'Tosca' as parents And 'Arjan' has denied being the father of 'Theo' When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | | 6030 | 1AA0100 | | 1 | K | 0 | 1 | 000000036 | Theo | gisteren - 17 jaar | | 1AA0100 | | 1 | K | 0 | 0 | | | | | 1AE0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | 2 | P | 0 | 0 | 000000024 | Tosca | | 6030 | 1AA0100 | | 2 | K | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | 6030 | 1AA0100 | | | 3 | 1 | 0 | 1 | 000000012 | Arjan | | | 1AA0100 | gisteren - 17 jaar | | 3 | 1 | 0 | 0 | | | | | 1AE0100 | | | 3 | 2 | 0 | 0 | 000000024 | Tosca | | | 1AA0100 | gisteren - 17 jaar | Scenario: {relatieve datum} '{naam}' denied parenthood Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' * is a minor * has 'Arjan' and 'Tosca' as parents And 4 years ago 'Arjan' denied parenthood When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | | 6030 | 1AA0100 | | 1 | K | 0 | 1 | 000000036 | Theo | gisteren - 17 jaar | | 1AA0100 | | 1 | K | 0 | 0 | | | | | 1AE0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000024 | Tosca | | 6030 | 1AA0100 | | 1 | K | 0 | 1 | 000000036 | Theo | gisteren - 17 jaar | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | geldigheid_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | gisteren - 17 jaar | 6030 | 1AA0100 | | | | 3 | 1 | 0 | 1 | 000000012 | Arjan | | | 1AA0100 | gisteren - 17 jaar | | | 3 | 1 | 0 | 0 | | | | | 1AE0100 | | 4 jaar geleden | | 3 | 2 | 0 | 0 | 000000024 | Tosca | | | 1AA0100 | gisteren - 17 jaar | | Scenario: {relatievedatum} authority was awarded in a judicial ruling to <gezaghebbende in stapdefinitie> Given the person 'Arjan' with citizen service number '000000012' And the person 'Tosca' with citizen service number '000000024' And the person 'Theo' with citizen service number '000000036' * has 'Arjan' and 'Tosca' as parents And <relatieve datum> a judicial ruling awarded authority to <gezaghebbende> When the SQL statements generated from the Given steps have been executed Then person 'Arjan' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 1 | 0 | And person 'Arjan' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 1 | P | 0 | 0 | 000000012 | Arjan | 6030 | 1AA0100 | | 1 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Tosca' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 2 | 0 | And person 'Tosca' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | 2 | P | 0 | 0 | 000000024 | Tosca | 6030 | 1AA0100 | | 2 | K | 0 | 0 | 000000036 | Theo | | 1AA0100 | And person 'Theo' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | 3 | 0 | And person 'Theo' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | 3 | P | 0 | 0 | 000000036 | Theo | 6030 | 1AA0100 | | | 3 | 1 | 0 | 0 | 000000012 | Arjan | | 1AA0100 | gisteren - 17 jaar | | 3 | 2 | 0 | 0 | 000000024 | Tosca | | 1AA0100 | gisteren - 17 jaar | And person 'Theo' has the following rows in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | 3 | 0 | <indicatie gezag> | <relatieve datum> | Examples: | relatieve datum | gezaghebbende | indicatie gezag | gezaghebbende in stapdefinitie | | 6 jaar geleden | 'Arjan' | 1 | '{naam}' | | vorige maand | 'Tosca' | 2 | '{naam}' | | gisteren - 5 jaar | een voogdijinstelling | D | een voogdijinstelling | | gisteren - 4 jaar | een derde | D | een derde | | 2 jaar geleden | beide ouders | 12 | beide ouders | | 2 jaar geleden | 'Arjan' en een derde | 1D | '{naam}' en een derde | | 2 jaar geleden | 'Tosca' en een derde | 2D | '{naam}' en een derde |