persona changes step definitions

# language: en
@stap-documentatie @integratie
Feature: persona changes step definitions

  Scenario: was adopted {vandaag, gisteren of morgen x jaar geleden} by the Dutch adoptive parent {string} with a Dutch adoption certificate
    Given the minor 'Jan' with one parent 'Petra'
    * was adopted 1 years ago by the Dutch adoptive parent 'Piet' with a Dutch adoption certificate
    When the SQL statements generated from the Given steps have been executed
    Then person 'Petra' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Petra |          0 |
    And person 'Petra' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | akte_nr |
      | Petra |         0 |       0 | P            |         000000101 | Petra          | morgen - 37 jaar  | V              | 1_A____ |
    And person 'Petra' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Petra |         0 |       0 | K            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_A____ |
    And person 'Piet' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Piet  |          0 |
    And person 'Piet' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | akte_nr |
      | Piet  |         0 |       0 | P            |         000000104 | Piet           | morgen - 37 jaar | M              | 1_A____ |
    And person 'Piet' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Piet  |         0 |       0 | K            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_Q____ |
    And person 'Jan' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Jan   |          0 |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Jan   |         0 |       1 | P            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_A____ |
      | Jan   |         0 |       0 | P            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_Q____ |
    And person 'Jan' has the following row in table 'lo3_pl_verblijfplaats'
      | pl_id | volg_nr | inschrijving_gemeente_code |
      | Jan   |       0 |                       0518 |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | familie_betrek_start_datum | akte_nr | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand |
      | Jan   |         0 |       0 |            1 | gisteren - 17 jaar         | 1_A____ |         000000101 | Petra          | morgen - 37 jaar | V              |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | akte_nr | geldigheid_start_datum |
      | Jan   |         0 |       1 |            2 | 1_A____ | gisteren - 17 jaar     |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | familie_betrek_start_datum | akte_nr |
      | Jan   |         0 |       0 |            2 |         000000104 | Piet           | morgen - 37 jaar | M              | vandaag - 1 jaar           | 1_Q____ |

  Scenario: was adopted {vandaag, gisteren of morgen x jaar geleden} by two Dutch adoptive parents {moeder} and {vader} with a Dutch adoption certificate
    Given the minor 'Jan' with one parent 'Petra'
    * was adopted 1 years ago by two Dutch adoptive parents 'Paula' and 'Piet' with a Dutch adoption certificate
    When the SQL statements generated from the Given steps have been executed
    Then person 'Petra' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Petra |          0 |
    And person 'Petra' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | akte_nr |
      | Petra |         0 |       0 | P            |         000000101 | Petra          | morgen - 37 jaar | V              | 1_A____ |
    And person 'Petra' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Petra |         0 |       0 | K            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_A____ |
    Then person 'Paula' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Paula |          0 |
    And person 'Paula' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | akte_nr |
      | Paula |         0 |       0 | P            |         000000104 | Paula          | morgen - 37 jaar | V              | 1_A____ |
    And person 'Paula' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Paula |         0 |       0 | K            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_Q____ |
    Then person 'Piet' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Piet  |          0 |
    And person 'Piet' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | akte_nr |
      | Piet  |         0 |       0 | P            |         000000105 | Piet           | morgen - 37 jaar | M              | 1_A____ |
    And person 'Piet' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Piet  |         0 |       0 | K            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_Q____ |
    Then person 'Jan' has the following row in table 'lo3_pl'
      | pl_id | geheim_ind |
      | Jan   |          0 |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum     | geboorte_land_code | akte_nr |
      | Jan   |         0 |       1 | P            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_A____ |
      | Jan   |         0 |       0 | P            |         000000103 | Jan            | gisteren - 17 jaar |               6030 | 1_Q____ |
    And person 'Jan' has the following row in table 'lo3_pl_verblijfplaats'
      | pl_id | volg_nr | inschrijving_gemeente_code |
      | Jan   |       0 |                       0518 |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | familie_betrek_start_datum | akte_nr | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand |
      | Jan   |         0 |       1 |            1 | gisteren - 17 jaar         | 1_A____ |         000000101 | Petra          | morgen - 37 jaar | V              |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | familie_betrek_start_datum | akte_nr |
      | Jan   |         0 |       0 |            1 |         000000104 | Paula          | morgen - 37 jaar | V              | vandaag - 1 jaar           | 1_Q____ |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | akte_nr | geldigheid_start_datum |
      | Jan   |         0 |       1 |            2 | 1_A____ | gisteren - 17 jaar     |
    And person 'Jan' has the following row in table 'lo3_pl_persoon'
      | pl_id | stapel_nr | volg_nr | persoon_type | burger_service_nr | geslachts_naam | geboorte_datum   | geslachts_aand | familie_betrek_start_datum | akte_nr |
      | Jan   |         0 |       0 |            2 |         000000105 | Piet           | morgen - 37 jaar | M              | vandaag - 1 jaar           | 1_Q____ |