From c94ae0b2b95110cf7c96a0bd89b20d3b97615aaa Mon Sep 17 00:00:00 2001
From: Paul Ramsey <pramsey@cleverelephant.ca>
Date: Fri, 18 Mar 2011 17:36:01 +0000
Subject: [PATCH] Jeff Adams: Adding a regression test for the loader that uses
 a schema-qualified table name.

git-svn-id: http://svn.osgeo.org/postgis/trunk@6928 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/Makefile.in                            |   1 +
 regress/loader/PointWithSchema-post.sql        |   2 ++
 regress/loader/PointWithSchema-pre.sql         |   1 +
 regress/loader/PointWithSchema.dbf             | Bin 0 -> 33 bytes
 regress/loader/PointWithSchema.opts            |   2 ++
 regress/loader/PointWithSchema.select.expected |   3 +++
 regress/loader/PointWithSchema.select.sql      |   2 ++
 regress/loader/PointWithSchema.shp             | Bin 0 -> 184 bytes
 regress/loader/PointWithSchema.shx             | Bin 0 -> 124 bytes
 9 files changed, 11 insertions(+)
 create mode 100644 regress/loader/PointWithSchema-post.sql
 create mode 100644 regress/loader/PointWithSchema-pre.sql
 create mode 100644 regress/loader/PointWithSchema.dbf
 create mode 100644 regress/loader/PointWithSchema.opts
 create mode 100644 regress/loader/PointWithSchema.select.expected
 create mode 100644 regress/loader/PointWithSchema.select.sql
 create mode 100644 regress/loader/PointWithSchema.shp
 create mode 100644 regress/loader/PointWithSchema.shx

diff --git a/regress/Makefile.in b/regress/Makefile.in
index 7762955cd..eea28f994 100644
--- a/regress/Makefile.in
+++ b/regress/Makefile.in
@@ -40,6 +40,7 @@ TESTS = \
 	loader/TSTPolygon \
 	loader/TSIPolygon \
 	loader/TSTIPolygon \
+	loader/PointWithSchema \
 	loader/NoTransPoint \
 	loader/NotReallyMultiPoint \
 	loader/MultiToSinglePoint \
diff --git a/regress/loader/PointWithSchema-post.sql b/regress/loader/PointWithSchema-post.sql
new file mode 100644
index 000000000..57b80cb4e
--- /dev/null
+++ b/regress/loader/PointWithSchema-post.sql
@@ -0,0 +1,2 @@
+DROP TABLE IF EXISTS pgreg.loadedshp;
+DROP SCHEMA pgreg;
diff --git a/regress/loader/PointWithSchema-pre.sql b/regress/loader/PointWithSchema-pre.sql
new file mode 100644
index 000000000..6a860c37b
--- /dev/null
+++ b/regress/loader/PointWithSchema-pre.sql
@@ -0,0 +1 @@
+CREATE SCHEMA pgreg;
diff --git a/regress/loader/PointWithSchema.dbf b/regress/loader/PointWithSchema.dbf
new file mode 100644
index 0000000000000000000000000000000000000000..13b4aeea0f36e95f37f532ac3645bfa848df67e0
GIT binary patch
literal 33
UcmZRMXP06C0!0Q!5QPD_028ACumAu6

literal 0
HcmV?d00001

diff --git a/regress/loader/PointWithSchema.opts b/regress/loader/PointWithSchema.opts
new file mode 100644
index 000000000..04264edc9
--- /dev/null
+++ b/regress/loader/PointWithSchema.opts
@@ -0,0 +1,2 @@
+# Test loading a table with a schema.
+-g the_geom loader/PointWithSchema pgreg.loadedshp 
diff --git a/regress/loader/PointWithSchema.select.expected b/regress/loader/PointWithSchema.select.expected
new file mode 100644
index 000000000..680e99b43
--- /dev/null
+++ b/regress/loader/PointWithSchema.select.expected
@@ -0,0 +1,3 @@
+POINT(0 1)
+POINT(9 -1)
+POINT(9 -1)
diff --git a/regress/loader/PointWithSchema.select.sql b/regress/loader/PointWithSchema.select.sql
new file mode 100644
index 000000000..38d217f8b
--- /dev/null
+++ b/regress/loader/PointWithSchema.select.sql
@@ -0,0 +1,2 @@
+select ST_Asewkt(the_geom) from pgreg.loadedshp;
+
diff --git a/regress/loader/PointWithSchema.shp b/regress/loader/PointWithSchema.shp
new file mode 100644
index 0000000000000000000000000000000000000000..51d38e75d0d84b98527aef900b79e814ac0d7b6a
GIT binary patch
literal 184
zcmZQzQ0HR64q{#~GcYh>$bHxk5mIu1&>!p}G+q*93>Ox&Kzf-_<&+$Nd>{bZ19Snh
NJ|zbr9|%6|2LKu+3Nioy

literal 0
HcmV?d00001

diff --git a/regress/loader/PointWithSchema.shx b/regress/loader/PointWithSchema.shx
new file mode 100644
index 0000000000000000000000000000000000000000..7db02aff8c7fe20dd30a11878a45af7929b04922
GIT binary patch
literal 124
tcmZQzQ0HR64(whqGcYh>$bHxk5mIu1&>!p}G+xpOC=0U30ZRLUXaH*h1$qDg

literal 0
HcmV?d00001

-- 
2.50.1