Public Member Functions#
_< ASqlQueryResult >	query (const AString &query, const AVector< AVariant > &params={})
	Execute a query with the result (SELECT).

int	execute (const AString &query, const AVector< AVariant > &params={})
	Execute a query with no result (UPDATE, INSERT, DELETE, etc.)

SqlDriverType	getDriverType ()
	the type of the driver. Required to correct queries in the database due to driver differences.

Static Public Member Functions#
static _< ASqlDatabase >	connect (const AString &driverName, const AString &address, uint16_t port=0, const AString &databaseName={}, const AString &username={}, const AString &password={})
	Connect to the database using the specified details and driver.

static void	registerDriver (_< ISqlDriver > driver)

Member Function Documentation#

◆ connect()#

static _< ASqlDatabase > ASqlDatabase::connect	(	const AString &	driverName,
		const AString &	address,
		uint16_t	port = 0,
		const AString &	databaseName = {},
		const AString &	username = {},
		const AString &	password = {} )

static

Parameters

driverName	name of the database driver. If the driver is not loaded, an attempt will be made to load the driver based on the template aui.DRIVERNAME (aui.DRIVERNAME.dll for Windows, libaui.DRIVERNAME.so for Linux, etc...). If the driver failed to load SQLException will be thrown.
address	server host (IP address or domain)
port	server port
databaseName	name of the database
username	user name; optional in some DBMS
password	user password; optional in some DBMS

Returns: object for communicating with the database; in some DBMS - optional

Exceptions

SQLException when any error occurs

int ASqlDatabase::execute	(	const AString &	query,
		const AVector< AVariant > &	params = {} )

Parameters

query	the SQL query
params	query arguments

Exceptions

SQLException if any error occurs

SqlDriverType ASqlDatabase::getDriverType ( )

_< ASqlQueryResult > ASqlDatabase::query	(	const AString &	query,
		const AVector< AVariant > &	params = {} )

Parameters

query	the SQL query
params	query arguments

Exceptions

SQLException when any error occurs

Contents