mysql-simple-0.4.7.2: A mid-level MySQL client library.
Copyright(c) 2011 MailRank Inc.
LicenseBSD3
MaintainerPaul Rouse <[email protected]>
Stabilityexperimental
Portabilityportable
Safe HaskellNone
LanguageHaskell2010

Database.MySQL.Simple.Result

Description

The Result typeclass, for converting a single value in a row returned by a SQL query into a more useful Haskell representation.

A Haskell numeric type is considered to be compatible with all MySQL numeric types that are less accurate than it. For instance, the Haskell Double type is compatible with the MySQL Long type because it can represent a Long exactly. On the other hand, since a Double might lose precision if representing a LongLong, the two are not considered compatible.

Synopsis

Documentation

class Result a where Source #

A type that may be converted from a SQL type.

Methods

convert :: Field -> Maybe ByteString -> a Source #

Convert a SQL value to a Haskell value.

Throws a ResultError if conversion fails.

Instances

Instances details
Result Bool Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Double Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Float Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Int Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Int8 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Int16 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Int32 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Int64 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Integer Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Word Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Word8 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Word16 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Word32 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Word64 Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result ByteString Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result ByteString Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Text Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Text Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result TimeOfDay Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result UTCTime Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result Day Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result [Char] Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result a => Result (Maybe a) Source # 
Instance details

Defined in Database.MySQL.Simple.Result

Result (Ratio Integer) Source # 
Instance details

Defined in Database.MySQL.Simple.Result

data ResultError Source #

Exception thrown if conversion from a SQL value to a Haskell value fails.

Constructors

Incompatible

The SQL and Haskell types are not compatible.

UnexpectedNull

A SQL NULL was encountered when the Haskell type did not permit it.

ConversionFailed

The SQL value could not be parsed, or could not be represented as a valid Haskell value, or an unexpected low-level error occurred (e.g. mismatch between metadata and actual data in a row).