sqlite3-statement.cpp
Go to the documentation of this file.
1 /* -*- Mode:C++; c-file-style:"gnu"; indent-tabs-mode:nil; -*- */
2 /*
3  * Copyright (c) 2013-2022 Regents of the University of California.
4  *
5  * This file is part of ndn-cxx library (NDN C++ library with eXperimental eXtensions).
6  *
7  * ndn-cxx library is free software: you can redistribute it and/or modify it under the
8  * terms of the GNU Lesser General Public License as published by the Free Software
9  * Foundation, either version 3 of the License, or (at your option) any later version.
10  *
11  * ndn-cxx library is distributed in the hope that it will be useful, but WITHOUT ANY
12  * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
13  * PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
14  *
15  * You should have received copies of the GNU General Public License and GNU Lesser
16  * General Public License along with ndn-cxx, e.g., in COPYING.md file. If not, see
17  * <http://www.gnu.org/licenses/>.
18  *
19  * See AUTHORS.md for complete list of ndn-cxx authors and contributors.
20  */
21 
23 
24 #include <sqlite3.h>
25 
26 namespace ndn {
27 namespace util {
28 
30 {
31  sqlite3_finalize(m_stmt);
32 }
33 
34 Sqlite3Statement::Sqlite3Statement(sqlite3* database, const std::string& statement)
35 {
36  int res = sqlite3_prepare_v2(database, statement.data(), -1, &m_stmt, nullptr);
37  if (res != SQLITE_OK)
38  NDN_THROW(std::domain_error("bad SQL statement: " + statement));
39 }
40 
41 int
42 Sqlite3Statement::bind(int index, const char* value, size_t size, void(*destructor)(void*))
43 {
44  return sqlite3_bind_text(m_stmt, index, value, size, destructor);
45 }
46 
47 int
48 Sqlite3Statement::bind(int index, const std::string& value, void(*destructor)(void*))
49 {
50  return sqlite3_bind_text(m_stmt, index, value.data(), value.size(), destructor);
51 }
52 
53 int
54 Sqlite3Statement::bind(int index, const void* buf, size_t size, void(*destructor)(void*))
55 {
56  return sqlite3_bind_blob(m_stmt, index, buf, size, destructor);
57 }
58 
59 int
60 Sqlite3Statement::bind(int index, const Block& block, void(*destructor)(void*))
61 {
62  return sqlite3_bind_blob(m_stmt, index, block.wire(), block.size(), destructor);
63 }
64 
65 int
66 Sqlite3Statement::bind(int index, int number)
67 {
68  return sqlite3_bind_int(m_stmt, index, number);
69 }
70 
71 std::string
73 {
74  return std::string(reinterpret_cast<const char*>(sqlite3_column_text(m_stmt, column)),
75  sqlite3_column_bytes(m_stmt, column));
76 }
77 
78 Block
80 {
81  return Block(make_span(reinterpret_cast<const uint8_t*>(sqlite3_column_blob(m_stmt, column)),
82  sqlite3_column_bytes(m_stmt, column)));
83 }
84 
85 int
87 {
88  return sqlite3_column_int(m_stmt, column);
89 }
90 
91 const uint8_t*
93 {
94  return static_cast<const uint8_t*>(sqlite3_column_blob(m_stmt, column));
95 }
96 
97 int
99 {
100  return sqlite3_column_bytes(m_stmt, column);
101 }
102 
103 int
105 {
106  return sqlite3_step(m_stmt);
107 }
108 
109 Sqlite3Statement::operator sqlite3_stmt*()
110 {
111  return m_stmt;
112 }
113 
114 } // namespace util
115 } // namespace ndn
Represents a TLV element of the NDN packet format.
Definition: block.hpp:45
const uint8_t * wire() const
Return a raw pointer to the beginning of the encoded wire.
Definition: block.cpp:296
size_t size() const
Return the size of the encoded wire, i.e.
Definition: block.cpp:305
Sqlite3Statement(sqlite3 *database, const std::string &statement)
initialize and prepare Sqlite3 statement
int bind(int index, const char *value, size_t size, void(*destructor)(void *))
bind a string to the statement
int getInt(int column)
get an integer from column.
const uint8_t * getBlob(int column)
get a pointer of byte blob from column.
Block getBlock(int column)
get a block from column.
~Sqlite3Statement()
finalize the statement
int getSize(int column)
get the size of column.
int step()
wrapper of sqlite3_step
std::string getString(int column)
get a string from column.
#define NDN_THROW(e)
Definition: exception.hpp:61
Definition: data.cpp:25