Sql

This object allows you to establish a connection to a SQL database like MySQL, PostgreSQL, SQLite and others.

Constructor function.

var myObject = new Sql(driver);

1. driver - (Driver) the database driver to use

• (NoDatabaseDriverError) no database driver specified

Create a Sql object operating on a MySQL database.

var myObject = new Sql(Sql.MySQL);

On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default. To see all available drivers call the drivers function.

Returns a list of available Drivers.

Sql.drivers();

Opens a connection with a database.

myObject.connect(parameters);

1. parameters - (object) the connection parameters
   • hostName - (string) the host name
   • port - (integer) the port to use (use the default port if not specified)
   • databaseName - (string) the database name (when using SQLite this is the filename of the database)
   • userName - (string) the user name
   • password - (string) the password
   • options - (string) connection options (see http://doc.qt.nokia.com/latest/qsqldatabase.html#setConnectOptions)

• (Sql) this Sql

• (DatabaseDriverUnavailableError) this driver is not available
• (ConnectionError) connection failed

Prepare a request on the current database.

myObject.prepare(queryString, parameters);

1. queryString - (string) the query string to prepare
2. parameters - (object) the prepare parameters

• (Sql) this Sql

• (PrepareQueryError) unable to prepare the query

myObject.prepare("INSERT INTO myTable (id, data) VALUES(:id, :data)", {
	id: 1,
	data: "My data"
});

Execute a prepared request or executes a request on the current database.

myObject.execute(queryString);

myObject.execute();

1. queryString - (string) the query string to execute

• (Sql) this Sql

• (ExecuteQueryError) failed to execute the query

Retrieves the result of an executed request.

myObject.fetchResult(indexStyle);

myObject.fetchResult();

1. indexStyle - (IndexStyle) the fetch index style

• (Sql) this Sql

• (FetchError) cannot fetch the result of a non-select query

Disconnects the current database connection.

myObject.disconnect();

• (Sql) this Sql

SQL drivers. On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.

1. SQLite2: SQLite 2
2. SQLite: SQLite 3
3. PostgreSQL: PostgreSQL (versions 7.3 and above)
4. MySQL: MySQL
5. ODBC: Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases
6. InterBase: Borland InterBase (Firebird)
7. OCI: Oracle Call Interface Driver
8. TDS: Sybase Adaptive Server (obsolete)
9. DB2: IBM DB2 (version 7.1 and above)

The fetch index style.

1. IndexNumber: indexes the results by number
2. IndexName: indexes the results by column name