beam-sqlite-0.5.4.0: Beam driver for SQLite
Safe HaskellNone
LanguageHaskell2010

Database.Beam.Sqlite.Syntax

Description

SQLite implementations of the Beam SQL syntax classes

The SQLite command syntax is implemented by SQLiteCommandSyntax.

Synopsis

SQLite syntaxes

data SqliteSyntax Source #

The syntax for SQLite is stored as a Builder along with a list of data that hasn't been serialized yet.

The first argument is a function that receives a builder for SQLData and returns the concrete syntax to embed into the query. For queries sent to the backend, this is simply a function that returns "?". Thus, the syntax sent to the backend includes proper placeholders. The list of data is sent to the SQLite library for proper escaping.

When the syntax is being serialized for display (for use in beam migrate for example), the data builder attempts to properly format and escape the data. This returns syntax suitable for inclusion in scripts. In this case, the value list is ignored.

Constructors

SqliteSyntax ((SQLData -> Builder) -> Builder) (DList SQLData) 

Instances

Instances details
Monoid SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

mempty :: SqliteSyntax #

mappend :: SqliteSyntax -> SqliteSyntax -> SqliteSyntax #

mconcat :: [SqliteSyntax] -> SqliteSyntax #

Semigroup SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(<>) :: SqliteSyntax -> SqliteSyntax -> SqliteSyntax #

sconcat :: NonEmpty SqliteSyntax -> SqliteSyntax #

stimes :: Integral b => b -> SqliteSyntax -> SqliteSyntax #

Show SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

showsPrec :: Int -> SqliteSyntax -> ShowS #

show :: SqliteSyntax -> String #

showList :: [SqliteSyntax] -> ShowS #

Sql92DisplaySyntax SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

displaySyntax :: SqliteSyntax -> String #

Eq SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(==) :: SqliteSyntax -> SqliteSyntax -> Bool #

(/=) :: SqliteSyntax -> SqliteSyntax -> Bool #

Hashable SqliteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

hashWithSalt :: Int -> SqliteSyntax -> Int #

hash :: SqliteSyntax -> Int #

data SqliteCommandSyntax Source #

A SQLite command. INSERT is special cased to handle AUTO INCREMENT columns. The fromSqliteCommand function will take an SqliteCommandSyntax and convert it into the correct SqliteSyntax.

Constructors

SqliteCommandSyntax SqliteSyntax 
SqliteCommandInsert SqliteInsertSyntax 

Instances

Instances details
IsSql92Syntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92SelectSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectSyntax SqliteCommandSyntax = SqliteSelectSyntax
type Sql92InsertSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertSyntax SqliteCommandSyntax = SqliteInsertSyntax
type Sql92UpdateSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateSyntax SqliteCommandSyntax = SqliteUpdateSyntax
type Sql92DeleteSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteSyntax SqliteCommandSyntax = SqliteDeleteSyntax

Methods

selectCmd :: Sql92SelectSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

insertCmd :: Sql92InsertSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

updateCmd :: Sql92UpdateSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

deleteCmd :: Sql92DeleteSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

IsSql92DdlCommandSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92DdlCommandCreateTableSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandCreateTableSyntax SqliteCommandSyntax
type Sql92DdlCommandAlterTableSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandAlterTableSyntax SqliteCommandSyntax
type Sql92DdlCommandDropTableSyntax SqliteCommandSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandDropTableSyntax SqliteCommandSyntax

Methods

createTableCmd :: Sql92DdlCommandCreateTableSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

dropTableCmd :: Sql92DdlCommandDropTableSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

alterTableCmd :: Sql92DdlCommandAlterTableSyntax SqliteCommandSyntax -> SqliteCommandSyntax #

type Sql92DeleteSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteSyntax SqliteCommandSyntax = SqliteDeleteSyntax
type Sql92InsertSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertSyntax SqliteCommandSyntax = SqliteInsertSyntax
type Sql92SelectSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectSyntax SqliteCommandSyntax = SqliteSelectSyntax
type Sql92UpdateSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateSyntax SqliteCommandSyntax = SqliteUpdateSyntax
type Sql92DdlCommandAlterTableSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandAlterTableSyntax SqliteCommandSyntax
type Sql92DdlCommandCreateTableSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandCreateTableSyntax SqliteCommandSyntax
type Sql92DdlCommandDropTableSyntax SqliteCommandSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DdlCommandDropTableSyntax SqliteCommandSyntax

newtype SqliteSelectSyntax Source #

SQLite SELECT syntax

Constructors

SqliteSelectSyntax 

Fields

Instances

Instances details
IsSql92SelectSyntax SqliteSelectSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92SelectSelectTableSyntax SqliteSelectSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectSelectTableSyntax SqliteSelectSyntax
type Sql92SelectOrderingSyntax SqliteSelectSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectOrderingSyntax SqliteSelectSyntax

Methods

selectStmt :: Sql92SelectSelectTableSyntax SqliteSelectSyntax -> [Sql92SelectOrderingSyntax SqliteSelectSyntax] -> Maybe Integer -> Maybe Integer -> SqliteSelectSyntax #

type Sql92SelectOrderingSyntax SqliteSelectSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectOrderingSyntax SqliteSelectSyntax
type Sql92SelectSelectTableSyntax SqliteSelectSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92SelectSelectTableSyntax SqliteSelectSyntax

data SqliteInsertSyntax Source #

SQLite INSERT syntax. This doesn't directly wrap SqliteSyntax because we need to do some processing on INSERT statements to deal with AUTO INCREMENT columns. Use formatSqliteInsert to turn SqliteInsertSyntax into SqliteSyntax.

Constructors

SqliteInsertSyntax 

Fields

Instances

Instances details
IsSql92InsertSyntax SqliteInsertSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92InsertValuesSyntax SqliteInsertSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesSyntax SqliteInsertSyntax = SqliteInsertValuesSyntax
type Sql92InsertTableNameSyntax SqliteInsertSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertTableNameSyntax SqliteInsertSyntax = SqliteTableNameSyntax

Methods

insertStmt :: Sql92InsertTableNameSyntax SqliteInsertSyntax -> [Text] -> Sql92InsertValuesSyntax SqliteInsertSyntax -> SqliteInsertSyntax #

type Sql92InsertTableNameSyntax SqliteInsertSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertTableNameSyntax SqliteInsertSyntax = SqliteTableNameSyntax
type Sql92InsertValuesSyntax SqliteInsertSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesSyntax SqliteInsertSyntax = SqliteInsertValuesSyntax

newtype SqliteUpdateSyntax Source #

SQLite UPDATE syntax

Constructors

SqliteUpdateSyntax 

Fields

Instances

Instances details
IsSql92UpdateSyntax SqliteUpdateSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92UpdateTableNameSyntax SqliteUpdateSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateTableNameSyntax SqliteUpdateSyntax = SqliteTableNameSyntax
type Sql92UpdateFieldNameSyntax SqliteUpdateSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateFieldNameSyntax SqliteUpdateSyntax = SqliteFieldNameSyntax
type Sql92UpdateExpressionSyntax SqliteUpdateSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateExpressionSyntax SqliteUpdateSyntax = SqliteExpressionSyntax

Methods

updateStmt :: Sql92UpdateTableNameSyntax SqliteUpdateSyntax -> [(Sql92UpdateFieldNameSyntax SqliteUpdateSyntax, Sql92UpdateExpressionSyntax SqliteUpdateSyntax)] -> Maybe (Sql92UpdateExpressionSyntax SqliteUpdateSyntax) -> SqliteUpdateSyntax #

type Sql92UpdateExpressionSyntax SqliteUpdateSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateExpressionSyntax SqliteUpdateSyntax = SqliteExpressionSyntax
type Sql92UpdateFieldNameSyntax SqliteUpdateSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateFieldNameSyntax SqliteUpdateSyntax = SqliteFieldNameSyntax
type Sql92UpdateTableNameSyntax SqliteUpdateSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92UpdateTableNameSyntax SqliteUpdateSyntax = SqliteTableNameSyntax

newtype SqliteDeleteSyntax Source #

SQLite DELETE syntax

Constructors

SqliteDeleteSyntax 

Fields

Instances

Instances details
IsSql92DeleteSyntax SqliteDeleteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92DeleteTableNameSyntax SqliteDeleteSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteTableNameSyntax SqliteDeleteSyntax = SqliteTableNameSyntax
type Sql92DeleteExpressionSyntax SqliteDeleteSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteExpressionSyntax SqliteDeleteSyntax = SqliteExpressionSyntax

Methods

deleteStmt :: Sql92DeleteTableNameSyntax SqliteDeleteSyntax -> Maybe Text -> Maybe (Sql92DeleteExpressionSyntax SqliteDeleteSyntax) -> SqliteDeleteSyntax #

deleteSupportsAlias :: Proxy SqliteDeleteSyntax -> Bool #

type Sql92DeleteExpressionSyntax SqliteDeleteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteExpressionSyntax SqliteDeleteSyntax = SqliteExpressionSyntax
type Sql92DeleteTableNameSyntax SqliteDeleteSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92DeleteTableNameSyntax SqliteDeleteSyntax = SqliteTableNameSyntax

newtype SqliteOnConflictSyntax Source #

SQLite ON CONFLICT syntax

Constructors

SqliteOnConflictSyntax 

Fields

data SqliteInsertValuesSyntax Source #

SQLite VALUES clause in INSERT. Expressions need to be handled explicitly in order to deal with DEFAULT values and AUTO INCREMENT columns.

Constructors

SqliteInsertExpressions [[SqliteExpressionSyntax]] 
SqliteInsertFromSql SqliteSelectSyntax 

Instances

Instances details
IsSql92InsertValuesSyntax SqliteInsertValuesSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92InsertValuesExpressionSyntax SqliteInsertValuesSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesExpressionSyntax SqliteInsertValuesSyntax = SqliteExpressionSyntax
type Sql92InsertValuesSelectSyntax SqliteInsertValuesSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesSelectSyntax SqliteInsertValuesSyntax = SqliteSelectSyntax

Methods

insertSqlExpressions :: [[Sql92InsertValuesExpressionSyntax SqliteInsertValuesSyntax]] -> SqliteInsertValuesSyntax #

insertFromSql :: Sql92InsertValuesSelectSyntax SqliteInsertValuesSyntax -> SqliteInsertValuesSyntax #

type Sql92InsertValuesExpressionSyntax SqliteInsertValuesSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesExpressionSyntax SqliteInsertValuesSyntax = SqliteExpressionSyntax
type Sql92InsertValuesSelectSyntax SqliteInsertValuesSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92InsertValuesSelectSyntax SqliteInsertValuesSyntax = SqliteSelectSyntax

data SqliteColumnSchemaSyntax Source #

SQLite syntax for column schemas in CREATE TABLE or ALTER COLUMN ... ADD COLUMN statements

Constructors

SqliteColumnSchemaSyntax 

Fields

Instances

Instances details
Generic SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Rep SqliteColumnSchemaSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteColumnSchemaSyntax = D1 ('MetaData "SqliteColumnSchemaSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteColumnSchemaSyntax" 'PrefixI 'True) (S1 ('MetaSel ('Just "fromSqliteColumnSchema") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax) :*: S1 ('MetaSel ('Just "sqliteIsSerialColumn") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool)))

Methods

from :: SqliteColumnSchemaSyntax -> Rep SqliteColumnSchemaSyntax x #

to :: Rep SqliteColumnSchemaSyntax x -> SqliteColumnSchemaSyntax #

Show SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

showsPrec :: Int -> SqliteColumnSchemaSyntax -> ShowS #

show :: SqliteColumnSchemaSyntax -> String #

showList :: [SqliteColumnSchemaSyntax] -> ShowS #

Sql92DisplaySyntax SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

displaySyntax :: SqliteColumnSchemaSyntax -> String #

IsSql92ColumnSchemaSyntax SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92ColumnSchemaColumnTypeSyntax SqliteColumnSchemaSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaColumnTypeSyntax SqliteColumnSchemaSyntax = SqliteDataTypeSyntax
type Sql92ColumnSchemaExpressionSyntax SqliteColumnSchemaSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaExpressionSyntax SqliteColumnSchemaSyntax = SqliteExpressionSyntax
type Sql92ColumnSchemaColumnConstraintDefinitionSyntax SqliteColumnSchemaSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaColumnConstraintDefinitionSyntax SqliteColumnSchemaSyntax

Methods

columnSchemaSyntax :: Sql92ColumnSchemaColumnTypeSyntax SqliteColumnSchemaSyntax -> Maybe (Sql92ColumnSchemaExpressionSyntax SqliteColumnSchemaSyntax) -> [Sql92ColumnSchemaColumnConstraintDefinitionSyntax SqliteColumnSchemaSyntax] -> Maybe Text -> SqliteColumnSchemaSyntax #

Eq SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(==) :: SqliteColumnSchemaSyntax -> SqliteColumnSchemaSyntax -> Bool #

(/=) :: SqliteColumnSchemaSyntax -> SqliteColumnSchemaSyntax -> Bool #

Hashable SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

hashWithSalt :: Int -> SqliteColumnSchemaSyntax -> Int #

hash :: SqliteColumnSchemaSyntax -> Int #

type Rep SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteColumnSchemaSyntax = D1 ('MetaData "SqliteColumnSchemaSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteColumnSchemaSyntax" 'PrefixI 'True) (S1 ('MetaSel ('Just "fromSqliteColumnSchema") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax) :*: S1 ('MetaSel ('Just "sqliteIsSerialColumn") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool)))
type Sql92ColumnSchemaColumnConstraintDefinitionSyntax SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaColumnConstraintDefinitionSyntax SqliteColumnSchemaSyntax
type Sql92ColumnSchemaColumnTypeSyntax SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaColumnTypeSyntax SqliteColumnSchemaSyntax = SqliteDataTypeSyntax
type Sql92ColumnSchemaExpressionSyntax SqliteColumnSchemaSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ColumnSchemaExpressionSyntax SqliteColumnSchemaSyntax = SqliteExpressionSyntax

data SqliteExpressionSyntax Source #

Implements beam SQL expression syntaxes

Constructors

SqliteExpressionSyntax SqliteSyntax 
SqliteExpressionDefault 

Instances

Instances details
Generic SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Rep SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteExpressionSyntax = D1 ('MetaData "SqliteExpressionSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteExpressionSyntax" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax)) :+: C1 ('MetaCons "SqliteExpressionDefault" 'PrefixI 'False) (U1 :: Type -> Type))

Methods

from :: SqliteExpressionSyntax -> Rep SqliteExpressionSyntax x #

to :: Rep SqliteExpressionSyntax x -> SqliteExpressionSyntax #

Show SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

showsPrec :: Int -> SqliteExpressionSyntax -> ShowS #

show :: SqliteExpressionSyntax -> String #

showList :: [SqliteExpressionSyntax] -> ShowS #

IsSql92AggregationExpressionSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax = SqliteAggregationSetQuantifierSyntax

Methods

countAllE :: SqliteExpressionSyntax #

countE :: Maybe (Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

avgE :: Maybe (Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

maxE :: Maybe (Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

minE :: Maybe (Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

sumE :: Maybe (Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

IsSql92ExpressionSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax
type Sql92ExpressionValueSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionValueSyntax SqliteExpressionSyntax = SqliteValueSyntax
type Sql92ExpressionSelectSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionSelectSyntax SqliteExpressionSyntax = SqliteSelectSyntax
type Sql92ExpressionFieldNameSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionFieldNameSyntax SqliteExpressionSyntax = SqliteFieldNameSyntax
type Sql92ExpressionCastTargetSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionCastTargetSyntax SqliteExpressionSyntax = SqliteDataTypeSyntax
type Sql92ExpressionExtractFieldSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionExtractFieldSyntax SqliteExpressionSyntax = ExtractField

Methods

valueE :: Sql92ExpressionValueSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

rowE :: [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

quantifierListE :: [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

coalesceE :: [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

caseE :: [(SqliteExpressionSyntax, SqliteExpressionSyntax)] -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

fieldE :: Sql92ExpressionFieldNameSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

betweenE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

andE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

orE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

addE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

subE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

mulE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

divE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

likeE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

modE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

overlapsE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

nullIfE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

positionE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

eqE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

neqE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

ltE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

gtE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

leE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

geE :: Maybe (Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax) -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

eqMaybeE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

neqMaybeE :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

castE :: SqliteExpressionSyntax -> Sql92ExpressionCastTargetSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

notE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

negateE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isNullE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isNotNullE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isTrueE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isNotTrueE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isFalseE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isNotFalseE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isUnknownE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

isNotUnknownE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

charLengthE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

octetLengthE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

bitLengthE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

lowerE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

upperE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

trimE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

absE :: SqliteExpressionSyntax -> SqliteExpressionSyntax #

extractE :: Sql92ExpressionExtractFieldSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax -> SqliteExpressionSyntax #

existsE :: Sql92ExpressionSelectSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

uniqueE :: Sql92ExpressionSelectSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

subqueryE :: Sql92ExpressionSelectSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

currentTimestampE :: SqliteExpressionSyntax #

defaultE :: SqliteExpressionSyntax #

inE :: SqliteExpressionSyntax -> [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

inSelectE :: SqliteExpressionSyntax -> Sql92ExpressionSelectSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

IsSql99ConcatExpressionSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

concatE :: [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

IsSql99FunctionExpressionSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

functionCallE :: SqliteExpressionSyntax -> [SqliteExpressionSyntax] -> SqliteExpressionSyntax #

functionNameE :: Text -> SqliteExpressionSyntax #

IsCustomSqlSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

newtype CustomSqlSyntax SqliteExpressionSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

newtype CustomSqlSyntax SqliteExpressionSyntax = SqliteCustomExpressionSyntax {}

Methods

customExprSyntax :: CustomSqlSyntax SqliteExpressionSyntax -> SqliteExpressionSyntax #

renderSyntax :: SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax #

Eq SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(==) :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> Bool #

(/=) :: SqliteExpressionSyntax -> SqliteExpressionSyntax -> Bool #

Hashable SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

hashWithSalt :: Int -> SqliteExpressionSyntax -> Int #

hash :: SqliteExpressionSyntax -> Int #

IsString (CustomSqlSyntax SqliteExpressionSyntax) Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

fromString :: String -> CustomSqlSyntax SqliteExpressionSyntax #

Monoid (CustomSqlSyntax SqliteExpressionSyntax) Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

mempty :: CustomSqlSyntax SqliteExpressionSyntax #

mappend :: CustomSqlSyntax SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax #

mconcat :: [CustomSqlSyntax SqliteExpressionSyntax] -> CustomSqlSyntax SqliteExpressionSyntax #

Semigroup (CustomSqlSyntax SqliteExpressionSyntax) Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(<>) :: CustomSqlSyntax SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax #

sconcat :: NonEmpty (CustomSqlSyntax SqliteExpressionSyntax) -> CustomSqlSyntax SqliteExpressionSyntax #

stimes :: Integral b => b -> CustomSqlSyntax SqliteExpressionSyntax -> CustomSqlSyntax SqliteExpressionSyntax #

type Rep SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteExpressionSyntax = D1 ('MetaData "SqliteExpressionSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteExpressionSyntax" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax)) :+: C1 ('MetaCons "SqliteExpressionDefault" 'PrefixI 'False) (U1 :: Type -> Type))
type Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92AggregationSetQuantifierSyntax SqliteExpressionSyntax = SqliteAggregationSetQuantifierSyntax
type Sql92ExpressionCastTargetSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionCastTargetSyntax SqliteExpressionSyntax = SqliteDataTypeSyntax
type Sql92ExpressionExtractFieldSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionExtractFieldSyntax SqliteExpressionSyntax = ExtractField
type Sql92ExpressionFieldNameSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionFieldNameSyntax SqliteExpressionSyntax = SqliteFieldNameSyntax
type Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionQuantifierSyntax SqliteExpressionSyntax
type Sql92ExpressionSelectSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionSelectSyntax SqliteExpressionSyntax = SqliteSelectSyntax
type Sql92ExpressionValueSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Sql92ExpressionValueSyntax SqliteExpressionSyntax = SqliteValueSyntax
newtype CustomSqlSyntax SqliteExpressionSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

newtype CustomSqlSyntax SqliteExpressionSyntax = SqliteCustomExpressionSyntax {}

newtype SqliteValueSyntax Source #

SQLite syntax for values that can be embedded in SqliteSyntax

Constructors

SqliteValueSyntax 

Fields

Instances

Instances details
HasSqlValueSyntax SqliteValueSyntax Int16 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Int16 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Int32 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Int32 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Int64 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Int64 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Int8 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Int8 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Word16 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Word16 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Word32 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Word32 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Word64 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Word64 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Word8 Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Word8 -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax SqlNull Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: SqlNull -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax ByteString Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: ByteString -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Scientific Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Scientific -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Text Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Text -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Text Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Text -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Day Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Day -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax UTCTime Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: UTCTime -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax LocalTime Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: LocalTime -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax String Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: String -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Bool Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Bool -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Double Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Double -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax Float Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Float -> SqliteValueSyntax #

(TypeError (PreferExplicitSize Int Int32) :: Constraint) => HasSqlValueSyntax SqliteValueSyntax Int Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Int -> SqliteValueSyntax #

(TypeError (PreferExplicitSize Word Word32) :: Constraint) => HasSqlValueSyntax SqliteValueSyntax Word Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Word -> SqliteValueSyntax #

HasSqlValueSyntax SqliteValueSyntax x => HasSqlValueSyntax SqliteValueSyntax (Maybe x) Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

sqlValueSyntax :: Maybe x -> SqliteValueSyntax #

newtype SqliteTableNameSyntax Source #

Constructors

SqliteTableNameSyntax 

Fields

Instances

Instances details
IsSql92TableNameSyntax SqliteTableNameSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

tableName :: Maybe Text -> Text -> SqliteTableNameSyntax #

newtype SqliteFieldNameSyntax Source #

Constructors

SqliteFieldNameSyntax 

Fields

Instances

Instances details
IsSql92FieldNameSyntax SqliteFieldNameSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

qualifiedField :: Text -> Text -> SqliteFieldNameSyntax #

unqualifiedField :: Text -> SqliteFieldNameSyntax #

newtype SqliteAggregationSetQuantifierSyntax Source #

Constructors

SqliteAggregationSetQuantifierSyntax 

Fields

Instances

Instances details
IsSql92AggregationSetQuantifierSyntax SqliteAggregationSetQuantifierSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

setQuantifierDistinct :: SqliteAggregationSetQuantifierSyntax #

setQuantifierAll :: SqliteAggregationSetQuantifierSyntax #

fromSqliteExpression :: SqliteExpressionSyntax -> SqliteSyntax Source #

SQLite data type syntax

data SqliteDataTypeSyntax Source #

SQLite syntax that implements IsSql92DataTypeSyntax and a good portion of IsSql99DataTypeSyntax, except for array and row types.

Constructors

SqliteDataTypeSyntax 

Fields

Instances

Instances details
Generic SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Associated Types

type Rep SqliteDataTypeSyntax 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteDataTypeSyntax = D1 ('MetaData "SqliteDataTypeSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteDataTypeSyntax" 'PrefixI 'True) ((S1 ('MetaSel ('Just "fromSqliteDataType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax) :*: S1 ('MetaSel ('Just "sqliteDataTypeToHs") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 HsDataType)) :*: (S1 ('MetaSel ('Just "sqliteDataTypeSerialized") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 BeamSerializedDataType) :*: S1 ('MetaSel ('Just "sqliteDataTypeSerial") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool))))

Methods

from :: SqliteDataTypeSyntax -> Rep SqliteDataTypeSyntax x #

to :: Rep SqliteDataTypeSyntax x -> SqliteDataTypeSyntax #

Show SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

showsPrec :: Int -> SqliteDataTypeSyntax -> ShowS #

show :: SqliteDataTypeSyntax -> String #

showList :: [SqliteDataTypeSyntax] -> ShowS #

IsSql2008BigIntDataTypeSyntax SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

bigIntType :: SqliteDataTypeSyntax #

IsSql92DataTypeSyntax SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

domainType :: Text -> SqliteDataTypeSyntax #

charType :: Maybe Word -> Maybe Text -> SqliteDataTypeSyntax #

varCharType :: Maybe Word -> Maybe Text -> SqliteDataTypeSyntax #

nationalCharType :: Maybe Word -> SqliteDataTypeSyntax #

nationalVarCharType :: Maybe Word -> SqliteDataTypeSyntax #

bitType :: Maybe Word -> SqliteDataTypeSyntax #

varBitType :: Maybe Word -> SqliteDataTypeSyntax #

numericType :: Maybe (Word, Maybe Word) -> SqliteDataTypeSyntax #

decimalType :: Maybe (Word, Maybe Word) -> SqliteDataTypeSyntax #

intType :: SqliteDataTypeSyntax #

smallIntType :: SqliteDataTypeSyntax #

floatType :: Maybe Word -> SqliteDataTypeSyntax #

doubleType :: SqliteDataTypeSyntax #

realType :: SqliteDataTypeSyntax #

dateType :: SqliteDataTypeSyntax #

timeType :: Maybe Word -> Bool -> SqliteDataTypeSyntax #

timestampType :: Maybe Word -> Bool -> SqliteDataTypeSyntax #

Sql92DisplaySyntax SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

displaySyntax :: SqliteDataTypeSyntax -> String #

IsSql99DataTypeSyntax SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

characterLargeObjectType :: SqliteDataTypeSyntax #

binaryLargeObjectType :: SqliteDataTypeSyntax #

booleanType :: SqliteDataTypeSyntax #

arrayType :: SqliteDataTypeSyntax -> Int -> SqliteDataTypeSyntax #

rowType :: [(Text, SqliteDataTypeSyntax)] -> SqliteDataTypeSyntax #

HasDataTypeCreatedCheck SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

dataTypeHasBeenCreated :: SqliteDataTypeSyntax -> (forall preCondition. Typeable preCondition => [preCondition]) -> Bool #

Sql92SerializableDataTypeSyntax SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

serializeDataType :: SqliteDataTypeSyntax -> Value #

Eq SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

(==) :: SqliteDataTypeSyntax -> SqliteDataTypeSyntax -> Bool #

(/=) :: SqliteDataTypeSyntax -> SqliteDataTypeSyntax -> Bool #

Hashable SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

Methods

hashWithSalt :: Int -> SqliteDataTypeSyntax -> Int #

hash :: SqliteDataTypeSyntax -> Int #

type Rep SqliteDataTypeSyntax Source # 
Instance details

Defined in Database.Beam.Sqlite.Syntax

type Rep SqliteDataTypeSyntax = D1 ('MetaData "SqliteDataTypeSyntax" "Database.Beam.Sqlite.Syntax" "beam-sqlite-0.5.4.0-22CTwXWT63884bnV7STsAn" 'False) (C1 ('MetaCons "SqliteDataTypeSyntax" 'PrefixI 'True) ((S1 ('MetaSel ('Just "fromSqliteDataType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 SqliteSyntax) :*: S1 ('MetaSel ('Just "sqliteDataTypeToHs") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 HsDataType)) :*: (S1 ('MetaSel ('Just "sqliteDataTypeSerialized") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 BeamSerializedDataType) :*: S1 ('MetaSel ('Just "sqliteDataTypeSerial") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool))))

sqliteTextType :: SqliteDataTypeSyntax Source #

sqliteBlobType :: SqliteDataTypeSyntax Source #

sqliteBigIntType :: SqliteDataTypeSyntax Source #

sqliteSerialType :: SqliteDataTypeSyntax Source #

Building and consuming SqliteSyntax

fromSqliteCommand :: SqliteCommandSyntax -> SqliteSyntax Source #

Convert a SqliteCommandSyntax into a renderable SqliteSyntax

formatSqliteInsert :: SqliteTableNameSyntax -> [Text] -> SqliteInsertValuesSyntax -> SqliteSyntax Source #

Format a SQLite INSERT expression for the given table name, fields, and values.

formatSqliteInsertOnConflict :: SqliteTableNameSyntax -> [Text] -> SqliteInsertValuesSyntax -> Maybe SqliteOnConflictSyntax -> SqliteSyntax Source #

Format a SQLite INSERT expression for the given table name, fields, values, and optionally an ON CONFLICT clause.

emit :: ByteString -> SqliteSyntax Source #

Embed a ByteString directly in the syntax

emitValue :: SQLData -> SqliteSyntax Source #

Emit a properly escaped value into the syntax

This causes a literal ? 3

parens :: SqliteSyntax -> SqliteSyntax Source #

commas :: [SqliteSyntax] -> SqliteSyntax Source #

quotedIdentifier :: Text -> SqliteSyntax Source #

sqliteEscape :: Text -> Text Source #

A best effort attempt to implement the escaping rules of SQLite. This is never used to escape data sent to the database; only for emitting scripts or displaying syntax to the user.

withPlaceholders :: ((SQLData -> Builder) -> Builder) -> Builder Source #

Convert the first argument of SQLiteSyntax to a ByteString Builder, where all the data has been replaced by "?" placeholders.

sqliteRenderSyntaxScript :: SqliteSyntax -> ByteString Source #

Render a SqliteSyntax as a lazy ByteString, for purposes of displaying to a user. Embedded SQLData is directly embedded into the concrete syntax, with a best effort made to escape strings.