DB module
A generic database connection and querying API. Separate database-specific modules are then used to set up connections to particular databases. Kaya currently distributes:
- MyDB (MySQL)
- PostgresDB (Postgres)
- SQLiteDB (SQLite)
Data types
- DB::DBHandle<a> - A database handle
- DB::DBIncResult<a> - An incremental query result
- DB::DBResult - A query result
- DB::DBStatement<a> - A prepared database statement
- DB::DBValue - Query result values
Exceptions
- InvalidTime - Converting to Time failed
Functions
- Bool bool(DBValue val) - Convert a database result to a Bool
- Void close(DBHandle<a> con) - Close a connection
- String column(DBResult res,Int col) - Get a column name
- DBResult defaultExecPrepared(DBStatement<a> con,[Maybe<String> ] params) - Default function
- [DBValue] defaultGetRow(DBIncResult<a> res) - Default function
- Void defaultIncDiscard(DBIncResult<a> res) - Default function
- DBIncResult<a> defaultIncExec(a con,String query,DBHandle<a> cptr) - Default function
- DBIncResult<a> defaultIncExecPrepared(DBStatement<a> con,[Maybe<String> ] params) - Default function
- DBStatement<a> defaultPrepare(DBHandle<a> con,String query) - Default function
- String escape(String val) - Escape a string to be used as part of a query
- DBResult exec(DBHandle<a> con,String query) - Execute a query
- DBResult execPrepared(DBStatement<a> statement,[Maybe<String> ] params) - Execute a prepared statement
- DBResult execPrepared(DBStatement<a> statement,[String] params) - Execute a prepared statement
- Float float(DBValue val) - Convert a database result to a Float
- [DBValue] getRow(DBIncResult<a> res) - Retrieve a row from an incremental query
- Void incDiscard(DBIncResult<a> res) - Discard an incremental query
- DBIncResult<a> incExec(DBHandle<a> con,String query) - Execute an incremental query
- DBIncResult<a> incExecPrepared(DBStatement<a> statement,[Maybe<String> ] params) - Incrementally execute a prepared statement
- Int int(DBValue val) - Convert a database result to an Int
- DBStatement<a> prepare(DBHandle<a> con,String query) - Prepare a database query
- String string(DBValue val) - Convert a database result to a String
- Time time(DBValue val) - Convert a database result to a Time
