Skip to content

Commit e972e21

Browse files
signedavnyalldawson
authored andcommittedSep 14, 2018
test db stuff json
1 parent f92a2ad commit e972e21

File tree

2 files changed

+16
-0
lines changed

2 files changed

+16
-0
lines changed
 

‎tests/testdata/provider/testdata_pg.sh

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -12,6 +12,7 @@ SCRIPTS="
1212
tests/testdata/provider/testdata_pg_array.sql
1313
tests/testdata/provider/testdata_pg_raster.sql
1414
tests/testdata/provider/testdata_pg_domain.sql
15+
tests/testdata/provider/testdata_pg_json.sql
1516
"
1617

1718
dropdb qgis_test 2> /dev/null || true
Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
2+
DROP TABLE IF EXISTS qgis_test.json;
3+
4+
CREATE TABLE qgis_test.json
5+
(
6+
pk SERIAL NOT NULL PRIMARY KEY,
7+
jvalue json,
8+
jbvalue jsonb
9+
);
10+
11+
INSERT INTO qgis_test.json(jvalue, jbvalue)
12+
VALUES
13+
('[1,2,3]', '[4,5,6]'),
14+
('{"a":1,"b":2}', '{"c":4,"d":5}'),
15+
('123', '456');

0 commit comments

Comments
 (0)
Please sign in to comment.