aboutsummaryrefslogtreecommitdiffstats
path: root/src/utils/sqlite3/sqlite3.h
blob: aef04ab4dbb75f4d56b34d5c76d4c561470ca63d (plain)
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
/*
* SQLite wrapper
* (C) 2012 Jack Lloyd
*
* Released under the terms of the Botan license
*/

#ifndef BOTAN_UTILS_SQLITE_WRAPPER_H__
#define BOTAN_UTILS_SQLITE_WRAPPER_H__

#include <botan/types.h>
#include <string>
#include <chrono>
#include <vector>

class sqlite3;
class sqlite3_stmt;

namespace Botan {

class sqlite3_database
   {
   public:
      sqlite3_database(const std::string& file);

      ~sqlite3_database();

      size_t row_count(const std::string& table_name);

      void create_table(const std::string& table_schema);
   private:
      friend class sqlite3_statement;

      sqlite3* m_db;
   };

class sqlite3_statement
   {
   public:
      sqlite3_statement(sqlite3_database* db,
                        const std::string& base_sql);

      void bind(int column, const std::string& val);

      void bind(int column, int val);

      void bind(int column, std::chrono::system_clock::time_point time);

      void bind(int column, const std::vector<byte>& val);

      std::pair<const byte*, size_t> get_blob(int column);

      size_t get_size_t(int column);

      void spin();

      bool step();

      sqlite3_stmt* stmt() { return m_stmt; }

      ~sqlite3_statement();
   private:
      sqlite3_stmt* m_stmt;
   };

}

#endif