opaleye-0.6.7003.1: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell2010

Opaleye.SqlTypes

Documentation

type SqlRange = PGRange #

type SqlJsonb = PGJsonb #

type SqlJson = PGJson #

type SqlBytea = PGBytea #

type SqlArray = PGArray #

type SqlCitext = PGCitext #

type SqlUuid = PGUuid #

type SqlTimestamptz = PGTimestamptz #

type SqlTimestamp = PGTimestamp #

type SqlTime = PGTime #

type SqlText = PGText #

type SqlNumeric = PGNumeric #

type SqlInt2 = PGInt2 #

type SqlInt4 = PGInt4 #

type SqlInt8 = PGInt8 #

type SqlFloat8 = PGFloat8 #

type SqlFloat4 = PGFloat4 #

type SqlDate = PGDate #

type SqlBool = PGBool #

sqlString :: String -> Field SqlText #

sqlLazyByteString :: ByteString -> Field SqlBytea #

sqlStrictByteString :: ByteString -> Field SqlBytea #

sqlStrictText :: Text -> Field SqlText #

sqlLazyText :: Text -> Field SqlText #

sqlNumeric :: Scientific -> Field SqlNumeric #

sqlInt4 :: Int -> Field SqlInt4 #

sqlInt8 :: Int64 -> Field SqlInt8 #

sqlDouble :: Double -> Field SqlFloat8 #

sqlBool :: Bool -> Field SqlBool #

sqlUUID :: UUID -> Field SqlUuid #

sqlDay :: Day -> Field SqlDate #

sqlUTCTime :: UTCTime -> Field SqlTimestamptz #

sqlLocalTime :: LocalTime -> Field SqlTimestamp #

sqlZonedTime :: ZonedTime -> Field SqlTimestamptz #

sqlTimeOfDay :: TimeOfDay -> Field SqlTime #

sqlCiStrictText :: CI Text -> Field SqlCitext #

sqlCiLazyText :: CI Text -> Field SqlCitext #

sqlJSON :: String -> Field SqlJson #

sqlStrictJSON :: ByteString -> Field SqlJson #

sqlLazyJSON :: ByteString -> Field SqlJson #

sqlValueJSON :: ToJSON a => a -> Field SqlJson #

sqlJSONB :: String -> Field SqlJsonb #

sqlStrictJSONB :: ByteString -> Field SqlJsonb #

sqlLazyJSONB :: ByteString -> Field SqlJsonb #

sqlValueJSONB :: ToJSON a => a -> Field SqlJsonb #

sqlArray :: IsSqlType b => (a -> Field b) -> [a] -> Field (SqlArray b) #

sqlRange :: IsRangeType b => (a -> Field b) -> RangeBound a -> RangeBound a -> Field (SqlRange b) #

class IsSqlType sqlType #

Instances
IsSqlType PGJsonb # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGJsonb -> String #

showSqlType :: proxy PGJsonb -> String #

IsSqlType PGJson # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGJson -> String #

showSqlType :: proxy PGJson -> String #

IsSqlType PGBytea # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGBytea -> String #

showSqlType :: proxy PGBytea -> String #

IsSqlType PGCitext # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGCitext -> String #

showSqlType :: proxy PGCitext -> String #

IsSqlType PGUuid # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGUuid -> String #

showSqlType :: proxy PGUuid -> String #

IsSqlType PGTimestamptz # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTimestamptz -> String #

showSqlType :: proxy PGTimestamptz -> String #

IsSqlType PGTimestamp # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTimestamp -> String #

showSqlType :: proxy PGTimestamp -> String #

IsSqlType PGTime # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTime -> String #

showSqlType :: proxy PGTime -> String #

IsSqlType PGText # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGText -> String #

showSqlType :: proxy PGText -> String #

IsSqlType PGNumeric # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGNumeric -> String #

showSqlType :: proxy PGNumeric -> String #

IsSqlType PGInt2 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt2 -> String #

showSqlType :: proxy PGInt2 -> String #

IsSqlType PGInt4 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt4 -> String #

showSqlType :: proxy PGInt4 -> String #

IsSqlType PGInt8 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt8 -> String #

showSqlType :: proxy PGInt8 -> String #

IsSqlType PGFloat8 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGFloat8 -> String #

showSqlType :: proxy PGFloat8 -> String #

IsSqlType PGFloat4 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGFloat4 -> String #

showSqlType :: proxy PGFloat4 -> String #

IsSqlType PGDate # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGDate -> String #

showSqlType :: proxy PGDate -> String #

IsSqlType PGBool # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGBool -> String #

showSqlType :: proxy PGBool -> String #

IsSqlType a => IsSqlType (Nullable a) # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy (Nullable a) -> String #

showSqlType :: proxy (Nullable a) -> String #

IsRangeType a => IsSqlType (PGRange a) # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy (PGRange a) -> String #

showSqlType :: proxy (PGRange a) -> String #

IsSqlType a => IsSqlType (PGArray a) # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy (PGArray a) -> String #

showSqlType :: proxy (PGArray a) -> String #

class IsSqlType pgType => IsRangeType pgType #

Minimal complete definition

showRangeType

Instances
IsRangeType PGTimestamptz # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGTimestamptz -> String #

IsRangeType PGTimestamp # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGTimestamp -> String #

IsRangeType PGNumeric # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGNumeric -> String #

IsRangeType PGInt4 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGInt4 -> String #

IsRangeType PGInt8 # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGInt8 -> String #

IsRangeType PGDate # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGDate -> String #