BRP API / Personen / Features / gegeven-stap-definities-adoptie
Person has been adopted

# language: en
@stap-documentatie
Feature: Person has been adopted

  Background:
    Given the 1st 'SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl' statement has the result '9999'
    And the 2nd 'SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl' statement has the result '10000'
    And the 3rd 'SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl' statement has the result '10001'

  Scenario Outline: was adopted by '[aanduiding]' as parent [1 or 2]
    Given the person 'P2' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000012 | P2                    |
    And the person 'P1' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000036 | P1                    |
    * 'P1' was adopted by 'P2' as parent <ouder type>
    Then the generated SQL statements are
      | stap       | categorie          | text                                                                                                                                                                        | values                                                      |
      | persoon-P2 | inschrijving       | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                           0 |
      |            | persoon            | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                                     9999,0,0,P,000000012,P2 |
      |            | kind-1             | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                               |                             9999,0,0,K,000000036,P1,1AQ0100 |
      | persoon-P1 | inschrijving       | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                           0 |
      |            | persoon            | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                                    10000,0,1,P,000000036,P1 |
      |            | persoon            | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                               |                            10000,0,0,P,000000036,P1,1AQ0100 |
      |            | ouder-<ouder type> | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8) | 10000,0,0,<ouder type>,000000012,P2,10 jaar geleden,1AQ0100 |

    Examples:
      | ouder type |
      |          1 |
      |          2 |

  Scenario: was adopted by '[aanduiding]' as parent [1 or 2] with the following data
    Given the person 'P1' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000012 | P1                    |
    And the person 'P2' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000024 | P2                    |
    * 'P2' was adopted by 'P1' as parent 1 with the following data
      | datum ingang familierechtelijke betrekking (62.10) | aktenummer (81.20) |
      | gisteren - 5 jaar                                  |            2BR1211 |
    Then the generated SQL statements are
      | stap       | categorie    | text                                                                                                                                                                        | values                                             |
      | persoon-P1 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                  0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                            9999,0,0,P,000000012,P1 |
      |            | kind-1       | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                               |                    9999,0,0,K,000000024,P2,1AQ0100 |
      | persoon-P2 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                  0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                           10000,0,1,P,000000024,P2 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                               |                   10000,0,0,P,000000024,P2,1AQ0100 |
      |            | ouder-1      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8) | 10000,0,0,1,000000012,P1,gisteren - 5 jaar,2BR1211 |

  Scenario: was adopted by persons as parent 1 and parent 2
    Given the person 'P2' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000012 | P2                    |
    And the person 'P3' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000024 | P3                    |
    And the person 'P1' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000036 | P1                    |
    * is a minor
    * was adopted by 'P2' as parent 1
    * was adopted by 'P3' as parent 2
    Then the generated SQL statements are
      | stap       | categorie    | text                                                                                                                                                                        | values                                              |
      | persoon-P2 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                   0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                             9999,0,0,P,000000012,P2 |
      |            | kind-1       | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,geboorte_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8)             |  9999,0,0,K,000000036,P1,gisteren - 17 jaar,1AQ0100 |
      | persoon-P3 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                   0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                          |                            10000,0,0,P,000000024,P3 |
      |            | kind-1       | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,geboorte_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8)             | 10000,0,0,K,000000036,P1,gisteren - 17 jaar,1AQ0100 |
      | persoon-P1 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                       |                                                   0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,geboorte_datum) VALUES($1,$2,$3,$4,$5,$6,$7)                        |         10001,0,2,P,000000036,P1,gisteren - 17 jaar |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,geboorte_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8)             | 10001,0,1,P,000000036,P1,gisteren - 17 jaar,1AQ0100 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,geboorte_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8)             | 10001,0,0,P,000000036,P1,gisteren - 17 jaar,1AQ0100 |
      |            | ouder-1      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8) |    10001,0,0,1,000000012,P2,10 jaar geleden,1AQ0100 |
      |            | ouder-2      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7,$8) |    10001,0,0,2,000000024,P3,10 jaar geleden,1AQ0100 |

  Scenario: was adopted by '[aanduiding]' as parent [1 or 2] with the following data
    Given the person 'P1' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000012 | P1                    |
    And the person 'P2' has the following data
      | burgerservicenummer (01.20) | geslachtsnaam (02.40) |
      |                   000000024 | P2                    |
    * 'P2' was adopted by 'P1' as parent 1 with the following data
      | datum ingang familierechtelijke betrekking (62.10) | aktenummer (81.20) |
      | gisteren - 5 jaar                                  |            2BR1211 |
    And the adoption of 'P2' has been revoked for 'P1' as parent 1
    Then the generated SQL statements are
      | stap       | categorie    | text                                                                                                                                                                                       | values                                               |
      | persoon-P1 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                                      |                                                    0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam) VALUES($1,$2,$3,$4,$5,$6)                                                         |                              9999,0,0,P,000000012,P1 |
      |            | kind-1       | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                                              |                      9999,0,0,K,000000024,P2,1AQ0100 |
      | persoon-P2 | inschrijving | INSERT INTO public.lo3_pl(pl_id,mutatie_dt,geheim_ind) VALUES((SELECT COALESCE(MAX(pl_id), 0)+1 FROM public.lo3_pl),current_timestamp,$1) RETURNING *                                      |                                                    0 |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,onjuist_ind) VALUES($1,$2,$3,$4,$5,$6,$7)                                          |                           10000,0,2,P,000000024,P2,O |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr,onjuist_ind) VALUES($1,$2,$3,$4,$5,$6,$7,$8)                               |                   10000,0,1,P,000000024,P2,1AQ0100,O |
      |            | persoon      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,akte_nr) VALUES($1,$2,$3,$4,$5,$6,$7)                                              |                     10000,0,0,P,000000024,P2,1AR0200 |
      |            | ouder-1      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum,akte_nr,onjuist_ind) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9) | 10000,0,1,1,000000012,P1,gisteren - 5 jaar,2BR1211,O |
      |            | ouder-1      | INSERT INTO public.lo3_pl_persoon(pl_id,stapel_nr,volg_nr,persoon_type,burger_service_nr,geslachts_naam,familie_betrek_start_datum) VALUES($1,$2,$3,$4,$5,$6,$7)                           |             10000,0,0,1,000000012,P1,morgen - 2 jaar |