# Io Reference

Databases / DBI / DBIConn

|  | An object that represents a DBI Connection.

close

Close the connection to the database.
connect

Connect to the database server.
driver

Return database driver name.
execute(sql_query)

Perform a database query that expects no results. Returns the number of rows affected.
option(key)

Retrieve an option value for the connection.
optionClear(key)

Clear a specific option associated with the connection.
optionPut(key,value)

Add an option key, value pair to the connection.
options

Retrieve an option list of the connection.
optionsClear

Clear all options associated with the connection
ping

Ping the database to see if it's alive. Will return true if it is, otherwise false.
query(sql_query)

Perform a database query returning a DBIResult object.
queryOne([object], sql)

Perform a query and return the first result. If [object] is supplied, the object is populated with the contents of the result, the result is marked done and the object is returned.
quote(value)

Quote a string value according to the database server's specifications.
sequenceLast([name])

Return the last inserted sequence value.
sequenceNext([name])

Return the next sequence that will be used during an INSERT query.