From 3b4849f3bb9d1939f61ac510327dd014f4eff86b Mon Sep 17 00:00:00 2001
From: kishoramballi <kishoramballi>
Date: Mon, 30 Jun 2008 14:33:59 +0000
Subject: [PATCH] test script corresponding to the cases in Wiki pages for the
 module

---
 test/cache/Gateway/test010.ksh | 31 +++++++++++++++++++++++++++++++
 test/cache/Gateway/test011.ksh | 28 ++++++++++++++++++++++++++++
 2 files changed, 59 insertions(+)
 create mode 100755 test/cache/Gateway/test010.ksh
 create mode 100755 test/cache/Gateway/test011.ksh

diff --git a/test/cache/Gateway/test010.ksh b/test/cache/Gateway/test010.ksh
new file mode 100755
index 00000000..938655ec
--- /dev/null
+++ b/test/cache/Gateway/test010.ksh
@@ -0,0 +1,31 @@
+#!/bin/sh
+
+#  10.Table there in csql and mysql and not cached. insert should insert only to csql table.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+CSQL_CONF=${PWD}/cache/Gateway/csql.conf
+input=${PWD}/cache/Gateway/mysqlinputtest1.sql
+REL_PATH=.
+if [ -s "$input" -a -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/cache/Gateway
+fi
+export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
+
+isql myodbc3 < $REL_PATH/mysqlinputtest1.sql > /dev/null 2>&1
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
+pid=$!
+sleep 5
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinputtest10.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/insert.sql
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql
+isql myodbc3 < $REL_PATH/dropall.sql > /dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+kill -9 $pid 
+ipcrm -M 1199 -M 2277
+exit 0;
diff --git a/test/cache/Gateway/test011.ksh b/test/cache/Gateway/test011.ksh
new file mode 100755
index 00000000..dbdb6581
--- /dev/null
+++ b/test/cache/Gateway/test011.ksh
@@ -0,0 +1,28 @@
+#!/bin/sh
+
+#  11.Table there in csql and mysql and not cached. select should return records in csql table.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+CSQL_CONF=${PWD}/cache/Gateway/csql.conf
+input=${PWD}/cache/Gateway/mysqlinputtest1.sql
+REL_PATH=.
+if [ -s "$input" -a -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/cache/Gateway
+fi
+export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
+
+isql myodbc3 < $REL_PATH/mysqlinputtest1.sql > /dev/null 2>&1
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
+pid=$!
+sleep 5
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinputtest10.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql
+isql myodbc3 < $REL_PATH/dropall.sql > /dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+kill -9 $pid 
+ipcrm -M 1199 -M 2277
+exit 0;
-- 
2.11.4.GIT