| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Database.Beam.Sqlite
Synopsis
- module Database.Beam.Sqlite.Connection
- sqliteText :: DataType Sqlite Text
- sqliteBlob :: DataType Sqlite ByteString
- sqliteBigInt :: DataType Sqlite Int64
- data SqliteCommandSyntax
- data SqliteSyntax
- data SqliteSelectSyntax
- data SqliteInsertSyntax
- data SqliteUpdateSyntax
- data SqliteDeleteSyntax
- fromSqliteCommand :: SqliteCommandSyntax -> SqliteSyntax
- sqliteRenderSyntaxScript :: SqliteSyntax -> ByteString
- sqliteGroupConcat :: ( BeamSqlBackendCanSerialize Sqlite a, BeamSqlBackendIsString Sqlite str, BeamSqlBackendIsString Sqlite str2) => QExpr Sqlite s a -> QExpr Sqlite s str -> QAgg Sqlite s ( Maybe str2)
- sqliteGroupConcatOver :: ( BeamSqlBackendCanSerialize Sqlite a, BeamSqlBackendIsString Sqlite str) => Maybe SqliteAggregationSetQuantifierSyntax -> QExpr Sqlite s a -> QAgg Sqlite s ( Maybe str)
Documentation
SQLite syntaxes
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
.
Instances
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.
Instances
| Eq SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Methods (==) :: SqliteSyntax -> SqliteSyntax -> Bool Source # (/=) :: SqliteSyntax -> SqliteSyntax -> Bool Source # |
|
| Show SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax |
|
| Semigroup SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Methods (<>) :: SqliteSyntax -> SqliteSyntax -> SqliteSyntax Source # sconcat :: NonEmpty SqliteSyntax -> SqliteSyntax Source # stimes :: Integral b => b -> SqliteSyntax -> SqliteSyntax Source # |
|
| Monoid SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Methods mempty :: SqliteSyntax Source # mappend :: SqliteSyntax -> SqliteSyntax -> SqliteSyntax Source # mconcat :: [ SqliteSyntax ] -> SqliteSyntax Source # |
|
| Hashable SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax |
|
| Sql92DisplaySyntax SqliteSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Methods displaySyntax :: SqliteSyntax -> String Source # |
|
data SqliteSelectSyntax Source #
SQLite
SELECT
syntax
Instances
| IsSql92SelectSyntax SqliteSelectSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Associated Types type Sql92SelectSelectTableSyntax SqliteSelectSyntax Source # Methods selectStmt :: Sql92SelectSelectTableSyntax SqliteSelectSyntax -> [ Sql92SelectOrderingSyntax SqliteSelectSyntax ] -> Maybe Integer -> Maybe Integer -> SqliteSelectSyntax Source # |
|
| type Sql92SelectOrderingSyntax SqliteSelectSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax |
|
| type Sql92SelectSelectTableSyntax SqliteSelectSyntax Source # | |
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
.
Instances
| IsSql92InsertSyntax SqliteInsertSyntax Source # | |
|
Defined in Database.Beam.Sqlite.Syntax Associated Types Methods insertStmt :: Sql92InsertTableNameSyntax SqliteInsertSyntax -> [ Text ] -> Sql92InsertValuesSyntax SqliteInsertSyntax -> SqliteInsertSyntax Source # |
|
| type Sql92InsertTableNameSyntax SqliteInsertSyntax Source # | |
| type Sql92InsertValuesSyntax SqliteInsertSyntax Source # | |
data SqliteUpdateSyntax Source #
SQLite
UPDATE
syntax
Instances
data SqliteDeleteSyntax Source #
SQLite
DELETE
syntax
Instances
fromSqliteCommand :: SqliteCommandSyntax -> SqliteSyntax Source #
Convert a
SqliteCommandSyntax
into a renderable
SqliteSyntax
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.
Sqlite functions and aggregates
sqliteGroupConcat :: ( BeamSqlBackendCanSerialize Sqlite a, BeamSqlBackendIsString Sqlite str, BeamSqlBackendIsString Sqlite str2) => QExpr Sqlite s a -> QExpr Sqlite s str -> QAgg Sqlite s ( Maybe str2) Source #
The SQLite
group_concat
function.
Joins the value in each row of the first argument, using the second
argument as a delimiter. See
sqliteGroupConcatOver
if you want to provide
explicit quantification.
sqliteGroupConcatOver :: ( BeamSqlBackendCanSerialize Sqlite a, BeamSqlBackendIsString Sqlite str) => Maybe SqliteAggregationSetQuantifierSyntax -> QExpr Sqlite s a -> QAgg Sqlite s ( Maybe str) Source #
The SQLite
group_concat
function.
Joins the value in each row of the first argument using ','.
See
sqliteGroupConcat
if you want to change the delimiter.
Choosing a custom delimiter and quantification isn't allowed by SQLite.