Index of class methods
B
bind_columns
[
Dbi.statement
]
This method binds result columns to variables (references).
C
close
[
Dbi_postgres.connection
]
close
[
Dbi_perl.connection
]
close
[
Dbi_mysql.connection
]
close
[
Dbi.connection
]
Closes the database handle.
closed
[
Dbi_postgres.connection
]
closed
[
Dbi_perl.connection
]
closed
[
Dbi_mysql.connection
]
closed
[
Dbi.connection
]
Returns
true
if this database handle has been closed.
commit
[
Dbi_postgres.connection
]
commit
[
Dbi_perl.connection
]
commit
[
Dbi_mysql.connection
]
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_postgres.connection
]
database
[
Dbi_perl.connection
]
database
[
Dbi_mysql.connection
]
database
[
Dbi.connection
]
Return the database name.
database_type
[
Dbi_postgres.connection
]
database_type
[
Dbi_perl.connection
]
database_type
[
Dbi_mysql.connection
]
database_type
[
Dbi.connection
]
Database type (eg.
debug
[
Dbi_postgres.connection
]
debug
[
Dbi_perl.connection
]
debug
[
Dbi_mysql.connection
]
debug
[
Dbi.connection
]
Returns true if this handle has debugging enabled.
E
ex
[
Dbi_postgres.connection
]
ex
[
Dbi_perl.connection
]
ex
[
Dbi_mysql.connection
]
ex
[
Dbi.connection
]
This is a shorthand for:
execute
[
Dbi.statement
]
Execute the statement with the given list of arguments substituted for
?
placeholders in the query string.
F
fetch1
[
Dbi.statement
]
The statement expects exactly one tuple to be returned from the query.
fetchall
[
Dbi.statement
]
This returns a list of all tuples returned from the query.
finish
[
Dbi.statement
]
"Finishes" the statement.
fold_left
[
Dbi.statement
]
Fold left over the result tuples.
fold_right
[
Dbi.statement
]
Fold right over the result tuples.
H
host
[
Dbi_postgres.connection
]
host
[
Dbi_perl.connection
]
host
[
Dbi_mysql.connection
]
host
[
Dbi.connection
]
Return the
host
parameter.
I
id
[
Dbi_postgres.connection
]
id
[
Dbi_perl.connection
]
id
[
Dbi_mysql.connection
]
id
[
Dbi.connection
]
Returns a unique integer which can be used to identify this connection.
iter
[
Dbi.statement
]
Iterate over the result tuples.
M
map
[
Dbi.statement
]
Map over the result tuples.
N
next
[
Dbi.statement
]
Returns the
next
row.
P
password
[
Dbi_postgres.connection
]
password
[
Dbi_perl.connection
]
password
[
Dbi_mysql.connection
]
password
[
Dbi.connection
]
Return the
password
parameter.
ping
[
Dbi_postgres.connection
]
ping
[
Dbi_perl.connection
]
ping
[
Dbi_mysql.connection
]
ping
[
Dbi.connection
]
This uses some active method to verify that the database handle is still working.
port
[
Dbi_postgres.connection
]
port
[
Dbi_perl.connection
]
port
[
Dbi_mysql.connection
]
port
[
Dbi.connection
]
Return the
port
parameter.
prepare
[
Dbi_postgres.connection
]
prepare
[
Dbi_perl.connection
]
prepare
[
Dbi_mysql.connection
]
prepare
[
Dbi.connection
]
Prepare a database query, and return the prepared statement.
prepare_cached
[
Dbi_postgres.connection
]
prepare_cached
[
Dbi_perl.connection
]
prepare_cached
[
Dbi_mysql.connection
]
prepare_cached
[
Dbi.connection
]
This method is identical to
prepare
except that, if possible, it caches the statement handle with the database object.
R
register_postrollback
[
Dbi_postgres.connection
]
register_postrollback
[
Dbi_perl.connection
]
register_postrollback
[
Dbi_mysql.connection
]
register_postrollback
[
Dbi.connection
]
Register a function which will be called just AFTER a rollback happens on this handle.
register_precommit
[
Dbi_postgres.connection
]
register_precommit
[
Dbi_perl.connection
]
register_precommit
[
Dbi_mysql.connection
]
register_precommit
[
Dbi.connection
]
Register a function which will be called just BEFORE a commit happens on this handle.
rollback
[
Dbi_postgres.connection
]
rollback
[
Dbi_perl.connection
]
rollback
[
Dbi_mysql.connection
]
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_postgres.connection
]
set_debug
[
Dbi_perl.connection
]
set_debug
[
Dbi_mysql.connection
]
set_debug
[
Dbi.connection
]
Use this to enable debugging on the handle.
U
unregister_postrollback
[
Dbi_postgres.connection
]
unregister_postrollback
[
Dbi_perl.connection
]
unregister_postrollback
[
Dbi_mysql.connection
]
unregister_postrollback
[
Dbi.connection
]
Unregister a postrollback callback.
unregister_precommit
[
Dbi_postgres.connection
]
unregister_precommit
[
Dbi_perl.connection
]
unregister_precommit
[
Dbi_mysql.connection
]
unregister_precommit
[
Dbi.connection
]
Unregister a precommit callback.
user
[
Dbi_postgres.connection
]
user
[
Dbi_perl.connection
]
user
[
Dbi_mysql.connection
]
user
[
Dbi.connection
]
Return the
user
parameter.