Safe Haskell	Safe-Inferred
Language	Haskell2010

Database.DuckDB.Simple.ToField

Description

The ToField class mirrors the interface provided by sqlite-simple while delegating to the DuckDB C API under the hood.

Synopsis

data FieldBinding
class DuckDBColumnType a => ToField a where
- toField :: a -> FieldBinding
class DuckDBColumnType a where
- duckdbColumnTypeFor :: Proxy a -> Text
data NamedParam where
- (:=) :: ToField a => Text -> a -> NamedParam
duckdbColumnType :: forall a. DuckDBColumnType a => Proxy a -> Text
bindFieldBinding :: Statement -> DuckDBIdx -> FieldBinding -> IO ()
renderFieldBinding :: FieldBinding -> String

Documentation

data FieldBinding Source #

Encapsulates the action required to bind a single positional parameter, together with a textual description used in diagnostics.

class DuckDBColumnType a => ToField a where Source #

Types that can be used as positional parameters.

Methods

toField :: a -> FieldBinding Source #

Instances

Instances details

ToField Int16 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Int16 -> FieldBinding Source #

ToField Int32 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Int32 -> FieldBinding Source #

ToField Int64 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Int64 -> FieldBinding Source #

ToField Word16 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Word16 -> FieldBinding Source #

ToField Word32 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Word32 -> FieldBinding Source #

ToField Word64 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Word64 -> FieldBinding Source #

ToField Word8 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Word8 -> FieldBinding Source #

ToField ByteString Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: ByteString -> FieldBinding Source #

ToField BigNum Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: BigNum -> FieldBinding Source #

ToField BitString Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: BitString -> FieldBinding Source #

ToField Null Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Null -> FieldBinding Source #

ToField Text Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Text -> FieldBinding Source #

ToField Day Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Day -> FieldBinding Source #

ToField UTCTime Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: UTCTime -> FieldBinding Source #

ToField LocalTime Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: LocalTime -> FieldBinding Source #

ToField TimeOfDay Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: TimeOfDay -> FieldBinding Source #

ToField UUID Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: UUID -> FieldBinding Source #

ToField String Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: String -> FieldBinding Source #

ToField Integer Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Integer -> FieldBinding Source #

ToField Natural Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Natural -> FieldBinding Source #

ToField Bool Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Bool -> FieldBinding Source #

ToField Double Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Double -> FieldBinding Source #

ToField Float Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Float -> FieldBinding Source #

ToField Int Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Int -> FieldBinding Source #

ToField Word Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Word -> FieldBinding Source #

ToField a => ToField (Maybe a) Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

toField :: Maybe a -> FieldBinding Source #

class DuckDBColumnType a where Source #

Types that map to a concrete DuckDB column type when used with ToField .

Methods

duckdbColumnTypeFor :: Proxy a -> Text Source #

Instances

Instances details

DuckDBColumnType Int16 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Int16 -> Text Source #

DuckDBColumnType Int32 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Int32 -> Text Source #

DuckDBColumnType Int64 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Int64 -> Text Source #

DuckDBColumnType Word16 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Word16 -> Text Source #

DuckDBColumnType Word32 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Word32 -> Text Source #

DuckDBColumnType Word64 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Word64 -> Text Source #

DuckDBColumnType Word8 Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Word8 -> Text Source #

DuckDBColumnType ByteString Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy ByteString -> Text Source #

DuckDBColumnType BigNum Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy BigNum -> Text Source #

DuckDBColumnType BitString Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy BitString -> Text Source #

DuckDBColumnType Null Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Null -> Text Source #

DuckDBColumnType Text Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Text -> Text Source #

DuckDBColumnType Day Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Day -> Text Source #

DuckDBColumnType UTCTime Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy UTCTime -> Text Source #

DuckDBColumnType LocalTime Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy LocalTime -> Text Source #

DuckDBColumnType TimeOfDay Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy TimeOfDay -> Text Source #

DuckDBColumnType UUID Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy UUID -> Text Source #

DuckDBColumnType String Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy String -> Text Source #

DuckDBColumnType Integer Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Integer -> Text Source #

DuckDBColumnType Natural Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Natural -> Text Source #

DuckDBColumnType Bool Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Bool -> Text Source #

DuckDBColumnType Double Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Double -> Text Source #

DuckDBColumnType Float Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Float -> Text Source #

DuckDBColumnType Int Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Int -> Text Source #

DuckDBColumnType Word Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy Word -> Text Source #

DuckDBColumnType a => DuckDBColumnType (Maybe a) Source #

Instance details

Defined in Database.DuckDB.Simple.ToField

Methods

duckdbColumnTypeFor :: Proxy (Maybe a) -> Text Source #

data NamedParam where Source #

Represents a named parameter binding using the := operator.

Constructors

(:=) :: ToField a => Text -> a -> NamedParam infixr 3

duckdbColumnType :: forall a. DuckDBColumnType a => Proxy a -> Text Source #

Report the DuckDB column type that best matches a given ToField instance.

bindFieldBinding :: Statement -> DuckDBIdx -> FieldBinding -> IO () Source #

Apply a FieldBinding to the given statement/index.

renderFieldBinding :: FieldBinding -> String Source #

Render a bound parameter for error reporting.