test db stuff json

qgis · Sep 14, 2018 · e972e21 · e972e21
1 parent f92a2ad
commit e972e21
Show file tree

Hide file tree

Showing 2 changed files with 16 additions and 0 deletions.
diff --git a/tests/testdata/provider/testdata_pg.sh b/tests/testdata/provider/testdata_pg.sh
@@ -12,6 +12,7 @@ SCRIPTS="
   tests/testdata/provider/testdata_pg_array.sql
   tests/testdata/provider/testdata_pg_raster.sql
   tests/testdata/provider/testdata_pg_domain.sql
+  tests/testdata/provider/testdata_pg_json.sql
 "
 
 dropdb qgis_test 2> /dev/null || true

diff --git a/tests/testdata/provider/testdata_pg_json.sql b/tests/testdata/provider/testdata_pg_json.sql
@@ -0,0 +1,15 @@
+
+DROP TABLE IF EXISTS qgis_test.json;
+
+CREATE TABLE qgis_test.json
+(
+  pk SERIAL NOT NULL PRIMARY KEY,
+  jvalue json,
+  jbvalue jsonb
+);
+
+INSERT INTO qgis_test.json(jvalue, jbvalue)
+  VALUES
+    ('[1,2,3]', '[4,5,6]'),
+    ('{"a":1,"b":2}', '{"c":4,"d":5}'),
+    ('123', '456');