1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
/*
* Copyright (c) 2015 Samsung Electronics Co., Ltd All Rights Reserved
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/*
* @file sql_query.h
* @author Janusz Kozerski (j.kozerski@samsung.com)
* @version 1.0
* @brief This file is the implementation of SQL queries
*/
#include <list>
#include <string>
#include <cchecker/dpl/db/sql_connection.h>
#include <cchecker/app.h>
namespace CCHECKER {
namespace DB {
class SqlQuery {
public:
class Exception {
public: DECLARE_EXCEPTION_TYPE(CCHECKER::Exception, Base);
public: DECLARE_EXCEPTION_TYPE(Base, InternalError);
public: DECLARE_EXCEPTION_TYPE(Base, TransactionError);
public: DECLARE_EXCEPTION_TYPE(Base, InvalidArgs);
};
SqlQuery() :
m_connection(NULL),
m_inUserTransaction(false)
{};
explicit SqlQuery(const std::string &path);
virtual ~SqlQuery();
// Connecting outside the constructor
bool connect(const std::string& path);
// Apps
bool add_app_to_check_list(const app_t &app);
void remove_app_from_check_list(const app_t &app);
void mark_as_verified(const app_t &app, const app_t::verified_t &verified);
void get_app_list(std::list<app_t> &apps_buffer); // TODO: typedef std::list<app_t>
protected:
SqlConnection *m_connection;
private:
bool m_inUserTransaction;
int getDBVersion(void);
void get_apps(std::list<app_t> &apps_buffer);
bool check_if_app_exists(const app_t &app);
bool get_check_id(const app_t &app, int32_t &check_id);
bool add_chain_id(const int32_t check_id, int32_t &chain_id);
int verified_enum_to_int(const app_t::verified_t &verified);
app_t::verified_t verified_int_to_enum(const int &verified);
};
} // DB
} // CCHECKER
|