napkin-0.5.9
Copyright(c) Soostone Inc 2020
LicenseAllRightsReserved
Stabilityexperimental
PortabilityPOSIX
Safe HaskellNone
LanguageHaskell2010

Napkin.Run.Sqlite

Description

 

Documentation

class ReifiesBackend b => Backend b #

Minimal complete definition

backendQuery, backendExecute

Instances

Instances details
Backend Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Associated Types

data BackendConn Sqlite #

Backend Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Associated Types

data BackendConn Redshift #

Backend Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Associated Types

data BackendConn Postgres #

Backend BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Associated Types

data BackendConn BigQuery #

class HasSqliteConn a #

Minimal complete definition

getSqliteConn

Instances

Instances details
HasSqliteConn Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

class Command command return backend | command backend -> return #

Minimal complete definition

execCommand

Instances

Instances details
Command Grant Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command Grant Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command Grant Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command Grant () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command CheckTableExists Bool Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command CheckTableExists Bool Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command CheckTableExists Bool Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command CheckTableExists Bool BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command DeleteFrom Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DeleteFrom Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DeleteFrom Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DeleteFrom Job BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command InsertIntoQuery Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command InsertIntoQuery Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command InsertIntoQuery Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command InsertIntoQuery Job BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command DropTable Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DropTable Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DropTable Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DropTable () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command DropView Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DropView Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DropView Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DropView () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command CreateViewAs Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command CreateViewAs Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command CreateViewAs Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command CreateViewAs Table BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command CopyTable Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command CopyTable Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command CopyTable Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command CopyTable () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command RenameTable Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command RenameTable Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command RenameTable Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command RenameTable () BigQuery #

BQ implements rename via copy-then-drop

Instance details

Defined in Napkin.Run.BigQuery

Command GetRelationSchema (Fields Field) Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command GetRelationSchema (Fields Field) Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command GetRelationSchema (Fields Field) Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command GetRelationSchema (Fields Field) BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateTableAs ()) Int Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command (CreateTableAs ()) Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateTableAs ()) Int64 Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command (CreateTableAs ()) Job BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateTableAs TableMeta) Int64 Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateTableAs TableMeta) Job BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

withSqliteString #

Arguments

:: String 
-> (BackendConn Sqlite -> IO b)

sqlite uri

-> IO b 

columnsToSchema :: [SchemaColDef] -> Schema Field #

Orphan instances

FromField Value # 
Instance details

Backend Sqlite # 
Instance details

Associated Types

data BackendConn Sqlite #

RunBackendConn Sqlite # 
Instance details

Command Grant Int Sqlite # 
Instance details

Command CheckTableExists Bool Sqlite # 
Instance details

Command DeleteFrom Int Sqlite # 
Instance details

Command InsertIntoQuery Int Sqlite # 
Instance details

Command DropTable Int Sqlite # 
Instance details

Command DropView Int Sqlite # 
Instance details

Command CreateViewAs Int Sqlite # 
Instance details

Command CopyTable Int Sqlite # 
Instance details

Command RenameTable Int Sqlite # 
Instance details

Command GetRelationSchema (Fields Field) Sqlite # 
Instance details

Eq (DbBackendOptions Sqlite) # 
Instance details

Show (DbBackendOptions Sqlite) # 
Instance details

Generic (DbBackendOptions Sqlite) # 
Instance details

Associated Types

type Rep (DbBackendOptions Sqlite) :: Type -> Type #

ToJSON (DbBackendOptions Sqlite) # 
Instance details

FromJSON (DbBackendOptions Sqlite) # 
Instance details

Default (DbBackendOptions Sqlite) # 
Instance details

Command (CreateTableAs ()) Int Sqlite # 
Instance details