SqliteDriver

#include <SqliteDriver.h>

Inheritance diagram for SqliteDriver:

[legend]

Public Member Functions
	SqliteDriver (QObject *parent, const QVariantList &args)

KDbEscapedString	ceilingOrFloorFunctionToString (const QString &name, const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const override

KDbEscapedString	collationSql () const override

KDbEscapedString	escapeBLOB (const QByteArray &array) const override

KDbEscapedString	escapeString (const QByteArray &str) const override

KDbEscapedString	escapeString (const QString &str) const override

KDbEscapedString	greatestOrLeastFunctionToString (const QString &name, const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const override

bool	isSystemDatabaseName (const QString &) const override

bool	isSystemObjectName (const QString &n) const override

KDbEscapedString	randomFunctionToString (const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const override

Public Member Functions inherited from KDbDriver
	~KDbDriver () override

KDbAdminTools &	adminTools () const

KDbEscapedString	concatenateFunctionToString (const KDbBinaryExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const

const QSet< KDbConnection * >	connections () const

KDbConnection *	createConnection (const KDbConnectionData &connData)

KDbConnection *	createConnection (const KDbConnectionData &connData, const KDbConnectionOptions &options)

virtual KDB_DEPRECATED KDbEscapedString	dateTimeToSql (const QDateTime &v) const

virtual KDbEscapedString	dateTimeToSql (const QVariant &v) const

virtual KDbEscapedString	dateToSql (const QVariant &v) const

QByteArray	escapeIdentifier (const QByteArray &str) const

QString	escapeIdentifier (const QString &str) const

int	features () const

virtual KDbEscapedString	hexFunctionToString (const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const

virtual KDbEscapedString	ifnullFunctionToString (const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const

KDbUtils::Property	internalProperty (const QByteArray &name) const

QList< QByteArray >	internalPropertyNames () const

bool	isDriverSpecificKeyword (const QByteArray &word) const

bool	isSystemFieldName (const QString &name) const

virtual KDbEscapedString	lengthFunctionToString (const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const

const KDbDriverMetaData *	metaData () const

virtual QString	sqlTypeName (KDbField::Type type, const KDbField &field) const

virtual KDbEscapedString	timeToSql (const QVariant &v) const

bool	transactionsSupported () const

virtual KDbEscapedString	unicodeFunctionToString (const KDbNArgExpression &args, KDbQuerySchemaParameterValueListIterator params, KDb::ExpressionCallStack callStack) const

KDbEscapedString	valueToSql (const KDbField *field, const QVariant &v) const

KDbEscapedString	valueToSql (const QString &ftype, const QVariant &v) const

virtual KDbEscapedString	valueToSql (KDbField::Type ftype, const QVariant &v) const

Public Member Functions inherited from QObject
	QObject (QObject *parent)

QBindable< QString >	bindableObjectName ()

bool	blockSignals (bool block)

const QObjectList &	children () const const

QMetaObject::Connection	connect (const QObject sender, const char signal, const char *method, Qt::ConnectionType type) const const

void	deleteLater ()

void	destroyed (QObject *obj)

bool	disconnect (const char signal, const QObject receiver, const char *method) const const

bool	disconnect (const QObject receiver, const char method) const const

void	dumpObjectInfo () const const

void	dumpObjectTree () const const

QList< QByteArray >	dynamicPropertyNames () const const

virtual bool	event (QEvent *e)

virtual bool	eventFilter (QObject watched, QEvent event)

T	findChild (const QString &name, Qt::FindChildOptions options) const const

QList< T >	findChildren (const QRegularExpression &re, Qt::FindChildOptions options) const const

QList< T >	findChildren (const QString &name, Qt::FindChildOptions options) const const

QList< T >	findChildren (Qt::FindChildOptions options) const const

bool	inherits (const char *className) const const

void	installEventFilter (QObject *filterObj)

bool	isQuickItemType () const const

bool	isWidgetType () const const

bool	isWindowType () const const

void	killTimer (int id)

virtual const QMetaObject *	metaObject () const const

void	moveToThread (QThread *targetThread)

QString	objectName () const const

void	objectNameChanged (const QString &objectName)

QObject *	parent () const const

QVariant	property (const char *name) const const

	Q_CLASSINFO (Name, Value)

	Q_EMIT Q_EMIT

	Q_ENUM (...)

	Q_ENUM_NS (...)

	Q_ENUMS (...)

	Q_FLAG (...)

	Q_FLAG_NS (...)

	Q_FLAGS (...)

	Q_GADGET Q_GADGET

	Q_GADGET_EXPORT (EXPORT_MACRO)

	Q_INTERFACES (...)

	Q_INVOKABLE Q_INVOKABLE

	Q_MOC_INCLUDE Q_MOC_INCLUDE

	Q_NAMESPACE Q_NAMESPACE

	Q_NAMESPACE_EXPORT (EXPORT_MACRO)

	Q_OBJECT Q_OBJECT

	Q_PROPERTY (...)

	Q_REVISION Q_REVISION

	Q_SET_OBJECT_NAME (Object)

	Q_SIGNAL Q_SIGNAL

	Q_SIGNALS Q_SIGNALS

	Q_SLOT Q_SLOT

	Q_SLOTS Q_SLOTS

T	qobject_cast (const QObject *object)

T	qobject_cast (QObject *object)

	QT_NO_NARROWING_CONVERSIONS_IN_CONNECT QT_NO_NARROWING_CONVERSIONS_IN_CONNECT

void	removeEventFilter (QObject *obj)

void	setObjectName (const QString &name)

void	setObjectName (QAnyStringView name)

void	setParent (QObject *parent)

bool	setProperty (const char *name, const QVariant &value)

bool	setProperty (const char *name, QVariant &&value)

bool	signalsBlocked () const const

int	startTimer (int interval, Qt::TimerType timerType)

int	startTimer (std::chrono::milliseconds interval, Qt::TimerType timerType)

QThread *	thread () const const

Public Member Functions inherited from KDbResultable
	KDbResultable (const KDbResultable &other)

void	clearResult ()

KDbMessageHandler *	messageHandler () const

KDbResultable &	operator= (const KDbResultable &other)

KDbResult	result () const

virtual QString	serverResultName () const

void	setMessageHandler (KDbMessageHandler *handler)

void	showMessage ()

Protected Member Functions
KDbAdminTools *	drv_createAdminTools () const override

KDbConnection *	drv_createConnection (const KDbConnectionData &connData, const KDbConnectionOptions &options) override

QByteArray	drv_escapeIdentifier (const QByteArray &str) const override

QString	drv_escapeIdentifier (const QString &str) const override

bool	drv_isSystemFieldName (const QString &n) const override

Protected Member Functions inherited from KDbDriver
	KDbDriver (QObject *parent, const QVariantList &args)

virtual KDbEscapedString	addLimitTo1 (const KDbEscapedString &sql, bool add=true)

KDbDriverBehavior *	behavior ()

const KDbDriverBehavior *	behavior () const

void	initDriverSpecificKeywords (const char const keywords)

virtual bool	isValid ()

KDbConnection *	removeConnection (KDbConnection *conn)

void	setMetaData (const KDbDriverMetaData *metaData)

virtual bool	supportsDefaultValue (const KDbField &field) const

Protected Member Functions inherited from QObject
virtual void	childEvent (QChildEvent *event)

virtual void	connectNotify (const QMetaMethod &signal)

virtual void	customEvent (QEvent *event)

virtual void	disconnectNotify (const QMetaMethod &signal)

bool	isSignalConnected (const QMetaMethod &signal) const const

int	receivers (const char *signal) const const

QObject *	sender () const const

int	senderSignalIndex () const const

virtual void	timerEvent (QTimerEvent *event)

Protected Attributes
SqliteDriverPrivate *const	dp

Protected Attributes inherited from KDbDriver
KDbDriverPrivate *const	d

Protected Attributes inherited from KDbResultable
Private *const	d

KDbResult	m_result

Additional Inherited Members
Public Types inherited from KDbDriver
enum	Features { NoFeatures = 0 , SingleTransactions = 1 , MultipleTransactions = 2 , NestedTransactions = 4 , CursorForward = 8 , CursorBackward = (CursorForward + 16) , CompactingDatabaseSupported = 32 , IgnoreTransactions = 1024 }

Public Types inherited from QObject
typedef	QObjectList

Properties inherited from QObject
	objectName

Static Public Member Functions inherited from KDbDriver
static QString	defaultSqlTypeName (KDbField::Type type)

static bool	isKDbSystemObjectName (const QString &name)

Static Public Member Functions inherited from QObject
QMetaObject::Connection	connect (const QObject sender, const char signal, const QObject receiver, const char method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject sender, const QMetaMethod &signal, const QObject receiver, const QMetaMethod &method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject sender, PointerToMemberFunction signal, const QObject context, Functor functor, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject sender, PointerToMemberFunction signal, const QObject receiver, PointerToMemberFunction method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject *sender, PointerToMemberFunction signal, Functor functor)

bool	disconnect (const QMetaObject::Connection &connection)

bool	disconnect (const QObject sender, const char signal, const QObject receiver, const char method)

bool	disconnect (const QObject sender, const QMetaMethod &signal, const QObject receiver, const QMetaMethod &method)

bool	disconnect (const QObject sender, PointerToMemberFunction signal, const QObject receiver, PointerToMemberFunction method)

QString	tr (const char sourceText, const char disambiguation, int n)

Detailed Description

SQLite database driver.

Definition at line 29 of file SqliteDriver.h.

Constructor & Destructor Documentation

◆ SqliteDriver()

SqliteDriver::SqliteDriver	(	QObject *	parent,
		const QVariantList &	args )

Definition at line 50 of file SqliteDriver.cpp.

◆ ~SqliteDriver()

SqliteDriver::~SqliteDriver ( )

override

Definition at line 96 of file SqliteDriver.cpp.

Member Function Documentation

◆ ceilingOrFloorFunctionToString()

KDbEscapedString SqliteDriver::ceilingOrFloorFunctionToString	(	const QString &	name,
		const KDbNArgExpression &	args,
		KDbQuerySchemaParameterValueListIterator *	params,
		KDb::ExpressionCallStack *	callStack ) const

overridevirtual

Generates native (driver-specific) CEILING() and FLOOR() function calls.

Default implementation USES CEILING() and FLOOR(), respectively. For CEILING() uses: (CASE WHEN X = CAST(X AS INT) THEN CAST(X AS INT) WHEN X >= 0 THEN CAST(X AS INT) + 1 ELSE CAST(X AS INT) END). For FLOOR() uses: (CASE WHEN X >= 0 OR X = CAST(X AS INT) THEN CAST(X AS INT) ELSE CAST(X AS INT) - 1 END).

Reimplemented from KDbDriver.

Definition at line 205 of file SqliteDriver.cpp.

◆ collationSql()

KDbEscapedString SqliteDriver::collationSql ( ) const

overridevirtual

Implemented for KDbDriver class.

Returns: SQL clause to add for unicode text collation sequence used in ORDER BY clauses of SQL statements generated by KDb. Later other clauses may use this statement. One space character should be be prepended. Can be reimplemented for other drivers, e.g. the SQLite3 driver returns " COLLATE ''". Default implementation returns empty string.

Reimplemented from KDbDriver.

Definition at line 157 of file SqliteDriver.cpp.

◆ drv_createAdminTools()

KDbAdminTools * SqliteDriver::drv_createAdminTools ( ) const

overrideprotectedvirtual

Creates admin tools object providing a number of database administration tools for the driver. This is called once per driver.

Note for driver developers: Reimplement this method by returning a KDbAdminTools-derived object. Default implementation creates anmd returns an empty admin tools KDbAdminTools object.

See also: adminTools()

Reimplemented from KDbDriver.

Definition at line 152 of file SqliteDriver.cpp.

◆ drv_createConnection()

KDbConnection * SqliteDriver::drv_createConnection	(	const KDbConnectionData &	connData,
		const KDbConnectionOptions &	options )

overrideprotectedvirtual

For reimplementation: creates and returns connection object with additional structures specific for a given driver. KDbConnection object should inherit KDbConnection and have a destructor that descructs all allocated driver-dependent connection structures.

Implements KDbDriver.

Definition at line 103 of file SqliteDriver.cpp.

◆ drv_escapeIdentifier() [1/2]

QByteArray SqliteDriver::drv_escapeIdentifier ( const QByteArray & str ) const

overrideprotectedvirtual

This is overloaded version of drv_escapeIdentifier( const QString& str ) to be implemented in the same way.

Implements KDbDriver.

Definition at line 147 of file SqliteDriver.cpp.

◆ drv_escapeIdentifier() [2/2]

QString SqliteDriver::drv_escapeIdentifier ( const QString & str ) const

overrideprotectedvirtual

Driver-specific SQL string escaping. This method is used by escapeIdentifier(). Implement escaping for any character like " or ' as your database engine requires. Do not append or prepend any quotation marks characters - it is automatically done by escapeIdentifier() using KDbDriverBehavior::OPENING_QUOTATION_MARK_BEGIN_FOR_IDENTIFIER and KDbDriverBehavior::CLOSING_QUOTATION_MARK_BEGIN_FOR_IDENTIFIER.

Implements KDbDriver.

Definition at line 142 of file SqliteDriver.cpp.

◆ drv_isSystemFieldName()

bool SqliteDriver::drv_isSystemFieldName ( const QString & n ) const

overrideprotectedvirtual

Returns: true if n is a system field name; for this driver fields with name equal "_ROWID_" is considered as system field.

Implements KDbDriver.

Definition at line 120 of file SqliteDriver.cpp.

◆ escapeBLOB()

KDbEscapedString SqliteDriver::escapeBLOB ( const QByteArray & array ) const

overridevirtual

Escape BLOB value array.

Implements KDbDriver.

Definition at line 137 of file SqliteDriver.cpp.

◆ escapeString() [1/2]

KDbEscapedString SqliteDriver::escapeString ( const QByteArray & str ) const

overridevirtual

This is overloaded version of escapeString( const QString& str ) to be implemented in the same way.

Implements KDbDriver.

Definition at line 132 of file SqliteDriver.cpp.

◆ escapeString() [2/2]

KDbEscapedString SqliteDriver::escapeString ( const QString & str ) const

overridevirtual

Escape a string for use as a value.

Implements KDbDriver.

Definition at line 127 of file SqliteDriver.cpp.

◆ greatestOrLeastFunctionToString()

KDbEscapedString SqliteDriver::greatestOrLeastFunctionToString	(	const QString &	name,
		const KDbNArgExpression &	args,
		KDbQuerySchemaParameterValueListIterator *	params,
		KDb::ExpressionCallStack *	callStack ) const

overridevirtual

Generates native (driver-specific) GREATEST() and LEAST() function calls.

Uses MAX() and MIN(), respectively. If arguments are of text type, to each argument default (unicode) collation is assigned that is configured for SQLite by KDb. Example: SELECT MAX('ą' COLLATE '', 'z' COLLATE '').

Reimplemented from KDbDriver.

Definition at line 162 of file SqliteDriver.cpp.

◆ isSystemDatabaseName()

bool SqliteDriver::isSystemDatabaseName ( const QString & name ) const

overridevirtual

Returns: false for this driver.

Implements KDbDriver.

Definition at line 114 of file SqliteDriver.cpp.

◆ isSystemObjectName()

bool SqliteDriver::isSystemObjectName ( const QString & n ) const

overridevirtual

Returns: true if n is a system object name; for this driver any object with name prefixed with "sqlite_" is considered as system object.

Implements KDbDriver.

Definition at line 109 of file SqliteDriver.cpp.

◆ randomFunctionToString()

KDbEscapedString SqliteDriver::randomFunctionToString	(	const KDbNArgExpression &	args,
		KDbQuerySchemaParameterValueListIterator *	params,
		KDb::ExpressionCallStack *	callStack ) const

overridevirtual

Generates native (driver-specific) RANDOM() and RANDOM(X,Y) function calls.

Accepted args can contain zero or two positive integer arguments X, Y; X < Y. In case of numeric arguments, RANDOM(X, Y) returns a random integer that is equal or greater than X and less than Y. Because SQLite returns integer between -9223372036854775808 and +9223372036854775807, RANDOM() for SQLite is equal to (RANDOM()+9223372036854775807)/18446744073709551615. Similarly, RANDOM(X,Y) for SQLite is equal to (X + CAST((Y-X) * (RANDOM()+9223372036854775807)/18446744073709551615 AS INT)).

(X + CAST((Y - X) * (RANDOM()+9223372036854775807)/18446744073709551615 AS INT)).

Reimplemented from KDbDriver.

Definition at line 187 of file SqliteDriver.cpp.

Member Data Documentation

◆ dp

SqliteDriverPrivate* const SqliteDriver::dp

protected

Definition at line 107 of file SqliteDriver.h.

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

KDE's Doxygen guidelines are available online.

Class Picker

Quick Links

About KDb

SqliteDriver

Public Member Functions

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ SqliteDriver()

◆ ~SqliteDriver()

Member Function Documentation

◆ ceilingOrFloorFunctionToString()

◆ collationSql()

◆ drv_createAdminTools()

◆ drv_createConnection()

◆ drv_escapeIdentifier() [1/2]

◆ drv_escapeIdentifier() [2/2]

◆ drv_isSystemFieldName()

◆ escapeBLOB()

◆ escapeString() [1/2]

◆ escapeString() [2/2]

◆ greatestOrLeastFunctionToString()

◆ isSystemDatabaseName()

◆ isSystemObjectName()

◆ randomFunctionToString()

Member Data Documentation

◆ dp