003 File Manager
Current Path:
/usr/src/contrib/kyua/utils/sqlite
usr
/
src
/
contrib
/
kyua
/
utils
/
sqlite
/
📁
..
📄
Kyuafile
(230 B)
📄
Makefile.am.inc
(3.99 KB)
📄
c_gate.cpp
(3.02 KB)
📄
c_gate.hpp
(2.67 KB)
📄
c_gate_fwd.hpp
(1.84 KB)
📄
c_gate_test.cpp
(3.39 KB)
📄
database.cpp
(10.73 KB)
📄
database.hpp
(3.92 KB)
📄
database_fwd.hpp
(1.85 KB)
📄
database_test.cpp
(8.91 KB)
📄
exceptions.cpp
(5.23 KB)
📄
exceptions.hpp
(3.24 KB)
📄
exceptions_test.cpp
(4.57 KB)
📄
statement.cpp
(18.69 KB)
📄
statement.hpp
(4.09 KB)
📄
statement.ipp
(2.25 KB)
📄
statement_fwd.hpp
(2.01 KB)
📄
statement_test.cpp
(26.77 KB)
📄
test_utils.hpp
(5.37 KB)
📄
transaction.cpp
(4.16 KB)
📄
transaction.hpp
(2.35 KB)
📄
transaction_fwd.hpp
(1.86 KB)
📄
transaction_test.cpp
(4.5 KB)
Editing: transaction_test.cpp
// Copyright 2011 The Kyua Authors. // All rights reserved. // // Redistribution and use in source and binary forms, with or without // modification, are permitted provided that the following conditions are // met: // // * Redistributions of source code must retain the above copyright // notice, this list of conditions and the following disclaimer. // * Redistributions in binary form must reproduce the above copyright // notice, this list of conditions and the following disclaimer in the // documentation and/or other materials provided with the distribution. // * Neither the name of Google Inc. nor the names of its contributors // may be used to endorse or promote products derived from this software // without specific prior written permission. // // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. #include "utils/sqlite/transaction.hpp" #include <atf-c++.hpp> #include "utils/format/macros.hpp" #include "utils/sqlite/database.hpp" #include "utils/sqlite/exceptions.hpp" #include "utils/sqlite/statement.ipp" namespace sqlite = utils::sqlite; namespace { /// Ensures that a table has a single specific value in a column. /// /// \param db The SQLite database. /// \param table_name The table to be checked. /// \param column_name The column to be checked. /// \param exp_value The value expected to be found in the column. /// /// \return True if the column contains a single value and it matches exp_value; /// false if not. If the query fails, the calling test is marked as bad. static bool check_in_table(sqlite::database& db, const char* table_name, const char* column_name, int exp_value) { sqlite::statement stmt = db.create_statement( F("SELECT * FROM %s WHERE %s == %s") % table_name % column_name % exp_value); if (!stmt.step()) return false; if (stmt.step()) ATF_FAIL("More than one value found in table"); return true; } } // anonymous namespace ATF_TEST_CASE_WITHOUT_HEAD(automatic_rollback); ATF_TEST_CASE_BODY(automatic_rollback) { sqlite::database db = sqlite::database::in_memory(); db.exec("CREATE TABLE t (col INTEGER PRIMARY KEY)"); db.exec("INSERT INTO t VALUES (3)"); { sqlite::transaction tx = db.begin_transaction(); db.exec("INSERT INTO t VALUES (5)"); } ATF_REQUIRE( check_in_table(db, "t", "col", 3)); ATF_REQUIRE(!check_in_table(db, "t", "col", 5)); } ATF_TEST_CASE_WITHOUT_HEAD(explicit_commit); ATF_TEST_CASE_BODY(explicit_commit) { sqlite::database db = sqlite::database::in_memory(); db.exec("CREATE TABLE t (col INTEGER PRIMARY KEY)"); db.exec("INSERT INTO t VALUES (3)"); { sqlite::transaction tx = db.begin_transaction(); db.exec("INSERT INTO t VALUES (5)"); tx.commit(); } ATF_REQUIRE(check_in_table(db, "t", "col", 3)); ATF_REQUIRE(check_in_table(db, "t", "col", 5)); } ATF_TEST_CASE_WITHOUT_HEAD(explicit_rollback); ATF_TEST_CASE_BODY(explicit_rollback) { sqlite::database db = sqlite::database::in_memory(); db.exec("CREATE TABLE t (col INTEGER PRIMARY KEY)"); db.exec("INSERT INTO t VALUES (3)"); { sqlite::transaction tx = db.begin_transaction(); db.exec("INSERT INTO t VALUES (5)"); tx.rollback(); } ATF_REQUIRE( check_in_table(db, "t", "col", 3)); ATF_REQUIRE(!check_in_table(db, "t", "col", 5)); } ATF_TEST_CASE_WITHOUT_HEAD(nested_fail); ATF_TEST_CASE_BODY(nested_fail) { sqlite::database db = sqlite::database::in_memory(); { sqlite::transaction tx = db.begin_transaction(); ATF_REQUIRE_THROW(sqlite::error, db.begin_transaction()); } } ATF_INIT_TEST_CASES(tcs) { ATF_ADD_TEST_CASE(tcs, automatic_rollback); ATF_ADD_TEST_CASE(tcs, explicit_commit); ATF_ADD_TEST_CASE(tcs, explicit_rollback); ATF_ADD_TEST_CASE(tcs, nested_fail); }
Upload File
Create Folder