From 8a2e2b2ff5321efc9cf3c940b54466cf090769ca Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Sun, 8 Feb 2009 16:49:12 +0000 Subject: [PATCH] common.h added to support AbsSqlConnection and AbsSqlStatement creations expected files for network cases are added --- test/sqlapi/Parameter/common.h | 27 +++++++ test/sqlapi/Parameter/exp.test001n | 146 +++++++++++++++++++++++++++++++++++++ test/sqlapi/Parameter/exp.test002n | 14 ++++ test/sqlapi/Parameter/exp.test003n | 10 +++ test/sqlapi/Parameter/exp.test004n | 17 +++++ 5 files changed, 214 insertions(+) create mode 100644 test/sqlapi/Parameter/common.h create mode 100644 test/sqlapi/Parameter/exp.test001n create mode 100644 test/sqlapi/Parameter/exp.test002n create mode 100644 test/sqlapi/Parameter/exp.test003n create mode 100644 test/sqlapi/Parameter/exp.test004n diff --git a/test/sqlapi/Parameter/common.h b/test/sqlapi/Parameter/common.h new file mode 100644 index 00000000..397b9981 --- /dev/null +++ b/test/sqlapi/Parameter/common.h @@ -0,0 +1,27 @@ +#include +#include +#include + +AbsSqlConnection *createConnection() +{ +#ifdef NET + AbsSqlConnection *con = new SqlNwConnection(); + con->setInnerConnection(NULL); + SqlNwConnection *conn = (SqlNwConnection *)con; + conn->setHost("localhost", 5678); +#else + AbsSqlConnection *con = SqlFactory::createConnection(CSql); +#endif + return con; +} + +AbsSqlStatement *createStatement() +{ +#ifdef NET + AbsSqlStatement *stmt = new SqlNwStatement(); + stmt->setInnerStatement(NULL); +#else + AbsSqlStatement *stmt = SqlFactory::createStatement(CSql); +#endif + return stmt; +} diff --git a/test/sqlapi/Parameter/exp.test001n b/test/sqlapi/Parameter/exp.test001n new file mode 100644 index 00000000..8b968347 --- /dev/null +++ b/test/sqlapi/Parameter/exp.test001n @@ -0,0 +1,146 @@ +Table created +noOfParamField Returns=11 + +*********************************************** +1 FIELD INFORMATION :: +Field Name :F1 +Data type of the field :0 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +2 FIELD INFORMATION :: +Field Name :F2 +Data type of the field :3 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +3 FIELD INFORMATION :: +Field Name :F3 +Data type of the field :30 +length of the field :32 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +4 FIELD INFORMATION :: +Field Name :F4 +Data type of the field :11 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +5 FIELD INFORMATION :: +Field Name :F5 +Data type of the field :11 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +6 FIELD INFORMATION :: +Field Name :F6 +Data type of the field :20 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +7 FIELD INFORMATION :: +Field Name :F7 +Data type of the field :21 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +8 FIELD INFORMATION :: +Field Name :F8 +Data type of the field :22 +length of the field :8 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +9 FIELD INFORMATION :: +Field Name :F9 +Data type of the field :0 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +10 FIELD INFORMATION :: +Field Name :F10 +Data type of the field :2 +length of the field :8 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** + +*********************************************** +11 FIELD INFORMATION :: +Field Name :F11 +Data type of the field :31 +length of the field :4 +Offset :0 +Default value : +Null field :0 +Default value :0 +*********************************************** +Total rows inserted 10 +F1=0 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=1 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=2 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=3 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=4 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=5 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=6 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=7 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=8 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +F1=9 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 + | 23FE +Total row fetched=10 +Table dropped diff --git a/test/sqlapi/Parameter/exp.test002n b/test/sqlapi/Parameter/exp.test002n new file mode 100644 index 00000000..ab9f2412 --- /dev/null +++ b/test/sqlapi/Parameter/exp.test002n @@ -0,0 +1,14 @@ +Table created +Total rows inserted 10 +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=100 | F2=10 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +10 Tuples fetched +Table dropped diff --git a/test/sqlapi/Parameter/exp.test003n b/test/sqlapi/Parameter/exp.test003n new file mode 100644 index 00000000..eca8b51d --- /dev/null +++ b/test/sqlapi/Parameter/exp.test003n @@ -0,0 +1,10 @@ +Table T1 created +Total rows inserted 10 +Total row deleted=5 +F1=0 | F2=1 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=1 | F2=1 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=2 | F2=1 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=3 | F2=1 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=4 | F2=1 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +Total row fetched=5 +Table dropped diff --git a/test/sqlapi/Parameter/exp.test004n b/test/sqlapi/Parameter/exp.test004n new file mode 100644 index 00000000..e559a56e --- /dev/null +++ b/test/sqlapi/Parameter/exp.test004n @@ -0,0 +1,17 @@ +Table created +10 Rows inserted +noOfParamFields return=8 +5 Rows updated +F1=0 | F2=11 | F3=lakshya | F4=11.220000 | F5=20.250000 | DATE=2007-3-30 | TIME=12:29:30 | TIMESTAMP=2007-3-30 10:25:55 | F9=20 | F10=15000 | AB12 +F1=1 | F2=12 | F3=lakshya | F4=11.220000 | F5=20.250000 | DATE=2007-3-30 | TIME=12:29:30 | TIMESTAMP=2007-3-30 10:25:55 | F9=20 | F10=15000 | AB12 +F1=2 | F2=13 | F3=lakshya | F4=11.220000 | F5=20.250000 | DATE=2007-3-30 | TIME=12:29:30 | TIMESTAMP=2007-3-30 10:25:55 | F9=20 | F10=15000 | AB12 +F1=3 | F2=14 | F3=lakshya | F4=11.220000 | F5=20.250000 | DATE=2007-3-30 | TIME=12:29:30 | TIMESTAMP=2007-3-30 10:25:55 | F9=20 | F10=15000 | AB12 +F1=4 | F2=15 | F3=lakshya | F4=11.220000 | F5=20.250000 | DATE=2007-3-30 | TIME=12:29:30 | TIMESTAMP=2007-3-30 10:25:55 | F9=20 | F10=15000 | AB12 + +F1=5 | F2=16 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2008-1-21 | TIME=12:29:30 | TIMESTAMP=2008-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=6 | F2=17 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2008-1-21 | TIME=12:29:30 | TIMESTAMP=2008-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=7 | F2=18 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2008-1-21 | TIME=12:29:30 | TIMESTAMP=2008-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=8 | F2=19 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2008-1-21 | TIME=12:29:30 | TIMESTAMP=2008-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +F1=9 | F2=20 | F3=jitendra | F4=5.500000 | F5=10.500000 | DATE=2008-1-21 | TIME=12:29:30 | TIMESTAMP=2008-1-21 12:29:30 | F9=20 | F10=12000 | 23FE +10 Rows fetched=4 +Table dropped -- 2.11.4.GIT