xref: /freebsd/contrib/kyua/utils/sqlite/exceptions_test.cpp (revision b0d29bc47dba79f6f38e67eabadfb4b32ffd9390)
1*b0d29bc4SBrooks Davis // Copyright 2011 The Kyua Authors.
2*b0d29bc4SBrooks Davis // All rights reserved.
3*b0d29bc4SBrooks Davis //
4*b0d29bc4SBrooks Davis // Redistribution and use in source and binary forms, with or without
5*b0d29bc4SBrooks Davis // modification, are permitted provided that the following conditions are
6*b0d29bc4SBrooks Davis // met:
7*b0d29bc4SBrooks Davis //
8*b0d29bc4SBrooks Davis // * Redistributions of source code must retain the above copyright
9*b0d29bc4SBrooks Davis //   notice, this list of conditions and the following disclaimer.
10*b0d29bc4SBrooks Davis // * Redistributions in binary form must reproduce the above copyright
11*b0d29bc4SBrooks Davis //   notice, this list of conditions and the following disclaimer in the
12*b0d29bc4SBrooks Davis //   documentation and/or other materials provided with the distribution.
13*b0d29bc4SBrooks Davis // * Neither the name of Google Inc. nor the names of its contributors
14*b0d29bc4SBrooks Davis //   may be used to endorse or promote products derived from this software
15*b0d29bc4SBrooks Davis //   without specific prior written permission.
16*b0d29bc4SBrooks Davis //
17*b0d29bc4SBrooks Davis // THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
18*b0d29bc4SBrooks Davis // "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
19*b0d29bc4SBrooks Davis // LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
20*b0d29bc4SBrooks Davis // A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
21*b0d29bc4SBrooks Davis // OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
22*b0d29bc4SBrooks Davis // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
23*b0d29bc4SBrooks Davis // LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
24*b0d29bc4SBrooks Davis // DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
25*b0d29bc4SBrooks Davis // THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26*b0d29bc4SBrooks Davis // (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
27*b0d29bc4SBrooks Davis // OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
28*b0d29bc4SBrooks Davis 
29*b0d29bc4SBrooks Davis #include "utils/sqlite/exceptions.hpp"
30*b0d29bc4SBrooks Davis 
31*b0d29bc4SBrooks Davis extern "C" {
32*b0d29bc4SBrooks Davis #include <sqlite3.h>
33*b0d29bc4SBrooks Davis }
34*b0d29bc4SBrooks Davis 
35*b0d29bc4SBrooks Davis #include <cstring>
36*b0d29bc4SBrooks Davis #include <string>
37*b0d29bc4SBrooks Davis 
38*b0d29bc4SBrooks Davis #include <atf-c++.hpp>
39*b0d29bc4SBrooks Davis 
40*b0d29bc4SBrooks Davis #include "utils/fs/path.hpp"
41*b0d29bc4SBrooks Davis #include "utils/optional.ipp"
42*b0d29bc4SBrooks Davis #include "utils/sqlite/c_gate.hpp"
43*b0d29bc4SBrooks Davis #include "utils/sqlite/database.hpp"
44*b0d29bc4SBrooks Davis 
45*b0d29bc4SBrooks Davis namespace fs = utils::fs;
46*b0d29bc4SBrooks Davis namespace sqlite = utils::sqlite;
47*b0d29bc4SBrooks Davis 
48*b0d29bc4SBrooks Davis using utils::none;
49*b0d29bc4SBrooks Davis 
50*b0d29bc4SBrooks Davis 
51*b0d29bc4SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(error__no_filename);
ATF_TEST_CASE_BODY(error__no_filename)52*b0d29bc4SBrooks Davis ATF_TEST_CASE_BODY(error__no_filename)
53*b0d29bc4SBrooks Davis {
54*b0d29bc4SBrooks Davis     const sqlite::database db = sqlite::database::in_memory();
55*b0d29bc4SBrooks Davis     const sqlite::error e(db.db_filename(), "Some text");
56*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("Some text (sqlite db: in-memory or temporary)",
57*b0d29bc4SBrooks Davis                    std::string(e.what()));
58*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ(db.db_filename(), e.db_filename());
59*b0d29bc4SBrooks Davis }
60*b0d29bc4SBrooks Davis 
61*b0d29bc4SBrooks Davis 
62*b0d29bc4SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(error__with_filename);
ATF_TEST_CASE_BODY(error__with_filename)63*b0d29bc4SBrooks Davis ATF_TEST_CASE_BODY(error__with_filename)
64*b0d29bc4SBrooks Davis {
65*b0d29bc4SBrooks Davis     const sqlite::database db = sqlite::database::open(
66*b0d29bc4SBrooks Davis         fs::path("test.db"), sqlite::open_readwrite | sqlite::open_create);
67*b0d29bc4SBrooks Davis     const sqlite::error e(db.db_filename(), "Some text");
68*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("Some text (sqlite db: test.db)", std::string(e.what()));
69*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ(db.db_filename(), e.db_filename());
70*b0d29bc4SBrooks Davis }
71*b0d29bc4SBrooks Davis 
72*b0d29bc4SBrooks Davis 
73*b0d29bc4SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(api_error__explicit);
ATF_TEST_CASE_BODY(api_error__explicit)74*b0d29bc4SBrooks Davis ATF_TEST_CASE_BODY(api_error__explicit)
75*b0d29bc4SBrooks Davis {
76*b0d29bc4SBrooks Davis     const sqlite::api_error e(none, "some_function", "Some text");
77*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ(
78*b0d29bc4SBrooks Davis         "Some text (sqlite op: some_function) "
79*b0d29bc4SBrooks Davis         "(sqlite db: in-memory or temporary)",
80*b0d29bc4SBrooks Davis         std::string(e.what()));
81*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("some_function", e.api_function());
82*b0d29bc4SBrooks Davis }
83*b0d29bc4SBrooks Davis 
84*b0d29bc4SBrooks Davis 
85*b0d29bc4SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(api_error__from_database);
ATF_TEST_CASE_BODY(api_error__from_database)86*b0d29bc4SBrooks Davis ATF_TEST_CASE_BODY(api_error__from_database)
87*b0d29bc4SBrooks Davis {
88*b0d29bc4SBrooks Davis     sqlite::database db = sqlite::database::open(
89*b0d29bc4SBrooks Davis         fs::path("test.db"), sqlite::open_readwrite | sqlite::open_create);
90*b0d29bc4SBrooks Davis 
91*b0d29bc4SBrooks Davis     // Use the raw sqlite3 API to cause an error.  Our C++ wrappers catch all
92*b0d29bc4SBrooks Davis     // errors and reraise them as exceptions, but here we want to handle the raw
93*b0d29bc4SBrooks Davis     // error directly for testing purposes.
94*b0d29bc4SBrooks Davis     sqlite::database_c_gate gate(db);
95*b0d29bc4SBrooks Davis     ::sqlite3_stmt* dummy_stmt;
96*b0d29bc4SBrooks Davis     const char* query = "ABCDE INVALID QUERY";
97*b0d29bc4SBrooks Davis     (void)::sqlite3_prepare_v2(gate.c_database(), query, std::strlen(query),
98*b0d29bc4SBrooks Davis                                &dummy_stmt, NULL);
99*b0d29bc4SBrooks Davis 
100*b0d29bc4SBrooks Davis     const sqlite::api_error e = sqlite::api_error::from_database(
101*b0d29bc4SBrooks Davis         db, "real_function");
102*b0d29bc4SBrooks Davis     ATF_REQUIRE_MATCH(
103*b0d29bc4SBrooks Davis         ".*ABCDE.*\\(sqlite op: real_function\\) \\(sqlite db: test.db\\)",
104*b0d29bc4SBrooks Davis         std::string(e.what()));
105*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("real_function", e.api_function());
106*b0d29bc4SBrooks Davis }
107*b0d29bc4SBrooks Davis 
108*b0d29bc4SBrooks Davis 
109*b0d29bc4SBrooks Davis ATF_TEST_CASE_WITHOUT_HEAD(invalid_column_error);
ATF_TEST_CASE_BODY(invalid_column_error)110*b0d29bc4SBrooks Davis ATF_TEST_CASE_BODY(invalid_column_error)
111*b0d29bc4SBrooks Davis {
112*b0d29bc4SBrooks Davis     const sqlite::invalid_column_error e(none, "some_name");
113*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("Unknown column 'some_name' "
114*b0d29bc4SBrooks Davis                    "(sqlite db: in-memory or temporary)",
115*b0d29bc4SBrooks Davis                    std::string(e.what()));
116*b0d29bc4SBrooks Davis     ATF_REQUIRE_EQ("some_name", e.column_name());
117*b0d29bc4SBrooks Davis }
118*b0d29bc4SBrooks Davis 
119*b0d29bc4SBrooks Davis 
ATF_INIT_TEST_CASES(tcs)120*b0d29bc4SBrooks Davis ATF_INIT_TEST_CASES(tcs)
121*b0d29bc4SBrooks Davis {
122*b0d29bc4SBrooks Davis     ATF_ADD_TEST_CASE(tcs, error__no_filename);
123*b0d29bc4SBrooks Davis     ATF_ADD_TEST_CASE(tcs, error__with_filename);
124*b0d29bc4SBrooks Davis 
125*b0d29bc4SBrooks Davis     ATF_ADD_TEST_CASE(tcs, api_error__explicit);
126*b0d29bc4SBrooks Davis     ATF_ADD_TEST_CASE(tcs, api_error__from_database);
127*b0d29bc4SBrooks Davis 
128*b0d29bc4SBrooks Davis     ATF_ADD_TEST_CASE(tcs, invalid_column_error);
129*b0d29bc4SBrooks Davis }
130