Takusen-0.8.4: doc/html/Database-Util.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--Rendered using the Haskell Html Library v0.2-->
<HTML
><HEAD
><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"
><TITLE
>Database.Util</TITLE
><LINK HREF="haddock.css" REL="stylesheet" TYPE="text/css"
><SCRIPT SRC="haddock.js" TYPE="text/javascript"
></SCRIPT
></HEAD
><BODY
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="topbar"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD
><IMG SRC="haskell_icon.gif" WIDTH="16" HEIGHT="16" ALT=" "
></TD
><TD CLASS="title"
>Takusen-0.8.2: Database library with left-fold interface, for PostgreSQL, Oracle, SQLite, ODBC.</TD
><TD CLASS="topbut"
><A HREF="index.html"
>Contents</A
></TD
><TD CLASS="topbut"
><A HREF="doc-index.html"
>Index</A
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="modulebar"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD
><FONT SIZE="6"
>Database.Util</FONT
></TD
><TD ALIGN="right"
><TABLE CLASS="narrow" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="infohead"
>Portability</TD
><TD CLASS="infoval"
>non-portable</TD
></TR
><TR
><TD CLASS="infohead"
>Stability</TD
><TD CLASS="infoval"
>experimental</TD
></TR
><TR
><TD CLASS="infohead"
>Maintainer</TD
><TD CLASS="infoval"
>oleg@pobox.com, alistair@abayley.org</TD
></TR
></TABLE
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Description</TD
></TR
><TR
><TD CLASS="doc"
>Utility functions. Mostly used in database back-ends, and tests.
</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Synopsis</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>class</SPAN
> Show a => <A HREF="#t%3AMyShow"
>MyShow</A
> a <SPAN CLASS="keyword"
>where</SPAN
></TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><A HREF="#v%3Ashow_"
>show_</A
> :: a -> String</TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3Aprint_"
>print_</A
> :: (MonadIO m, <A HREF="Database-Util.html#t%3AMyShow"
>MyShow</A
> a) => a -> m ()</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AmkUTCTime"
>mkUTCTime</A
> :: (Integral a, Real b) => a -> a -> a -> a -> a -> b -> UTCTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AmkCalTime"
>mkCalTime</A
> :: Integral a => a -> a -> a -> a -> a -> a -> CalendarTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3Aint64ToDateParts"
>int64ToDateParts</A
> :: Int64 -> (Int64, Int64, Int64, Int64, Int64, Int64)</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AdatePartsToInt64"
>datePartsToInt64</A
> :: (Integral a1, Integral a2, Integral a3, Integral a4, Integral a5, Integral a6) => (a1, a2, a3, a4, a5, a6) -> Int64</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AcalTimeToInt64"
>calTimeToInt64</A
> :: CalendarTime -> Int64</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3Aint64ToCalTime"
>int64ToCalTime</A
> :: Int64 -> CalendarTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3Aint64ToUTCTime"
>int64ToUTCTime</A
> :: Int64 -> UTCTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AwordsBy"
>wordsBy</A
> :: (Char -> Bool) -> String -> [String]</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AskipNonMatch"
>skipNonMatch</A
> :: (Char -> Bool) -> String -> [String]</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3Apositions"
>positions</A
> :: Eq a => [a] -> [a] -> [Int]</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3ApgDatetimetoUTCTime"
>pgDatetimetoUTCTime</A
> :: String -> UTCTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3ApgDatetimetoCalTime"
>pgDatetimetoCalTime</A
> :: String -> CalendarTime</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3ApgDatetimeToParts"
>pgDatetimeToParts</A
> :: String -> (Int, Int, Int, Int, Int, Double, Int)</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AutcTimeToIsoString"
>utcTimeToIsoString</A
> :: (Integral a, Integral b) => UTCTime -> String -> (a -> a) -> (b -> String) -> String</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AutcTimeToPGDatetime"
>utcTimeToPGDatetime</A
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AutcTimeToIsoDatetime"
>utcTimeToIsoDatetime</A
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AutcTimeToOdbcDatetime"
>utcTimeToOdbcDatetime</A
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="decl"
><A HREF="#v%3AcalTimeToPGDatetime"
>calTimeToPGDatetime</A
> :: CalendarTime -> String</TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="section1"
>Documentation</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><SPAN CLASS="keyword"
>class</SPAN
> Show a => <A NAME="t%3AMyShow"
></A
><B
>MyShow</B
> a <SPAN CLASS="keyword"
>where</SPAN
></TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="section4"
>Methods</TD
></TR
><TR
><TD CLASS="body"
><TABLE CLASS="vanilla" CELLSPACING="0" CELLPADDING="0"
><TR
><TD CLASS="decl"
><A NAME="v%3Ashow_"
></A
><B
>show_</B
> :: a -> String</TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s8"
></TD
></TR
><TR
><TD CLASS="section4"
><IMG SRC="minus.gif" CLASS="coll" ONCLICK="toggle(this,'i:MyShow')" ALT="show/hide"
> Instances</TD
></TR
><TR
><TD CLASS="body"
><DIV ID="i:MyShow" STYLE="display:block;"
><TABLE CLASS="vanilla" CELLSPACING="1" CELLPADDING="0"
><TR
><TD CLASS="decl"
><A HREF="Database-Util.html#t%3AMyShow"
>MyShow</A
> String</TD
></TR
><TR
><TD CLASS="decl"
>Show a => <A HREF="Database-Util.html#t%3AMyShow"
>MyShow</A
> a</TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
></TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3Aprint_"
></A
><B
>print_</B
> :: (MonadIO m, <A HREF="Database-Util.html#t%3AMyShow"
>MyShow</A
> a) => a -> m ()</TD
></TR
><TR
><TD CLASS="doc"
>Like <TT
><A HREF="System-IO.html#v%3Aprint"
>print</A
></TT
>, except that Strings are not escaped or quoted.
</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AmkUTCTime"
></A
><B
>mkUTCTime</B
> :: (Integral a, Real b) => a -> a -> a -> a -> a -> b -> UTCTime</TD
></TR
><TR
><TD CLASS="doc"
>Convenience for making UTCTimes. Assumes the time given is already UTC time
i.e. there's no timezone adjustment.
</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AmkCalTime"
></A
><B
>mkCalTime</B
> :: Integral a => a -> a -> a -> a -> a -> a -> CalendarTime</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3Aint64ToDateParts"
></A
><B
>int64ToDateParts</B
> :: Int64 -> (Int64, Int64, Int64, Int64, Int64, Int64)</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AdatePartsToInt64"
></A
><B
>datePartsToInt64</B
> :: (Integral a1, Integral a2, Integral a3, Integral a4, Integral a5, Integral a6) => (a1, a2, a3, a4, a5, a6) -> Int64</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AcalTimeToInt64"
></A
><B
>calTimeToInt64</B
> :: CalendarTime -> Int64</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3Aint64ToCalTime"
></A
><B
>int64ToCalTime</B
> :: Int64 -> CalendarTime</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3Aint64ToUTCTime"
></A
><B
>int64ToUTCTime</B
> :: Int64 -> UTCTime</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AwordsBy"
></A
><B
>wordsBy</B
> :: (Char -> Bool) -> String -> [String]</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AskipNonMatch"
></A
><B
>skipNonMatch</B
> :: (Char -> Bool) -> String -> [String]</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3Apositions"
></A
><B
>positions</B
> :: Eq a => [a] -> [a] -> [Int]</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3ApgDatetimetoUTCTime"
></A
><B
>pgDatetimetoUTCTime</B
> :: String -> UTCTime</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3ApgDatetimetoCalTime"
></A
><B
>pgDatetimetoCalTime</B
> :: String -> CalendarTime</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3ApgDatetimeToParts"
></A
><B
>pgDatetimeToParts</B
> :: String -> (Int, Int, Int, Int, Int, Double, Int)</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AutcTimeToIsoString"
></A
><B
>utcTimeToIsoString</B
> :: (Integral a, Integral b) => UTCTime -> String -> (a -> a) -> (b -> String) -> String</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AutcTimeToPGDatetime"
></A
><B
>utcTimeToPGDatetime</B
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AutcTimeToIsoDatetime"
></A
><B
>utcTimeToIsoDatetime</B
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AutcTimeToOdbcDatetime"
></A
><B
>utcTimeToOdbcDatetime</B
> :: UTCTime -> String</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="decl"
><A NAME="v%3AcalTimeToPGDatetime"
></A
><B
>calTimeToPGDatetime</B
> :: CalendarTime -> String</TD
></TR
><TR
><TD CLASS="doc"
>Assumes CalendarTime is also UTC i.e. ignores ctTZ component.
</TD
></TR
><TR
><TD CLASS="s15"
></TD
></TR
><TR
><TD CLASS="botbar"
>Produced by <A HREF="http://www.haskell.org/haddock/"
>Haddock</A
> version 0.7</TD
></TR
></TABLE
></BODY
></HTML
>