new SQLConnection()
Represents a connection to a SQL database
- Source:
Methods
-
close(handler)
-
Closes the connection. Important to always close the connection when you are done so it's returned to the pool.
Parameters:
Name Type Description handlerfunction the handler called when this operation completes. - Source:
-
commit(handler) → {SQLConnection}
-
Commits all changes made since the previous commit/rollback.
Parameters:
Name Type Description handlerfunction the handler called when this operation completes. - Source:
Returns:
- Type
- SQLConnection
-
execute(sql, resultHandler) → {SQLConnection}
-
Executes the given SQL statement
Parameters:
Name Type Description sqlstring the SQL to execute. For example CREATE TABLE IF EXISTS table ...resultHandlerfunction the handler which is called once this operation completes. - Source:
Returns:
- Type
- SQLConnection
-
query(sql, resultHandler) → {SQLConnection}
-
Executes the given SQL
SELECTstatement which returns the results of the query.Parameters:
Name Type Description sqlstring the SQL to execute. For example SELECT * FROM table ....resultHandlerfunction the handler which is called once the operation completes. It will return a ResultSet. - Source:
Returns:
- Type
- SQLConnection
-
queryWithParams(sql, params, resultHandler) → {SQLConnection}
-
Executes the given SQL
SELECTprepared statement which returns the results of the query.Parameters:
Name Type Description sqlstring the SQL to execute. For example SELECT * FROM table ....paramstodo these are the parameters to fill the statement. resultHandlerfunction the handler which is called once the operation completes. It will return a ResultSet. - Source:
Returns:
- Type
- SQLConnection
-
rollback(handler) → {SQLConnection}
-
Rolls back all changes made since the previous commit/rollback.
Parameters:
Name Type Description handlerfunction the handler called when this operation completes. - Source:
Returns:
- Type
- SQLConnection
-
setAutoCommit(autoCommit, resultHandler) → {SQLConnection}
-
Sets the auto commit flag for this connection. True by default.
Parameters:
Name Type Description autoCommitboolean the autoCommit flag, true by default. resultHandlerfunction the handler which is called once this operation completes. - Source:
Returns:
- Type
- SQLConnection
-
update(sql, resultHandler) → {SQLConnection}
-
Executes the given SQL statement which may be an
INSERT,UPDATE, orDELETEstatement.Parameters:
Name Type Description sqlstring the SQL to execute. For example INSERT INTO table ...resultHandlerfunction the handler which is called once the operation completes. - Source:
Returns:
- Type
- SQLConnection
-
updateWithParams(sql, params, resultHandler) → {SQLConnection}
-
Executes the given prepared statement which may be an
INSERT,UPDATE, orDELETEstatement with the given parametersParameters:
Name Type Description sqlstring the SQL to execute. For example INSERT INTO table ...paramstodo these are the parameters to fill the statement. resultHandlerfunction the handler which is called once the operation completes. - Source:
Returns:
- Type
- SQLConnection