|
Database.SQLite | Portability | portable | Stability | provisional | Maintainer | docserver-dev-team@galois.com |
|
|
|
|
|
Description |
A Haskell binding to the sqlite3 database.
See:
for more information.
The api is documented at:
|
|
Synopsis |
|
|
|
Documentation |
|
module Database.SQLite.Base |
|
module Database.SQLite.Types |
|
module Database.SQL.Types |
|
Opening and closing a database
|
|
|
Open a new database connection, whose name is given
by the dbName argument. A sqlite3 handle is returned.
An exception is thrown if the database could not be opened.
|
|
|
Close a database connection.
Destroys the SQLite value associated with a database, closes
all open files relating to the database, and releases all resources.
|
|
Executing SQL queries on the database
|
|
|
Evaluate the SQL statement specified by sqlStmt
|
|
|
Returns an error, or Nothing if everything was OK.
|
|
|
Prepare and execute a parameterized statment.
Statement parameter names start with a colon (for example, :col_id).
Note that for the moment, column names should not contain 0
characters because that part of the column name will be ignored.
|
|
|
Prepare and execute a parameterized statment, ignoring the result.
See also execParamStatement.
|
|
Basic insertion operations
|
|
|
Insert a row into the table tab.
|
|
|
Define a new table, populated from tab in the database.
|
|
|
|
|
Return the rowid (as an Integer) of the most recent
successful INSERT into the database.
|
|
|
|
|
Constructors | | Instances | |
|
|
|
This function registers a RegexpHandler to be called when
REGEXP(regexp,str) is used in an SQL query.
|
|
|
This is the type of the function supported by the addRegexpSupport
function. The first argument is the regular expression to match with
and the second argument is the string to match. The result shall be
True for successful match and False otherwise.
|
|
|
|
|
|
|
|
User-defined callback functions
|
|
|
| Methods | | | Instances | |
|
|
class IsFunctionHandler a where | Source |
|
| Methods | | | funcHandler :: a -> FunctionHandler | Source |
|
| | Instances | IsValue r => IsFunctionHandler (IO r) | (IsValue a, IsValue r) => IsFunctionHandler ([] a -> IO r) | (IsValue a, IsValue r) => IsFunctionHandler ([] a -> r) | IsValue r => IsFunctionHandler (String -> IO r) | IsValue r => IsFunctionHandler (String -> r) | (IsValue a, IsValue b, IsValue c, IsValue d, IsValue r) => IsFunctionHandler (a -> b -> c -> d -> IO r) | (IsValue a, IsValue b, IsValue c, IsValue r) => IsFunctionHandler (a -> b -> c -> IO r) | (IsValue a, IsValue b, IsValue r) => IsFunctionHandler (a -> b -> IO r) | (IsValue a, IsValue r) => IsFunctionHandler (a -> IO r) | (IsValue a, IsValue b, IsValue c, IsValue d, IsValue r) => IsFunctionHandler (a -> b -> c -> d -> r) | (IsValue a, IsValue b, IsValue c, IsValue r) => IsFunctionHandler (a -> b -> c -> r) | (IsValue a, IsValue b, IsValue r) => IsFunctionHandler (a -> b -> r) | (IsValue a, IsValue r) => IsFunctionHandler (a -> r) |
|
|
|
|
|
|
|
|
|
Produced by Haddock version 2.4.2 |