db
Provides methods for working with Data Bases through ODBC.
Before using this module, make sure to install unixodbc:
  • Windows - Install Windows SDK
  • OS X - brew install unixodbc
  • Linux - sudo apt-get install unixodbc unixodbc-dev or sudo dnf install unixODBC unixODBC-devel

executeNonQuery

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

executeQuery

Executes SQL query and returns the result set.
Parameters:
Name
Type
Description
query
String
The query to execute.
Returns:
Object - The result set.

getScalar

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.

setConnectionString

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.
Last modified 3mo ago