From 72ea13e2bde689aad757631007e5ada9a2795fb5 Mon Sep 17 00:00:00 2001
From: kishoramballi <kishoramballi>
Date: Wed, 2 Jul 2008 12:32:22 +0000
Subject: [PATCH] test scripts for the module

---
 test/cache/CacheTable/test001.ksh | 11 +++++++
 test/cache/CacheTable/test002.ksh | 65 +++++++++++++++++++++++++++++++++++++++
 test/cache/CacheTable/test003.ksh | 46 +++++++++++++++++++++++++++
 test/cache/CacheTable/test004.ksh | 42 +++++++++++++++++++++++++
 test/cache/CacheTable/test005.ksh | 33 ++++++++++++++++++++
 test/cache/CacheTable/test006.ksh | 31 +++++++++++++++++++
 test/cache/CacheTable/test007.ksh | 33 ++++++++++++++++++++
 test/cache/CacheTable/test008.ksh | 65 +++++++++++++++++++++++++++++++++++++++
 test/cache/CacheTable/test009.ksh | 35 +++++++++++++++++++++
 9 files changed, 361 insertions(+)
 create mode 100755 test/cache/CacheTable/test001.ksh
 create mode 100755 test/cache/CacheTable/test002.ksh
 create mode 100755 test/cache/CacheTable/test003.ksh
 create mode 100755 test/cache/CacheTable/test004.ksh
 create mode 100755 test/cache/CacheTable/test005.ksh
 create mode 100755 test/cache/CacheTable/test006.ksh
 create mode 100755 test/cache/CacheTable/test007.ksh
 create mode 100755 test/cache/CacheTable/test008.ksh
 create mode 100755 test/cache/CacheTable/test009.ksh

diff --git a/test/cache/CacheTable/test001.ksh b/test/cache/CacheTable/test001.ksh
new file mode 100755
index 00000000..c7247fb5
--- /dev/null
+++ b/test/cache/CacheTable/test001.ksh
@@ -0,0 +1,11 @@
+#!/bin/sh
+# Test Case
+# 1. Check for help message: $ cachetable -? 
+
+$CSQL_INSTALL_ROOT/bin/cachetable ?
+if [ $? -ne 0 ]
+then
+   exit 1;
+fi
+exit 0;
+
diff --git a/test/cache/CacheTable/test002.ksh b/test/cache/CacheTable/test002.ksh
new file mode 100755
index 00000000..ec2b269e
--- /dev/null
+++ b/test/cache/CacheTable/test002.ksh
@@ -0,0 +1,65 @@
+#!/bin/sh
+# Test Case
+# 2. Create table t1 with primary key in mysql. Cache the table in csql.
+#    Check for user authentication: 
+#    $ cachetable [-U username] [-P password] -t t1 
+#         by entering
+#    a. correct username correct password - should pass
+#    b. correct username wrong password - should return error
+#    c. wrong username correct password - should return error
+#    d. wrong username wrong password - should return error
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 1;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+# check with correct username and correct password
+$CSQL_INSTALL_ROOT/bin/cachetable -U root -P manager -t t1 > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 2;
+fi
+
+# correct username and wrong password
+$CSQL_INSTALL_ROOT/bin/cachetable -U root -P MANAGER -t t1 > /dev/null 2>&1
+if [ $? -eq 0 ]
+then
+   exit 3;
+fi
+
+# wrong username and correct password
+$CSQL_INSTALL_ROOT/bin/cachetable -U ROOT -P manager -t t1 > /dev/null 2>&1
+if [ $? -eq 0 ]
+then
+   exit 4;
+fi
+
+#wrong username and wrong password
+$CSQL_INSTALL_ROOT/bin/cachetable -U ROOT -P MANAGER -t t1 > /dev/null 2>&1
+if [ $? -eq 0 ]
+then
+   exit 5;
+fi
+ 
+$CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+exit 0;
+
diff --git a/test/cache/CacheTable/test003.ksh b/test/cache/CacheTable/test003.ksh
new file mode 100755
index 00000000..1a343ccf
--- /dev/null
+++ b/test/cache/CacheTable/test003.ksh
@@ -0,0 +1,46 @@
+#!/bin/sh
+# Test Case
+
+# 3.create table, load with no definition option. should succeed and csqldump should display the records.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinput.sql > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 1;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 -s > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 2;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csqldump 
+if [ $? -ne 0 ]
+then
+   exit 3;
+fi
+$CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+exit 0;
+
diff --git a/test/cache/CacheTable/test004.ksh b/test/cache/CacheTable/test004.ksh
new file mode 100755
index 00000000..41cf6d8f
--- /dev/null
+++ b/test/cache/CacheTable/test004.ksh
@@ -0,0 +1,42 @@
+#!/bin/sh
+# Test Case
+
+# 4.create table, insert some records into the table and then load with no definition option. should fail.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinputwithrec.sql > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 1;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 -s >/dev/null 2>&1 
+if [ $? -eq 0 ]
+then
+    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
+    isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+    rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+    touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+    exit 2;
+fi
+
+$CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+exit 0;
+
diff --git a/test/cache/CacheTable/test005.ksh b/test/cache/CacheTable/test005.ksh
new file mode 100755
index 00000000..1b9c6e8d
--- /dev/null
+++ b/test/cache/CacheTable/test005.ksh
@@ -0,0 +1,33 @@
+#!/bin/sh
+# Test Case
+
+# 5.create table, load with definition option. should fail.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinput.sql > /dev/null 2>&1
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 > /dev/null 2>&1
+if [ $? -eq 0 ]
+then
+    exit 1;
+fi
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+exit 0;
+
diff --git a/test/cache/CacheTable/test006.ksh b/test/cache/CacheTable/test006.ksh
new file mode 100755
index 00000000..244bb4f8
--- /dev/null
+++ b/test/cache/CacheTable/test006.ksh
@@ -0,0 +1,31 @@
+#!/bin/sh
+# Test Case
+
+# 6.load with definition option. should succeed.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+    exit 1;
+fi
+
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+exit 0;
diff --git a/test/cache/CacheTable/test007.ksh b/test/cache/CacheTable/test007.ksh
new file mode 100755
index 00000000..d5941df1
--- /dev/null
+++ b/test/cache/CacheTable/test007.ksh
@@ -0,0 +1,33 @@
+#!/bin/sh
+# Test Case
+
+# 7.Do not create table, load with no definition option. should fail.i
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 -s > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+    isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+    rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+    touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+    exit 0;
+fi
+
+exit 1;
+
diff --git a/test/cache/CacheTable/test008.ksh b/test/cache/CacheTable/test008.ksh
new file mode 100755
index 00000000..ae93c5cc
--- /dev/null
+++ b/test/cache/CacheTable/test008.ksh
@@ -0,0 +1,65 @@
+#!/bin/sh
+# Test Case
+
+# 8.load table. csqldump , 
+#   unload table csqldump, insert record to mysql directly, 
+#   reload table, csqldump and verify the results. 
+#   reload should get the inserted record also.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 1;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csqldump 
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 -u > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 2;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csqldump 
+
+isql myodbc3 < ${REL_PATH}/insert.sql >/dev/null 2>&1
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 > /dev/null 2>&1
+if [ $? -ne 0 ]
+then
+   exit 3;
+fi
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csqldump 
+
+$CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+exit 0;
+
diff --git a/test/cache/CacheTable/test009.ksh b/test/cache/CacheTable/test009.ksh
new file mode 100755
index 00000000..8177a49c
--- /dev/null
+++ b/test/cache/CacheTable/test009.ksh
@@ -0,0 +1,35 @@
+#!/bin/sh
+# Test Case
+
+# 9.create table t1 (f1 int, f2 int) in mysql and 
+#   create table t1 (f1 int, f2 int, f3 int) in csql. 
+#   load with no definition option. should fail.
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+input=${PWD}/cache/CacheTable/inputtest4.sql
+REL_PATH=.
+if [ -s "$input" ]
+then
+    REL_PATH=${PWD}/cache/CacheTable
+fi
+
+isql myodbc3 < ${REL_PATH}/inputtest4.sql >/dev/null 2>&1
+
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+
+$CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/csqlinputtest9.sql > /dev/null 2>&1
+
+$CSQL_INSTALL_ROOT/bin/cachetable -t t1 -s > /dev/null 2>&1
+if [ $? -eq 0 ]
+then
+    exit 1;
+fi
+
+isql myodbc3 < ${REL_PATH}/drop.sql >/dev/null 2>&1
+rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
+touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
+exit 0;
+
-- 
2.11.4.GIT