108334c51SBrooks Davis // Copyright 2011 The Kyua Authors.
208334c51SBrooks Davis // All rights reserved.
308334c51SBrooks Davis //
408334c51SBrooks Davis // Redistribution and use in source and binary forms, with or without
508334c51SBrooks Davis // modification, are permitted provided that the following conditions are
608334c51SBrooks Davis // met:
708334c51SBrooks Davis //
808334c51SBrooks Davis // * Redistributions of source code must retain the above copyright
908334c51SBrooks Davis // notice, this list of conditions and the following disclaimer.
1008334c51SBrooks Davis // * Redistributions in binary form must reproduce the above copyright
1108334c51SBrooks Davis // notice, this list of conditions and the following disclaimer in the
1208334c51SBrooks Davis // documentation and/or other materials provided with the distribution.
1308334c51SBrooks Davis // * Neither the name of Google Inc. nor the names of its contributors
1408334c51SBrooks Davis // may be used to endorse or promote products derived from this software
1508334c51SBrooks Davis // without specific prior written permission.
1608334c51SBrooks Davis //
1708334c51SBrooks Davis // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
1808334c51SBrooks Davis // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
1908334c51SBrooks Davis // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
2008334c51SBrooks Davis // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
2108334c51SBrooks Davis // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
2208334c51SBrooks Davis // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
2308334c51SBrooks Davis // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
2408334c51SBrooks Davis // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
2508334c51SBrooks Davis // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
2608334c51SBrooks Davis // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
2708334c51SBrooks Davis // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
2808334c51SBrooks Davis
2908334c51SBrooks Davis #include "utils/sqlite/c_gate.hpp"
3008334c51SBrooks Davis
3108334c51SBrooks Davis #include <atf-c++.hpp>
3208334c51SBrooks Davis
3308334c51SBrooks Davis #include "utils/fs/path.hpp"
3408334c51SBrooks Davis #include "utils/optional.ipp"
3508334c51SBrooks Davis #include "utils/sqlite/database.hpp"
3608334c51SBrooks Davis #include "utils/sqlite/test_utils.hpp"
3708334c51SBrooks Davis
3808334c51SBrooks Davis namespace fs = utils::fs;
3908334c51SBrooks Davis namespace sqlite = utils::sqlite;
4008334c51SBrooks Davis
4108334c51SBrooks Davis
4208334c51SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(connect);
ATF_TEST_CASE_BODY(connect)4308334c51SBrooks Davis ATF_TEST_CASE_BODY(connect)
4408334c51SBrooks Davis {
4508334c51SBrooks Davis ::sqlite3* raw_db;
4608334c51SBrooks Davis ATF_REQUIRE_EQ(SQLITE_OK, ::sqlite3_open_v2(":memory:", &raw_db,
4708334c51SBrooks Davis SQLITE_OPEN_READWRITE, NULL));
4808334c51SBrooks Davis {
4908334c51SBrooks Davis sqlite::database database = sqlite::database_c_gate::connect(raw_db);
5008334c51SBrooks Davis create_test_table(raw(database));
5108334c51SBrooks Davis }
5208334c51SBrooks Davis // If the wrapper object has closed the SQLite 3 database, we will misbehave
5308334c51SBrooks Davis // here either by crashing or not finding our test table.
5408334c51SBrooks Davis verify_test_table(raw_db);
5508334c51SBrooks Davis ::sqlite3_close(raw_db);
5608334c51SBrooks Davis }
5708334c51SBrooks Davis
5808334c51SBrooks Davis
5908334c51SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(c_database);
ATF_TEST_CASE_BODY(c_database)6008334c51SBrooks Davis ATF_TEST_CASE_BODY(c_database)
6108334c51SBrooks Davis {
6208334c51SBrooks Davis sqlite::database db = sqlite::database::in_memory();
6308334c51SBrooks Davis create_test_table(raw(db));
6408334c51SBrooks Davis {
6508334c51SBrooks Davis sqlite::database_c_gate gate(db);
6608334c51SBrooks Davis ::sqlite3* raw_db = gate.c_database();
6708334c51SBrooks Davis verify_test_table(raw_db);
6808334c51SBrooks Davis }
6908334c51SBrooks Davis }
7008334c51SBrooks Davis
7108334c51SBrooks Davis
7208334c51SBrooks Davis ATF_TEST_CASE(database__db_filename);
ATF_TEST_CASE_HEAD(database__db_filename)7308334c51SBrooks Davis ATF_TEST_CASE_HEAD(database__db_filename)
7408334c51SBrooks Davis {
7508334c51SBrooks Davis set_md_var("descr", "The current implementation of db_filename() has no "
7608334c51SBrooks Davis "means to access the filename of a database connected to a raw "
7708334c51SBrooks Davis "sqlite3 object");
7808334c51SBrooks Davis }
ATF_TEST_CASE_BODY(database__db_filename)7908334c51SBrooks Davis ATF_TEST_CASE_BODY(database__db_filename)
8008334c51SBrooks Davis {
8108334c51SBrooks Davis ::sqlite3* raw_db;
8208334c51SBrooks Davis ATF_REQUIRE_EQ(SQLITE_OK, ::sqlite3_open_v2(
8308334c51SBrooks Davis "test.db", &raw_db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL));
8408334c51SBrooks Davis
8508334c51SBrooks Davis sqlite::database database = sqlite::database_c_gate::connect(raw_db);
8608334c51SBrooks Davis ATF_REQUIRE(!database.db_filename());
8708334c51SBrooks Davis ::sqlite3_close(raw_db);
8808334c51SBrooks Davis }
8908334c51SBrooks Davis
9008334c51SBrooks Davis
ATF_INIT_TEST_CASES(tcs)9108334c51SBrooks Davis ATF_INIT_TEST_CASES(tcs)
9208334c51SBrooks Davis {
9308334c51SBrooks Davis ATF_ADD_TEST_CASE(tcs, c_database);
9408334c51SBrooks Davis ATF_ADD_TEST_CASE(tcs, connect);
9508334c51SBrooks Davis ATF_ADD_TEST_CASE(tcs, database__db_filename);
9608334c51SBrooks Davis }
97