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

[csaba]

    Date: Wednesday, January 11, 2006 @ 12:55:33
  Author: csaba
    Path: /cvsroot/carob/libmysequoia/test

Modified: TestMySQLAPI.cpp (1.18 -> 1.19) TestMySQLAPI.hpp (1.7 -> 1.8)

Unit testing mysql_stmt_bind(), mysq_stmt_execute(), mysql_stmt_affected_rows().


------------------+
 TestMySQLAPI.cpp |   20 +++++++++++++++++++-
 TestMySQLAPI.hpp |    4 ++--
 2 files changed, 21 insertions(+), 3 deletions(-)


Index: libmysequoia/test/TestMySQLAPI.cpp
diff -u libmysequoia/test/TestMySQLAPI.cpp:1.18 
libmysequoia/test/TestMySQLAPI.cpp:1.19
--- libmysequoia/test/TestMySQLAPI.cpp:1.18     Wed Jan 11 12:19:48 2006
+++ libmysequoia/test/TestMySQLAPI.cpp  Wed Jan 11 12:55:33 2006
@@ -334,14 +334,32 @@
 {
 }
 
-void TestMySQLAPI::mysql_stmt_prepare_test(void)
+void TestMySQLAPI::mysql_stmt_prepare_bind_exec_test(void)
 {
   MYSQL_STMT *stmt;
+  MYSQL_BIND bind[1];
+  int int_data;
   char *query = "insert into t1 (b) 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);
+  
+  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;
+  CPPUNIT_ASSERT(mysql_stmt_bind_param(stmt, bind) == 0);
+  
+  int_data = 4;
+  CPPUNIT_ASSERT(mysql_stmt_execute(stmt) == 0);
+  CPPUNIT_ASSERT(mysql_stmt_affected_rows(stmt) == 1);
+  
+  int_data = 5;
+  CPPUNIT_ASSERT(mysql_stmt_execute(stmt) == 0);
+  CPPUNIT_ASSERT(mysql_stmt_affected_rows(stmt) == 1);
+
   CPPUNIT_ASSERT(mysql_stmt_close(stmt) == 0); 
 }
Index: libmysequoia/test/TestMySQLAPI.hpp
diff -u libmysequoia/test/TestMySQLAPI.hpp:1.7 
libmysequoia/test/TestMySQLAPI.hpp:1.8
--- libmysequoia/test/TestMySQLAPI.hpp:1.7      Wed Jan 11 12:11:33 2006
+++ libmysequoia/test/TestMySQLAPI.hpp  Wed Jan 11 12:55:33 2006
@@ -50,7 +50,7 @@
     CPPUNIT_TEST (mysql_fetch_row_use_test);
     CPPUNIT_TEST (mysql_stmt_init_close_test);
     CPPUNIT_TEST (mysql_stmt_attr_get_set_test);
-    CPPUNIT_TEST (mysql_stmt_prepare_test);
+    CPPUNIT_TEST (mysql_stmt_prepare_bind_exec_test);
   CPPUNIT_TEST_SUITE_END ();
 
 public:
@@ -78,7 +78,7 @@
   void mysql_fetch_row_use_test(void);
   void mysql_stmt_init_close_test(void);
   void mysql_stmt_attr_get_set_test(void);
-  void mysql_stmt_prepare_test(void);  
+  void mysql_stmt_prepare_bind_exec_test(void);
 private:
   MYSQL *mysql;
 };

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