Index of class methods


C
close [Dbi.connection]
Closes the database handle.
close_in [IO.in_chars]
close_in [IO.in_channel]
close_out [IO.out_chars]
close_out [IO.out_channel]
closed [Dbi.connection]
Returns true if this database handle has been closed.
commit [Dbi.connection]
Perform a COMMIT operation on the database.
connection [Dbi.statement]
Return the database handle associated with this statement handle.

D
database [Dbi.connection]
Return the database name.
database_type [Dbi.connection]
Database type (e.g.
debug [Dbi.connection]
Returns true if this handle has debugging enabled.

E
ex [Dbi.connection]
dbh#ex stm args is a shorthand for
 let sth = dbh#prepare_cached stmt in
        sth#execute args;
        sth
        
execute [Dbi.statement]
Execute the statement with the given list of arguments substituted for ? placeholders in the query string.

F
fetch1 [Dbi.statement]
Fetches one row from the result set and returns it.
fetch1hash [Dbi.statement]
Fetches a row and return it as an association list of pairs (column name, value).
fetch1int [Dbi.statement]
This fetches a single integer field.
fetch1string [Dbi.statement]
This fetches a single string field.
fetchall [Dbi.statement]
This returns a list of all tuples returned from the query.
finish [Dbi.statement]
"Finishes" the statement.
flush [IO.out_chars]
flush [IO.out_channel]
fold_left [Dbi.statement]
Fold left over the result tuples.
fold_right [Dbi.statement]
Fold right over the result tuples.

G
get [IO.in_chars]

H
host [Dbi.connection]
Return the host parameter.

I
id [Dbi.connection]
Returns a unique integer which can be used to identify this connection.
input [IO.in_channel]
iter [Dbi.statement]
Iterate over the result tuples.

M
map [Dbi.statement]
Map over the result tuples.

N
names [Dbi.statement]
Returns the names of the columns of the result.

O
output [IO.out_channel]

P
password [Dbi.connection]
Return the password parameter.
ping [Dbi.connection]
This uses some active method to verify that the database handle is still working.
port [Dbi.connection]
Return the port parameter.
prepare [Dbi.connection]
Prepare a database query, and return the prepared statement.
prepare_cached [Dbi.connection]
This method is identical to prepare except that, if possible, it caches the statement handle with the database object.
put [IO.out_chars]

R
register_postrollback [Dbi.connection]
Register a function which will be called just AFTER a rollback happens on this handle.
register_precommit [Dbi.connection]
Register a function which will be called just BEFORE a commit happens on this handle.
rollback [Dbi.connection]
Perform a ROLLBACK operation on the database.

S
serial [Dbi.statement]
If the statement is an INSERT and has been executed, then some databases support retrieving the serial number of the INSERT statement (assuming there is a SERIAL column or SEQUENCE attached to the table).
set_debug [Dbi.connection]
Use this to enable debugging on the handle.

U
unregister_postrollback [Dbi.connection]
Unregister a postrollback callback.
unregister_precommit [Dbi.connection]
Unregister a precommit callback.
user [Dbi.connection]
Return the user parameter.