/usr/share/doc/libghc-postgresql-simple-doc/html/src/Database-PostgreSQL-Simple-SqlQQ.html is in libghc-postgresql-simple-doc 0.4.0.2-1.
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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 | <?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/PostgreSQL/Simple/SqlQQ.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.PostgreSQL.Simple.SqlQQ</span>
<a name="line-4"></a><span class='hs-comment'>-- Copyright: (c) 2011-2012 Leon P Smith</span>
<a name="line-5"></a><span class='hs-comment'>-- License: BSD3</span>
<a name="line-6"></a><span class='hs-comment'>-- Maintainer: Leon P Smith <leon@melding-monads.com></span>
<a name="line-7"></a><span class='hs-comment'>-- Stability: experimental</span>
<a name="line-8"></a><span class='hs-comment'>--</span>
<a name="line-9"></a><span class='hs-comment'>------------------------------------------------------------------------------</span>
<a name="line-10"></a>
<a name="line-11"></a><span class='hs-keyword'>module</span> <span class='hs-conid'>Database</span><span class='hs-varop'>.</span><span class='hs-conid'>PostgreSQL</span><span class='hs-varop'>.</span><span class='hs-conid'>Simple</span><span class='hs-varop'>.</span><span class='hs-conid'>SqlQQ</span> <span class='hs-layout'>(</span><span class='hs-varid'>sql</span><span class='hs-layout'>)</span> <span class='hs-keyword'>where</span>
<a name="line-12"></a>
<a name="line-13"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Language</span><span class='hs-varop'>.</span><span class='hs-conid'>Haskell</span><span class='hs-varop'>.</span><span class='hs-conid'>TH</span>
<a name="line-14"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Language</span><span class='hs-varop'>.</span><span class='hs-conid'>Haskell</span><span class='hs-varop'>.</span><span class='hs-conid'>TH</span><span class='hs-varop'>.</span><span class='hs-conid'>Quote</span>
<a name="line-15"></a><span class='hs-keyword'>import</span> <span class='hs-conid'>Data</span><span class='hs-varop'>.</span><span class='hs-conid'>Char</span>
<a name="line-16"></a>
<a name="line-17"></a><span class='hs-comment'>-- | 'sql' is a quasiquoter that eases the syntactic burden</span>
<a name="line-18"></a><span class='hs-comment'>-- of writing big sql statements in Haskell source code. For example:</span>
<a name="line-19"></a><span class='hs-comment'>--</span>
<a name="line-20"></a><span class='hs-comment'>-- > {-# LANGUAGE QuasiQuotes #-}</span>
<a name="line-21"></a><span class='hs-comment'>-- ></span>
<a name="line-22"></a><span class='hs-comment'>-- > query conn [sql| SELECT column_a, column_b</span>
<a name="line-23"></a><span class='hs-comment'>-- > FROM table1 NATURAL JOIN table2</span>
<a name="line-24"></a><span class='hs-comment'>-- > WHERE ? <= time AND time < ?</span>
<a name="line-25"></a><span class='hs-comment'>-- > AND name LIKE ?</span>
<a name="line-26"></a><span class='hs-comment'>-- > ORDER BY size DESC</span>
<a name="line-27"></a><span class='hs-comment'>-- > LIMIT 100 |]</span>
<a name="line-28"></a><span class='hs-comment'>-- > (beginTime,endTime,string)</span>
<a name="line-29"></a><span class='hs-comment'>--</span>
<a name="line-30"></a><span class='hs-comment'>-- This quasiquoter attempts to mimimize whitespace; otherwise the</span>
<a name="line-31"></a><span class='hs-comment'>-- above query would consist of approximately half whitespace when sent</span>
<a name="line-32"></a><span class='hs-comment'>-- to the database backend. It also recognizes and strips out standard</span>
<a name="line-33"></a><span class='hs-comment'>-- sql comments "--".</span>
<a name="line-34"></a><span class='hs-comment'>--</span>
<a name="line-35"></a><span class='hs-comment'>-- The implementation of the whitespace reducer is currently incomplete.</span>
<a name="line-36"></a><span class='hs-comment'>-- Thus it can mess up your syntax in cases where whitespace should be</span>
<a name="line-37"></a><span class='hs-comment'>-- preserved as-is. It does preserve whitespace inside standard SQL string</span>
<a name="line-38"></a><span class='hs-comment'>-- literals. But it can get confused by the non-standard PostgreSQL string</span>
<a name="line-39"></a><span class='hs-comment'>-- literal syntax (which is the default setting in PostgreSQL 8 and below),</span>
<a name="line-40"></a><span class='hs-comment'>-- the extended escape string syntax, quoted identifiers, and other similar</span>
<a name="line-41"></a><span class='hs-comment'>-- constructs.</span>
<a name="line-42"></a><span class='hs-comment'>--</span>
<a name="line-43"></a><span class='hs-comment'>-- Of course, this caveat only applies to text written inside the SQL</span>
<a name="line-44"></a><span class='hs-comment'>-- quasiquoter; whitespace reduction is a compile-time computation and</span>
<a name="line-45"></a><span class='hs-comment'>-- thus will not touch the @string@ parameter above, which is a run-time</span>
<a name="line-46"></a><span class='hs-comment'>-- value.</span>
<a name="line-47"></a><span class='hs-comment'>--</span>
<a name="line-48"></a><span class='hs-comment'>-- Also note that this will not work if the substring @|]@ is contained</span>
<a name="line-49"></a><span class='hs-comment'>-- in the query.</span>
<a name="line-50"></a>
<a name="line-51"></a><a name="sql"></a><span class='hs-definition'>sql</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>QuasiQuoter</span>
<a name="line-52"></a><span class='hs-definition'>sql</span> <span class='hs-keyglyph'>=</span> <span class='hs-conid'>QuasiQuoter</span>
<a name="line-53"></a> <span class='hs-layout'>{</span> <span class='hs-varid'>quotePat</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>error</span> <span class='hs-str'>"Database.PostgreSQL.Simple.SqlQQ.sql:\
<a name="line-54"></a> \ quasiquoter used in pattern context"</span>
<a name="line-55"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>quoteType</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>error</span> <span class='hs-str'>"Database.PostgreSQL.Simple.SqlQQ.sql:\
<a name="line-56"></a> \ quasiquoter used in type context"</span>
<a name="line-57"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>quoteExp</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>sqlExp</span>
<a name="line-58"></a> <span class='hs-layout'>,</span> <span class='hs-varid'>quoteDec</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>error</span> <span class='hs-str'>"Database.PostgreSQL.Simple.SqlQQ.sql:\
<a name="line-59"></a> \ quasiquoter used in declaration context"</span>
<a name="line-60"></a> <span class='hs-layout'>}</span>
<a name="line-61"></a>
<a name="line-62"></a><a name="sqlExp"></a><span class='hs-definition'>sqlExp</span> <span class='hs-keyglyph'>::</span> <span class='hs-conid'>String</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>Q</span> <span class='hs-conid'>Exp</span>
<a name="line-63"></a><span class='hs-definition'>sqlExp</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>stringE</span> <span class='hs-varop'>.</span> <span class='hs-varid'>minimizeSpace</span>
<a name="line-64"></a>
<a name="line-65"></a><a name="minimizeSpace"></a><span class='hs-definition'>minimizeSpace</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-66"></a><span class='hs-definition'>minimizeSpace</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>drop</span> <span class='hs-num'>1</span> <span class='hs-varop'>.</span> <span class='hs-varid'>reduceSpace</span>
<a name="line-67"></a> <span class='hs-keyword'>where</span>
<a name="line-68"></a> <span class='hs-varid'>needsReduced</span> <span class='hs-conid'>[]</span> <span class='hs-keyglyph'>=</span> <span class='hs-conid'>False</span>
<a name="line-69"></a> <span class='hs-varid'>needsReduced</span> <span class='hs-layout'>(</span><span class='hs-chr'>'-'</span><span class='hs-conop'>:</span><span class='hs-chr'>'-'</span><span class='hs-conop'>:</span><span class='hs-keyword'>_</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-conid'>True</span>
<a name="line-70"></a> <span class='hs-varid'>needsReduced</span> <span class='hs-layout'>(</span><span class='hs-varid'>x</span><span class='hs-conop'>:</span><span class='hs-keyword'>_</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>isSpace</span> <span class='hs-varid'>x</span>
<a name="line-71"></a>
<a name="line-72"></a> <span class='hs-varid'>reduceSpace</span> <span class='hs-varid'>xs</span> <span class='hs-keyglyph'>=</span>
<a name="line-73"></a> <span class='hs-keyword'>case</span> <span class='hs-varid'>dropWhile</span> <span class='hs-varid'>isSpace</span> <span class='hs-varid'>xs</span> <span class='hs-keyword'>of</span>
<a name="line-74"></a> <span class='hs-conid'>[]</span> <span class='hs-keyglyph'>-></span> <span class='hs-conid'>[]</span>
<a name="line-75"></a> <span class='hs-layout'>(</span><span class='hs-chr'>'-'</span><span class='hs-conop'>:</span><span class='hs-chr'>'-'</span><span class='hs-conop'>:</span><span class='hs-varid'>ys</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>-></span> <span class='hs-varid'>reduceSpace</span> <span class='hs-layout'>(</span><span class='hs-varid'>dropWhile</span> <span class='hs-layout'>(</span><span class='hs-varop'>/=</span> <span class='hs-chr'>'\n'</span><span class='hs-layout'>)</span> <span class='hs-varid'>ys</span><span class='hs-layout'>)</span>
<a name="line-76"></a> <span class='hs-varid'>ys</span> <span class='hs-keyglyph'>-></span> <span class='hs-chr'>' '</span> <span class='hs-conop'>:</span> <span class='hs-varid'>insql</span> <span class='hs-varid'>ys</span>
<a name="line-77"></a>
<a name="line-78"></a> <span class='hs-varid'>insql</span> <span class='hs-layout'>(</span><span class='hs-chr'>'\''</span><span class='hs-conop'>:</span><span class='hs-varid'>xs</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-chr'>'\''</span> <span class='hs-conop'>:</span> <span class='hs-varid'>instring</span> <span class='hs-varid'>xs</span>
<a name="line-79"></a> <span class='hs-varid'>insql</span> <span class='hs-varid'>xs</span> <span class='hs-keyglyph'>|</span> <span class='hs-varid'>needsReduced</span> <span class='hs-varid'>xs</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>reduceSpace</span> <span class='hs-varid'>xs</span>
<a name="line-80"></a> <span class='hs-varid'>insql</span> <span class='hs-layout'>(</span><span class='hs-varid'>x</span><span class='hs-conop'>:</span><span class='hs-varid'>xs</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>x</span> <span class='hs-conop'>:</span> <span class='hs-varid'>insql</span> <span class='hs-varid'>xs</span>
<a name="line-81"></a> <span class='hs-varid'>insql</span> <span class='hs-conid'>[]</span> <span class='hs-keyglyph'>=</span> <span class='hs-conid'>[]</span>
<a name="line-82"></a>
<a name="line-83"></a> <span class='hs-varid'>instring</span> <span class='hs-layout'>(</span><span class='hs-chr'>'\''</span><span class='hs-conop'>:</span><span class='hs-chr'>'\''</span><span class='hs-conop'>:</span><span class='hs-varid'>xs</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-chr'>'\''</span><span class='hs-conop'>:</span><span class='hs-chr'>'\''</span><span class='hs-conop'>:</span> <span class='hs-varid'>instring</span> <span class='hs-varid'>xs</span>
<a name="line-84"></a> <span class='hs-varid'>instring</span> <span class='hs-layout'>(</span><span class='hs-chr'>'\''</span><span class='hs-conop'>:</span><span class='hs-varid'>xs</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-chr'>'\''</span><span class='hs-conop'>:</span> <span class='hs-varid'>insql</span> <span class='hs-varid'>xs</span>
<a name="line-85"></a> <span class='hs-varid'>instring</span> <span class='hs-layout'>(</span><span class='hs-varid'>x</span><span class='hs-conop'>:</span><span class='hs-varid'>xs</span><span class='hs-layout'>)</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>x</span> <span class='hs-conop'>:</span> <span class='hs-varid'>instring</span> <span class='hs-varid'>xs</span>
<a name="line-86"></a> <span class='hs-varid'>instring</span> <span class='hs-conid'>[]</span> <span class='hs-keyglyph'>=</span> <span class='hs-varid'>error</span> <span class='hs-str'>"Database.PostgreSQL.Simple.SqlQQ.sql:\
<a name="line-87"></a> \ string literal not terminated"</span>
</pre></body>
</html>
|