Botan 3.14.1
Crypto and TLS for C&
psk_db_sql.cpp
Go to the documentation of this file.
1/*
2* (C) 2017 Jack Lloyd
3*
4* Botan is released under the Simplified BSD License (see license.txt)
5*/
6
7#include <botan/psk_db.h>
8
9#include <botan/assert.h>
10#include <botan/database.h>
11
12namespace Botan {
13
15 std::shared_ptr<SQL_Database> db,
16 std::string_view table_name) :
17 Encrypted_PSK_Database(master_key), m_db(std::move(db)), m_table_name(table_name) {
18 using DB = SQL_Database;
19 BOTAN_ARG_CHECK(m_db != nullptr, "Database must not be null");
20 BOTAN_ARG_CHECK(m_db->is_valid_table_name(m_table_name), "Provided table name is not valid for this database");
21 m_db->create_table(DB::Table_Schema(m_table_name,
22 {
23 DB::Column("psk_name", DB::Column_Type::String).primary_key(),
24 DB::Column("psk_value", DB::Column_Type::String),
25 })
26 .if_not_exists());
27}
28
30
31void Encrypted_PSK_Database_SQL::kv_del(std::string_view name) {
32 const auto stmt = m_db->new_statement("delete from " + m_table_name + " where psk_name=?1");
33 stmt->bind(1, name);
34 stmt->spin();
35}
36
37void Encrypted_PSK_Database_SQL::kv_set(std::string_view name, std::string_view value) {
38 const auto stmt = m_db->upsert(m_table_name, {"psk_name", "psk_value"});
39
40 stmt->bind(1, name);
41 stmt->bind(2, value);
42
43 stmt->spin();
44}
45
46std::string Encrypted_PSK_Database_SQL::kv_get(std::string_view name) const {
47 const auto stmt = m_db->select("psk_value", m_table_name, "psk_name = ?1");
48
49 stmt->bind(1, name);
50
51 while(stmt->step()) {
52 return stmt->get_str(0).value_or("");
53 }
54 return "";
55}
56
57std::set<std::string> Encrypted_PSK_Database_SQL::kv_get_all() const {
58 std::set<std::string> names;
59
60 const auto stmt = m_db->select("psk_name", m_table_name);
61
62 while(stmt->step()) {
63 // A NULL name can only come from external modification of the table
64 if(auto name = stmt->get_str(0)) {
65 names.insert(std::move(*name));
66 }
67 }
68
69 return names;
70}
71
72} // namespace Botan
#define BOTAN_ARG_CHECK(expr, msg)
Definition assert.h:33
Encrypted_PSK_Database_SQL(const secure_vector< uint8_t > &master_key, std::shared_ptr< SQL_Database > db, std::string_view table_name)
BOTAN_FUTURE_EXPLICIT Encrypted_PSK_Database(const secure_vector< uint8_t > &master_key)
Definition psk_db.cpp:27
virtual std::set< std::string > kv_get_all() const =0
const char * name
Definition ffi_tls.h:59
std::vector< T, secure_allocator< T > > secure_vector
Definition secmem.h:128