Add logic for field regex substitution.

This is useful to replace a YYYYMMDD formatted date with YYYY-MM-DD.
The target field can then be set to not-nullable and its type set to
Date, as the OGR_F_SetField*() with take care of the conversion.

We could also do that via an SQL query, but in our case the sources are
not proper RDBMS so SQL is emulated anyway.

1 files changed, 8 insertions, 8 deletions

diff --git a/schema.sql b/schema.sql
index 6fbef97..6b4e773 100644
--- a/schema.sql
+++ b/schema.sql
@@ -170,7 +170,7 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_applied" (
     "Applicant" character varying(254) NOT NULL,
     "ApplicationDate" date NOT NULL,
     "DiaryNr" character(16) NOT NULL,
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -217,7 +217,7 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_approved" (
     "ValidFrom" date NOT NULL,
     "ValidTo" date NOT NULL,
     "DiaryNr" character(16),
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -261,7 +261,7 @@ CREATE TABLE postgis."mrr:markanvisningar" (
     "Name" character varying(254) NOT NULL,
     "DecisionDate" date,
     "DiaryNr" character(16),
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -307,7 +307,7 @@ CREATE TABLE postgis."mrr:mineral_applied" (
     "Applicant" character varying(254) NOT NULL,
     "ApplicationDate" date NOT NULL,
     "DiaryNr" character(16) NOT NULL,
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -355,7 +355,7 @@ CREATE TABLE postgis."mrr:mineral_approved" (
     "ValidFrom" date NOT NULL,
     "ValidTo" date NOT NULL,
     "DiaryNr" character(16),
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -401,7 +401,7 @@ CREATE TABLE postgis."mrr:olja_gas_diamant_applied" (
     "Applicant" character varying(254) NOT NULL,
     "ApplicationDate" date NOT NULL,
     "DiaryNr" character(16) NOT NULL,
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -449,7 +449,7 @@ CREATE TABLE postgis."mrr:olja_gas_diamant_approved" (
     "ValidFrom" date NOT NULL,
     "ValidTo" date NOT NULL,
     "DiaryNr" character(16),
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
@@ -496,7 +496,7 @@ CREATE TABLE postgis."mrr:torvkoncessioner" (
     "ValidFrom" date NOT NULL,
     "ValidTo" date NOT NULL,
     "DiaryNr" character(16),
-    "LastUpdated" character(10) NOT NULL,
+    "LastUpdated" date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006)
 );