From fdcfa3c356643602b23c0430fe621666cae8fba6 Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Fri, 26 Nov 2004 16:54:43 +0000
Subject: [PATCH] First regress test cleaned up.

git-svn-id: http://svn.osgeo.org/postgis/trunk@1118 b70326c6-7e19-0410-871a-916f4a2858ee
---
 lwgeom/regress/lwgeom_regress.sql      | 16 +++++++--------
 lwgeom/regress/lwgeom_regress_expected | 16 ---------------
 lwgeom/regress/run_regress             | 27 ++++++++++++++------------
 3 files changed, 23 insertions(+), 36 deletions(-)

diff --git a/lwgeom/regress/lwgeom_regress.sql b/lwgeom/regress/lwgeom_regress.sql
index 994cb8f5e..205492f90 100644
--- a/lwgeom/regress/lwgeom_regress.sql
+++ b/lwgeom/regress/lwgeom_regress.sql
@@ -1,8 +1,8 @@
 CREATE TABLE test_data (
     id integer,
     wkt text,
-    wkb_xdr wkb,
-    wkb_ndr wkb
+    wkb_xdr text,
+    wkb_ndr text
 );
 
 
@@ -84,9 +84,9 @@ INSERT INTO test_data VALUES (-13, 'POLYGON((0 0.1 -0.01,0.2 10.3 -0.02,10.4 10.
 
 
 SELECT id,wkt FROM test_data WHERE
-       asText(lwgeom(wkt)) != wkt  OR
-       asText(lwgeom(wkb_xdr)) != wkt OR 
-       asText(lwgeom(wkb_ndr)) != wkt OR
-       ( (asBinary(lwgeom(wkb_ndr)) != wkb_ndr) AND (asBinary(lwgeom(wkb_ndr)) != wkb_xdr)  )  OR
-       ( (asBinary(lwgeom(wkb_xdr)) != wkb_ndr) AND (asBinary(lwgeom(wkb_xdr)) != wkb_xdr)  ) 
-;
+       asText(geometry(wkt)) != wkt  OR
+       asText(geometry(wkb_xdr)) != wkt OR 
+       asText(geometry(wkb_ndr)) != wkt OR
+       asBinary(geometry(wkb_ndr)) != asBinary(geometry(wkb_xdr)) OR
+       asBinary(geometry(wkt)) != asBinary(geometry(wkb_xdr));
+
diff --git a/lwgeom/regress/lwgeom_regress_expected b/lwgeom/regress/lwgeom_regress_expected
index ba68e2902..c6392fdab 100644
--- a/lwgeom/regress/lwgeom_regress_expected
+++ b/lwgeom/regress/lwgeom_regress_expected
@@ -1,17 +1 @@
-CREATE TABLE test_data (
-    id integer,
-    wkt text,
-    wkb_xdr wkb,
-    wkb_ndr wkb
-);
 CREATE TABLE
-SELECT id,wkt FROM test_data WHERE
-       asText(lwgeom(wkt)) != wkt  OR
-       asText(lwgeom(wkb_xdr)) != wkt OR 
-       asText(lwgeom(wkb_ndr)) != wkt OR
-       ( (asBinary(lwgeom(wkb_ndr)) != wkb_ndr) AND (asBinary(lwgeom(wkb_ndr)) != wkb_xdr)  )  OR
-       ( (asBinary(lwgeom(wkb_xdr)) != wkb_ndr) AND (asBinary(lwgeom(wkb_xdr)) != wkb_xdr)  ) 
- id | wkt 
-----+-----
-(0 rows)
-
diff --git a/lwgeom/regress/run_regress b/lwgeom/regress/run_regress
index a7c415e12..f1d59084b 100755
--- a/lwgeom/regress/run_regress
+++ b/lwgeom/regress/run_regress
@@ -1,18 +1,21 @@
-#!/bin/csh
+#!/bin/sh
 echo "Running LWGEOM Regression Test..."
 echo ""
-echo "Differences such as 'INSERT 18641077 1' are not important"
-echo ""
-echo "Building a database for testing (lwgeom_reg) on port 5432."
-echo "Building postgis and lwgeom support in it."
+echo "Building a database for testing (postgis_reg)."
+
+DB=postgis_reg
+createdb $DB > /dev/null
+
+echo "Building postgis support in it."
 echo ""
+
+createlang plpgsql $DB > /dev/null
+psql -f ../lwpostgis.sql $DB > /dev/null 2>&1
+
 echo "there shouldnt be any real output produced after this line."
 echo ""
-createdb lwgeom_reg
-createlang plpgsql lwgeom_reg
-psql -e lwgeom_reg <../../postgis.sql >& /dev/null 
-psql -e lwgeom_reg <../lwgeom.sql >& /dev/null 
-psql -e lwgeom_reg <lwgeom_regress.sql |& grep -v "^INSERT" > lwgeom_regress_out
+
+psql -tA < lwgeom_regress.sql $DB 2>&1 | grep -v "^INSERT" > lwgeom_regress_out
 diff lwgeom_regress_out lwgeom_regress_expected
-sleep 5
-dropdb lwgeom_reg
+sleep 1
+dropdb $DB > /dev/null
-- 
2.40.0