Safe Haskell | None |
---|---|
Language | Haskell2010 |
Use Opaleye.SqlTypes instead. Will be deprecated in version 0.7.
Synopsis
- data PGRange a
- data PGJsonb
- data PGJson
- data PGBytea
- data PGArray a
- data PGCitext
- data PGUuid
- data PGTimestamptz
- data PGTimestamp
- data PGTime
- data PGText
- data PGNumeric
- data PGInt2
- data PGInt4
- data PGInt8
- data PGFloat8
- data PGFloat4
- data PGDate
- data PGBool
- class IsSqlType pgType => IsRangeType pgType where
- showRangeType :: proxy pgType -> String
- pgString :: String -> Column PGText
- pgLazyByteString :: ByteString -> Column PGBytea
- pgStrictByteString :: ByteString -> Column PGBytea
- pgStrictText :: Text -> Column PGText
- pgLazyText :: Text -> Column PGText
- pgNumeric :: Scientific -> Column PGNumeric
- pgInt4 :: Int -> Column PGInt4
- pgInt8 :: Int64 -> Column PGInt8
- pgDouble :: Double -> Column PGFloat8
- pgBool :: Bool -> Column PGBool
- pgUUID :: UUID -> Column PGUuid
- pgDay :: Day -> Column PGDate
- pgUTCTime :: UTCTime -> Column PGTimestamptz
- pgLocalTime :: LocalTime -> Column PGTimestamp
- pgZonedTime :: ZonedTime -> Column PGTimestamptz
- pgTimeOfDay :: TimeOfDay -> Column PGTime
- pgCiStrictText :: CI Text -> Column PGCitext
- pgCiLazyText :: CI Text -> Column PGCitext
- pgJSON :: String -> Column PGJson
- pgStrictJSON :: ByteString -> Column PGJson
- pgLazyJSON :: ByteString -> Column PGJson
- pgValueJSON :: ToJSON a => a -> Column PGJson
- pgJSONB :: String -> Column PGJsonb
- pgStrictJSONB :: ByteString -> Column PGJsonb
- pgLazyJSONB :: ByteString -> Column PGJsonb
- pgValueJSONB :: ToJSON a => a -> Column PGJsonb
- pgArray :: forall a b. IsSqlType b => (a -> Column b) -> [a] -> Column (PGArray b)
- pgRange :: forall a b. IsRangeType b => (a -> Column b) -> RangeBound a -> RangeBound a -> Column (PGRange b)
- literalColumn :: Literal -> Column a
- unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c
- class IsSqlType sqlType where
- showPGType :: proxy sqlType -> String
- showSqlType :: proxy sqlType -> String
Documentation
Instances
Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source # | |
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source # | |
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source # | |
Defined in Opaleye.Constant def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) # | |
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source # | |
Defined in Opaleye.Constant | |
Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source # | |
Defined in Opaleye.Constant | |
Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source # | |
IsRangeType a => IsSqlType (PGRange a) Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy (PGRange a) -> String Source # showSqlType :: proxy (PGRange a) -> String Source # | |
(Typeable b, FromField b, DefaultFromField a b) => QueryRunnerColumnDefault (PGRange a) (PGRange b) Source # | |
Defined in Opaleye.Internal.RunQuery |
Instances
IsSqlType PGJsonb Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGJsonb -> String Source # showSqlType :: proxy PGJsonb -> String Source # | |
PGIsJson SqlJsonb Source # | |
Defined in Opaleye.Operators | |
QueryRunnerColumnDefault PGJsonb Value Source # | |
QueryRunnerColumnDefault PGJsonb String Source # | |
Default ToFields ByteString (Column SqlJsonb) Source # | |
Defined in Opaleye.Constant | |
Default ToFields ByteString (Column SqlJsonb) Source # | |
Defined in Opaleye.Constant | |
Default ToFields Value (Column SqlJsonb) Source # | |
type Map Nulled (Column PGJsonb) Source # | |
Instances
IsSqlType PGJson Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGJson -> String Source # showSqlType :: proxy PGJson -> String Source # | |
PGIsJson SqlJson Source # | |
Defined in Opaleye.Operators | |
QueryRunnerColumnDefault PGJson Value Source # | |
QueryRunnerColumnDefault PGJson String Source # | |
Default ToFields ByteString (Column SqlJson) Source # | |
Defined in Opaleye.Constant | |
Default ToFields ByteString (Column SqlJson) Source # | |
Defined in Opaleye.Constant | |
Default ToFields Value (Column SqlJson) Source # | |
type Map Nulled (Column PGJson) Source # | |
Instances
IsSqlType PGBytea Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGBytea -> String Source # showSqlType :: proxy PGBytea -> String Source # | |
QueryRunnerColumnDefault PGBytea ByteString Source # | |
QueryRunnerColumnDefault PGBytea ByteString Source # | |
Default ToFields ByteString (Column SqlBytea) Source # | |
Defined in Opaleye.Constant | |
Default ToFields ByteString (Column SqlBytea) Source # | |
Defined in Opaleye.Constant | |
bytestring ~ ByteString => Default (Inferrable FromField) SqlBytea bytestring Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlBytea bytestring # | |
type Map Nulled (Column PGBytea) Source # | |
Instances
(Default ToFields a (Column b), IsSqlType b) => Default ToFields [a] (Column (SqlArray b)) Source # | |
IsSqlType a => IsSqlType (PGArray a) Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy (PGArray a) -> String Source # showSqlType :: proxy (PGArray a) -> String Source # | |
(Typeable b, DefaultFromField a b) => QueryRunnerColumnDefault (PGArray a) [b] Source # | |
Defined in Opaleye.Internal.RunQuery queryRunnerColumnDefault :: FromField (PGArray a) [b] Source # defaultFromField :: FromField (PGArray a) [b] Source # | |
(Typeable h, Default (Inferrable FromField) f h, hs ~ [h]) => Default (Inferrable FromField) (SqlArray f) hs Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField (SqlArray f) hs # |
Instances
PGString PGCitext Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGCitext Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGCitext -> String Source # showSqlType :: proxy PGCitext -> String Source # | |
PGOrd SqlCitext Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGCitext (CI Text) Source # | |
Defined in Opaleye.Internal.RunQuery | |
QueryRunnerColumnDefault PGCitext (CI Text) Source # | |
Defined in Opaleye.Internal.RunQuery | |
Default ToFields (CI Text) (Column SqlCitext) Source # | |
Default ToFields (CI Text) (Column SqlCitext) Source # | |
cttext ~ CI Text => Default (Inferrable FromField) SqlCitext cttext Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlCitext cttext # | |
type Map Nulled (Column PGCitext) Source # | |
Instances
IsSqlType PGUuid Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGUuid -> String Source # showSqlType :: proxy PGUuid -> String Source # | |
PGOrd SqlUuid Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGUuid UUID Source # | |
Default ToFields UUID (Column SqlUuid) Source # | |
uuid ~ UUID => Default (Inferrable FromField) SqlUuid uuid Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlUuid uuid # | |
type Map Nulled (Column PGUuid) Source # | |
data PGTimestamptz Source #
Instances
IsSqlType PGTimestamptz Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGTimestamptz -> String Source # showSqlType :: proxy PGTimestamptz -> String Source # | |
IsRangeType PGTimestamptz Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGTimestamptz -> String Source # | |
PGOrd SqlTimestamptz Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGTimestamptz UTCTime Source # | |
QueryRunnerColumnDefault PGTimestamptz ZonedTime Source # | |
Default ToFields UTCTime (Column SqlTimestamptz) Source # | |
Defined in Opaleye.Constant | |
Default ToFields ZonedTime (Column SqlTimestamptz) Source # | |
Defined in Opaleye.Constant | |
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source # | |
Defined in Opaleye.Constant | |
type Map Nulled (Column PGTimestamptz) Source # | |
Defined in Opaleye.Internal.Join |
data PGTimestamp Source #
Instances
IsSqlType PGTimestamp Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGTimestamp -> String Source # showSqlType :: proxy PGTimestamp -> String Source # | |
IsRangeType PGTimestamp Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGTimestamp -> String Source # | |
PGOrd SqlTimestamp Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGTimestamp LocalTime Source # | |
Default ToFields LocalTime (Column SqlTimestamp) Source # | |
Defined in Opaleye.Constant | |
Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source # | |
Defined in Opaleye.Constant | |
localtime ~ LocalTime => Default (Inferrable FromField) SqlTimestamp localtime Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlTimestamp localtime # | |
type Map Nulled (Column PGTimestamp) Source # | |
Defined in Opaleye.Internal.Join |
Instances
IsSqlType PGTime Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGTime -> String Source # showSqlType :: proxy PGTime -> String Source # | |
PGOrd SqlTime Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGTime TimeOfDay Source # | |
Default ToFields TimeOfDay (Column SqlTime) Source # | |
timeofday ~ TimeOfDay => Default (Inferrable FromField) SqlTime timeofday Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlTime timeofday # | |
type Map Nulled (Column PGTime) Source # | |
Instances
PGString PGText Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGText Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGText -> String Source # showSqlType :: proxy PGText -> String Source # | |
PGOrd SqlText Source # | |
Defined in Opaleye.Order | |
PGJsonIndex SqlText Source # | |
Defined in Opaleye.Operators | |
QueryRunnerColumnDefault PGText Text Source # | |
QueryRunnerColumnDefault PGText Text Source # | |
QueryRunnerColumnDefault PGText String Source # | |
Default ToFields Text (Column SqlText) Source # | |
Default ToFields Text (Column SqlText) Source # | |
Default ToFields String (Column SqlText) Source # | |
text ~ Text => Default (Inferrable FromField) SqlText text Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlText text # | |
type Map Nulled (Column PGText) Source # | |
type Map Nulled (Column PGText) Source # | |
Instances
PGIntegral PGNumeric Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGNumeric Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGNumeric -> String Source # showSqlType :: proxy PGNumeric -> String Source # | |
IsRangeType PGNumeric Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGNumeric -> String Source # | |
PGOrd SqlNumeric Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGNumeric Scientific Source # | |
Default ToFields Scientific (Column SqlNumeric) Source # | |
Defined in Opaleye.Constant def :: ToFields Scientific (Column SqlNumeric) # | |
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source # | |
Defined in Opaleye.Constant def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) # | |
scientific ~ Scientific => Default (Inferrable FromField) SqlNumeric scientific Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlNumeric scientific # |
Instances
PGIntegral PGInt2 Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGInt2 Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGInt2 -> String Source # showSqlType :: proxy PGInt2 -> String Source # | |
PGOrd SqlInt2 Source # | |
Defined in Opaleye.Order |
Instances
PGIntegral PGInt4 Source # | |
Defined in Opaleye.PGTypes | |
PGNum PGInt4 Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGInt4 Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGInt4 -> String Source # showSqlType :: proxy PGInt4 -> String Source # | |
IsRangeType PGInt4 Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGInt4 -> String Source # | |
PGOrd SqlInt4 Source # | |
Defined in Opaleye.Order | |
PGJsonIndex SqlInt4 Source # | |
Defined in Opaleye.Operators | |
QueryRunnerColumnDefault PGInt4 Int Source # | |
QueryRunnerColumnDefault PGInt4 Int32 Source # | |
Default ToFields Int (Column SqlInt4) Source # | |
Default ToFields Int32 (Column SqlInt4) Source # | |
Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source # | |
int ~ Int => Default (Inferrable FromField) SqlInt4 int Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlInt4 int # | |
type Map Nulled (Column PGInt4) Source # | |
Instances
PGIntegral PGInt8 Source # | |
Defined in Opaleye.PGTypes | |
PGNum PGInt8 Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGInt8 Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGInt8 -> String Source # showSqlType :: proxy PGInt8 -> String Source # | |
IsRangeType PGInt8 Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGInt8 -> String Source # | |
PGOrd SqlInt8 Source # | |
Defined in Opaleye.Order | |
PGJsonIndex SqlInt8 Source # | |
Defined in Opaleye.Operators | |
QueryRunnerColumnDefault PGInt8 Int64 Source # | |
Default ToFields Int64 (Column SqlInt8) Source # | |
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source # | |
int64 ~ Int64 => Default (Inferrable FromField) SqlInt8 int64 Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlInt8 int64 # | |
type Map Nulled (Column PGInt8) Source # | |
Instances
PGFractional PGFloat8 Source # | |
Defined in Opaleye.PGTypes | |
PGNum PGFloat8 Source # | |
Defined in Opaleye.PGTypes | |
IsSqlType PGFloat8 Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGFloat8 -> String Source # showSqlType :: proxy PGFloat8 -> String Source # | |
PGOrd SqlFloat8 Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGFloat8 Double Source # | |
Default ToFields Double (Column SqlFloat8) Source # | |
double ~ Double => Default (Inferrable FromField) SqlFloat8 double Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlFloat8 double # | |
type Map Nulled (Column PGFloat8) Source # | |
Instances
IsSqlType PGFloat4 Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGFloat4 -> String Source # showSqlType :: proxy PGFloat4 -> String Source # | |
PGOrd SqlFloat4 Source # | |
Defined in Opaleye.Order |
Instances
IsSqlType PGDate Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGDate -> String Source # showSqlType :: proxy PGDate -> String Source # | |
IsRangeType PGDate Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGDate -> String Source # | |
PGOrd SqlDate Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGDate Day Source # | |
Default ToFields Day (Column SqlDate) Source # | |
Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source # | |
day ~ Day => Default (Inferrable FromField) SqlDate day Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlDate day # | |
type Map Nulled (Column PGDate) Source # | |
Instances
IsSqlType PGBool Source # | |
Defined in Opaleye.PGTypes showPGType :: proxy PGBool -> String Source # showSqlType :: proxy PGBool -> String Source # | |
PGOrd SqlBool Source # | |
Defined in Opaleye.Order | |
QueryRunnerColumnDefault PGBool Bool Source # | |
Default ToFields Bool (Column SqlBool) Source # | |
bool ~ Bool => Default (Inferrable FromField) SqlBool bool Source # | |
Defined in Opaleye.Internal.Inferrable def :: Inferrable FromField SqlBool bool # | |
type Map Nulled (Column PGBool) Source # | |
class IsSqlType pgType => IsRangeType pgType where Source #
showRangeType :: proxy pgType -> String Source #
Instances
IsRangeType PGTimestamptz Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGTimestamptz -> String Source # | |
IsRangeType PGTimestamp Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGTimestamp -> String Source # | |
IsRangeType PGNumeric Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGNumeric -> String Source # | |
IsRangeType PGInt4 Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGInt4 -> String Source # | |
IsRangeType PGInt8 Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGInt8 -> String Source # | |
IsRangeType PGDate Source # | |
Defined in Opaleye.PGTypes showRangeType :: proxy PGDate -> String Source # |
pgLocalTime :: LocalTime -> Column PGTimestamp Source #
pgStrictJSON :: ByteString -> Column PGJson Source #
pgLazyJSON :: ByteString -> Column PGJson Source #
pgStrictJSONB :: ByteString -> Column PGJsonb Source #
pgLazyJSONB :: ByteString -> Column PGJsonb Source #
pgRange :: forall a b. IsRangeType b => (a -> Column b) -> RangeBound a -> RangeBound a -> Column (PGRange b) Source #
literalColumn :: Literal -> Column a Source #
Deprecated: literalColumn
has been moved to Opaleye.Internal.PGTypes and will be removed in version 0.7.
unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c Source #
Deprecated: unsafePgFormatTime
has been moved to Opaleye.Internal.PGTypes and will be removed in version 0.7.
class IsSqlType sqlType where Source #
showPGType :: proxy sqlType -> String Source #
Deprecated: Use showSqlType
instead. showPGType
will be removed in version 0.7.
showSqlType :: proxy sqlType -> String Source #