Documentation
database
typePaperVelocity
A SQL database connection pool.
Properties 2
mysql, mariadb, postgresql or sqlite.
Name of the database connection.
Methods 6
Runs a SELECT. Returns a list of rows; each row is a map of column to value. Use ? placeholders with a list of params.
Runs a SELECT and returns the first row, or none.
Runs INSERT, UPDATE, DELETE or DDL. Returns the number of affected rows.
Runs one statement for every list of params in rows. Returns the total affected rows.
Starts a transaction. Call .commit() or .rollback() on the result.
Closes the connection pool.