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

[csaba]

    Date: Wednesday, January 18, 2006 @ 15:38:26
  Author: csaba
    Path: /cvsroot/carob/libmysequoia/test

Modified: TestMySQLAPI.cpp (1.24 -> 1.25)

Added test with TIME param.


------------------+
 TestMySQLAPI.cpp |   32 +++++++++++++++++++++++++++-----
 1 files changed, 27 insertions(+), 5 deletions(-)


Index: libmysequoia/test/TestMySQLAPI.cpp
diff -u libmysequoia/test/TestMySQLAPI.cpp:1.24 
libmysequoia/test/TestMySQLAPI.cpp:1.25
--- libmysequoia/test/TestMySQLAPI.cpp:1.24     Wed Jan 18 15:27:55 2006
+++ libmysequoia/test/TestMySQLAPI.cpp  Wed Jan 18 15:38:26 2006
@@ -210,7 +210,8 @@
 
 void TestMySQLAPI::mysql_real_query_2_test(void)
 {
-  char *query = "insert into t1 (b,d) values 
(1,'2006-01-01'),(2,'2006-01-02'),(3,'2006-01-03')";
+  char *query = "insert into t1 (b,d,e) values (1,'2006-01-01', '1:2:3'),"
+                "(2,'2006-01-02','4:5:6'),(3,'2006-01-03','7:8:9')";
 
   // connect to the database
   CPPUNIT_ASSERT(mysql_real_connect(mysql, HOST, USER1, PASSWD1, DB1, 0, 0, 0) 
!= 0);
@@ -339,15 +340,15 @@
 void TestMySQLAPI::mysql_stmt_prepare_bind_exec_test(void)
 {
   MYSQL_STMT *stmt;
-  MYSQL_BIND bind[2];
+  MYSQL_BIND bind[3];
   int int_data;
-  MYSQL_TIME date_data;
-  char *query = "insert into t1 (b,d) values (?,?)";
+  MYSQL_TIME date_data, time_data;
+  char *query = "insert into t1 (b,d,e) 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) == 2);
+  CPPUNIT_ASSERT(mysql_stmt_param_count(stmt) == 3);
   
   memset(bind, 0, sizeof(bind));
   bind[0].buffer_type = MYSQL_TYPE_LONG;
@@ -356,6 +357,11 @@
   bind[1].buffer_type = MYSQL_TYPE_DATE;
   bind[1].buffer = (char *)&date_data;
   bind[1].buffer_length = sizeof(MYSQL_TIME);
+
+  bind[2].buffer_type = MYSQL_TYPE_TIME;
+  bind[2].buffer = (char *)&time_data;
+  bind[2].buffer_length = sizeof(MYSQL_TIME);
+
   CPPUNIT_ASSERT(mysql_stmt_bind_param(stmt, bind) == 0);
   
   int_data = 4;
@@ -364,10 +370,26 @@
   date_data.year = 2006;
   date_data.month = 1;
   date_data.day = 4;
+  memset(&time_data, 0, sizeof(MYSQL_TIME));
+  time_data.time_type = MYSQL_TIMESTAMP_TIME;
+  time_data.hour = 10;
+  time_data.minute = 11;
+  time_data.second = 12;
+  
   CPPUNIT_ASSERT(mysql_stmt_execute(stmt) == 0);
   CPPUNIT_ASSERT(mysql_stmt_affected_rows(stmt) == 1);
   
   int_data = 5;
+  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 = 5;
+  memset(&time_data, 0, sizeof(MYSQL_TIME));
+  time_data.time_type = MYSQL_TIMESTAMP_TIME;
+  time_data.hour = 13;
+  time_data.minute = 14;
+  time_data.second = 15;
   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