7#include <botan/psk_db.h>
8#include <botan/database.h>
13 std::shared_ptr<SQL_Database> db,
14 const std::string& table_name) :
17 m_table_name(table_name)
20 "create table if not exists " + m_table_name +
21 "(psk_name TEXT PRIMARY KEY, psk_value TEXT)");
29void Encrypted_PSK_Database_SQL::kv_del(
const std::string&
name)
31 auto stmt = m_db->new_statement(
"delete from " + m_table_name +
" where psk_name=?1");
36void Encrypted_PSK_Database_SQL::kv_set(
const std::string&
name,
const std::string& value)
38 auto stmt = m_db->new_statement(
"insert or replace into " + m_table_name +
" values(?1, ?2)");
46std::string Encrypted_PSK_Database_SQL::kv_get(
const std::string&
name)
const
48 auto stmt = m_db->new_statement(
"select psk_value from " + m_table_name +
49 " where psk_name = ?1");
55 return stmt->get_str(0);
60std::set<std::string> Encrypted_PSK_Database_SQL::kv_get_all()
const
62 std::set<std::string> names;
64 auto stmt = m_db->new_statement(
"select psk_name from " + m_table_name);
68 names.insert(stmt->get_str(0));
~Encrypted_PSK_Database_SQL()
Encrypted_PSK_Database_SQL(const secure_vector< uint8_t > &master_key, std::shared_ptr< SQL_Database > db, const std::string &table_name)
std::vector< T, secure_allocator< T > > secure_vector