shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 1 | /* -*- Mode:C++; c-file-style:"gnu"; indent-tabs-mode:nil; -*- */ |
| 2 | /** |
| 3 | * Copyright (c) 2014, Regents of the University of California. |
| 4 | * |
| 5 | * This file is part of NDNS (Named Data Networking Domain Name Service). |
| 6 | * See AUTHORS.md for complete list of NDNS authors and contributors. |
| 7 | * |
| 8 | * NDNS is free software: you can redistribute it and/or modify it under the terms |
| 9 | * of the GNU General Public License as published by the Free Software Foundation, |
| 10 | * either version 3 of the License, or (at your option) any later version. |
| 11 | * |
| 12 | * NDNS is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; |
| 13 | * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR |
| 14 | * PURPOSE. See the GNU General Public License for more details. |
| 15 | * |
| 16 | * You should have received a copy of the GNU General Public License along with |
| 17 | * NDNS, e.g., in COPYING.md file. If not, see <http://www.gnu.org/licenses/>. |
| 18 | */ |
| 19 | |
| 20 | #ifndef NDNS_DB_MGR_CPP |
| 21 | #define NDNS_DB_MGR_CPP |
| 22 | |
| 23 | #include <sqlite3.h> |
| 24 | #include <iostream> |
| 25 | |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 26 | namespace ndn { |
| 27 | namespace ndns { |
| 28 | |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 29 | class DBMgr |
| 30 | { |
| 31 | public: |
| 32 | enum m_status |
| 33 | { |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 34 | DBConnected, DBClosed, DBError |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 35 | }; |
| 36 | |
| 37 | public: |
| 38 | DBMgr(); |
| 39 | virtual ~DBMgr(); |
| 40 | |
| 41 | void open(); |
| 42 | void close(); |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 43 | void execute(std::string sql, int (*callback)(void*, int, char**, char**), |
| 44 | void * paras); |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 45 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 46 | inline void addResultNum() |
| 47 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 48 | m_resultNum += 1; |
| 49 | } |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 50 | inline void clearResultNum() |
| 51 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 52 | m_resultNum = 0; |
| 53 | } |
| 54 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 55 | const std::string& getDbfile() const |
| 56 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 57 | return m_dbfile; |
| 58 | } |
| 59 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 60 | void setDbfile(const std::string& dbfile) |
| 61 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 62 | this->m_dbfile = dbfile; |
| 63 | } |
| 64 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 65 | const std::string& getErr() const |
| 66 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 67 | return m_err; |
| 68 | } |
| 69 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 70 | void setErr(const std::string& err) |
| 71 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 72 | this->m_err = err; |
| 73 | } |
| 74 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 75 | int getReCode() const |
| 76 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 77 | return m_reCode; |
| 78 | } |
| 79 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 80 | void setReCode(int reCode) |
| 81 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 82 | this->m_reCode = reCode; |
| 83 | } |
| 84 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 85 | m_status getStatus() const |
| 86 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 87 | return m_status; |
| 88 | } |
| 89 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 90 | void setStatus(m_status status) |
| 91 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 92 | this->m_status = status; |
| 93 | } |
| 94 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 95 | int getResultNum() const |
| 96 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 97 | return m_resultNum; |
| 98 | } |
| 99 | |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 100 | void setResultNum(int resultNum) |
| 101 | { |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 102 | m_resultNum = resultNum; |
| 103 | } |
| 104 | |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 105 | private: |
| 106 | std::string m_dbfile; |
| 107 | sqlite3 *m_conn; |
| 108 | std::string m_err; |
| 109 | int m_reCode; |
| 110 | m_status m_status; |
| 111 | int m_resultNum; |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 112 | }; |
| 113 | //class DBMgr |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 114 | }//namespace ndns |
shockjiang | 99ad389 | 2014-08-03 14:56:13 -0700 | [diff] [blame^] | 115 | } //namespace ndn |
shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 116 | |
| 117 | #endif |