/usr/share/doc/haskell-haskelldb-doc/html/Database-HaskellDB-Database.html is in libghc-haskelldb-doc 2.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Database.HaskellDB.Database</title><link href="ocean.css" rel="stylesheet" type="text/css" title="Ocean" /><script src="haddock-util.js" type="text/javascript"></script><script type="text/javascript">//<![CDATA[
window.onload = function () {pageLoad();setSynopsis("mini_Database-HaskellDB-Database.html");};
//]]>
</script></head><body><div id="package-header"><ul class="links" id="page-menu"><li><a href="src/Database-HaskellDB-Database.html">Source</a></li><li><a href="index.html">Contents</a></li><li><a href="doc-index.html">Index</a></li></ul><p class="caption">haskelldb-2.1.1: A library of combinators for generating and executing SQL statements.</p></div><div id="content"><div id="module-header"><table class="info"><tr><th>Portability</th><td>non-portable</td></tr><tr><th>Stability</th><td>experimental</td></tr><tr><th>Maintainer</th><td>haskelldb-users@lists.sourceforge.net</td></tr><tr><th>Safe Haskell</th><td>None</td></tr></table><p class="caption">Database.HaskellDB.Database</p></div><div id="table-of-contents"><p class="caption">Contents</p><ul><li><a href="#g:1">Operators
</a></li><li><a href="#g:2">Type declarations
</a></li><li><a href="#g:3">Function declarations
</a></li></ul></div><div id="description"><p class="caption">Description</p><div class="doc"><p>Defines standard database operations and the
primitive hooks that a particular database binding
must provide.
</p></div></div><div id="synopsis"><p id="control.syn" class="caption expander" onclick="toggleSection('syn')">Synopsis</p><ul id="section.syn" class="hide" onclick="toggleSection('syn')"><li class="src short"><a href="#v:-33-.">(!.)</a> :: <a href="Database-HaskellDB-HDBRec.html#t:Select">Select</a> f r a => r -> f -> a</li><li class="src short"><span class="keyword">data</span> <a href="#t:Database">Database</a> = <a href="#v:Database">Database</a> {<ul class="subs"><li><a href="#v:dbQuery">dbQuery</a> :: <span class="keyword">forall</span> er vr. <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> er vr => <a href="Database-HaskellDB-PrimQuery.html#t:PrimQuery">PrimQuery</a> -> <a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr]</li><li><a href="#v:dbInsert">dbInsert</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:Assoc">Assoc</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbInsertQuery">dbInsertQuery</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:PrimQuery">PrimQuery</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbDelete">dbDelete</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [<a href="Database-HaskellDB-PrimQuery.html#t:PrimExpr">PrimExpr</a>] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbUpdate">dbUpdate</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [<a href="Database-HaskellDB-PrimQuery.html#t:PrimExpr">PrimExpr</a>] -> <a href="Database-HaskellDB-PrimQuery.html#t:Assoc">Assoc</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbTables">dbTables</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a>]</li><li><a href="#v:dbDescribe">dbDescribe</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)]</li><li><a href="#v:dbTransaction">dbTransaction</a> :: <span class="keyword">forall</span> a. <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li><a href="#v:dbCreateDB">dbCreateDB</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbCreateTable">dbCreateTable</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbDropDB">dbDropDB</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbDropTable">dbDropTable</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li><a href="#v:dbCommit">dbCommit</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li></ul>}</li><li class="src short"><span class="keyword">class</span> <a href="#t:GetRec">GetRec</a> er vr | er -> vr, vr -> er <span class="keyword">where</span><ul class="subs"><li><a href="#v:getRec">getRec</a> :: <a href="Database-HaskellDB-Database.html#t:GetInstances">GetInstances</a> s -> <a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er -> <a href="Database-HaskellDB-PrimQuery.html#t:Scheme">Scheme</a> -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr)</li></ul></li><li class="src short"><span class="keyword">data</span> <a href="#t:GetInstances">GetInstances</a> s = <a href="#v:GetInstances">GetInstances</a> {<ul class="subs"><li><a href="#v:getString">getString</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>)</li><li><a href="#v:getInt">getInt</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a>)</li><li><a href="#v:getInteger">getInteger</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a>)</li><li><a href="#v:getDouble">getDouble</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a>)</li><li><a href="#v:getBool">getBool</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</li><li><a href="#v:getCalendarTime">getCalendarTime</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-DBLayout.html#t:CalendarTime">CalendarTime</a>)</li></ul>}</li><li class="src short"><span class="keyword">class</span> <a href="#t:GetValue">GetValue</a> a <span class="keyword">where</span><ul class="subs"><li><a href="#v:getValue">getValue</a> :: <a href="Database-HaskellDB-Database.html#t:GetInstances">GetInstances</a> s -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li></ul></li><li class="src short"><a href="#v:query">query</a> :: <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> er vr => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Query">Query</a> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr]</li><li class="src short"><a href="#v:insert">insert</a> :: (<a href="Database-HaskellDB-Query.html#t:ToPrimExprs">ToPrimExprs</a> r, <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r, <a href="Database-HaskellDB-Query.html#t:InsertRec">InsertRec</a> r er) => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> er -> <a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> r -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:delete">delete</a> :: <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r -> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-Query.html#t:Expr">Expr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:update">update</a> :: (<a href="Database-HaskellDB-HDBRec.html#t:ShowLabels">ShowLabels</a> s, <a href="Database-HaskellDB-Query.html#t:ToPrimExprs">ToPrimExprs</a> s) => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r -> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-Query.html#t:Expr">Expr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>) -> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> s) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:insertQuery">insertQuery</a> :: <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r -> <a href="Database-HaskellDB-Query.html#t:Query">Query</a> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:tables">tables</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a>]</li><li class="src short"><a href="#v:describe">describe</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)]</li><li class="src short"><a href="#v:transaction">transaction</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</li><li class="src short"><a href="#v:commit">commit</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:createDB">createDB</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:createTable">createTable</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:dropDB">dropDB</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li><li class="src short"><a href="#v:dropTable">dropTable</a> :: <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></li></ul></div><div id="interface"><h1 id="g:1">Operators
</h1><div class="top"><p class="src"><a name="v:-33-." class="def">(!.)</a> :: <a href="Database-HaskellDB-HDBRec.html#t:Select">Select</a> f r a => r -> f -> a<a href="src/Database-HaskellDB-Database.html#%21." class="link">Source</a></p><div class="doc"><p>The (!.) operator selects over returned records from
the database (= rows)
Non-overloaded version of <code><a href="Database-HaskellDB-HDBRec.html#v:-33-">!</a></code>. For backwards compatibility.
</p></div></div><h1 id="g:2">Type declarations
</h1><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:Database" class="def">Database</a> <a href="src/Database-HaskellDB-Database.html#Database" class="link">Source</a></p><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:Database" class="def">Database</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:dbQuery" class="def">dbQuery</a> :: <span class="keyword">forall</span> er vr. <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> er vr => <a href="Database-HaskellDB-PrimQuery.html#t:PrimQuery">PrimQuery</a> -> <a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr]</dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbInsert" class="def">dbInsert</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:Assoc">Assoc</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbInsertQuery" class="def">dbInsertQuery</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="Database-HaskellDB-PrimQuery.html#t:PrimQuery">PrimQuery</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbDelete" class="def">dbDelete</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [<a href="Database-HaskellDB-PrimQuery.html#t:PrimExpr">PrimExpr</a>] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbUpdate" class="def">dbUpdate</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [<a href="Database-HaskellDB-PrimQuery.html#t:PrimExpr">PrimExpr</a>] -> <a href="Database-HaskellDB-PrimQuery.html#t:Assoc">Assoc</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbTables" class="def">dbTables</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a>]</dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbDescribe" class="def">dbDescribe</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)]</dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbTransaction" class="def">dbTransaction</a> :: <span class="keyword">forall</span> a. <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbCreateDB" class="def">dbCreateDB</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbCreateTable" class="def">dbCreateTable</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)] -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbDropDB" class="def">dbDropDB</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbDropTable" class="def">dbDropTable</a> :: <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd><dt class="src"><a name="v:dbCommit" class="def">dbCommit</a> :: <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></dt><dd class="doc empty"> </dd></dl><div class="clear"></div></div></td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">class</span> <a name="t:GetRec" class="def">GetRec</a> er vr | er -> vr, vr -> er <span class="keyword">where</span><a href="src/Database-HaskellDB-Database.html#GetRec" class="link">Source</a></p><div class="subs methods"><p class="caption">Methods</p><p class="src"><a name="v:getRec" class="def">getRec</a><a href="src/Database-HaskellDB-Database.html#getRec" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:GetInstances">GetInstances</a> s</td><td class="doc"><p>Driver functions for getting values
of different types.
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er</td><td class="doc"><p>Phantom argument to the the return type right
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-PrimQuery.html#t:Scheme">Scheme</a></td><td class="doc"><p>Fields to get.
</p></td></tr><tr><td class="src">-> s</td><td class="doc"><p>Driver-specific result data
(for example a Statement object)
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr)</td><td class="doc"><p>Result record.
</p></td></tr></table></div><div class="doc"><p>Create a result record.
</p></div></div><div class="subs instances"><p id="control.i:GetRec" class="caption collapser" onclick="toggleSection('i:GetRec')">Instances</p><div id="section.i:GetRec" class="show"><table><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> <a href="Database-HaskellDB-HDBRec.html#t:RecNil">RecNil</a> <a href="Database-HaskellDB-HDBRec.html#t:RecNil">RecNil</a></td><td class="doc empty"> </td></tr><tr><td class="src">(<a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> a, <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> er vr) => <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> (<a href="Database-HaskellDB-HDBRec.html#t:RecCons">RecCons</a> f (<a href="Database-HaskellDB-Query.html#t:Expr">Expr</a> a) er) (<a href="Database-HaskellDB-HDBRec.html#t:RecCons">RecCons</a> f a vr)</td><td class="doc empty"> </td></tr></table></div></div></div><div class="top"><p class="src"><span class="keyword">data</span> <a name="t:GetInstances" class="def">GetInstances</a> s <a href="src/Database-HaskellDB-Database.html#GetInstances" class="link">Source</a></p><div class="doc"><p>Functions for getting values of a given type. Database drivers
need to implement these functions and pass this record to <code><a href="Database-HaskellDB-Database.html#v:getRec">getRec</a></code>
when getting query results.
</p><p>All these functions should return <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#v:Nothing">Nothing</a></code> if the value is NULL.
</p></div><div class="subs constructors"><p class="caption">Constructors</p><table><tr><td class="src"><a name="v:GetInstances" class="def">GetInstances</a></td><td class="doc empty"> </td></tr><tr><td colspan="2"><div class="subs fields"><p class="caption">Fields</p><dl><dt class="src"><a name="v:getString" class="def">getString</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>)</dt><dd class="doc"><p>Get a <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></code> value.
</p></dd><dt class="src"><a name="v:getInt" class="def">getInt</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a>)</dt><dd class="doc"><p>Get an <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></code> value.
</p></dd><dt class="src"><a name="v:getInteger" class="def">getInteger</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a>)</dt><dd class="doc"><p>Get an <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a></code> value.
</p></dd><dt class="src"><a name="v:getDouble" class="def">getDouble</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a>)</dt><dd class="doc"><p>Get a <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></code> value.
</p></dd><dt class="src"><a name="v:getBool" class="def">getBool</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</dt><dd class="doc"><p>Get a <code><a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a></code> value.
</p></dd><dt class="src"><a name="v:getCalendarTime" class="def">getCalendarTime</a> :: s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-DBLayout.html#t:CalendarTime">CalendarTime</a>)</dt><dd class="doc"><p>Get a <code><a href="Database-HaskellDB-DBLayout.html#t:CalendarTime">CalendarTime</a></code> value.
</p></dd></dl><div class="clear"></div></div></td></tr></table></div></div><div class="top"><p class="src"><span class="keyword">class</span> <a name="t:GetValue" class="def">GetValue</a> a <span class="keyword">where</span><a href="src/Database-HaskellDB-Database.html#GetValue" class="link">Source</a></p><div class="subs methods"><p class="caption">Methods</p><p class="src"><a name="v:getValue" class="def">getValue</a> :: <a href="Database-HaskellDB-Database.html#t:GetInstances">GetInstances</a> s -> s -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a> -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a<a href="src/Database-HaskellDB-Database.html#getValue" class="link">Source</a></p></div><div class="subs instances"><p id="control.i:GetValue" class="caption collapser" onclick="toggleSection('i:GetValue')">Instances</p><div id="section.i:GetValue" class="show"><table><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> <a href="Database-HaskellDB-DBLayout.html#t:CalendarTime">CalendarTime</a></td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Double">Double</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Int.html#t:Int">Int</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Prelude.html#t:Integer">Integer</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> <a href="Database-HaskellDB-DBLayout.html#t:CalendarTime">CalendarTime</a>)</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-BoundedList.html#t:Size">Size</a> n => <a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Maybe.html#t:Maybe">Maybe</a> (<a href="Database-HaskellDB-BoundedString.html#t:BoundedString">BoundedString</a> n))</td><td class="doc empty"> </td></tr><tr><td class="src"><a href="Database-HaskellDB-BoundedList.html#t:Size">Size</a> n => <a href="Database-HaskellDB-Database.html#t:GetValue">GetValue</a> (<a href="Database-HaskellDB-BoundedString.html#t:BoundedString">BoundedString</a> n)</td><td class="doc empty"> </td></tr></table></div></div></div><h1 id="g:3">Function declarations
</h1><div class="top"><p class="src"><a name="v:query" class="def">query</a> :: <a href="Database-HaskellDB-Database.html#t:GetRec">GetRec</a> er vr => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Query">Query</a> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> er) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> vr]<a href="src/Database-HaskellDB-Database.html#query" class="link">Source</a></p><div class="doc"><p>performs a query on a database
</p></div></div><div class="top"><p class="src"><a name="v:insert" class="def">insert</a> :: (<a href="Database-HaskellDB-Query.html#t:ToPrimExprs">ToPrimExprs</a> r, <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r, <a href="Database-HaskellDB-Query.html#t:InsertRec">InsertRec</a> r er) => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> er -> <a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> r -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a><a href="src/Database-HaskellDB-Database.html#insert" class="link">Source</a></p><div class="doc"><p>Inserts a record into a table
</p></div></div><div class="top"><p class="src"><a name="v:delete" class="def">delete</a><a href="src/Database-HaskellDB-Database.html#delete" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r</td><td class="doc empty"> </td></tr><tr><td class="src">=> <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>The database
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r</td><td class="doc"><p>The table to delete records from
</p></td></tr><tr><td class="src">-> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-Query.html#t:Expr">Expr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</td><td class="doc"><p>Predicate used to select records to delete
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>deletes a bunch of records
</p></div></div><div class="top"><p class="src"><a name="v:update" class="def">update</a><a href="src/Database-HaskellDB-Database.html#update" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: (<a href="Database-HaskellDB-HDBRec.html#t:ShowLabels">ShowLabels</a> s, <a href="Database-HaskellDB-Query.html#t:ToPrimExprs">ToPrimExprs</a> s)</td><td class="doc empty"> </td></tr><tr><td class="src">=> <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>The database
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r</td><td class="doc"><p>The table to update
</p></td></tr><tr><td class="src">-> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-Query.html#t:Expr">Expr</a> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-Bool.html#t:Bool">Bool</a>)</td><td class="doc"><p>Predicate used to select records to update
</p></td></tr><tr><td class="src">-> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r -> <a href="Database-HaskellDB-HDBRec.html#t:Record">Record</a> s)</td><td class="doc"><p>Function used to modify selected records
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Updates records
</p></div></div><div class="top"><p class="src"><a name="v:insertQuery" class="def">insertQuery</a> :: <a href="Database-HaskellDB-HDBRec.html#t:ShowRecRow">ShowRecRow</a> r => <a href="Database-HaskellDB-Database.html#t:Database">Database</a> -> <a href="Database-HaskellDB-Query.html#t:Table">Table</a> r -> <a href="Database-HaskellDB-Query.html#t:Query">Query</a> (<a href="Database-HaskellDB-Query.html#t:Rel">Rel</a> r) -> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a><a href="src/Database-HaskellDB-Database.html#insertQuery" class="link">Source</a></p><div class="doc"><p>Inserts values from a query into a table
</p></div></div><div class="top"><p class="src"><a name="v:tables" class="def">tables</a><a href="src/Database-HaskellDB-Database.html#tables" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [<a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a>]</td><td class="doc"><p>Names of all tables in the database
</p></td></tr></table></div><div class="doc"><p>List all tables in the database
</p></div></div><div class="top"><p class="src"><a name="v:describe" class="def">describe</a><a href="src/Database-HaskellDB-Database.html#describe" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a></td><td class="doc"><p>Name of the tables whose columns are to be listed
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)]</td><td class="doc"><p>Name and type info for each column
</p></td></tr></table></div><div class="doc"><p>List all columns in a table, along with their types
</p></div></div><div class="top"><p class="src"><a name="v:transaction" class="def">transaction</a><a href="src/Database-HaskellDB-Database.html#transaction" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</td><td class="doc"><p>Action to run
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> a</td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Performs some database action in a transaction. If no exception is thrown,
the changes are committed.
</p></div></div><div class="top"><p class="src"><a name="v:commit" class="def">commit</a><a href="src/Database-HaskellDB-Database.html#commit" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Commit any pending data to the database.
</p></div></div><div class="top"><p class="src"><a name="v:createDB" class="def">createDB</a><a href="src/Database-HaskellDB-Database.html#createDB" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>Name of database to create
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div><div class="doc"><p>Is not very useful. You need to be root to use it.
We suggest you solve this in another way
</p></div></div><div class="top"><p class="src"><a name="v:createTable" class="def">createTable</a><a href="src/Database-HaskellDB-Database.html#createTable" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a></td><td class="doc"><p>Name of table to create
</p></td></tr><tr><td class="src">-> [(<a href="Database-HaskellDB-PrimQuery.html#t:Attribute">Attribute</a>, <a href="Database-HaskellDB-FieldType.html#t:FieldDesc">FieldDesc</a>)]</td><td class="doc"><p>The fields of the table
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div></div><div class="top"><p class="src"><a name="v:dropDB" class="def">dropDB</a><a href="src/Database-HaskellDB-Database.html#dropDB" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/Data-String.html#t:String">String</a></td><td class="doc"><p>Name of database to drop
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div></div><div class="top"><p class="src"><a name="v:dropTable" class="def">dropTable</a><a href="src/Database-HaskellDB-Database.html#dropTable" class="link">Source</a></p><div class="subs arguments"><p class="caption">Arguments</p><table><tr><td class="src">:: <a href="Database-HaskellDB-Database.html#t:Database">Database</a></td><td class="doc"><p>Database
</p></td></tr><tr><td class="src">-> <a href="Database-HaskellDB-PrimQuery.html#t:TableName">TableName</a></td><td class="doc"><p>Name of table to drop
</p></td></tr><tr><td class="src">-> <a href="/usr/share/doc/ghc-doc/html/libraries/base-4.5.0.0/System-IO.html#t:IO">IO</a> <a href="/usr/share/doc/ghc-doc/html/libraries/ghc-prim-0.2.0.0/GHC-Tuple.html#t:-40--41-">()</a></td><td class="doc empty"> </td></tr></table></div></div></div></div><div id="footer"><p>Produced by <a href="http://www.haskell.org/haddock/">Haddock</a> version 2.10.0</p></div></body></html>
|