From 534f2ab72217df7827dd8c0b308c4d4019641dd6 Mon Sep 17 00:00:00 2001
From: kishoramballi <kishoramballi>
Date: Mon, 30 Jun 2008 10:18:20 +0000
Subject: [PATCH] test script corresponding to the cases in Wiki pages for the
 module

---
 test/cache/Gateway/test001.ksh | 46 ++++++++++++++++++++++++++++++++++++++++++
 test/cache/Gateway/test002.ksh | 46 ++++++++++++++++++++++++++++++++++++++++++
 test/cache/Gateway/test003.ksh | 42 ++++++++++++++++++++++++++++++++++++++
 test/cache/Gateway/test004.ksh | 33 ++++++++++++++++++++++++++++++
 4 files changed, 167 insertions(+)
 create mode 100755 test/cache/Gateway/test001.ksh
 create mode 100755 test/cache/Gateway/test002.ksh
 create mode 100755 test/cache/Gateway/test003.ksh
 create mode 100755 test/cache/Gateway/test004.ksh

diff --git a/test/cache/Gateway/test001.ksh b/test/cache/Gateway/test001.ksh
new file mode 100755
index 00000000..01cd4583
--- /dev/null
+++ b/test/cache/Gateway/test001.ksh
@@ -0,0 +1,46 @@
+#!/bin/sh
+
+# 1. Create table t1 in MySQL with all supported data types in it. and insert 10 records in it.
+# Cache the table in CSQL. and run csqlserver -c to load the records.
+# insert 10 more records using csql tool.
+# select records with WHERE clause containing parameters for all the fields with different data types.
+# update all fields with WHERE clause on primary key
+# delete records with WHERE clause on all fields
+
+#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
+
+# edit /tmp/csql/csqltable.conf
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+for (( a=1; a<2; a++ ))
+do
+    echo "1:t$a"
+done >> /tmp/csql/csqltable.conf
+$CSQL_INSTALL_ROOT/bin/csqlserver -c >/dev/null 2>&1 &
+pid=$!
+sleep 5
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest1.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/select.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/update.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/delete.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql
+isql myodbc3 < $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/test002.ksh b/test/cache/Gateway/test002.ksh
new file mode 100755
index 00000000..a76a09ae
--- /dev/null
+++ b/test/cache/Gateway/test002.ksh
@@ -0,0 +1,46 @@
+#!/bin/sh
+
+#  2. Create table t1 in MySQL with all supported data types in it. and insert 10 records in it.
+#  Note that in this test case the table is not cached in csql and it is present only in MySQL.
+#  insert 10 more records using csql tool.
+#  select records with WHERE clause containing parameters for all the fields with different data types.
+#  update all fields with WHERE clause on primary key
+#  delete records with WHERE clause on all fields
+
+#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
+
+# edit /tmp/csql/csqltable.conf
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+for (( a=1; a<2; a++ ))
+do
+    echo "1:t$a"
+done >> /tmp/csql/csqltable.conf
+$CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
+pid=$!
+sleep 5
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest1.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql>/dev/null 2>&1 
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/select.sql>/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/update.sql>/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/delete.sql>/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql>/dev/null 2>&1 
+isql myodbc3 < $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/test003.ksh b/test/cache/Gateway/test003.ksh
new file mode 100755
index 00000000..5c80306e
--- /dev/null
+++ b/test/cache/Gateway/test003.ksh
@@ -0,0 +1,42 @@
+#!/bin/sh
+
+#  3. Create table t1 in CSQL with all supported data types in it. and insert 10 records in it.
+#  Note that in this test case the table is not cached in csql and is present in csql
+#  insert 10 more records using csql tool.
+#  select records with WHERE clause containing parameters for all the fields with different data types.
+#  update all fields with WHERE clause on primary key
+#  delete records with WHERE clause on all fields
+
+#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
+
+# edit /tmp/csql/csqltable.conf
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
+pid=$!
+sleep 5
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest3.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql 
+isql myodbc3 < $REL_PATH/selectstar.sql 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest3a.sql >/dev/null 2>&1 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/select.sql 
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/update.sql >/dev/null 2>&1   
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/delete.sql >/dev/null 2>&1  
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql 
+isql myodbc3 < $REL_PATH/selectstar.sql 2>&1
+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/test004.ksh b/test/cache/Gateway/test004.ksh
new file mode 100755
index 00000000..198e8b9a
--- /dev/null
+++ b/test/cache/Gateway/test004.ksh
@@ -0,0 +1,33 @@
+#!/bin/sh
+
+#  4.insert, select, update, delete on table which is not there in both mysql and csql. All should fail.
+
+#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
+
+# edit /tmp/csql/csqltable.conf
+
+$CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
+pid=$!
+sleep 5
+
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest1.sql 2>/dev/null
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql 2>/dev/null
+isql myodbc3 < $REL_PATH/selectstar.sql
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/select.sql 2>/dev/null
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/update.sql 2>/dev/null
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/delete.sql 2>/dev/null
+$CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql 2>/dev/null
+isql myodbc3 < $REL_PATH/selectstar.sql 2>/dev/null
+isql myodbc3 < $REL_PATH/dropall.sql > /dev/null 2>&1
+kill -9 $pid 
+ipcrm -M 1199 -M 2277
+exit 0;
-- 
2.11.4.GIT