#include <Database.h>

Inheritance diagram for CDatabase:

Classes
struct	DatasetFieldInfo

class	DatasetLayout

class	ExistsSubQuery

class	Filter

Public Member Functions
	CDatabase ()

virtual	~CDatabase (void)

bool	IsOpen ()

virtual void	Close ()

bool	Compress (bool bForce=true)

void	Interrupt ()

bool	Open (const DatabaseSettings &db)

void	BeginTransaction ()

virtual bool	CommitTransaction ()

void	RollbackTransaction ()

void	CopyDB (const std::string &latestDb)

void	DropAnalytics ()

std::string	PrepareSQL (std::string strStmt,...) const

std::string	GetSingleValue (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) const
	Get a single value from a table.

std::string	GetSingleValue (const std::string &query) const

std::string	GetSingleValue (const std::string &query, const std::unique_ptr< dbiplus::Dataset > &ds) const
	Get a single value from a query on a dataset.

int	GetSingleValueInt (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) const
	Get a single integer value from a table.

int	GetSingleValueInt (const std::string &query) const

int	GetSingleValueInt (const std::string &query, const std::unique_ptr< dbiplus::Dataset > &ds) const
	Get a single integer value from a query on a dataset.

bool	DeleteValues (const std::string &strTable, const Filter &filter=Filter())
	Delete values from a table.

bool	ExecuteQuery (const std::string &strQuery)
	Execute a query that does not return any result. Note that if BeginMultipleExecute() has been called, the query will be queued until CommitMultipleExecute() is called.

bool	ResultQuery (const std::string &strQuery) const
	Execute a query that returns a result.

bool	BeginMultipleExecute ()
	Start a multiple execution queue. Any ExecuteQuery() function following this call will be queued rather than executed until CommitMultipleExecute() is performed. NOTE: Queries that rely on any queued execute query will not function as expected during this period!

bool	CommitMultipleExecute ()
	Commit the multiple execution queue to the database. Queries are performed within a transaction, and the transaction is rolled back should any one query fail.

bool	QueueInsertQuery (const std::string &strQuery)
	Put an INSERT or REPLACE query in the queue.

bool	CommitInsertQueries ()
	Commit all queries in the queue.

size_t	GetInsertQueriesCount ()
	Get the number of INSERT queries in the queue.

bool	QueueDeleteQuery (const std::string &strQuery)
	Put a DELETE query in the queue.

bool	CommitDeleteQueries ()
	Commit all queued DELETE queries.

size_t	GetDeleteQueriesCount ()
	Get the number of DELETE queries in the queue.

virtual bool	GetFilter (CDbUrl &dbUrl, Filter &filter, SortDescription &sorting)

virtual bool	BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl)

virtual bool	BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl, SortDescription &sorting)

bool	Connect (const std::string &dbName, const DatabaseSettings &db, bool create)

Protected Member Functions
void	Split (const std::string &strFileNameAndPath, std::string &strPath, std::string &strFileName)

virtual bool	Open ()

bool	CreateDatabase ()
	Create database tables and analytics as needed. Calls CreateTables() and CreateAnalytics() on child classes.

virtual void	CreateTables ()=0

virtual void	CreateAnalytics ()=0

virtual void	UpdateTables (int version)

virtual int	GetMinSchemaVersion () const

virtual int	GetSchemaVersion () const =0

virtual const char *	GetBaseDBName () const =0

int	GetDBVersion ()

bool	BuildSQL (const std::string &strQuery, const Filter &filter, std::string &strSQL) const

Protected Attributes
bool	m_sqlite
	whether we use sqlite (defaults to true)

std::unique_ptr< dbiplus::Database >	m_pDB

std::unique_ptr< dbiplus::Dataset >	m_pDS

std::unique_ptr< dbiplus::Dataset >	m_pDS2

const CProfileManager &	m_profileManager

Friends
class	CDatabaseManager

Constructor & Destructor Documentation

◆ CDatabase()

CDatabase::CDatabase ( )

◆ ~CDatabase()

CDatabase::~CDatabase ( void )

virtual

Member Function Documentation

◆ BeginMultipleExecute()

bool CDatabase::BeginMultipleExecute ( )

Start a multiple execution queue. Any ExecuteQuery() function following this call will be queued rather than executed until CommitMultipleExecute() is performed. NOTE: Queries that rely on any queued execute query will not function as expected during this period!

Returns: true if we could start a multiple execution queue, false otherwise.

See also: CommitMultipleExecute, ExecuteQuery

◆ BeginTransaction()

void CDatabase::BeginTransaction ( )

◆ BuildSQL() [1/3]

bool CDatabase::BuildSQL	(	const std::string &	strBaseDir,
		const std::string &	strQuery,
		Filter &	filter,
		std::string &	strSQL,
		CDbUrl &	dbUrl )

virtual

◆ BuildSQL() [2/3]

bool CDatabase::BuildSQL	(	const std::string &	strBaseDir,
		const std::string &	strQuery,
		Filter &	filter,
		std::string &	strSQL,
		CDbUrl &	dbUrl,
		SortDescription &	sorting )

virtual

◆ BuildSQL() [3/3]

bool CDatabase::BuildSQL	(	const std::string &	strQuery,
		const Filter &	filter,
		std::string &	strSQL ) const

protected

◆ Close()

void CDatabase::Close ( )

virtual

Reimplemented in PVR::CPVRDatabase, and PVR::CPVREpgDatabase.

◆ CommitDeleteQueries()

bool CDatabase::CommitDeleteQueries ( )

Commit all queued DELETE queries.

Returns: True if all queries were executed successfully, false otherwise.

◆ CommitInsertQueries()

bool CDatabase::CommitInsertQueries ( )

Commit all queries in the queue.

Returns: True if all queries were executed successfully, false otherwise.

◆ CommitMultipleExecute()

bool CDatabase::CommitMultipleExecute ( )

Commit the multiple execution queue to the database. Queries are performed within a transaction, and the transaction is rolled back should any one query fail.

Returns: True if the queries were executed successfully, false otherwise.

See also: BeginMultipleExecute, ExecuteQuery

◆ CommitTransaction()

bool CDatabase::CommitTransaction ( )

virtual

Reimplemented in CMusicDatabase, and CVideoDatabase.

◆ Compress()

bool CDatabase::Compress ( bool bForce = true )

◆ Connect()

bool CDatabase::Connect	(	const std::string &	dbName,
		const DatabaseSettings &	db,
		bool	create )

◆ CopyDB()

void CDatabase::CopyDB ( const std::string & latestDb )

◆ CreateAnalytics()

virtual void CDatabase::CreateAnalytics ( )

protectedpure virtual

Implemented in ADDON::CAddonDatabase, CMusicDatabase, CTextureDatabase, and CViewDatabase.

◆ CreateDatabase()

bool CDatabase::CreateDatabase ( )

protected

Create database tables and analytics as needed. Calls CreateTables() and CreateAnalytics() on child classes.

◆ CreateTables()

virtual void CDatabase::CreateTables ( )

protectedpure virtual

Implemented in ADDON::CAddonDatabase, CMusicDatabase, CTextureDatabase, and CViewDatabase.

◆ DeleteValues()

bool CDatabase::DeleteValues	(	const std::string &	strTable,
		const Filter &	filter = Filter() )

Delete values from a table.

Parameters

strTable	The table to delete the values from.
filter	The Filter to apply to this query.

Returns: True if the query was executed successfully, false otherwise.

◆ DropAnalytics()

void CDatabase::DropAnalytics ( )

◆ ExecuteQuery()

bool CDatabase::ExecuteQuery ( const std::string & strQuery )

Execute a query that does not return any result. Note that if BeginMultipleExecute() has been called, the query will be queued until CommitMultipleExecute() is called.

Parameters

strQuery The query to execute.

Returns: True if the query was executed successfully, false otherwise.

See also: BeginMultipleExecute, CommitMultipleExecute

◆ GetBaseDBName()

virtual const char * CDatabase::GetBaseDBName ( ) const

protectedpure virtual

Implemented in ADDON::CAddonDatabase, CMusicDatabase, CTextureDatabase, CViewDatabase, PVR::CPVRDatabase, and PVR::CPVREpgDatabase.

◆ GetDBVersion()

int CDatabase::GetDBVersion ( )

protected

◆ GetDeleteQueriesCount()

size_t CDatabase::GetDeleteQueriesCount ( )

Get the number of DELETE queries in the queue.

Returns: The number of queries.

◆ GetFilter()

virtual bool CDatabase::GetFilter	(	CDbUrl &	dbUrl,
		Filter &	filter,
		SortDescription &	sorting )

inlinevirtual

Reimplemented in CMusicDatabase, and CVideoDatabase.

◆ GetInsertQueriesCount()

size_t CDatabase::GetInsertQueriesCount ( )

Get the number of INSERT queries in the queue.

Returns: The number of queries.

◆ GetMinSchemaVersion()

virtual int CDatabase::GetMinSchemaVersion ( ) const

inlineprotectedvirtual

Reimplemented in ADDON::CAddonDatabase, and CMusicDatabase.

◆ GetSchemaVersion()

virtual int CDatabase::GetSchemaVersion ( ) const

protectedpure virtual

Implemented in ADDON::CAddonDatabase, CMusicDatabase, CTextureDatabase, CViewDatabase, PVR::CPVRDatabase, and PVR::CPVREpgDatabase.

◆ GetSingleValue() [1/3]

std::string CDatabase::GetSingleValue ( const std::string & query ) const

◆ GetSingleValue() [2/3]

std::string CDatabase::GetSingleValue	(	const std::string &	query,
		const std::unique_ptr< dbiplus::Dataset > &	ds ) const

Get a single value from a query on a dataset.

Parameters

query	the query in question.
ds	the dataset to use for the query.

Returns: the value from the query, empty on failure.

◆ GetSingleValue() [3/3]

std::string CDatabase::GetSingleValue	(	const std::string &	strTable,
		const std::string &	strColumn,
		const std::string &	strWhereClause = std::string(),
		const std::string &	strOrderBy = std::string() ) const

Get a single value from a table.

Remarks: The values of the strWhereClause and strOrderBy parameters have to be FormatSQL'ed when used.

Parameters

strTable	The table to get the value from.
strColumn	The column to get.
strWhereClause	If set, use this WHERE clause.
strOrderBy	If set, use this ORDER BY clause.

Returns: The requested value or an empty string if it wasn't found.

◆ GetSingleValueInt() [1/3]

int CDatabase::GetSingleValueInt ( const std::string & query ) const

◆ GetSingleValueInt() [2/3]

int CDatabase::GetSingleValueInt	(	const std::string &	query,
		const std::unique_ptr< dbiplus::Dataset > &	ds ) const

Get a single integer value from a query on a dataset.

Parameters

query	the query in question.
ds	the dataset to use for the query.

Returns: the value from the query, 0 on failure.

◆ GetSingleValueInt() [3/3]

int CDatabase::GetSingleValueInt	(	const std::string &	strTable,
		const std::string &	strColumn,
		const std::string &	strWhereClause = std::string(),
		const std::string &	strOrderBy = std::string() ) const

Get a single integer value from a table.

Remarks: The values of the strWhereClause and strOrderBy parameters have to be FormatSQL'ed when used.

Parameters

strTable	The table to get the value from.
strColumn	The column to get.
strWhereClause	If set, use this WHERE clause.
strOrderBy	If set, use this ORDER BY clause.

Returns: The requested value or 0 if it wasn't found.

◆ Interrupt()

void CDatabase::Interrupt ( )

◆ IsOpen()

bool CDatabase::IsOpen ( )

◆ Open() [1/2]

bool CDatabase::Open ( )

protectedvirtual

Reimplemented in ADDON::CAddonDatabase, CMusicDatabase, CTextureDatabase, CVideoDatabase, CViewDatabase, PVR::CPVRDatabase, and PVR::CPVREpgDatabase.

◆ Open() [2/2]

bool CDatabase::Open ( const DatabaseSettings & db )

◆ PrepareSQL()

std::string CDatabase::PrepareSQL	(	std::string	strStmt,
			... ) const

◆ QueueDeleteQuery()

bool CDatabase::QueueDeleteQuery ( const std::string & strQuery )

Put a DELETE query in the queue.

Parameters

strQuery The query to queue.

Returns: True if the query was added successfully, false otherwise.

◆ QueueInsertQuery()

bool CDatabase::QueueInsertQuery ( const std::string & strQuery )

Put an INSERT or REPLACE query in the queue.

Parameters

strQuery The query to queue.

Returns: True if the query was added successfully, false otherwise.

◆ ResultQuery()

bool CDatabase::ResultQuery ( const std::string & strQuery ) const

Execute a query that returns a result.

Remarks: Call m_pDS->close(); to clean up the dataset when done.

Parameters

strQuery The query to execute.

Returns: True if the query was executed successfully, false otherwise.

◆ RollbackTransaction()

void CDatabase::RollbackTransaction ( )

◆ Split()

void CDatabase::Split	(	const std::string &	strFileNameAndPath,
		std::string &	strPath,
		std::string &	strFileName )

protected

◆ UpdateTables()

virtual void CDatabase::UpdateTables ( int version )

inlineprotectedvirtual

Reimplemented in ADDON::CAddonDatabase, CTextureDatabase, and CViewDatabase.

Friends And Related Symbol Documentation

◆ CDatabaseManager

friend class CDatabaseManager

friend

Member Data Documentation

◆ m_pDB

std::unique_ptr<dbiplus::Database> CDatabase::m_pDB

protected

◆ m_pDS

std::unique_ptr<dbiplus::Dataset> CDatabase::m_pDS

protected

◆ m_pDS2

std::unique_ptr<dbiplus::Dataset> CDatabase::m_pDS2

protected

◆ m_profileManager

const CProfileManager& CDatabase::m_profileManager

protected

◆ m_sqlite

bool CDatabase::m_sqlite

protected

whether we use sqlite (defaults to true)

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

Classes

Public Member Functions

Protected Member Functions

Protected Attributes

Friends

Constructor & Destructor Documentation

◆ CDatabase()

◆ ~CDatabase()

Member Function Documentation

◆ BeginMultipleExecute()

◆ BeginTransaction()

◆ BuildSQL() [1/3]

◆ BuildSQL() [2/3]

◆ BuildSQL() [3/3]

◆ Close()

◆ CommitDeleteQueries()

◆ CommitInsertQueries()

◆ CommitMultipleExecute()

◆ CommitTransaction()

◆ Compress()

◆ Connect()

◆ CopyDB()

◆ CreateAnalytics()

◆ CreateDatabase()

◆ CreateTables()

◆ DeleteValues()

◆ DropAnalytics()

◆ ExecuteQuery()

◆ GetBaseDBName()

◆ GetDBVersion()

◆ GetDeleteQueriesCount()

◆ GetFilter()

◆ GetInsertQueriesCount()

◆ GetMinSchemaVersion()

◆ GetSchemaVersion()

◆ GetSingleValue() [1/3]

◆ GetSingleValue() [2/3]

◆ GetSingleValue() [3/3]

◆ GetSingleValueInt() [1/3]

◆ GetSingleValueInt() [2/3]

◆ GetSingleValueInt() [3/3]

◆ Interrupt()

◆ IsOpen()

◆ Open() [1/2]

◆ Open() [2/2]

◆ PrepareSQL()

◆ QueueDeleteQuery()

◆ QueueInsertQuery()

◆ ResultQuery()

◆ RollbackTransaction()

◆ Split()

◆ UpdateTables()

Friends And Related Symbol Documentation

◆ CDatabaseManager

Member Data Documentation

◆ m_pDB

◆ m_pDS

◆ m_pDS2

◆ m_profileManager

◆ m_sqlite