Opaleye.SQLite.Column

Documentation

null :: Column (Nullable a)

A NULL of any type

isNull :: Column (Nullable a) -> Column PGBool

matchNullable :: Column b -> (Column a -> Column b) -> Column (Nullable a) -> Column b

If the Column (Nullable a) is NULL then return the Column b otherwise map the underlying Column a using the provided function.

The Opaleye equivalent of the maybe function.

fromNullable :: Column a -> Column (Nullable a) -> Column a

If the Column (Nullable a) is NULL then return the provided Column a otherwise return the underlying Column a.

The Opaleye equivalent of the fromMaybe function

toNullable :: Column a -> Column (Nullable a)

The Opaleye equivalent of Just

maybeToNullable :: Maybe (Column a) -> Column (Nullable a)

If the argument is Nothing return NULL otherwise return the provided value coerced to a nullable type.

unsafeCast :: String -> Column a -> Column b

Cast a column to any other type. This is safe for some conversions such as uuid to text.

data Column a

The Num and Fractional instances for Column a are too general. For example, they allow you to add two Column Strings. This will be fixed in a subsequent release.

Instances

Default ViewColumnMaker String (Column a)

Defined in Opaleye.SQLite.Internal.TableMaker

Methods

def :: ViewColumnMaker String (Column a)

Default Constant Bool (Column SqlBool)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant Bool (Column SqlBool)

Default Constant Double (Column SqlReal)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant Double (Column SqlReal)

Default Constant Int (Column SqlInt)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant Int (Column SqlInt)

Default Constant Text (Column SqlText)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant Text (Column SqlText)

Default Constant Text (Column SqlText)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant Text (Column SqlText)

Default Constant String (Column SqlText)

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant String (Column SqlText)

QueryRunnerColumnDefault a b => Default QueryRunner (Column a) b

Defined in Opaleye.SQLite.Internal.RunQuery

Methods

def :: QueryRunner (Column a) b

Default Binaryspec (Column a) (Column a)

Defined in Opaleye.SQLite.Internal.Binary

Methods

def :: Binaryspec (Column a) (Column a)

Default Unpackspec (Column a) (Column a)

Defined in Opaleye.SQLite.Internal.Unpackspec

Methods

def :: Unpackspec (Column a) (Column a)

Default Valuesspec (Column PGInt4) (Column PGInt4)

Defined in Opaleye.SQLite.Internal.Values

Methods

def :: Valuesspec (Column PGInt4) (Column PGInt4)

Default ColumnMaker (Column a) (Column a)

Defined in Opaleye.SQLite.Internal.TableMaker

Methods

def :: ColumnMaker (Column a) (Column a)

Default NullMaker (Column a) (Column (Nullable a))

Defined in Opaleye.SQLite.Internal.Join

Methods

def :: NullMaker (Column a) (Column (Nullable a))

Default NullMaker (Column (Nullable a)) (Column (Nullable a))

Defined in Opaleye.SQLite.Internal.Join

Methods

def :: NullMaker (Column (Nullable a)) (Column (Nullable a))

Default Distinctspec (Column a) (Column a)

Defined in Opaleye.SQLite.Internal.Distinct

Methods

def :: Distinctspec (Column a) (Column a)

Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Column (Nullable sql))

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant (Maybe haskell) (Column (Nullable sql))

(PGNum a, PGFractional a) => Fractional (Column a)

Defined in Opaleye.SQLite.Internal.Column

Methods

(/) :: Column a -> Column a -> Column a

recip :: Column a -> Column a

fromRational :: Rational -> Column a

PGNum a => Num (Column a)

Defined in Opaleye.SQLite.Internal.Column

Methods

(+) :: Column a -> Column a -> Column a

(-) :: Column a -> Column a -> Column a

(*) :: Column a -> Column a -> Column a

negate :: Column a -> Column a

abs :: Column a -> Column a

signum :: Column a -> Column a

fromInteger :: Integer -> Column a

Show (Column a)

Defined in Opaleye.SQLite.Internal.Column

Methods

showsPrec :: Int -> Column a -> ShowS

show :: Column a -> String

showList :: [Column a] -> ShowS

data Nullable a

Instances

Default NullMaker (Column a) (Column (Nullable a))

Defined in Opaleye.SQLite.Internal.Join

Methods

def :: NullMaker (Column a) (Column (Nullable a))

Default NullMaker (Column (Nullable a)) (Column (Nullable a))

Defined in Opaleye.SQLite.Internal.Join

Methods

def :: NullMaker (Column (Nullable a)) (Column (Nullable a))

Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Column (Nullable sql))

Defined in Opaleye.SQLite.Constant

Methods

def :: Constant (Maybe haskell) (Column (Nullable sql))

QueryRunnerColumnDefault a b => QueryRunnerColumnDefault (Nullable a) (Maybe b)

Defined in Opaleye.SQLite.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn (Nullable a) (Maybe b)

unsafeCoerce :: Column a -> Column b

Deprecated: Use unsafeCoerceColumn instead

unsafeCoerceColumn :: Column a -> Column b