From db167258c9b42a23de0dbcc72bb1c36354edfd3a Mon Sep 17 00:00:00 2001
From: Kees Monshouwer <mind04@monshouwer.org>
Date: Tue, 31 Dec 2013 09:10:28 +0100
Subject: [PATCH] add goracle backend to regression tests

---
 regression-tests/.gitignore      |  1 +
 regression-tests/start-test-stop | 66 ++++++++++++++++++++++++++++++++
 2 files changed, 67 insertions(+)

diff --git a/regression-tests/.gitignore b/regression-tests/.gitignore
index 7e7cda0e7..afe907e23 100644
--- a/regression-tests/.gitignore
+++ b/regression-tests/.gitignore
@@ -38,3 +38,4 @@ real_result
 /dsset-*
 /bind.conf
 /bind-slave.conf
+/oracle.log
diff --git a/regression-tests/start-test-stop b/regression-tests/start-test-stop
index 23ace88fa..bf8d81cdc 100755
--- a/regression-tests/start-test-stop
+++ b/regression-tests/start-test-stop
@@ -312,6 +312,7 @@ remotebackend-pipe remotebackend-unix remotebackend-http remotebackend-zeromq
 remotebackend-pipe-dnssec remotebackend-unix-dnssec remotebackend-http-dnssec remotebackend-zeromq-dnssec
 #remotebackend-pipe-nsec3 remotebackend-unix-nsec3 remotebackend-http-nsec3
 #remotebackend-pipe-nsec3-narrow remotebackend-unix-nsec3-narrow remotebackend-http-nsec3-narrow
+goracle-nodnssec goracle goracle-nsec3 goracle-nsec3-optout
 
 * Add -presigned to any ext-nsd, ext-bind, bind, gmysql or gsqlite3 test (except narrow)
   to test presigned operation.
@@ -804,6 +805,71 @@ __EOF__
 			fi
 			skipreasons="nodyndns"
 			;;
+
+
+		goracle-nodnssec | goracle | goracle-nsec3 | goracle-nsec3-optout)
+
+			echo "DROP USER pdns CASCADE;" | sqlplus -S powerdns/powerdns > oracle.log || true
+			echo "CREATE USER pdns IDENTIFIED BY pdns;" | sqlplus -S powerdns/powerdns >> oracle.log
+			echo "GRANT CONNECT, RESOURCE TO pdns;" | sqlplus -S powerdns/powerdns >> oracle.log
+			sqlplus -S pdns/pdns@xe < ../modules/goraclebackend/goracle-schema.sql >> oracle.log
+			tosql goracle | sqlplus -S pdns/pdns@xe >> oracle.log
+
+			cat > pdns-goracle.conf << __EOF__
+launch=goracle
+goracle-home=$ORACLE_HOME
+goracle-sid=$ORACLE_SID
+goracle-nls-lang=$NLS_LANG
+
+goracle-tnsname=xe
+goracle-user=pdns
+goracle-password=pdns
+__EOF__
+
+			if [ $context != goracle-nodnssec ]
+			then
+				echo "goracle-dnssec" >> pdns-goracle.conf
+				../pdns/pdnssec --config-dir=. --config-name=goracle import-tsig-key test $ALGORITHM $KEY
+				../pdns/pdnssec --config-dir=. --config-name=goracle activate-tsig-key tsig.com test master
+			fi
+
+			for zone in $(grep zone named.conf  | cut -f2 -d\")
+			do
+				if [ $context != goracle-nodnssec ]
+				then
+					securezone $zone goracle
+					if [ $context = goracle-nsec3 ] || [ $context = goracle-nsec3-optout ]
+					then
+						../pdns/pdnssec --config-dir=. --config-name=goracle set-nsec3 $zone "1 $optout 1 abcd" 2>&1
+						../pdns/pdnssec --config-dir=. --config-name=goracle rectify-zone $zone 2>&1
+					fi
+				else
+					../pdns/pdnssec --config-dir=. --config-name=goracle rectify-zone $zone 2>&1
+				fi
+			done
+
+			$RUNWRAPPER $PDNS --daemon=no --local-port=$port --config-dir=. \
+				--config-name=goracle --socket-dir=./ --no-shuffle \
+				--send-root-referral \
+				--allow-2136-from=127.0.0.0/8 --experimental-rfc2136=yes \
+				--cache-ttl=$cachettl $lua_prequery &
+
+			skipreasons="nodyndns"
+			if [ $context = goracle-nsec3 ]
+			then
+				extracontexts="dnssec nsec3"
+			elif [ $context = goracle-nsec3-optout ]
+			then
+				extracontexts="dnssec nsec3 nsec3-optout"
+			elif [ $context = goracle-nodnssec ]
+			then
+				skipreasons="nodnssec nodyndns"
+			else
+				extracontexts="dnssec"
+			fi
+			;;
+
+
 		tinydns)
 			$RUNWRAPPER $PDNS --daemon=no --local-port=$port --socket-dir=./ \
 				--no-shuffle --launch=tinydns \
-- 
2.50.1