Make calls to SQL databases - currently MSSQL is supported.
Connects to an SQL database. Returns an sql object that can be used to query the DB, and throws an exception on failure to connect.
An sql location normally retrieved using busby.locations["name of sql location"]
An Sql object used for querying
Run an sql stored procedure, the results will be available by calling getResult and getOutputs
the procedure to run
An Sql object used for chaining
Gets the output parameters from a stored procedure.
An object whose keys are the names of the output parameter
Gets the result of a query or stored procedure
An array of results, where the keys are the returned column names.
Gets the result of a query or stored procedure
An array of results, where the keys are the returned column names.
Add an input parameter to be used in a later query or execute command for example busby.sql.connect("ms location").input("input1").query("select * from mytable where id = @input1")
the name of the input parameter
the value of the input parameter
An Sql object used for chaining
Add an output parameter to be used in a later execute command, which can then be retrieved through busby.sql.getOutputs
the name of the output parameter
An Sql object used for chaining
Run an sql query, the results will be available by calling getResult
the query to run
An Sql object used for chaining