From aa7fcdbd6b46ccb7cbfba43a0a30d1b41b7b9a71 Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Thu, 9 May 2013 06:34:22 +0000
Subject: [PATCH] start accounting for more raster helper types - addbandarg
 etc.

git-svn-id: http://svn.osgeo.org/postgis/trunk@11385 b70326c6-7e19-0410-871a-916f4a2858ee
---
 doc/xsl/raster_gardentest.sql.xsl | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/doc/xsl/raster_gardentest.sql.xsl b/doc/xsl/raster_gardentest.sql.xsl
index 4a1b6a628..2f261845f 100644
--- a/doc/xsl/raster_gardentest.sql.xsl
+++ b/doc/xsl/raster_gardentest.sql.xsl
@@ -24,6 +24,8 @@
 	<xsl:variable name='var_NDRXDR'>XDR</xsl:variable>
 	<xsl:variable name='var_text'>'monkey'</xsl:variable>
 	<xsl:variable name='var_varchar'>'test'</xsl:variable>
+	<xsl:variable name='var_options'>NULL</xsl:variable>
+	<xsl:variable name="var_onerasteruserfunc">'monkey_oneuserfunc(float,integer[],text[])'::regprocedure</xsl:variable> 
 	<xsl:variable name='var_pixeltype'>'1BB'</xsl:variable>
 	<xsl:variable name='var_pixeltypenoq'>8BUI</xsl:variable>
 	<xsl:variable name='var_pixelvalue'>0</xsl:variable>
@@ -35,6 +37,8 @@
 	<xsl:variable name='var_pixelvalues'>{255,0}</xsl:variable>
 	<xsl:variable name='var_algorithm'>'Lanczos'</xsl:variable>
 	<xsl:variable name='var_pt'>ST_Centroid(rast1.rast::geometry)</xsl:variable>
+	<xsl:variable name='var_addbandarg'>ROW(NULL, '8BUI', 255, 0)::addbandarg</xsl:variable>
+	<xsl:variable name='var_addbandargset'>ARRAY[ROW(1, '1BB'::text, 0, NULL),ROW(2, '4BUI'::text, 0, NULL)]::addbandarg[]</xsl:variable>
 	
 	<xsl:variable name='var_reclassarg'>ROW(2, '0-100:1-10, 101-500:11-150,501 - 10000: 151-254', '8BUI', 255)</xsl:variable>
 	<xsl:variable name='var_georefcoords'>'2 0 0 3 0.5 0.5'</xsl:variable>
@@ -126,6 +130,11 @@ CREATE TABLE <xsl:value-of select="$var_logtable" />_output(logid integer PRIMAR
 <!-- define a table we call pgis_rgarden_mega that will contain a raster column with a band for all types of pixels we support -->
 DROP TABLE IF EXISTS pgis_rgarden_mega;
 CREATE TABLE pgis_rgarden_mega(rid serial PRIMARY KEY, rast raster);
+<!--define map algebra functions -->
+CREATE OR REPLACE FUNCTION monkey_oneuserfunc(pixel FLOAT, pos INTEGER[], VARIADIC args TEXT[])RETURNS FLOAT
+    AS $$ BEGIN
+        RETURN 0.0;
+    END; $$ LANGUAGE plpgsql IMMUTABLE;
 <!--Start Test table creation -->
 		<xsl:for-each select="document('')//pgis:pixeltypes/pgis:pixeltype[not(contains(@createtable,'false'))]">
 			<xsl:variable name='log_label'>create table Test <xsl:value-of select="@PixType" /></xsl:variable>
@@ -406,6 +415,9 @@ SELECT '<xsl:value-of select="$fnname" /><xsl:text> </xsl:text><xsl:value-of sel
 					<xsl:when test="contains(parameter, 'format')">
 						<xsl:value-of select="$var_format" />
 					</xsl:when>
+					<xsl:when test="contains(parameter, 'options')">
+						<xsl:value-of select="$var_options" />
+					</xsl:when>
 					<xsl:when test="contains(parameter, 'pt')">
 						<xsl:value-of select="$var_pt" />
 					</xsl:when>
@@ -424,9 +436,15 @@ SELECT '<xsl:value-of select="$fnname" /><xsl:text> </xsl:text><xsl:value-of sel
 					<xsl:when test="contains(parameter, 'NDR')">
 						'<xsl:value-of select="$var_NDRXDR" />'
 					</xsl:when>
+					<xsl:when test="contains(parameter, 'onerasteruserfunc')">
+						<xsl:value-of select="$var_onerasteruserfunc" />
+					</xsl:when>
 					<xsl:when test="contains(parameter, 'version') and position() = 2">
 						<xsl:value-of select="$var_version1" />
 					</xsl:when>
+					<xsl:when test="contains(parameter, 'addbandargset')">
+						<xsl:value-of select="$var_addbandargset" />
+					</xsl:when>
 					<xsl:when test="(contains(type,'box') or type = 'geometry' or type = 'geometry ' or contains(type,'geometry set')) and (position() = 1 or count($func/paramdef/type[contains(text(),'geometry') or contains(text(),'box') or contains(text(), 'WKT') or contains(text(), 'bytea')]) = '1')">
 						<xsl:text>rast1.rast::geometry</xsl:text>
 					</xsl:when>
@@ -453,6 +471,9 @@ SELECT '<xsl:value-of select="$fnname" /><xsl:text> </xsl:text><xsl:value-of sel
 					<xsl:when test="type = 'raster' or type = 'raster ' or contains(type, 'raster set')">
 						<xsl:text>rast2.rast</xsl:text>
 					</xsl:when>
+					<xsl:when test="type = 'raster' or type = 'raster ' or contains(type, 'raster set')">
+						<xsl:text>rast2.rast</xsl:text>
+					</xsl:when>
 					<xsl:when test="contains(type, 'geometry[]') and count($func/paramdef/type[contains(text(),'geometry') or contains(text(),'box') or contains(text(), 'WKT') or contains(text(), 'bytea')]) = '1'">
 						ARRAY[foo1.the_geom]
 					</xsl:when>
@@ -486,6 +507,7 @@ SELECT '<xsl:value-of select="$fnname" /><xsl:text> </xsl:text><xsl:value-of sel
 					<xsl:when test="contains(type,'reclassarg')">
 						<xsl:value-of select="$var_reclassarg" />
 					</xsl:when>
+					
 					<xsl:when test="contains(type, 'text')">
 						<xsl:value-of select="$var_text" />
 					</xsl:when>
-- 
2.50.1