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 <anna/core/functions.hpp>
39 #include <anna/dbms/Connection.hpp>
40 #include <anna/dbms/Database.hpp>
41 #include <anna/dbms/functions.hpp>
42 #include <anna/dbms/String.hpp>
43 #include <anna/dbms/Statement.hpp>
49 void dbms::functions::verifyDataScheme(dbms::Connection& connection, const char* tableName, const char* requiredPatch, const char* columnID, const char* columnDate)
50 throw(RuntimeException) {
51 dbms::Database& database = connection.getDatabase();
52 dbms::Statement* statement = NULL;
54 string sql = anna::functions::asString(
55 "select max(%s) from %s where %s in (select max(%s) from %s)",
56 columnID, tableName, columnDate,
61 statement = database.createStatement("dbms::functions::VerifyDataScheme", sql);
62 statement->bindOutput("max_id", id);
63 dbms::ResultCode resultCode = connection.execute(statement);
65 if(resultCode.successful() == false)
66 throw dbms::DatabaseException(resultCode, ANNA_FILE_LOCATION);
69 const string _id(id.getValue());
70 const string _required(requiredPatch);
72 if(_required != _id) {
73 std::string msg("DataScheme is out of date | Current patch: ");
75 msg += " | Required patch: ";
77 throw RuntimeException(msg, ANNA_FILE_LOCATION);
80 database.releaseStatement(statement);
81 } catch(dbms::DatabaseException& edb) {
82 database.releaseStatement(statement);
83 throw RuntimeException(edb);
84 } catch(RuntimeException&) {
85 database.releaseStatement(statement);