db

Provides methods for working with Data Bases through ODBC.

Methods

setConnectionString(connString)

Sets DB connection string to be used by other methods.

This method doesn't actually open the connection as it's opened/closed automatically by query methods.
Example connection strings:
  • Driver={MySQL ODBC 5.3 UNICODE Driver};Server=localhost; Database=myDatabase;User=myUsername;Password=myPassword;Option=3;
  • Driver={Oracle in instantclient_11_2};dbq=127.0.0.1:1521/XE; uid=myUsername;pwd=myPassword;
Parameters:
Name Type Description
connString String ODBC connection string.

getScalar(query)→ {Object}

Executes SQL query and returns the first column of the first row in the result set.
Parameters:
Name Type Description
query String The query to execute.
Returns:
Object - The first column of the first row in the result set, or null if the result set is empty.

executeNonQuery(query)

Executes SQL statement.

Any results from the query are discarded.
Parameters:
Name Type Description
query String The query to execute.