Urho3D::DbConnection Class Reference

Database connection. More...

#include <Urho3D/Database/SQLite/SQLiteConnection.h>

Inheritance diagram for Urho3D::DbConnection:

Collaboration diagram for Urho3D::DbConnection:

Public Member Functions
	DbConnection (Context *context, const String &connectionString)
	Construct.
	~DbConnection ()
	Destruct.
void	Finalize ()
	Finalize all prepared statements, close all BLOB handles, and finish all sqlite3_backup objects.
DbResult	Execute (const String &sql, bool useCursorEvent=false)
	Execute an SQL statements immediately. Send E_DBCURSOR event for each row in the resultset when useCursorEvent parameter is set to true.
const String &	GetConnectionString () const
	Return database connection string. The connection string for SQLite3 is using the URI format described in https://www.sqlite.org/uri.html, while the connection string for ODBC is using DSN format as per ODBC standard.
const nanodbc::connection *	GetConnectionImpl () const
	Return the underlying implementation connection object pointer. It is sqlite* when using SQLite3 or nanodbc::connection* when using ODBC.
bool	IsConnected () const
	Return true when the connection object is connected to the associated database.
	DbConnection (Context *context, const String &connectionString)
	Construct.
	~DbConnection ()
	Destruct.
void	Finalize ()
	Finalize all prepared statements, close all BLOB handles, and finish all sqlite3_backup objects.
DbResult	Execute (const String &sql, bool useCursorEvent=false)
	Execute an SQL statements immediately. Send E_DBCURSOR event for each row in the resultset when useCursorEvent parameter is set to true.
const String &	GetConnectionString () const
	Return database connection string. The connection string for SQLite3 is using the URI format described in https://www.sqlite.org/uri.html, while the connection string for ODBC is using DSN format as per ODBC standard.
const sqlite3 *	GetConnectionImpl () const
	Return the underlying implementation connection object pointer. It is sqlite* when using SQLite3 or nanodbc::connection* when using ODBC.
bool	IsConnected () const
	Return true when the connection object is connected to the associated database.
Public Member Functions inherited from Urho3D::Object
	Object (Context *context)
	Construct.
virtual	~Object ()
	Destruct. Clean up self from event sender & receiver structures.
virtual StringHash	GetType () const =0
	Return type hash.
virtual const String &	GetTypeName () const =0
	Return type name.
virtual const TypeInfo *	GetTypeInfo () const =0
	Return type info.
virtual void	OnEvent (Object *sender, StringHash eventType, VariantMap &eventData)
	Handle event.
bool	IsInstanceOf (StringHash type) const
	Check current instance is type of specified type.
bool	IsInstanceOf (const TypeInfo *typeInfo) const
	Check current instance is type of specified type.
template<typename T >
bool	IsInstanceOf () const
	Check current instance is type of specified class.
void	SubscribeToEvent (StringHash eventType, EventHandler *handler)
	Subscribe to an event that can be sent by any sender.
void	SubscribeToEvent (Object *sender, StringHash eventType, EventHandler *handler)
	Subscribe to a specific sender's event.
void	UnsubscribeFromEvent (StringHash eventType)
	Unsubscribe from an event.
void	UnsubscribeFromEvent (Object *sender, StringHash eventType)
	Unsubscribe from a specific sender's event.
void	UnsubscribeFromEvents (Object *sender)
	Unsubscribe from a specific sender's events.
void	UnsubscribeFromAllEvents ()
	Unsubscribe from all events.
void	UnsubscribeFromAllEventsExcept (const PODVector< StringHash > &exceptions, bool onlyUserData)
	Unsubscribe from all events except those listed, and optionally only those with userdata (script registered events.)
void	SendEvent (StringHash eventType)
	Send event to all subscribers.
void	SendEvent (StringHash eventType, VariantMap &eventData)
	Send event with parameters to all subscribers. More...
VariantMap &	GetEventDataMap () const
	Return a preallocated map for event data. Used for optimization to avoid constant re-allocation of event data maps.
Context *	GetContext () const
	Return execution context.
const Variant &	GetGlobalVar (StringHash key) const
	Return global variable based on key.
const VariantMap &	GetGlobalVars () const
	Return all global variables.
void	SetGlobalVar (StringHash key, const Variant &value)
	Set global variable with the respective key and value.
Object *	GetSubsystem (StringHash type) const
	Return subsystem by type.
Object *	GetEventSender () const
	Return active event sender. Null outside event handling.
EventHandler *	GetEventHandler () const
	Return active event handler. Null outside event handling.
bool	HasSubscribedToEvent (StringHash eventType) const
	Return whether has subscribed to an event without specific sender.
bool	HasSubscribedToEvent (Object *sender, StringHash eventType) const
	Return whether has subscribed to a specific sender's event.
bool	HasEventHandlers () const
	Return whether has subscribed to any event.
template<class T >
T *	GetSubsystem () const
	Template version of returning a subsystem.
const String &	GetCategory () const
	Return object category. Categories are (optionally) registered along with the object factory. Return an empty string if the object category is not registered.
Public Member Functions inherited from Urho3D::RefCounted
	RefCounted ()
	Construct. Allocate the reference count structure and set an initial self weak reference.
virtual	~RefCounted ()
	Destruct. Mark as expired and also delete the reference count structure if no outside weak references exist.
void	AddRef ()
	Increment reference count. Can also be called outside of a SharedPtr for traditional reference counting.
void	ReleaseRef ()
	Decrement reference count and delete self if no more references. Can also be called outside of a SharedPtr for traditional reference counting.
int	Refs () const
	Return reference count.
int	WeakRefs () const
	Return weak reference count.
RefCount *	RefCountPtr ()
	Return pointer to the reference count structure.

Private Member Functions
	URHO3D_OBJECT (DbConnection, Object)
void	HandleRuntimeError (const char *message, const char *cause)
	Internal helper method to handle runtime exception by logging it to stderr stream.
	URHO3D_OBJECT (DbConnection, Object)

Private Attributes
String	connectionString_
	The connection string for SQLite3 is using the URI format described in https://www.sqlite.org/uri.html, while the connection string for ODBC is using DSN format as per ODBC standard.
nanodbc::connection	connectionImpl_
	The underlying implementation connection object.
sqlite3 *	connectionImpl_
	The underlying implementation connection object.

Additional Inherited Members
Static Public Member Functions inherited from Urho3D::Object
static const TypeInfo *	GetTypeInfoStatic ()
	Return type info static.
static bool	IsTypeOf (StringHash type)
	Check current type is type of specified type.
static bool	IsTypeOf (const TypeInfo *typeInfo)
	Check current type is type of specified type.
template<typename T >
static bool	IsTypeOf ()
	Check current type is type of specified class.
Protected Attributes inherited from Urho3D::Object
Context *	context_
	Execution context.

Detailed Description

Database connection.

---

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

• Source/Urho3D/Database/ODBC/ODBCConnection.h
• Source/Urho3D/Database/SQLite/SQLiteConnection.h
• Source/Urho3D/Database/ODBC/ODBCConnection.cpp
• Source/Urho3D/Database/SQLite/SQLiteConnection.cpp