Revert "Remove mysql and oracle resources for anna-ericsson project"

[anna.git] / source / dbms.mysql / BaseBind.cpp

diff --git a/source/dbms.mysql/BaseBind.cpp b/source/dbms.mysql/BaseBind.cpp
new file mode 100644 (file)
index 0000000..b91ca85
--- /dev/null
+++ b/source/dbms.mysql/BaseBind.cpp
@@ -0,0 +1,107 @@
+// ANNA - Anna is Not Nothingness Anymore                                                         //
+//                                                                                                //
+// (c) Copyright 2005-2015 Eduardo Ramos Testillano & Francisco Ruiz Rayo                         //
+//                                                                                                //
+// See project site at http://redmine.teslayout.com/projects/anna-suite                           //
+// See accompanying file LICENSE or copy at http://www.teslayout.com/projects/public/anna.LICENSE //
+
+
+#include <mysql/mysql.h>
+
+#include <anna/core/DataBlock.hpp>
+
+#include <anna/dbms/Data.hpp>
+#include <anna/dbms/LongBlock.hpp>
+
+#include <anna/dbms.mysql/BaseBind.hpp>
+
+using namespace std;
+using namespace anna;
+
+//----------------------------------------------------------------------------
+// (1) Reserva 2 Kbytes para trabajar con el  LOB.
+//----------------------------------------------------------------------------
+dbms::mysql::BaseBind::BaseBind(const dbms::Data& data) :
+  a_type(data.getType()),
+  a_time(NULL) {
+  switch(a_type) {
+  case Data::Type::ShortBlock:
+  case Data::Type::LongBlock:
+    break;
+  case Data::Type::Date:                                                                                                                    // (1)
+  case Data::Type::TimeStamp:
+    a_time = new MYSQL_TIME;
+    break;
+  default: break;
+  }
+}
+
+dbms::mysql::BaseBind::~BaseBind() {
+  delete a_time;
+}
+
+/**
+ * Según http://dev.mysql.com/doc/refman/4.1/en/c-api-prepared-statement-datatypes.html
+ * y el truco para recoger BLOB's http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-fetch.html.
+ */
+void dbms::mysql::BaseBind::setupBind(st_mysql_bind& bind, dbms::Data& data)
+throw(RuntimeException) {
+  anna_memset(&bind, 0, sizeof(bind));
+  bind.is_null = &a_nullIndicator;
+  a_length = 0;
+
+  switch(a_type) {
+  case Data::Type::Integer:
+    bind.buffer_type = MYSQL_TYPE_LONG;
+    bind.buffer_length = data.getMaxSize();
+    bind.length = &a_length;
+    bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
+    bind.is_unsigned = false;
+    break;
+  case Data::Type::String:
+    bind.buffer_type = MYSQL_TYPE_STRING;
+    bind.buffer_length = data.getMaxSize();
+    bind.length = &a_length;
+    bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
+    break;
+  case Data::Type::Float:
+    bind.buffer_type = MYSQL_TYPE_FLOAT;
+    bind.buffer_length = data.getMaxSize();
+    bind.length = &a_length;
+    bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
+    break;
+  case Data::Type::Date:                                                                                                                    // (1)
+    bind.buffer_type = MYSQL_TYPE_DATE;
+    bind.buffer_length = sizeof(MYSQL_TIME);
+    bind.length = &a_length;
+    bind.buffer = (char*) a_time;
+    break;
+  case Data::Type::TimeStamp:
+    bind.buffer_type = MYSQL_TYPE_DATETIME;
+    bind.buffer_length = sizeof(MYSQL_TIME);
+    bind.length = &a_length;
+    bind.buffer = (char*) a_time;
+    break;
+  case Data::Type::ShortBlock:
+
+    if((bind.buffer_length = data.getMaxSize()) < MaxBlobSize) {
+      bind.buffer_type = MYSQL_TYPE_BLOB;
+      bind.length = &a_length;
+      bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
+    } else {
+      string msg(data.asString());
+      msg += functions::asString(" | Over maximum size: %d/%d",  data.getMaxSize(), MaxBlobSize);
+      throw RuntimeException(msg, ANNA_FILE_LOCATION);
+    }
+
+    break;
+  case Data::Type::LongBlock:
+    /**
+     * El tratamiento particular se realiza en las clases InputBind y OutputBind.
+     */
+    break;
+  default:
+    throw RuntimeException(functions::asString("Unsupported data type %d", (int) a_type), ANNA_FILE_LOCATION);
+  }
+}
+