[Carob-commits] CVS update of libmysequoia/test (TestMySQLAPI.cpp)

[csaba]

    Date: Wednesday, January 18, 2006 @ 10:29:57
  Author: csaba
    Path: /cvsroot/carob/libmysequoia/test

Modified: TestMySQLAPI.cpp (1.21 -> 1.22)

Added test with DATE data type.


------------------+
 TestMySQLAPI.cpp |   32 ++++++++++++++++++++++----------
 1 files changed, 22 insertions(+), 10 deletions(-)


Index: libmysequoia/test/TestMySQLAPI.cpp
diff -u libmysequoia/test/TestMySQLAPI.cpp:1.21 
libmysequoia/test/TestMySQLAPI.cpp:1.22
--- libmysequoia/test/TestMySQLAPI.cpp:1.21     Tue Jan 17 09:38:38 2006
+++ libmysequoia/test/TestMySQLAPI.cpp  Wed Jan 18 10:29:57 2006
@@ -197,7 +197,11 @@
 
 void TestMySQLAPI::mysql_real_query_1_test(void)
 {
-  char *query = "create table t1 (a int(11) not null auto_increment, b int(11) 
default null, c varchar(200) default null, primary key  (a))";
+//  char *query = "create table t1 (a int(11) not null auto_increment, b 
int(11) default null,"
+//                " c varchar(200) default null, d date default null, e time 
default null, "
+//                "datetime default null, primary key  (a))";
+  char *query = "create table t1 (a int(11) not null auto_increment, b int(11) 
default null,"
+                " c varchar(200) default null, d date default null, primary 
key  (a))";
   
   // connect to the database
   CPPUNIT_ASSERT(mysql_real_connect(mysql, HOST, USER1, PASSWD1, DB1, 0, 0, 0) 
!= 0);
@@ -208,7 +212,7 @@
 
 void TestMySQLAPI::mysql_real_query_2_test(void)
 {
-  char *query = "insert into t1 (b) values (1),(2),(3)";
+  char *query = "insert into t1 (b,d) values 
(1,'2006-01-01'),(2,'2006-01-02'),(3,'2006-01-03')";
 
   // connect to the database
   CPPUNIT_ASSERT(mysql_real_connect(mysql, HOST, USER1, PASSWD1, DB1, 0, 0, 0) 
!= 0);
@@ -337,23 +341,31 @@
 void TestMySQLAPI::mysql_stmt_prepare_bind_exec_test(void)
 {
   MYSQL_STMT *stmt;
-  MYSQL_BIND bind[1];
+  MYSQL_BIND bind[2];
   int int_data;
-  char *query = "insert into t1 (b) values (?)";
+  MYSQL_TIME date_data;
+  char *query = "insert into t1 (b,d) values (?,?)";
 
   CPPUNIT_ASSERT(mysql_real_connect(mysql, HOST, USER1, PASSWD1, DB1, 0, 0, 0) 
!= 0);
   CPPUNIT_ASSERT((stmt = mysql_stmt_init(mysql)) != 0);
   CPPUNIT_ASSERT(mysql_stmt_prepare(stmt, query, strlen(query)) == 0);
-  CPPUNIT_ASSERT(mysql_stmt_param_count(stmt) == 1);
+  CPPUNIT_ASSERT(mysql_stmt_param_count(stmt) == 2);
   
-  memset(bind, 0, sizeof(bind));
-  bind[0].buffer_type= MYSQL_TYPE_LONG;
-  bind[0].buffer= (char *)&int_data;
-  bind[0].is_null= 0;
-  bind[0].length= 0;
+  memset(bind, 0, sizeof(MYSQL_BIND));
+  bind[0].buffer_type = MYSQL_TYPE_LONG;
+  bind[0].buffer = (char *)&int_data;
+  
+  bind[1].buffer_type = MYSQL_TYPE_DATE;
+  bind[1].buffer = (char *)&date_data;
+  bind[1].buffer_length = sizeof(MYSQL_TIME);
   CPPUNIT_ASSERT(mysql_stmt_bind_param(stmt, bind) == 0);
   
   int_data = 4;
+  memset(&date_data, 0, sizeof(MYSQL_TIME));
+  date_data.time_type = MYSQL_TIMESTAMP_DATE;
+  date_data.year = 2006;
+  date_data.month = 1;
+  date_data.day = 4;
   CPPUNIT_ASSERT(mysql_stmt_execute(stmt) == 0);
   CPPUNIT_ASSERT(mysql_stmt_affected_rows(stmt) == 1);
   

_______________________________________________
Carob-commits mailing list
Carob-commits@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/carob-commits