Verblijfstitel Given step definitions

#language: en

@stap-documentatie
Feature: Verblijfstitel Given step definitions

  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'

  Scenario: the person with citizen service number '[bsn]' has obtained a 'verblijfstitel' with the following data
    Given the person with citizen service number '000000012' has obtained a 'verblijfstitel' with the following data
    | aanduiding verblijfstitel (39.10) |
    | 37                                |
    Then the generated SQL statements are
    | stap | categorie      | text                                                                                                                                                  | values               |
    | 1    | 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) VALUES($1,$2,$3,$4,$5)                                      | 9999,0,0,P,000000012 |
    |      | verblijfstitel | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,verblijfstitel_aand) VALUES($1,$2,$3)                                                          | 9999,0,37            |

  Scenario: the person has obtained a 'verblijfstitel' with the following data
    Given the person with citizen service number '000000012' has the following data
    | geslachtsnaam (02.40) |
    | Jansen                |
    And the person has obtained a 'verblijfstitel' with the following data
    | aanduiding verblijfstitel (39.10) |
    | 37                                |
    Then the generated SQL statements are
    | stap | categorie      | text                                                                                                                                                  | values                      |
    | 1    | 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,Jansen |
    |      | verblijfstitel | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,verblijfstitel_aand) VALUES($1,$2,$3)                                                          | 9999,0,37                   |

  Scenario: the 'verblijfstitel' has been changed to the following data
    Given the person with citizen service number '000000012' has obtained a 'verblijfstitel' with the following data
    | aanduiding verblijfstitel (39.10) |
    | 37                                |
    And the 'verblijfstitel' has been changed to the following data
    | aanduiding verblijfstitel (39.10) |
    | 38                                |
    Then the generated SQL statements are
    | stap | categorie      | text                                                                                                                                                  | values               |
    | 1    | 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) VALUES($1,$2,$3,$4,$5)                                      | 9999,0,0,P,000000012 |
    |      | verblijfstitel | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,verblijfstitel_aand) VALUES($1,$2,$3)                                                          | 9999,1,37            |
    |      |                | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,verblijfstitel_aand) VALUES($1,$2,$3)                                                          | 9999,0,38            |


  Scenario: Given the 'verblijfstitel' has been corrected to the following data
    Given the person with citizen service number '000000012' has obtained a 'verblijfstitel' with the following data
    | aanduiding verblijfstitel (39.10) |
    | 37                                |
    And the 'verblijfstitel' has been corrected to the following data
    | ingangsdatum geldigheid (85.10) |
    | 20031107                        |
    Then the generated SQL statements are
    | stap | categorie      | text                                                                                                                                                  | values               |
    | 1    | 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) VALUES($1,$2,$3,$4,$5)                                      | 9999,0,0,P,000000012 |
    |      | verblijfstitel | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,verblijfstitel_aand,onjuist_ind) VALUES($1,$2,$3,$4)                                           | 9999,1,37,O          |
    |      |                | INSERT INTO public.lo3_pl_verblijfstitel(pl_id,volg_nr,geldigheid_start_datum) VALUES($1,$2,$3)                                                       | 9999,0,20031107      |