/usr/share/doc/haskell-haskelldb-doc/html/src/Database-HaskellDB-Sql-SQLite.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 | <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<!-- Generated by HsColour, http://code.haskell.org/~malcolm/hscolour/ -->
<title>src/Database/HaskellDB/Sql/SQLite.hs</title>
<link type='text/css' rel='stylesheet' href='hscolour.css' />
</head>
<body>
<pre><a name="line-1"></a><span class='hs-comment'>-----------------------------------------------------------</span>
<a name="line-2"></a><span class='hs-comment'>-- |</span>
<a name="line-3"></a><span class='hs-comment'>-- Module : Database.HaskellDB.Sql.SQLite</span>
<a name="line-4"></a><span class='hs-comment'>-- Copyright : Bjorn Bringert 2006</span>
<a name="line-5"></a><span class='hs-comment'>-- License : BSD-style</span>
<a name="line-6"></a><span class='hs-comment'>-- </span>
<a name="line-7"></a><span class='hs-comment'>-- Maintainer : haskelldb-users@lists.sourceforge.net</span>
<a name="line-8"></a><span class='hs-comment'>-- Stability : experimental</span>
<a name="line-9"></a><span class='hs-comment'>-- Portability : non-portable</span>
<a name="line-10"></a><span class='hs-comment'>-- </span>
<a name="line-11"></a><span class='hs-comment'>-- SQL generation for SQLite.</span>
<a name="line-12"></a><span class='hs-comment'>-- See <<a href="http://www.sqlite.org/lang.html">http://www.sqlite.org/lang.html</a>> for documentation.</span>
<a name="line-13"></a><span class='hs-comment'>-- </span>
<a name="line-14"></a><span class='hs-comment'>-----------------------------------------------------------</span>
<a name="line-15"></a><span class='hs-keyword'>module</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>SQLite</span> <span class='hs-layout'>(</span><span class='hs-varid'>generator</span><span class='hs-layout'>)</span> <span class='hs-keyword'>where</span>
<a name="line-16"></a>
<a name="line-17"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>Default</span>
<a name="line-18"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>Sql</span><span class='hs-varop'>.</span><span class='hs-conid'>Generate</span>
<a name="line-19"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>HaskellDB</span><span class='hs-varop'>.</span><span class='hs-conid'>PrimQuery</span>
<a name="line-20"></a>
<a name="line-21"></a><a name="generator"></a><span class='hs-definition'>generator</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>SqlGenerator</span>
<a name="line-22"></a><span class='hs-definition'>generator</span> <span class='hs-keyglyph'>=</span> <span class='hs-layout'>(</span><span class='hs-varid'>mkSqlGenerator</span> <span class='hs-varid'>generator</span><span class='hs-layout'>)</span>
<a name="line-23"></a> <span class='hs-layout'>{</span>
<a name="line-24"></a> <span class='hs-varid'>sqlLiteral</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>literal</span>
<a name="line-25"></a> <span class='hs-layout'>}</span>
<a name="line-26"></a>
<a name="line-27"></a><a name="literal"></a><span class='hs-definition'>literal</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>Literal</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>String</span>
<a name="line-28"></a><span class='hs-definition'>literal</span> <span class='hs-layout'>(</span><span class='hs-conid'>StringLit</span> <span class='hs-varid'>s</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>quote</span> <span class='hs-varid'>s</span>
<a name="line-29"></a><span class='hs-definition'>literal</span> <span class='hs-conid'>DefaultLit</span> <span class='hs-keyglyph'>=</span> <span class='hs-str'>"NULL"</span>
<a name="line-30"></a><span class='hs-definition'>literal</span> <span class='hs-layout'>(</span><span class='hs-conid'>BoolLit</span> <span class='hs-conid'>True</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-str'>"1"</span>
<a name="line-31"></a><span class='hs-definition'>literal</span> <span class='hs-layout'>(</span><span class='hs-conid'>BoolLit</span> <span class='hs-conid'>False</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-str'>"0"</span>
<a name="line-32"></a><span class='hs-definition'>literal</span> <span class='hs-varid'>l</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>defaultSqlLiteral</span> <span class='hs-varid'>generator</span> <span class='hs-varid'>l</span>
<a name="line-33"></a>
<a name="line-34"></a><a name="quote"></a><span class='hs-comment'>{-
<a name="line-35"></a>From <a href="http://www.sqlite.org/lang_expr.html">http://www.sqlite.org/lang_expr.html</a>
<a name="line-36"></a>
<a name="line-37"></a>"A string constant is formed by enclosing the string in single quotes (').
<a name="line-38"></a>A single quote within the string can be encoded by putting two single quotes
<a name="line-39"></a>in a row - as in Pascal. C-style escapes using the backslash character
<a name="line-40"></a>are not supported because they are not standard SQL."
<a name="line-41"></a>-}</span>
<a name="line-42"></a><span class='hs-definition'>quote</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>String</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>String</span>
<a name="line-43"></a><span class='hs-definition'>quote</span> <span class='hs-varid'>s</span> <span class='hs-keyglyph'>=</span> <span class='hs-str'>"'"</span> <span class='hs-varop'>++</span> <span class='hs-varid'>concatMap</span> <span class='hs-varid'>escape</span> <span class='hs-varid'>s</span> <span class='hs-varop'>++</span> <span class='hs-str'>"'"</span>
<a name="line-44"></a>
<a name="line-45"></a><a name="escape"></a><span class='hs-definition'>escape</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>Char</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>String</span>
<a name="line-46"></a><span class='hs-definition'>escape</span> <span class='hs-chr'>'\''</span> <span class='hs-keyglyph'>=</span> <span class='hs-str'>"''"</span>
<a name="line-47"></a><span class='hs-definition'>escape</span> <span class='hs-varid'>c</span> <span class='hs-keyglyph'>=</span> <span class='hs-keyglyph'>[</span><span class='hs-varid'>c</span><span class='hs-keyglyph'>]</span>
</pre></body>
</html>
|