1 // ANNA - Anna is Not Nothingness Anymore
3 // (c) Copyright 2005-2014 Eduardo Ramos Testillano & Francisco Ruiz Rayo
5 // http://redmine.teslayout.com/projects/anna-suite
7 // Redistribution and use in source and binary forms, with or without
8 // modification, are permitted provided that the following conditions
11 // * Redistributions of source code must retain the above copyright
12 // notice, this list of conditions and the following disclaimer.
13 // * Redistributions in binary form must reproduce the above
14 // copyright notice, this list of conditions and the following disclaimer
15 // in the documentation and/or other materials provided with the
17 // * Neither the name of the copyright holder nor the names of its
18 // contributors may be used to endorse or promote products derived from
19 // this software without specific prior written permission.
21 // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
22 // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
23 // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
24 // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
25 // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
26 // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
27 // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
28 // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
29 // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
30 // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
31 // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
33 // Authors: eduardo.ramos.testillano@gmail.com
34 // cisco.tierra@gmail.com
37 #include <mysql/mysql.h>
39 #include <anna/core/DataBlock.hpp>
41 #include <anna/dbms/Data.hpp>
42 #include <anna/dbms/LongBlock.hpp>
44 #include <anna/dbms.mysql/BaseBind.hpp>
49 //----------------------------------------------------------------------------
50 // (1) Reserva 2 Kbytes para trabajar con el LOB.
51 //----------------------------------------------------------------------------
52 dbms::mysql::BaseBind::BaseBind(const dbms::Data& data) :
53 a_type(data.getType()),
56 case Data::Type::ShortBlock:
57 case Data::Type::LongBlock:
59 case Data::Type::Date: // (1)
60 case Data::Type::TimeStamp:
61 a_time = new MYSQL_TIME;
67 dbms::mysql::BaseBind::~BaseBind() {
72 * SegĂșn http://dev.mysql.com/doc/refman/4.1/en/c-api-prepared-statement-datatypes.html
73 * y el truco para recoger BLOB's http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-fetch.html.
75 void dbms::mysql::BaseBind::setupBind(st_mysql_bind& bind, dbms::Data& data)
76 throw(RuntimeException) {
77 anna_memset(&bind, 0, sizeof(bind));
78 bind.is_null = &a_nullIndicator;
82 case Data::Type::Integer:
83 bind.buffer_type = MYSQL_TYPE_LONG;
84 bind.buffer_length = data.getMaxSize();
85 bind.length = &a_length;
86 bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
87 bind.is_unsigned = false;
89 case Data::Type::String:
90 bind.buffer_type = MYSQL_TYPE_STRING;
91 bind.buffer_length = data.getMaxSize();
92 bind.length = &a_length;
93 bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
95 case Data::Type::Float:
96 bind.buffer_type = MYSQL_TYPE_FLOAT;
97 bind.buffer_length = data.getMaxSize();
98 bind.length = &a_length;
99 bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
101 case Data::Type::Date: // (1)
102 bind.buffer_type = MYSQL_TYPE_DATE;
103 bind.buffer_length = sizeof(MYSQL_TIME);
104 bind.length = &a_length;
105 bind.buffer = (char*) a_time;
107 case Data::Type::TimeStamp:
108 bind.buffer_type = MYSQL_TYPE_DATETIME;
109 bind.buffer_length = sizeof(MYSQL_TIME);
110 bind.length = &a_length;
111 bind.buffer = (char*) a_time;
113 case Data::Type::ShortBlock:
115 if((bind.buffer_length = data.getMaxSize()) < MaxBlobSize) {
116 bind.buffer_type = MYSQL_TYPE_BLOB;
117 bind.length = &a_length;
118 bind.buffer = const_cast <dbms::Data&>(data).getBuffer();
120 string msg(data.asString());
121 msg += functions::asString(" | Over maximum size: %d/%d", data.getMaxSize(), MaxBlobSize);
122 throw RuntimeException(msg, ANNA_FILE_LOCATION);
126 case Data::Type::LongBlock:
128 * El tratamiento particular se realiza en las clases InputBind y OutputBind.
132 throw RuntimeException(functions::asString("Unsupported data type %d", (int) a_type), ANNA_FILE_LOCATION);