qtsql Namespace Reference

Classes
class	CompositeTypeHelper
	Provides helper services for the management of SQL composite types. More...
class	DatabaseManager
	Provides threading and SQL logging control over QSqlDatabase. More...
class	DatabaseSettings
	Settings to connect to a database. Settings can be loaded and saved from/to a QSettings. More...
class	SqlQueryError
	Provides a std::runtime_error that can convey a QSqlError object. More...

Functions
QSqlQuery	execSqlCode (const QString &sqlCode, const QSqlDatabase &db)
	Execute SQL statements in code use databse connection db. More...
QSqlQuery	execSqlCodeInTransaction (const QString &sqlCode, QSqlDatabase db)
	Same as qtsql::execSqlCode() but execution performs inside a transaction. More...
void	throwIfError (const QSqlQuery &qry)
	Throw SqlQueryError if SQL query qry has error. More...

Function Documentation

QTTOOLS_SQL_EXPORT QSqlQuery qtsql::execSqlCode	(	const QString &	sqlCode,
		const QSqlDatabase &	db
	)

Execute SQL statements in code use databse connection db.

Note

Does nothing if sqlCode is empty

Exceptions

SqlQueryError

if no connection to database or if SQL exec fails (SQL query has error)

QTTOOLS_SQL_EXPORT QSqlQuery qtsql::execSqlCodeInTransaction	(	const QString &	sqlCode,
		QSqlDatabase	db
	)

Same as qtsql::execSqlCode() but execution performs inside a transaction.

Note

Any SqlQueryError exceptions thrown by qtsql::execSqlCode() is catched (transaction is rolled back then)

QTTOOLS_SQL_EXPORT void qtsql::throwIfError

(

const QSqlQuery &

qry

)

Throw SqlQueryError if SQL query qry has error.