Botan 3.0.0
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#include <botan/database.h>
9
10namespace Botan {
11
13 std::shared_ptr<SQL_Database> db,
14 std::string_view table_name) :
15 Encrypted_PSK_Database(master_key),
16 m_db(std::move(db)),
17 m_table_name(table_name)
18 {
19 m_db->create_table(
20 "create table if not exists " + m_table_name +
21 "(psk_name TEXT PRIMARY KEY, psk_value TEXT)");
22 }
23
25
26void Encrypted_PSK_Database_SQL::kv_del(std::string_view name)
27 {
28 auto stmt = m_db->new_statement("delete from " + m_table_name + " where psk_name=?1");
29 stmt->bind(1, name);
30 stmt->spin();
31 }
32
33void Encrypted_PSK_Database_SQL::kv_set(std::string_view name, std::string_view value)
34 {
35 auto stmt = m_db->new_statement("insert or replace into " + m_table_name + " values(?1, ?2)");
36
37 stmt->bind(1, name);
38 stmt->bind(2, value);
39
40 stmt->spin();
41 }
42
43std::string Encrypted_PSK_Database_SQL::kv_get(std::string_view name) const
44 {
45 auto stmt = m_db->new_statement("select psk_value from " + m_table_name +
46 " where psk_name = ?1");
47
48 stmt->bind(1, name);
49
50 while(stmt->step())
51 {
52 return stmt->get_str(0);
53 }
54 return "";
55 }
56
57std::set<std::string> Encrypted_PSK_Database_SQL::kv_get_all() const
58 {
59 std::set<std::string> names;
60
61 auto stmt = m_db->new_statement("select psk_name from " + m_table_name);
62
63 while(stmt->step())
64 {
65 names.insert(stmt->get_str(0));
66 }
67
68 return names;
69 }
70
71}
72
Encrypted_PSK_Database_SQL(const secure_vector< uint8_t > &master_key, std::shared_ptr< SQL_Database > db, std::string_view table_name)
Definition: psk_db_sql.cpp:12
std::string name
Definition: alg_id.cpp:12
std::vector< T, secure_allocator< T > > secure_vector
Definition: secmem.h:64
Definition: bigint.h:1092