From 4554ef2d36c4fa4e2e65eaa788725a676dfbe53d Mon Sep 17 00:00:00 2001 From: prabatuty Date: Sat, 24 Nov 2007 05:03:51 +0000 Subject: [PATCH] Addding test cases for connection and datatype module. changed storage to performance module added system/config module --- test/TestModules | 7 +- test/dbapi/Connection/Makefile | 3 + test/dbapi/Connection/conntest13.c | 2 + .../Connection/{conntest13.c => conntest17.c} | 11 +- test/dbapi/Connection/conntest9.c | 21 ++- test/dbapi/DataType/Makefile | 57 +++++--- test/dbapi/DataType/byteinttest.c | 15 ++- test/dbapi/DataType/chartest.c | 10 ++ test/dbapi/DataType/datetest.c | 10 ++ test/dbapi/DataType/doubletest.c | 10 ++ test/dbapi/DataType/exp.test002 | 1 + test/dbapi/DataType/exp.test004 | 1 + test/dbapi/DataType/{exp.test002 => exp.test006} | 1 + test/dbapi/DataType/{exp.test002 => exp.test007} | 0 test/dbapi/DataType/{exp.test002 => exp.test008} | 1 + test/dbapi/DataType/{exp.test008 => exp.test015} | 0 test/dbapi/DataType/{exp.test008 => exp.test016} | 1 + test/dbapi/DataType/exp.test017 | 107 +++++++++++++++ test/dbapi/DataType/exp.test018 | 108 +++++++++++++++ test/dbapi/DataType/exp.test019 | 107 +++++++++++++++ test/dbapi/DataType/exp.test020 | 108 +++++++++++++++ test/dbapi/DataType/exp.test021 | 48 +++++++ test/dbapi/DataType/exp.test022 | 50 +++++++ test/dbapi/DataType/floattest.c | 10 ++ test/dbapi/DataType/inttest.c | 9 ++ test/dbapi/DataType/longlongtest.c | 12 +- test/dbapi/DataType/longtest.c | 10 ++ test/dbapi/DataType/shorttest.c | 11 ++ test/dbapi/DataType/timestamptest.c | 10 ++ test/dbapi/DataType/timetest.c | 10 ++ test/dbapi/Index/Makefile | 6 + test/dbapi/Index/twoindex1.c | 146 ++++++++++++++++++++ test/dbapi/Index/twoindex2.c | 148 +++++++++++++++++++++ test/execTests.ksh | 2 +- test/genReport.ksh | 2 +- test/{storage => performance}/DMLTest.c | 0 test/{storage => performance}/DMLTestChar.c | 0 test/{storage => performance}/DMLThreadTest.c | 0 test/{storage => performance}/Makefile | 0 test/{storage => performance}/Range.c | 0 test/{dbapi/Index => system/config}/Makefile | 13 +- test/system/config/conftest1.c | 16 +++ 42 files changed, 1031 insertions(+), 53 deletions(-) copy test/dbapi/Connection/{conntest13.c => conntest17.c} (92%) copy test/dbapi/DataType/{exp.test002 => exp.test006} (98%) copy test/dbapi/DataType/{exp.test002 => exp.test007} (100%) copy test/dbapi/DataType/{exp.test002 => exp.test008} (98%) copy test/dbapi/DataType/{exp.test008 => exp.test015} (100%) rename test/dbapi/DataType/{exp.test008 => exp.test016} (98%) create mode 100644 test/dbapi/DataType/exp.test017 create mode 100644 test/dbapi/DataType/exp.test018 create mode 100644 test/dbapi/DataType/exp.test019 create mode 100644 test/dbapi/DataType/exp.test020 create mode 100644 test/dbapi/DataType/exp.test021 create mode 100644 test/dbapi/DataType/exp.test022 create mode 100644 test/dbapi/Index/twoindex1.c create mode 100644 test/dbapi/Index/twoindex2.c rename test/{storage => performance}/DMLTest.c (100%) rename test/{storage => performance}/DMLTestChar.c (100%) rename test/{storage => performance}/DMLThreadTest.c (100%) rename test/{storage => performance}/Makefile (100%) rename test/{storage => performance}/Range.c (100%) copy test/{dbapi/Index => system/config}/Makefile (67%) create mode 100644 test/system/config/conftest1.c diff --git a/test/TestModules b/test/TestModules index e816bafc..f163c8f2 100644 --- a/test/TestModules +++ b/test/TestModules @@ -1,8 +1,5 @@ -#This file contains all the test directories. -#Note:Do not add any unnecessary information in this file and no blank lines. -#Any line which has "#" symbol is considered as comment and negleted dbapi/Connection -dbapi/UserManager -#dbapi/Table dbapi/Index dbapi/DataType +dbapi/Table +dbapi/UserManager diff --git a/test/dbapi/Connection/Makefile b/test/dbapi/Connection/Makefile index 5ce3ca75..43b47ddc 100644 --- a/test/dbapi/Connection/Makefile +++ b/test/dbapi/Connection/Makefile @@ -38,6 +38,7 @@ TARGETS = \ test014 \ test015 \ test016 \ + test017 \ test101 @@ -77,6 +78,8 @@ test015: conntest15.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) test016: conntest16.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test017: conntest17.c + $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) test101: threadtest1.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) diff --git a/test/dbapi/Connection/conntest13.c b/test/dbapi/Connection/conntest13.c index 9f9bbd8c..3726fc1b 100644 --- a/test/dbapi/Connection/conntest13.c +++ b/test/dbapi/Connection/conntest13.c @@ -107,6 +107,7 @@ int main() conn.commit(); + conn.startTransaction(); //Displays the database after the transaction table->setCondition(NULL); table->execute(); @@ -116,6 +117,7 @@ int main() if (tuple == NULL) {break;} printf("\nBinded Tuple value is %d %s", id, name); } + conn.commit(); table->close(); dbMgr->closeTable(table); diff --git a/test/dbapi/Connection/conntest13.c b/test/dbapi/Connection/conntest17.c similarity index 92% copy from test/dbapi/Connection/conntest13.c copy to test/dbapi/Connection/conntest17.c index 9f9bbd8c..c00e28f0 100644 --- a/test/dbapi/Connection/conntest13.c +++ b/test/dbapi/Connection/conntest17.c @@ -1,5 +1,5 @@ -//In a transaction mix insert, update and delete a tuple. -//All should take effect in a transaction +//In a transaction mix insert, update and delete a tuple and abort it +//All should not take effect in a transaction #include int main() @@ -105,21 +105,26 @@ int main() table->close(); printf("Deleted successfully"); - conn.commit(); + conn.rollback(); + conn.startTransaction(); //Displays the database after the transaction table->setCondition(NULL); table->execute(); + int count =0; while(true) { tuple = (char*)table->fetch() ; if (tuple == NULL) {break;} printf("\nBinded Tuple value is %d %s", id, name); + count++; } + conn.commit(); table->close(); dbMgr->closeTable(table); dbMgr->dropTable("t1"); conn.close(); + if (count !=0) return 100; return 0; } diff --git a/test/dbapi/Connection/conntest9.c b/test/dbapi/Connection/conntest9.c index bd65dc41..e16f47b3 100644 --- a/test/dbapi/Connection/conntest9.c +++ b/test/dbapi/Connection/conntest9.c @@ -11,17 +11,24 @@ int main (int argc, char **argv) DbRetVal rv = conn.open("praba","manager"); printf ("Main open Returned %d\n", rv); pthread_t thread1, thread2; - char *message1 = "Thread 1"; - char *message2 = "Thread 2"; + int message1 =1; + int message2 =2; int status; pthread_create (&thread1, NULL, - &print_message_function, (void *) message1); + &print_message_function, (void *) &message1); pthread_create (&thread2, NULL, - &print_message_function, (void *) message2); + &print_message_function, (void *) &message2); pthread_join(thread1, (void **)&status); pthread_join(thread2, (void **)&status); + + + DatabaseManager *dbMgr = conn.getDatabaseManager(); + if (dbMgr == NULL) { printf("Auth failed\n"); return NULL;} + dbMgr->dropTable("T1"); + dbMgr->dropTable("T2"); + rv = conn.close(); printf ("Main Returned %d\n", rv); exit (0); @@ -30,7 +37,9 @@ int main (int argc, char **argv) void* print_message_function(void *ptr) { - if (flag == 0) {flag =1; sleep(2); } + //if (flag == 0) {flag =1; sleep(2); } + char tblname[20]; + sprintf(tblname, "T%d", *(int*)ptr ); Connection conn; DbRetVal rv=conn.open("praba","manager"); printf("Thread Return value of open %d %d\n", rv, getpid()); @@ -45,7 +54,7 @@ void* print_message_function(void *ptr) TableDef tabDef; tabDef.addField("f1", typeInt, 0, NULL, true, true); tabDef.addField("f2", typeInt); - rv = dbMgr->createTable("t1", tabDef); + rv = dbMgr->createTable(tblname, tabDef); if (rv != OK) { printf("Table creation failed\n"); return NULL; } printf("Table created\n"); diff --git a/test/dbapi/DataType/Makefile b/test/dbapi/DataType/Makefile index a98fe3d4..510f6b9e 100644 --- a/test/dbapi/DataType/Makefile +++ b/test/dbapi/DataType/Makefile @@ -22,17 +22,10 @@ INCL= -I$(CSQL_INSTALL_ROOT)/include LIBS= -L$(CSQL_INSTALL_ROOT)/lib -lcsql TARGETS = \ - test001 \ - test002 \ - test003 \ - test004 \ - test005 \ - test006 \ - test007 \ - test009 \ - test010 \ - test011 \ - test008 + test001 test002 test003 test004 test005 test006 test007 \ + test008 test009 test010 test011 test012 test013 test014 \ + test015 test016 test017 test018 test019 test020 test021 \ + test022 @@ -42,26 +35,48 @@ endif test001: inttest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test002: longtest.c +test002: inttest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test003: longtest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test003: longlongtest.c +test004: longtest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test005: longlongtest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test004: shorttest.c +test006: longlongtest.c + $(CPlus) $(CPlusFlags) -DWITHINDEX -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test007: shorttest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test005: byteinttest.c +test008: shorttest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test009: byteinttest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test006: floattest.c +test010: byteinttest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test011: floattest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test007: doubletest.c +test012: floattest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test013: doubletest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test008: chartest.c +test014: doubletest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test015: chartest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test009: datetest.c +test016: chartest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test017: datetest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test010: timetest.c +test018: datetest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test019: timetest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test011: timestamptest.c +test020: timetest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test021: timestamptest.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test022: timestamptest.c + $(CPlus) -DWITHINDEX $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) clean: rm -f $(TARGETS) diff --git a/test/dbapi/DataType/byteinttest.c b/test/dbapi/DataType/byteinttest.c index 1b03ee6a..c94f5811 100644 --- a/test/dbapi/DataType/byteinttest.c +++ b/test/dbapi/DataType/byteinttest.c @@ -10,14 +10,11 @@ int select(Table *table, ComparisionOp op) p1.setTerm("f1", op, &val1); table->setCondition(&p1); table->execute(); -printf("executed\n"); void *tuple; while ((tuple = (char*) table->fetch())) { printf("tuple value is %c %s \n", id, name); } -printf("before cloase\n"); table->close(); -printf("returned\n"); return 0; } @@ -39,7 +36,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); -return 0; +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); @@ -117,7 +123,6 @@ return 0; table->execute(); while ((tuple = (char*) table->fetch())) { printf("after delete tuple present. Its value is %c %s \n", id, name); - return 10; } table->close(); conn.commit(); diff --git a/test/dbapi/DataType/chartest.c b/test/dbapi/DataType/chartest.c index 5d1b5b10..d4e3d3e8 100644 --- a/test/dbapi/DataType/chartest.c +++ b/test/dbapi/DataType/chartest.c @@ -36,6 +36,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", id); diff --git a/test/dbapi/DataType/datetest.c b/test/dbapi/DataType/datetest.c index 230fedfc..9cddb844 100644 --- a/test/dbapi/DataType/datetest.c +++ b/test/dbapi/DataType/datetest.c @@ -38,6 +38,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/doubletest.c b/test/dbapi/DataType/doubletest.c index 0a041f50..df11adc6 100644 --- a/test/dbapi/DataType/doubletest.c +++ b/test/dbapi/DataType/doubletest.c @@ -36,6 +36,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/exp.test002 b/test/dbapi/DataType/exp.test002 index c4e31c5c..ba974f09 100644 --- a/test/dbapi/DataType/exp.test002 +++ b/test/dbapi/DataType/exp.test002 @@ -1,4 +1,5 @@ Table created +Index created Operator test for 0 tuple value is 3 PRABAKARAN0123456750590 Operator test for 1 diff --git a/test/dbapi/DataType/exp.test004 b/test/dbapi/DataType/exp.test004 index c4e31c5c..ba974f09 100644 --- a/test/dbapi/DataType/exp.test004 +++ b/test/dbapi/DataType/exp.test004 @@ -1,4 +1,5 @@ Table created +Index created Operator test for 0 tuple value is 3 PRABAKARAN0123456750590 Operator test for 1 diff --git a/test/dbapi/DataType/exp.test002 b/test/dbapi/DataType/exp.test006 similarity index 98% copy from test/dbapi/DataType/exp.test002 copy to test/dbapi/DataType/exp.test006 index c4e31c5c..ba974f09 100644 --- a/test/dbapi/DataType/exp.test002 +++ b/test/dbapi/DataType/exp.test006 @@ -1,4 +1,5 @@ Table created +Index created Operator test for 0 tuple value is 3 PRABAKARAN0123456750590 Operator test for 1 diff --git a/test/dbapi/DataType/exp.test002 b/test/dbapi/DataType/exp.test007 similarity index 100% copy from test/dbapi/DataType/exp.test002 copy to test/dbapi/DataType/exp.test007 diff --git a/test/dbapi/DataType/exp.test002 b/test/dbapi/DataType/exp.test008 similarity index 98% copy from test/dbapi/DataType/exp.test002 copy to test/dbapi/DataType/exp.test008 index c4e31c5c..ba974f09 100644 --- a/test/dbapi/DataType/exp.test002 +++ b/test/dbapi/DataType/exp.test008 @@ -1,4 +1,5 @@ Table created +Index created Operator test for 0 tuple value is 3 PRABAKARAN0123456750590 Operator test for 1 diff --git a/test/dbapi/DataType/exp.test008 b/test/dbapi/DataType/exp.test015 similarity index 100% copy from test/dbapi/DataType/exp.test008 copy to test/dbapi/DataType/exp.test015 diff --git a/test/dbapi/DataType/exp.test008 b/test/dbapi/DataType/exp.test016 similarity index 98% rename from test/dbapi/DataType/exp.test008 rename to test/dbapi/DataType/exp.test016 index d53acac3..3184f161 100644 --- a/test/dbapi/DataType/exp.test008 +++ b/test/dbapi/DataType/exp.test016 @@ -1,4 +1,5 @@ Table created +Index created Operator test for 0 tuple value is Value3 PRABAKARAN0123456750590 Operator test for 1 diff --git a/test/dbapi/DataType/exp.test017 b/test/dbapi/DataType/exp.test017 new file mode 100644 index 00000000..6a687c9a --- /dev/null +++ b/test/dbapi/DataType/exp.test017 @@ -0,0 +1,107 @@ +Table created +Operator test for 0 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +deleting tuple 20/12/1981 PRABAKARAN0123456750590 +deleting tuple 21/12/1981 PRABAKARAN0123456750590 +deleting tuple 22/12/1981 Its your birthday +deleting tuple 23/12/1981 PRABAKARAN0123456750590 +deleting tuple 24/12/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/11/1981 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/exp.test018 b/test/dbapi/DataType/exp.test018 new file mode 100644 index 00000000..61ad538c --- /dev/null +++ b/test/dbapi/DataType/exp.test018 @@ -0,0 +1,108 @@ +Table created +Index created +Operator test for 0 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 20/8/1981 PRABAKARAN0123456750590 +tuple value is 21/8/1981 PRABAKARAN0123456750590 +tuple value is 22/8/1981 PRABAKARAN0123456750590 +tuple value is 23/8/1981 PRABAKARAN0123456750590 +tuple value is 24/8/1981 PRABAKARAN0123456750590 +tuple value is 20/9/1981 PRABAKARAN0123456750590 +tuple value is 21/9/1981 PRABAKARAN0123456750590 +tuple value is 22/9/1981 PRABAKARAN0123456750590 +tuple value is 23/9/1981 PRABAKARAN0123456750590 +tuple value is 24/9/1981 PRABAKARAN0123456750590 +tuple value is 20/10/1981 PRABAKARAN0123456750590 +tuple value is 21/10/1981 PRABAKARAN0123456750590 +tuple value is 22/10/1981 PRABAKARAN0123456750590 +tuple value is 23/10/1981 PRABAKARAN0123456750590 +tuple value is 24/10/1981 PRABAKARAN0123456750590 +tuple value is 20/11/1981 PRABAKARAN0123456750590 +tuple value is 21/11/1981 PRABAKARAN0123456750590 +tuple value is 22/11/1981 PRABAKARAN0123456750590 +tuple value is 23/11/1981 PRABAKARAN0123456750590 +tuple value is 24/11/1981 PRABAKARAN0123456750590 +tuple value is 20/12/1981 PRABAKARAN0123456750590 +tuple value is 21/12/1981 PRABAKARAN0123456750590 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 22/12/1981 PRABAKARAN0123456750590 +tuple value is 23/12/1981 PRABAKARAN0123456750590 +tuple value is 24/12/1981 PRABAKARAN0123456750590 +deleting tuple 20/12/1981 PRABAKARAN0123456750590 +deleting tuple 21/12/1981 PRABAKARAN0123456750590 +deleting tuple 22/12/1981 Its your birthday +deleting tuple 23/12/1981 PRABAKARAN0123456750590 +deleting tuple 24/12/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/8/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/9/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/10/1981 PRABAKARAN0123456750590 +after delete tuple value is 20/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 21/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 22/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 23/11/1981 PRABAKARAN0123456750590 +after delete tuple value is 24/11/1981 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/exp.test019 b/test/dbapi/DataType/exp.test019 new file mode 100644 index 00000000..ec61871c --- /dev/null +++ b/test/dbapi/DataType/exp.test019 @@ -0,0 +1,107 @@ +Table created +Operator test for 0 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +deleting tuple 12:29:30.0 PRABAKARAN0123456750590 +deleting tuple 12:30:30.0 My value is updated +deleting tuple 12:31:30.0 PRABAKARAN0123456750590 +deleting tuple 12:32:30.0 PRABAKARAN0123456750590 +deleting tuple 12:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:33:30.0 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/exp.test020 b/test/dbapi/DataType/exp.test020 new file mode 100644 index 00000000..ae8e1f95 --- /dev/null +++ b/test/dbapi/DataType/exp.test020 @@ -0,0 +1,108 @@ +Table created +Index created +Operator test for 0 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 10:29:30.0 PRABAKARAN0123456750590 +tuple value is 10:30:30.0 PRABAKARAN0123456750590 +tuple value is 10:31:30.0 PRABAKARAN0123456750590 +tuple value is 10:32:30.0 PRABAKARAN0123456750590 +tuple value is 10:33:30.0 PRABAKARAN0123456750590 +tuple value is 11:29:30.0 PRABAKARAN0123456750590 +tuple value is 11:30:30.0 PRABAKARAN0123456750590 +tuple value is 11:31:30.0 PRABAKARAN0123456750590 +tuple value is 11:32:30.0 PRABAKARAN0123456750590 +tuple value is 11:33:30.0 PRABAKARAN0123456750590 +tuple value is 12:29:30.0 PRABAKARAN0123456750590 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 12:30:30.0 PRABAKARAN0123456750590 +tuple value is 12:31:30.0 PRABAKARAN0123456750590 +tuple value is 12:32:30.0 PRABAKARAN0123456750590 +tuple value is 12:33:30.0 PRABAKARAN0123456750590 +tuple value is 13:29:30.0 PRABAKARAN0123456750590 +tuple value is 13:30:30.0 PRABAKARAN0123456750590 +tuple value is 13:31:30.0 PRABAKARAN0123456750590 +tuple value is 13:32:30.0 PRABAKARAN0123456750590 +tuple value is 13:33:30.0 PRABAKARAN0123456750590 +tuple value is 14:29:30.0 PRABAKARAN0123456750590 +tuple value is 14:30:30.0 PRABAKARAN0123456750590 +tuple value is 14:31:30.0 PRABAKARAN0123456750590 +tuple value is 14:32:30.0 PRABAKARAN0123456750590 +tuple value is 14:33:30.0 PRABAKARAN0123456750590 +deleting tuple 12:29:30.0 PRABAKARAN0123456750590 +deleting tuple 12:30:30.0 My value is updated +deleting tuple 12:31:30.0 PRABAKARAN0123456750590 +deleting tuple 12:32:30.0 PRABAKARAN0123456750590 +deleting tuple 12:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 10:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 11:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 13:33:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:29:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:30:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:31:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:32:30.0 PRABAKARAN0123456750590 +after delete tuple value is 14:33:30.0 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/exp.test021 b/test/dbapi/DataType/exp.test021 new file mode 100644 index 00000000..a7abac6f --- /dev/null +++ b/test/dbapi/DataType/exp.test021 @@ -0,0 +1,48 @@ +Table created +Inserted 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +Inserted 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +Inserted 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Inserted 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +Inserted 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +Inserted 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +Inserted 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +Inserted 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +Inserted 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 0 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +tuple value is 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +tuple value is 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +tuple value is 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +tuple value is 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +tuple value is 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +tuple value is 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +tuple value is 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +tuple value is 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +tuple value is 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +tuple value is 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +deleting 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +after delete 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +after delete 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +after delete 24/12/1981 12:30:30.0 My value is updated +after delete 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +after delete 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +after delete 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +after delete 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +after delete 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/exp.test022 b/test/dbapi/DataType/exp.test022 new file mode 100644 index 00000000..026f2431 --- /dev/null +++ b/test/dbapi/DataType/exp.test022 @@ -0,0 +1,50 @@ +15880:3086161600:BucketList.cxx:87:Node not found in the bucket list +Table created +Index created +Inserted 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +Inserted 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +Inserted 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Inserted 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +Inserted 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +Inserted 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +Inserted 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +Inserted 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +Inserted 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 0 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 1 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +tuple value is 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +tuple value is 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +tuple value is 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +tuple value is 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +tuple value is 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 2 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +Operator test for 3 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +Operator test for 4 +tuple value is 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +tuple value is 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +tuple value is 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +tuple value is 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +tuple value is 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +tuple value is 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 +Operator test for 5 +tuple value is 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +tuple value is 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +tuple value is 24/12/1981 12:30:30.0 PRABAKARAN0123456750590 +deleting 28/12/1981 12:30:34.0 PRABAKARAN0123456750590 +after delete 22/12/1981 12:30:28.0 PRABAKARAN0123456750590 +after delete 23/12/1981 12:30:29.0 PRABAKARAN0123456750590 +after delete 24/12/1981 12:30:30.0 My value is updated +after delete 25/12/1981 12:30:31.0 PRABAKARAN0123456750590 +after delete 26/12/1981 12:30:32.0 PRABAKARAN0123456750590 +after delete 27/12/1981 12:30:33.0 PRABAKARAN0123456750590 +after delete 29/12/1981 12:30:35.0 PRABAKARAN0123456750590 +after delete 30/12/1981 12:30:36.0 PRABAKARAN0123456750590 diff --git a/test/dbapi/DataType/floattest.c b/test/dbapi/DataType/floattest.c index 8a0c2d0e..a7a34d9f 100644 --- a/test/dbapi/DataType/floattest.c +++ b/test/dbapi/DataType/floattest.c @@ -37,6 +37,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/inttest.c b/test/dbapi/DataType/inttest.c index a1e664af..d8df10bd 100644 --- a/test/dbapi/DataType/inttest.c +++ b/test/dbapi/DataType/inttest.c @@ -36,6 +36,15 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/longlongtest.c b/test/dbapi/DataType/longlongtest.c index ef618e6f..3f01e1fb 100644 --- a/test/dbapi/DataType/longlongtest.c +++ b/test/dbapi/DataType/longlongtest.c @@ -31,11 +31,21 @@ int main() DatabaseManager *dbMgr = conn.getDatabaseManager(); if (dbMgr == NULL) { printf("Auth failed\n"); return 2;} TableDef tabDef; - tabDef.addField("f1", typeLongLong, 0, NULL, true, true ); + tabDef.addField("f1", typeLongLong); tabDef.addField("f2", typeString, 196); rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/longtest.c b/test/dbapi/DataType/longtest.c index 97273d20..d9094704 100644 --- a/test/dbapi/DataType/longtest.c +++ b/test/dbapi/DataType/longtest.c @@ -36,6 +36,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/shorttest.c b/test/dbapi/DataType/shorttest.c index c09eaf06..4130b092 100644 --- a/test/dbapi/DataType/shorttest.c +++ b/test/dbapi/DataType/shorttest.c @@ -36,6 +36,17 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); + +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/timestamptest.c b/test/dbapi/DataType/timestamptest.c index 529394af..72a6041d 100644 --- a/test/dbapi/DataType/timestamptest.c +++ b/test/dbapi/DataType/timestamptest.c @@ -38,6 +38,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/DataType/timetest.c b/test/dbapi/DataType/timetest.c index d5af280c..85b3ebbf 100644 --- a/test/dbapi/DataType/timetest.c +++ b/test/dbapi/DataType/timetest.c @@ -38,6 +38,16 @@ int main() rv = dbMgr->createTable("t1", tabDef); if (rv != OK) { printf("Table creation failed\n"); return 3; } printf("Table created\n"); +#ifdef WITHINDEX + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created\n"); +#endif + Table *table = dbMgr->openTable("t1"); if (table == NULL) { printf("Unable to open table\n"); return 4; } table->bindFld("f1", &id); diff --git a/test/dbapi/Index/Makefile b/test/dbapi/Index/Makefile index c8178a47..6d5e6569 100644 --- a/test/dbapi/Index/Makefile +++ b/test/dbapi/Index/Makefile @@ -24,6 +24,8 @@ LIBS= -L$(CSQL_INSTALL_ROOT)/lib -lcsql TARGETS = \ test001 \ test002 \ + test004 \ + test005 \ test003 @@ -37,6 +39,10 @@ test002: uniqueindex2.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) test003: uniqueindex3.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test004: twoindex1.c + $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) +test005: twoindex2.c + $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) clean: rm -f $(TARGETS) diff --git a/test/dbapi/Index/twoindex1.c b/test/dbapi/Index/twoindex1.c new file mode 100644 index 00000000..2323e1f7 --- /dev/null +++ b/test/dbapi/Index/twoindex1.c @@ -0,0 +1,146 @@ +#include +int main() +{ + + Connection conn; + DbRetVal rv = conn.open("praba", "manager"); + if (rv != OK) + { + printf("Error during connection %d\n", rv); + return -1; + } + DatabaseManager *dbMgr = conn.getDatabaseManager(); + if (dbMgr == NULL) { printf("Auth failed\n"); return -1;} + TableDef tabDef; + tabDef.addField("f1", typeInt, 0, NULL, true, true ); + tabDef.addField("f2", typeInt); + rv = dbMgr->createTable("t1", tabDef); + if (rv != OK) { printf("Table creation failed\n"); return -1; } + printf("Table created\n"); + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created for f1\n"); + printf("size of index field list %d\n", idxInfo->list.size()); + idxInfo->list.remove("f1"); + printf("size of index field list %d\n", idxInfo->list.size()); + idxInfo->list.append("f2"); + printf("size of index field list %d\n", idxInfo->list.size()); + rv = dbMgr->createIndex("indx2", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created for f2\n"); + + Table *table = dbMgr->openTable("t1"); + if (table == NULL) { printf("Unable to open table\n"); return -1; } + int id1 = 0, id2=0; + table->bindFld("f1", &id1); + table->bindFld("f2", &id2); + char *tuple; + int ret; + int i; + int icount =0; + rv = conn.startTransaction(); + if (rv != OK) exit(1); + for(i = 0; i< 10; i++) + { + id1= i; + id2= i+100; + ret = table->insertTuple(); + if (ret != 0) break; + icount++; + } + conn.commit(); + printf("Total tuples inserted: %d\n", icount); + Condition p1, p2; + int val1 = 0; + p1.setTerm("f1", OpEquals, &val1); + p2.setTerm("f2", OpEquals, &val1); + table->setCondition(&p1); + rv =conn.startTransaction(); + if (rv != OK) exit(1); + for(i = 0; i< 10; i++) + { + val1 = i; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple == NULL) {printf("loop break in %d\n", i);table->close();break;} + printf("I:tuple value is %d %d \n", id1, id2); + table->close(); + } + + table->setCondition(&p2); + for(i = 0; i< 10; i++) + { + val1 = i+100; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple == NULL) {printf("loop break in %d\n", i);table->close();break;} + printf("II:tuple value is %d %d \n", id1, id2); + table->close(); + } + conn.commit(); + + rv = conn.startTransaction(); + if (rv != OK) exit (1); + table->setCondition(&p1); + val1 = 0; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + id2=99; + table->updateTuple(); + } + table->close(); + table->setCondition(&p2); + val1 = 109; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + id1=99; + table->updateTuple(); + } + table->close(); + conn.commit(); + + + rv = conn.startTransaction(); + if (rv != OK) exit (1); + table->setCondition(&p1); + val1 = 1; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + table->deleteTuple(); + } + table->close(); + table->setCondition(&p2); + val1 = 101; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + table->deleteTuple(); + } + table->close(); + conn.commit(); + + int count =0; + rv = conn.startTransaction(); + table->setCondition(NULL); + if (rv != OK) exit (1); + table->execute(); + while((tuple = (char*)table->fetch())!= NULL) { + printf("tuple value is %d %d \n", id1, id2); + count++; + } + table->close(); + conn.commit(); + printf("Total rows selected %d\n", count); + dbMgr->closeTable(table); + dbMgr->dropTable("t1"); + + conn.close(); + return 0; +} diff --git a/test/dbapi/Index/twoindex2.c b/test/dbapi/Index/twoindex2.c new file mode 100644 index 00000000..ede6137d --- /dev/null +++ b/test/dbapi/Index/twoindex2.c @@ -0,0 +1,148 @@ +#include +int main() +{ + + Connection conn; + DbRetVal rv = conn.open("praba", "manager"); + if (rv != OK) + { + printf("Error during connection %d\n", rv); + return -1; + } + DatabaseManager *dbMgr = conn.getDatabaseManager(); + if (dbMgr == NULL) { printf("Auth failed\n"); return -1;} + TableDef tabDef; + tabDef.addField("f1", typeInt, 0, NULL, true, true ); + tabDef.addField("f2", typeString, 50); + rv = dbMgr->createTable("t1", tabDef); + if (rv != OK) { printf("Table creation failed\n"); return -1; } + printf("Table created\n"); + HashIndexInitInfo *idxInfo = new HashIndexInitInfo(); + strcpy(idxInfo->tableName, "t1"); + idxInfo->list.append("f1"); + idxInfo->indType = hashIndex; + rv = dbMgr->createIndex("indx1", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created for f1\n"); + printf("size of index field list %d\n", idxInfo->list.size()); + idxInfo->list.remove("f1"); + printf("size of index field list %d\n", idxInfo->list.size()); + idxInfo->list.append("f2"); + printf("size of index field list %d\n", idxInfo->list.size()); + rv = dbMgr->createIndex("indx2", idxInfo); + if (rv != OK) { printf("Index creation failed\n"); return -1; } + printf("Index created for f2\n"); + + Table *table = dbMgr->openTable("t1"); + if (table == NULL) { printf("Unable to open table\n"); return -1; } + int id1 = 0; + char id2[50] ="Aruna"; + table->bindFld("f1", &id1); + table->bindFld("f2", id2); + char *tuple; + int ret; + int i; + int icount =0; + rv = conn.startTransaction(); + if (rv != OK) exit(1); + for(i = 0; i< 10; i++) + { + id1= i; + sprintf(id2, "Aruna:%d", i); + ret = table->insertTuple(); + if (ret != 0) break; + icount++; + } + conn.commit(); + printf("Total tuples inserted: %d\n", icount); + Condition p1, p2; + int val1 = 0; + char val2[50]; + p1.setTerm("f1", OpEquals, &val1); + p2.setTerm("f2", OpEquals, &val2); + table->setCondition(&p1); + rv =conn.startTransaction(); + if (rv != OK) exit(1); + for(i = 0; i< 10; i++) + { + val1 = i; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple == NULL) {printf("loop break in %d\n", i);table->close();break;} + printf("I:tuple value is %d %s \n", id1, id2); + table->close(); + } + + table->setCondition(&p2); + for(i = 0; i< 10; i++) + { + sprintf(val2, "Aruna:%d", i); + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple == NULL) {printf("loop break in %d\n", i);table->close();break;} + printf("II:tuple value is %d %s \n", id1, id2); + table->close(); + } + conn.commit(); + + rv = conn.startTransaction(); + if (rv != OK) exit (1); + table->setCondition(&p1); + val1 = 0; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + sprintf(id2,"Aruna:%d", 99); + table->updateTuple(); + } + table->close(); + table->setCondition(&p2); + sprintf(val2, "Aruna:%d", 10); + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + id1=99; + table->updateTuple(); + } + table->close(); + conn.commit(); + + + rv = conn.startTransaction(); + if (rv != OK) exit (1); + table->setCondition(&p1); + val1 = 1; + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + table->deleteTuple(); + } + table->close(); + table->setCondition(&p2); + sprintf(val2, "Aruna:%d", 101); + table->execute(); + tuple = (char*)table->fetch() ; + if (tuple != NULL) { + table->deleteTuple(); + } + table->close(); + conn.commit(); + + int count =0; + rv = conn.startTransaction(); + table->setCondition(NULL); + if (rv != OK) exit (1); + table->execute(); + while((tuple = (char*)table->fetch())!= NULL) { + printf("tuple value is %d %s \n", id1, id2); + count++; + } + table->close(); + conn.commit(); + printf("Total rows selected %d\n", count); + dbMgr->closeTable(table); + dbMgr->dropTable("t1"); + + conn.close(); + return 0; +} diff --git a/test/execTests.ksh b/test/execTests.ksh index 68cbc926..b363905f 100755 --- a/test/execTests.ksh +++ b/test/execTests.ksh @@ -1,4 +1,4 @@ -#!/bin/ksh +#!/bin/sh ################### Settings ######################################## #Timeout value for the hanging scripts diff --git a/test/genReport.ksh b/test/genReport.ksh index 05a8d77b..70165f56 100755 --- a/test/genReport.ksh +++ b/test/genReport.ksh @@ -1,4 +1,4 @@ -#!/bin/ksh +#!/bin/sh ##################Test Report Generator main starts here############## #TEST_RUN_DIR should be set before running this diff --git a/test/storage/DMLTest.c b/test/performance/DMLTest.c similarity index 100% rename from test/storage/DMLTest.c rename to test/performance/DMLTest.c diff --git a/test/storage/DMLTestChar.c b/test/performance/DMLTestChar.c similarity index 100% rename from test/storage/DMLTestChar.c rename to test/performance/DMLTestChar.c diff --git a/test/storage/DMLThreadTest.c b/test/performance/DMLThreadTest.c similarity index 100% rename from test/storage/DMLThreadTest.c rename to test/performance/DMLThreadTest.c diff --git a/test/storage/Makefile b/test/performance/Makefile similarity index 100% rename from test/storage/Makefile rename to test/performance/Makefile diff --git a/test/storage/Range.c b/test/performance/Range.c similarity index 100% rename from test/storage/Range.c rename to test/performance/Range.c diff --git a/test/dbapi/Index/Makefile b/test/system/config/Makefile similarity index 67% copy from test/dbapi/Index/Makefile copy to test/system/config/Makefile index c8178a47..cb27d1f2 100644 --- a/test/dbapi/Index/Makefile +++ b/test/system/config/Makefile @@ -9,7 +9,7 @@ SYSLIBS=-ldl -lnsl -lsocket -lposix4 else ifeq ($(OSNAME), Linux) CPlus = g++ -CPlusFlags = -g -w +CPlusFlags = -O2 -w SYSLIBS= -rdynamic -lrt -lpthread -lcrypt else PlatForm=notsupported @@ -22,20 +22,13 @@ INCL= -I$(CSQL_INSTALL_ROOT)/include LIBS= -L$(CSQL_INSTALL_ROOT)/lib -lcsql TARGETS = \ - test001 \ - test002 \ - test003 - + test001 ifeq ($(PlatForm), supported) all: $(TARGETS) endif -test001: uniqueindex1.c - $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test002: uniqueindex2.c - $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) -test003: uniqueindex3.c +test001: conftest1.c $(CPlus) $(CPlusFlags) -o $@ $< $(INCL) $(LIBS) $(SYSLIBS) clean: diff --git a/test/system/config/conftest1.c b/test/system/config/conftest1.c new file mode 100644 index 00000000..b5d804ae --- /dev/null +++ b/test/system/config/conftest1.c @@ -0,0 +1,16 @@ +#include +int main() +{ + Connection conn; + DbRetVal rv = OK; + + os::setenv("CSQL_CONFIG_FILE", "/tmp/csql1.conf"); + + + rv = conn.open("praba", "manager"); + if (rv == OK) return 1; + + rv = conn.close(); + if (rv != OK) return 2; + return 0; +} -- 2.11.4.GIT