test/bdd/db/update/postcode.feature

   1 @DB
   2 Feature: Update of postcode
   3     Tests for updating of data related to postcodes
   4
   5     Scenario: A new postcode appears in the postcode and word table
   6         Given the places
   7            | osm | class | type  | addr+postcode | addr+housenumber | geometry |
   8            | N34 | place | house | 01982         | 111              |country:de |
   9         When importing
  10         Then location_postcode contains exactly
  11            | country | postcode | geometry |
  12            | de      | 01982    | country:de |
  13         When updating places
  14            | osm | class | type  | addr+postcode | addr+housenumber | geometry |
  15            | N35 | place | house | 4567          | 5                |country:ch |
  16         And updating postcodes
  17         Then location_postcode contains exactly
  18            | country | postcode | geometry |
  19            | de      | 01982    | country:de |
  20            | ch      | 4567     | country:ch |
  21         And there are word tokens for postcodes 01982,4567
  22
  23      Scenario: When the last postcode is deleted, it is deleted from postcode and word
  24         Given the places
  25            | osm | class | type  | addr+postcode | addr+housenumber | geometry |
  26            | N34 | place | house | 01982         | 111              |country:de |
  27            | N35 | place | house | 4567          | 5                |country:ch |
  28         When importing
  29         And marking for delete N34
  30         And updating postcodes
  31         Then location_postcode contains exactly
  32            | country | postcode | geometry |
  33            | ch      | 4567     | country:ch |
  34         And there are word tokens for postcodes 4567
  35         And there are no word tokens for postcodes 01982
  36
  37      Scenario: A postcode is not deleted from postcode and word when it exist in another country
  38         Given the places
  39            | osm | class | type  | addr+postcode | addr+housenumber | geometry |
  40            | N34 | place | house | 01982         | 111              |country:de |
  41            | N35 | place | house | 01982         | 5                |country:ch |
  42         When importing
  43         And marking for delete N34
  44         And updating postcodes
  45         Then location_postcode contains exactly
  46            | country | postcode | geometry |
  47            | ch      | 01982    | country:ch |
  48         And there are word tokens for postcodes 01982
  49
  50      Scenario: Updating a postcode is reflected in postcode table
  51         Given the places
  52            | osm | class | type     | addr+postcode |  geometry |
  53            | N34 | place | postcode | 01982         | country:de |
  54         When importing
  55         And updating places
  56            | osm | class | type     | addr+postcode |  geometry |
  57            | N34 | place | postcode | 20453         | country:de |
  58         And updating postcodes
  59         Then location_postcode contains exactly
  60            | country | postcode | geometry |
  61            | de      | 20453    | country:de |
  62         And there are word tokens for postcodes 20453
  63
  64      Scenario: When changing from a postcode type, the entry appears in placex
  65         When importing
  66         And updating places
  67            | osm | class | type     | addr+postcode |  geometry |
  68            | N34 | place | postcode | 01982         | country:de |
  69         Then placex has no entry for N34
  70         When updating places
  71            | osm | class | type  | addr+postcode | housenr |  geometry |
  72            | N34 | place | house | 20453         | 1       | country:de |
  73         Then placex contains
  74            | object | addr+housenumber | geometry |
  75            | N34    | 1                | country:de|
  76         And place contains exactly
  77            | object | class | type  |
  78            | N34    | place | house |
  79         When updating postcodes
  80         Then location_postcode contains exactly
  81            | country | postcode | geometry |
  82            | de      | 20453    | country:de |
  83         And there are word tokens for postcodes 20453
  84
  85      Scenario: When changing to a postcode type, the entry disappears from placex
  86         When importing
  87         And updating places
  88            | osm | class | type  | addr+postcode | housenr |  geometry |
  89            | N34 | place | house | 20453         | 1       | country:de |
  90         Then placex contains
  91            | object | addr+housenumber | geometry |
  92            | N34    | 1                | country:de|
  93         When updating places
  94            | osm | class | type     | addr+postcode |  geometry |
  95            | N34 | place | postcode | 01982         | country:de |
  96         Then placex has no entry for N34
  97         And place contains exactly
  98            | object | class | type     |
  99            | N34    | place | postcode |
 100         When updating postcodes
 101         Then location_postcode contains exactly
 102            | country | postcode | geometry |
 103            | de      | 01982    | country:de |
 104         And there are word tokens for postcodes 01982