Botan 3.9.0
Crypto and TLS for C&
database.h
Go to the documentation of this file.
1/*
2* SQL database interface
3* (C) 2014 Jack Lloyd
4*
5* Botan is released under the Simplified BSD License (see license.txt)
6*/
7
8#ifndef BOTAN_SQL_DATABASE_H_
9#define BOTAN_SQL_DATABASE_H_
10
11#include <botan/exceptn.h>
12#include <botan/types.h>
13#include <chrono>
14#include <memory>
15#include <string>
16#include <vector>
17
18namespace Botan {
19
20class BOTAN_PUBLIC_API(2, 0) SQL_Database /* NOLINT(*-special-member-functions) */ {
21 public:
22 class BOTAN_PUBLIC_API(2, 0) SQL_DB_Error final : public Exception {
23 public:
24 explicit SQL_DB_Error(std::string_view what) : Exception("SQL database", what), m_rc(0) {}
25
26 SQL_DB_Error(std::string_view what, int rc) : Exception("SQL database", what), m_rc(rc) {}
27
28 ErrorType error_type() const noexcept override { return ErrorType::DatabaseError; }
29
30 int error_code() const noexcept override { return m_rc; }
31
32 private:
33 int m_rc;
34 };
35
36 class BOTAN_PUBLIC_API(2, 0) Statement /* NOLINT(*-special-member-functions) */ {
37 public:
38 /* Bind statement parameters */
39 virtual void bind(int column, std::string_view str) = 0;
40
41 virtual void bind(int column, size_t i) = 0;
42
43 virtual void bind(int column, std::chrono::system_clock::time_point time) = 0;
44
45 virtual void bind(int column, const std::vector<uint8_t>& blob) = 0;
46
47 virtual void bind(int column, const uint8_t* data, size_t len) = 0;
48
49 /* Get output */
50 virtual std::pair<const uint8_t*, size_t> get_blob(int column) = 0;
51
52 virtual std::string get_str(int column) = 0;
53
54 virtual size_t get_size_t(int column) = 0;
55
56 /* Run to completion */
57 virtual size_t spin() = 0;
58
59 /* Maybe update */
60 virtual bool step() = 0;
61
62 virtual ~Statement() = default;
63 };
64
65 /*
66 * Create a new statement for execution.
67 * Use ?1, ?2, ?3, etc for parameters to set later with bind
68 */
69 virtual std::shared_ptr<Statement> new_statement(std::string_view base_sql) const = 0;
70
71 virtual size_t row_count(std::string_view table_name) = 0;
72
73 virtual void create_table(std::string_view table_schema) = 0;
74
75 virtual size_t rows_changed_by_last_statement() = 0;
76
77 virtual size_t exec(std::string_view sql) { return new_statement(sql)->spin(); }
78
79 virtual bool is_threadsafe() const { return false; }
80
81 virtual ~SQL_Database() = default;
82};
83
84} // namespace Botan
85
86#endif
#define BOTAN_PUBLIC_API(maj, min)
Definition api.h:21
const char * what() const noexcept override
Definition exceptn.h:93
Exception(std::string_view msg)
Definition exceptn.cpp:71
SQL_DB_Error(std::string_view what, int rc)
Definition database.h:26
ErrorType error_type() const noexcept override
Definition database.h:28
int error_code() const noexcept override
Definition database.h:30
SQL_DB_Error(std::string_view what)
Definition database.h:24
virtual ~Statement()=default
virtual std::pair< const uint8_t *, size_t > get_blob(int column)=0
virtual void bind(int column, size_t i)=0
virtual void bind(int column, std::chrono::system_clock::time_point time)=0
virtual void bind(int column, const uint8_t *data, size_t len)=0
virtual void bind(int column, const std::vector< uint8_t > &blob)=0
virtual void bind(int column, std::string_view str)=0
virtual std::string get_str(int column)=0
virtual size_t get_size_t(int column)=0
virtual std::shared_ptr< Statement > new_statement(std::string_view base_sql) const =0
virtual bool is_threadsafe() const
Definition database.h:79
virtual size_t exec(std::string_view sql)
Definition database.h:77
virtual size_t rows_changed_by_last_statement()=0
virtual void create_table(std::string_view table_schema)=0
virtual size_t row_count(std::string_view table_name)=0
virtual ~SQL_Database()=default
ErrorType
Definition exceptn.h:20