napkin-0.5.13
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 | backend command -> return #

Minimal complete definition

execCommand

Instances

Instances details
Command UpdateQuery () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command UpdateQuery () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command UpdateQuery () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command UpdateQuery () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command Grant () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Methods

execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> Grant -> m () #

Command Grant () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command Grant () 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 () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DeleteFrom () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DeleteFrom () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DeleteFrom () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command InsertIntoQuery () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command InsertIntoQuery () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command InsertIntoQuery () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command InsertIntoQuery () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command DropTable () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DropTable () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DropTable () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DropTable () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command DropView () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command DropView () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command DropView () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command DropView () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command CopyTable () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command CopyTable () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command CopyTable () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command CopyTable () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command RenameTable () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command RenameTable () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command RenameTable () 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 [BackendSchemaField Sqlite] Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command GetRelationSchema [BackendSchemaField Redshift] Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command GetRelationSchema [BackendSchemaField Postgres] Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command GetRelationSchema [BackendSchemaField BigQuery] BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateMaterializedViewAs ()) () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateMaterializedViewAs SqliteMaterializedViewMeta) () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command (CreateMaterializedViewAs MaterializedViewMeta) () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command (CreateMaterializedViewAs MaterializedViewMeta) () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateViewAs ()) () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command (CreateViewAs ()) () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateViewAs ()) () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command (CreateViewAs ()) () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateTableAs ()) () Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command (CreateTableAs ()) () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateTableAs ()) () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Command (CreateTableAs TableMeta) () Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command (CreateTableAs TableMeta) () Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command (CreateTableAs TableMeta) () BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

withSqliteString #

Arguments

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

sqlite uri

-> IO b 

data family BackendSchemaField bk #

Instances

Instances details
Command GetRelationSchema [BackendSchemaField Sqlite] Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

Command GetRelationSchema [BackendSchemaField Redshift] Redshift # 
Instance details

Defined in Napkin.Run.Redshift

Command GetRelationSchema [BackendSchemaField Postgres] Postgres # 
Instance details

Defined in Napkin.Run.Postgres

Command GetRelationSchema [BackendSchemaField BigQuery] BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Eq (BackendSchemaField Sqlite) # 
Instance details

Defined in Napkin.Run.Sqlite

Eq (BackendSchemaField Redshift) # 
Instance details

Defined in Napkin.Run.Redshift

Eq (BackendSchemaField Postgres) # 
Instance details

Defined in Napkin.Run.Postgres

Eq (BackendSchemaField BigQuery) # 
Instance details

Defined in Napkin.Run.BigQuery

Show (BackendSchemaField Sqlite) # 
Instance details

Defined in Napkin.Run.Sqlite

Show (BackendSchemaField Redshift) # 
Instance details

Defined in Napkin.Run.Redshift

Show (BackendSchemaField Postgres) # 
Instance details

Defined in Napkin.Run.Postgres

Show (BackendSchemaField BigQuery) # 
Instance details

Defined in Napkin.Run.BigQuery

FromRow (BackendSchemaField Sqlite) # 
Instance details

Defined in Napkin.Run.Sqlite

data BackendSchemaField Sqlite # 
Instance details

Defined in Napkin.Run.Sqlite

data BackendSchemaField Redshift # 
Instance details

Defined in Napkin.Run.Redshift

data BackendSchemaField Postgres # 
Instance details

Defined in Napkin.Run.Postgres

data BackendSchemaField BigQuery # 
Instance details

Defined in Napkin.Run.BigQuery

Orphan instances

FromField Value # 
Instance details

Backend Sqlite # 
Instance details

Associated Types

data BackendConn Sqlite #

RunBackendConn Sqlite # 
Instance details

Command UpdateQuery () Sqlite # 
Instance details

Command Grant () Sqlite # 
Instance details

Methods

execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> Grant -> m () #

Command CheckTableExists Bool Sqlite # 
Instance details

Command DeleteFrom () Sqlite # 
Instance details

Command InsertIntoQuery () Sqlite # 
Instance details

Command DropTable () Sqlite # 
Instance details

Command DropView () Sqlite # 
Instance details

Command CopyTable () Sqlite # 
Instance details

Command RenameTable () Sqlite # 
Instance details

Command GetRelationSchema [BackendSchemaField Sqlite] 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

HasBackendSchemaField Sqlite # 
Instance details

Associated Types

data BackendSchemaField Sqlite #

Command (CreateMaterializedViewAs SqliteMaterializedViewMeta) () Sqlite # 
Instance details

Command (CreateViewAs ()) () Sqlite # 
Instance details

Command (CreateTableAs ()) () Sqlite # 
Instance details

Eq (BackendSchemaField Sqlite) # 
Instance details

Show (BackendSchemaField Sqlite) # 
Instance details

FromRow (BackendSchemaField Sqlite) # 
Instance details