Botan::Sqlite3_Database Class Reference

#include <sqlite3.h>

Inheritance diagram for Botan::Sqlite3_Database:

Public Member Functions
void	create_table (const std::string &table_schema) override
std::shared_ptr< Statement >	new_statement (const std::string &sql) const override
size_t	row_count (const std::string &table_name) override
	Sqlite3_Database (const std::string &file)
	~Sqlite3_Database ()

Detailed Description

Definition at line 18 of file sqlite3.h.

Constructor & Destructor Documentation

Sqlite3_Database()

Botan::Sqlite3_Database::Sqlite3_Database

(

const std::string &

file

)

Definition at line 15 of file sqlite3.cpp.

   {
   int rc = ::sqlite3_open(db_filename.c_str(), &m_db);
 
   if(rc)
      {
      const std::string err_msg = ::sqlite3_errmsg(m_db);
      ::sqlite3_close(m_db);
      m_db = nullptr;
      throw SQL_DB_Error("sqlite3_open failed - " + err_msg);
      }
   }

~Sqlite3_Database()

Botan::Sqlite3_Database::~Sqlite3_Database

(

)

Definition at line 28 of file sqlite3.cpp.

   {
   if(m_db)
      ::sqlite3_close(m_db);
   m_db = nullptr;
   }

Member Function Documentation

create_table()

void Botan::Sqlite3_Database::create_table ( const std::string &  table_schema )

overridevirtual

Implements Botan::SQL_Database.

Definition at line 50 of file sqlite3.cpp.

   {
   char* errmsg = nullptr;
   int rc = ::sqlite3_exec(m_db, table_schema.c_str(), nullptr, nullptr, &errmsg);
 
   if(rc != SQLITE_OK)
      {
      const std::string err_msg = errmsg;
      ::sqlite3_free(errmsg);
      ::sqlite3_close(m_db);
      m_db = nullptr;
      throw SQL_DB_Error("sqlite3_exec for table failed - " + err_msg);
      }
   }

new_statement()

std::shared_ptr< SQL_Database::Statement > Botan::Sqlite3_Database::new_statement ( const std::string &  sql ) const

overridevirtual

Implements Botan::SQL_Database.

Definition at line 35 of file sqlite3.cpp.

   {
   return std::make_shared<Sqlite3_Statement>(m_db, base_sql);
   }

Referenced by row_count().

row_count()

size_t Botan::Sqlite3_Database::row_count ( const std::string &  table_name )

overridevirtual

Implements Botan::SQL_Database.

Definition at line 40 of file sqlite3.cpp.

   {
   auto stmt = new_statement("select count(*) from " + table_name);
 
   if(stmt->step())
      return stmt->get_size_t(0);
   else
      throw SQL_DB_Error("Querying size of table " + table_name + " failed");
   }

References new_statement().

---

The documentation for this class was generated from the following files:

• src/lib/utils/sqlite3/sqlite3.h
• src/lib/utils/sqlite3/sqlite3.cpp