Safe Haskell	None
Language	GHC2021

Napkin.Run.Sqlite

Contents

Orphan instances

Documentation

class ReifiesBackend b => Backend b #

Minimal complete definition

backendQuery, backendConnectionString

Instances

Instances details

Backend BigQuery #

Instance details

Defined in Napkin.Run.BigQuery

Associated Types

data BackendConn BigQuery
Instance details Defined in Napkin.Run.BigQuery data BackendConn BigQuery = BigQueryEnv { bqeEnv :: Pool GoogleEnv bqeDefaultProject :: BQProjectId bqeJobLabels :: Labels }

Methods

backendQuery :: (MonadNapkin BigQuery m, RenderSql q BigQuery) => BackendConn BigQuery -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn BigQuery -> ConnectionString #

Backend MsSql #

Instance details

Defined in Napkin.Run.MsSql

Associated Types

data BackendConn MsSql
Instance details Defined in Napkin.Run.MsSql data BackendConn MsSql = MsSqlConn { connectionString :: ConnectionString msSqlConn :: Pool Connection }

Methods

backendQuery :: (MonadNapkin MsSql m, RenderSql q MsSql) => BackendConn MsSql -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn MsSql -> ConnectionString #

Backend Postgres #

Instance details

Defined in Napkin.Run.Postgres

Associated Types

data BackendConn Postgres
Instance details Defined in Napkin.Run.Postgres data BackendConn Postgres = PostgresConn { getConnectionString :: ConnectionString getPostgresConn :: Pool Connection }

Methods

backendQuery :: (MonadNapkin Postgres m, RenderSql q Postgres) => BackendConn Postgres -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn Postgres -> ConnectionString #

Backend Redshift #

Instance details

Defined in Napkin.Run.Redshift

Associated Types

data BackendConn Redshift
Instance details Defined in Napkin.Run.Redshift data BackendConn Redshift = RedshiftConn ConnectionString (Pool Connection)

Methods

backendQuery :: (MonadNapkin Redshift m, RenderSql q Redshift) => BackendConn Redshift -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn Redshift -> ConnectionString #

Backend Sqlite #

Instance details

Defined in Napkin.Run.Sqlite

Associated Types

data BackendConn Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendConn Sqlite = SqliteConn { connectionString :: ConnectionString sqliteConn :: Pool Connection }

Methods

backendQuery :: (MonadNapkin Sqlite m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn Sqlite -> ConnectionString #

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

Minimal complete definition

execCommand

Instances

Instances details

Command AEDA TableDiagnostics BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> AEDA -> m TableDiagnostics #
Command AEDA TableDiagnostics MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> AEDA -> m TableDiagnostics #
Command AEDA TableDiagnostics Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> AEDA -> m TableDiagnostics #
Command AEDA TableDiagnostics Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> AEDA -> m TableDiagnostics #
Command AEDA TableDiagnostics Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> AEDA -> m TableDiagnostics #
Command AnnotateCommand () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> AnnotateCommand -> m () #
Command AnnotateCommand () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> AnnotateCommand -> m () #
Command AnnotateCommand () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> AnnotateCommand -> m () #
Command AnnotateCommand () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> AnnotateCommand -> m () #
Command AnnotateCommand () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> AnnotateCommand -> m () #
Command CheckTableExists Bool BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CheckTableExists -> m Bool #
Command CheckTableExists Bool MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CheckTableExists -> m Bool #
Command CheckTableExists Bool Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CheckTableExists -> m Bool #
Command CheckTableExists Bool Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CheckTableExists -> m Bool #
Command CheckTableExists Bool Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CheckTableExists -> m Bool #
Command CopyTable () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CopyTable -> m () #
Command CopyTable () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CopyTable -> m () #
Command CopyTable () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CopyTable -> m () #
Command CopyTable () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CopyTable -> m () #
Command CopyTable () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CopyTable -> m () #
Command DeleteFrom () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> DeleteFrom -> m () #
Command DeleteFrom () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DeleteFrom -> m () #
Command DeleteFrom () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DeleteFrom -> m () #
Command DeleteFrom () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> DeleteFrom -> m () #
Command DeleteFrom () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DeleteFrom -> m () #
Command DropTable () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> DropTable -> m () #
Command DropTable () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DropTable -> m () #
Command DropTable () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DropTable -> m () #
Command DropTable () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> DropTable -> m () #
Command DropTable () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DropTable -> m () #
Command DropView () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> DropView -> m () #
Command DropView () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DropView -> m () #
Command DropView () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DropView -> m () #
Command DropView () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> DropView -> m () #
Command DropView () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DropView -> m () #
Command GetTableKind TableKind BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> GetTableKind -> m TableKind #
Command GetTableKind TableKind MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> GetTableKind -> m TableKind #
Command GetTableKind TableKind Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> GetTableKind -> m TableKind #
Command GetTableKind TableKind Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> GetTableKind -> m TableKind #
Command GetTableKind TableKind Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> GetTableKind -> m TableKind #
Command InsertIntoQuery () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> InsertIntoQuery -> m () #
Command InsertIntoQuery () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> InsertIntoQuery -> m () #
Command InsertIntoQuery () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> InsertIntoQuery -> m () #
Command InsertIntoQuery () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> InsertIntoQuery -> m () #
Command InsertIntoQuery () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> InsertIntoQuery -> m () #
Command InsertIntoTable () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> InsertIntoTable -> m () #
Command InsertIntoTable () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> InsertIntoTable -> m () #
Command InsertIntoTable () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> InsertIntoTable -> m () #
Command InsertIntoTable () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> InsertIntoTable -> m () #
Command InsertIntoTable () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> InsertIntoTable -> m () #
Command ReadAnnotationCommand TableAnnotations BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> ReadAnnotationCommand -> m TableAnnotations #
Command ReadAnnotationCommand TableAnnotations MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> ReadAnnotationCommand -> m TableAnnotations #
Command ReadAnnotationCommand TableAnnotations Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> ReadAnnotationCommand -> m TableAnnotations #
Command ReadAnnotationCommand TableAnnotations Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> ReadAnnotationCommand -> m TableAnnotations #
Command ReadAnnotationCommand TableAnnotations Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> ReadAnnotationCommand -> m TableAnnotations #
Command RenameTable () BigQuery #	BQ implements rename via copy-then-drop
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> RenameTable -> m () #
Command RenameTable () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> RenameTable -> m () #
Command RenameTable () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> RenameTable -> m () #
Command RenameTable () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> RenameTable -> m () #
Command RenameTable () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> RenameTable -> m () #
Command Merge () BigQuery #
Instance details Defined in Napkin.Run.BigQuery.Merge Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> Merge -> m () #
Command Grant () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> Grant -> m () #
Command Grant () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> Grant -> m () #
Command Grant () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> Grant -> m () #
Command Grant () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> Grant -> m () #
Command Grant () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> Grant -> m () #
Command UpdateQuery () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> UpdateQuery -> m () #
Command UpdateQuery () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> UpdateQuery -> m () #
Command UpdateQuery () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> UpdateQuery -> m () #
Command UpdateQuery () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> UpdateQuery -> m () #
Command UpdateQuery () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> UpdateQuery -> m () #
Command GetRelationSchema [BackendSchemaField BigQuery] BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> GetRelationSchema -> m [BackendSchemaField BigQuery] #
Command GetRelationSchema [BackendSchemaField MsSql] MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> GetRelationSchema -> m [BackendSchemaField MsSql] #
Command GetRelationSchema [BackendSchemaField Postgres] Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> GetRelationSchema -> m [BackendSchemaField Postgres] #
Command GetRelationSchema [BackendSchemaField Redshift] Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> GetRelationSchema -> m [BackendSchemaField Redshift] #
Command GetRelationSchema [BackendSchemaField Sqlite] Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> GetRelationSchema -> m [BackendSchemaField Sqlite] #
Command ListTables (Set ListedTable) BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> ListTables -> m (Set ListedTable) #
Command ListTables (Set ListedTable) MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> ListTables -> m (Set ListedTable) #
Command ListTables (Set ListedTable) Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> ListTables -> m (Set ListedTable) #
Command ListTables (Set ListedTable) Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> ListTables -> m (Set ListedTable) #
Command ListTables (Set ListedTable) Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> ListTables -> m (Set ListedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
Command (CreateMaterializedView MaterializedViewMeta) () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CreateMaterializedView MaterializedViewMeta -> m () #
Command (CreateMaterializedView MsSqlMaterializedViewMeta) () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateMaterializedView MsSqlMaterializedViewMeta -> m () #
Command (CreateMaterializedView MaterializedViewMeta) () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateMaterializedView MaterializedViewMeta -> m () #
Command (CreateMaterializedView SqliteMaterializedViewMeta) () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateMaterializedView SqliteMaterializedViewMeta -> m () #
Command (CreateMaterializedView ()) () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CreateMaterializedView () -> m () #
Command (CreateTable TableMeta) () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CreateTable TableMeta -> m () #
Command (CreateTable TableMeta) () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateTable TableMeta -> m () #
Command (CreateTable TableMeta) () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateTable TableMeta -> m () #
Command (CreateTable TableMeta) () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CreateTable TableMeta -> m () #
Command (CreateTable ()) () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CreateTable () -> m () #
Command (CreateTable ()) () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CreateTable () -> m () #
Command (CreateTable ()) () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateTable () -> m () #
Command (CreateTableDDL TableMeta) () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CreateTableDDL TableMeta -> m () #
Command (CreateTableDDL TableMeta) () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateTableDDL TableMeta -> m () #
Command (CreateTableDDL TableMeta) () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateTableDDL TableMeta -> m () #
Command (CreateTableDDL TableMeta) () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CreateTableDDL TableMeta -> m () #
Command (CreateTableDDL ()) () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateTableDDL () -> m () #
Command (CreateView ViewMeta) () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> CreateView ViewMeta -> m () #
Command (CreateView ()) () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateView () -> m () #
Command (CreateView ()) () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateView () -> m () #
Command (CreateView ()) () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> CreateView () -> m () #
Command (CreateView ()) () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateView () -> m () #

sqliteUriSyntax :: Text -> IO FilePath #

withSqliteString #

Arguments

:: ConnectionString
-> (BackendConn Sqlite -> IO b)	sqlite uri
-> IO b

data family BackendSchemaField (bk :: k) #

Instances

Instances details

Command GetRelationSchema [BackendSchemaField BigQuery] BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> GetRelationSchema -> m [BackendSchemaField BigQuery] #
Command GetRelationSchema [BackendSchemaField MsSql] MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> GetRelationSchema -> m [BackendSchemaField MsSql] #
Command GetRelationSchema [BackendSchemaField Postgres] Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> GetRelationSchema -> m [BackendSchemaField Postgres] #
Command GetRelationSchema [BackendSchemaField Redshift] Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> GetRelationSchema -> m [BackendSchemaField Redshift] #
Command GetRelationSchema [BackendSchemaField Sqlite] Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> GetRelationSchema -> m [BackendSchemaField Sqlite] #
Show (BackendSchemaField BigQuery) #
Instance details Defined in Napkin.Run.BigQuery Methods showsPrec :: Int -> BackendSchemaField BigQuery -> ShowS # show :: BackendSchemaField BigQuery -> String # showList :: [BackendSchemaField BigQuery] -> ShowS #
Show (BackendSchemaField MsSql) #
Instance details Defined in Napkin.Run.MsSql Methods showsPrec :: Int -> BackendSchemaField MsSql -> ShowS # show :: BackendSchemaField MsSql -> String # showList :: [BackendSchemaField MsSql] -> ShowS #
Show (BackendSchemaField Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods showsPrec :: Int -> BackendSchemaField Postgres -> ShowS # show :: BackendSchemaField Postgres -> String # showList :: [BackendSchemaField Postgres] -> ShowS #
Show (BackendSchemaField Redshift) #
Instance details Defined in Napkin.Run.Redshift Methods showsPrec :: Int -> BackendSchemaField Redshift -> ShowS # show :: BackendSchemaField Redshift -> String # showList :: [BackendSchemaField Redshift] -> ShowS #
Show (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods showsPrec :: Int -> BackendSchemaField Sqlite -> ShowS # show :: BackendSchemaField Sqlite -> String # showList :: [BackendSchemaField Sqlite] -> ShowS #
Eq (BackendSchemaField BigQuery) #
Instance details Defined in Napkin.Run.BigQuery Methods (==) :: BackendSchemaField BigQuery -> BackendSchemaField BigQuery -> Bool # (/=) :: BackendSchemaField BigQuery -> BackendSchemaField BigQuery -> Bool #
Eq (BackendSchemaField MsSql) #
Instance details Defined in Napkin.Run.MsSql Methods (==) :: BackendSchemaField MsSql -> BackendSchemaField MsSql -> Bool # (/=) :: BackendSchemaField MsSql -> BackendSchemaField MsSql -> Bool #
Eq (BackendSchemaField Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods (==) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool # (/=) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool #
Eq (BackendSchemaField Redshift) #
Instance details Defined in Napkin.Run.Redshift Methods (==) :: BackendSchemaField Redshift -> BackendSchemaField Redshift -> Bool # (/=) :: BackendSchemaField Redshift -> BackendSchemaField Redshift -> Bool #
Eq (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods (==) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool # (/=) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool #
FromRow (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods fromRow :: RowParser (BackendSchemaField Sqlite) #
data BackendSchemaField BigQuery #
Instance details Defined in Napkin.Run.BigQuery data BackendSchemaField BigQuery = BigQuerySchemaField TableFieldSchema
data BackendSchemaField MsSql #
Instance details Defined in Napkin.Run.MsSql data BackendSchemaField MsSql = MsSqlSchemaField MsSchemaField
data BackendSchemaField Postgres #
Instance details Defined in Napkin.Run.Postgres data BackendSchemaField Postgres = PostgresSchemaField PGSchemaField
data BackendSchemaField Redshift #
Instance details Defined in Napkin.Run.Redshift data BackendSchemaField Redshift = RedshiftSchemaField PGSchemaField
data BackendSchemaField Sqlite #
Instance details Defined in Napkin.Run.Sqlite data BackendSchemaField Sqlite = SqliteSchemaField { scdCid :: Int scdName :: Text scdType :: Text scdNullable :: Int scdDefaultValue :: Maybe Int scdPrimaryKey :: Int }

getSchema :: MonadNapkin Sqlite m => BackendConn Sqlite -> Relation -> Ref Table -> m [BackendSchemaField Sqlite] #

data family DbBackendOptions b #

Instances

Instances details

FromJSON (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

Methods

parseJSON :: Value -> Parser (DbBackendOptions BigQuery) #

parseJSONList :: Value -> Parser [DbBackendOptions BigQuery] #

omittedField :: Maybe (DbBackendOptions BigQuery) #

FromJSON (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

Methods

parseJSON :: Value -> Parser (DbBackendOptions MsSql) #

parseJSONList :: Value -> Parser [DbBackendOptions MsSql] #

omittedField :: Maybe (DbBackendOptions MsSql) #

FromJSON (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Methods

parseJSON :: Value -> Parser (DbBackendOptions Postgres) #

parseJSONList :: Value -> Parser [DbBackendOptions Postgres] #

omittedField :: Maybe (DbBackendOptions Postgres) #

FromJSON (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

Methods

parseJSON :: Value -> Parser (DbBackendOptions Redshift) #

parseJSONList :: Value -> Parser [DbBackendOptions Redshift] #

omittedField :: Maybe (DbBackendOptions Redshift) #

FromJSON (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

Methods

parseJSON :: Value -> Parser (DbBackendOptions Sqlite) #

parseJSONList :: Value -> Parser [DbBackendOptions Sqlite] #

omittedField :: Maybe (DbBackendOptions Sqlite) #

Generic (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

Associated Types

type Rep (DbBackendOptions BigQuery)

Instance details

Defined in Napkin.Run.BigQuery.Types

type Rep (DbBackendOptions BigQuery) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.BigQuery.Types" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "BigQueryOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Labels) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Seconds)))))

Methods

from :: DbBackendOptions BigQuery -> Rep (DbBackendOptions BigQuery) x #

to :: Rep (DbBackendOptions BigQuery) x -> DbBackendOptions BigQuery #

Generic (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

Associated Types

type Rep (DbBackendOptions MsSql)
Instance details Defined in Napkin.Run.MsSql type Rep (DbBackendOptions MsSql) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.MsSql" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "MsSqlOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

Methods

from :: DbBackendOptions MsSql -> Rep (DbBackendOptions MsSql) x #

to :: Rep (DbBackendOptions MsSql) x -> DbBackendOptions MsSql #

Generic (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Associated Types

type Rep (DbBackendOptions Postgres)
Instance details Defined in Napkin.Run.Postgres type Rep (DbBackendOptions Postgres) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "PostgresOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

Methods

from :: DbBackendOptions Postgres -> Rep (DbBackendOptions Postgres) x #

to :: Rep (DbBackendOptions Postgres) x -> DbBackendOptions Postgres #

Generic (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

Associated Types

type Rep (DbBackendOptions Redshift)
Instance details Defined in Napkin.Run.Redshift type Rep (DbBackendOptions Redshift) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Redshift" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "RedshiftOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

Methods

from :: DbBackendOptions Redshift -> Rep (DbBackendOptions Redshift) x #

to :: Rep (DbBackendOptions Redshift) x -> DbBackendOptions Redshift #

Generic (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

Associated Types

type Rep (DbBackendOptions Sqlite)
Instance details Defined in Napkin.Run.Sqlite type Rep (DbBackendOptions Sqlite) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Sqlite" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "SqliteOptions" 'PrefixI 'False) (U1 :: Type -> Type))

Methods

from :: DbBackendOptions Sqlite -> Rep (DbBackendOptions Sqlite) x #

to :: Rep (DbBackendOptions Sqlite) x -> DbBackendOptions Sqlite #

Show (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

Methods

showsPrec :: Int -> DbBackendOptions BigQuery -> ShowS #

show :: DbBackendOptions BigQuery -> String #

showList :: [DbBackendOptions BigQuery] -> ShowS #

Show (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

Methods

showsPrec :: Int -> DbBackendOptions MsSql -> ShowS #

show :: DbBackendOptions MsSql -> String #

showList :: [DbBackendOptions MsSql] -> ShowS #

Show (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Methods

showsPrec :: Int -> DbBackendOptions Postgres -> ShowS #

show :: DbBackendOptions Postgres -> String #

showList :: [DbBackendOptions Postgres] -> ShowS #

Show (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

Methods

showsPrec :: Int -> DbBackendOptions Redshift -> ShowS #

show :: DbBackendOptions Redshift -> String #

showList :: [DbBackendOptions Redshift] -> ShowS #

Show (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

Methods

showsPrec :: Int -> DbBackendOptions Sqlite -> ShowS #

show :: DbBackendOptions Sqlite -> String #

showList :: [DbBackendOptions Sqlite] -> ShowS #

Default (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

Methods

def :: DbBackendOptions BigQuery #

Default (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

Methods

def :: DbBackendOptions MsSql #

Default (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Methods

def :: DbBackendOptions Postgres #

Default (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

Methods

def :: DbBackendOptions Redshift #

Default (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

Methods

def :: DbBackendOptions Sqlite #

Eq (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

Methods

(==) :: DbBackendOptions BigQuery -> DbBackendOptions BigQuery -> Bool #

(/=) :: DbBackendOptions BigQuery -> DbBackendOptions BigQuery -> Bool #

Eq (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

Methods

(==) :: DbBackendOptions MsSql -> DbBackendOptions MsSql -> Bool #

(/=) :: DbBackendOptions MsSql -> DbBackendOptions MsSql -> Bool #

Eq (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Methods

(==) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool #

(/=) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool #

Eq (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

Methods

(==) :: DbBackendOptions Redshift -> DbBackendOptions Redshift -> Bool #

(/=) :: DbBackendOptions Redshift -> DbBackendOptions Redshift -> Bool #

Eq (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

Methods

(==) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool #

(/=) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool #

data DbBackendOptions BigQuery #

Instance details

Defined in Napkin.Run.BigQuery.Types

data DbBackendOptions BigQuery = BigQueryOptions Labels Natural (Maybe Seconds)

newtype DbBackendOptions MsSql #

Instance details

Defined in Napkin.Run.MsSql

newtype DbBackendOptions MsSql = MsSqlOptions Natural

newtype DbBackendOptions Postgres #

Instance details

Defined in Napkin.Run.Postgres

newtype DbBackendOptions Postgres = PostgresOptions Natural

newtype DbBackendOptions Redshift #

Instance details

Defined in Napkin.Run.Redshift

newtype DbBackendOptions Redshift = RedshiftOptions Natural

data DbBackendOptions Sqlite #

Instance details

Defined in Napkin.Run.Sqlite

data DbBackendOptions Sqlite = SqliteOptions

type Rep (DbBackendOptions BigQuery) #

Instance details

Defined in Napkin.Run.BigQuery.Types

type Rep (DbBackendOptions BigQuery) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.BigQuery.Types" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "BigQueryOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Labels) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Seconds)))))

type Rep (DbBackendOptions MsSql) #

Instance details

Defined in Napkin.Run.MsSql

type Rep (DbBackendOptions MsSql) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.MsSql" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "MsSqlOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

type Rep (DbBackendOptions Postgres) #

Instance details

Defined in Napkin.Run.Postgres

type Rep (DbBackendOptions Postgres) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "PostgresOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

type Rep (DbBackendOptions Redshift) #

Instance details

Defined in Napkin.Run.Redshift

type Rep (DbBackendOptions Redshift) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Redshift" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "RedshiftOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

type Rep (DbBackendOptions Sqlite) #

Instance details

Defined in Napkin.Run.Sqlite

type Rep (DbBackendOptions Sqlite) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Sqlite" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "SqliteOptions" 'PrefixI 'False) (U1 :: Type -> Type))

Orphan instances

Backend Sqlite #

Instance details

Associated Types

data BackendConn Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendConn Sqlite = SqliteConn { connectionString :: ConnectionString sqliteConn :: Pool Connection }

Methods

backendQuery :: (MonadNapkin Sqlite m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn Sqlite -> ConnectionString #

RunBackendConn Sqlite #

Instance details

Methods

runBackendConn :: LogEnv -> DbBackendOptions Sqlite -> ConnectionString -> AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn Sqlite -> IO a) -> IO a #

FromField Value #

Instance details

Methods

fromField :: FieldParser Value #

FromRow Text #

Instance details

Methods

fromRow :: RowParser Text #

HasBackendSchemaField Sqlite #

Instance details

Associated Types

data BackendSchemaField Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendSchemaField Sqlite = SqliteSchemaField { scdCid :: Int scdName :: Text scdType :: Text scdNullable :: Int scdDefaultValue :: Maybe Int scdPrimaryKey :: Int }

Methods

fieldName :: BackendSchemaField Sqlite -> Text #

fieldType :: BackendSchemaField Sqlite -> Type #

CSVImport Sqlite #

Instance details

Methods

chunkLimit :: Int #

isEnabled :: Bool #

HasBackendQueryStats Sqlite #

Instance details

Associated Types

data BackendQueryStats Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendQueryStats Sqlite = BackendQueryStats

Methods

prettyPrint :: BackendQueryStats Sqlite -> Maybe String #

Command AEDA TableDiagnostics Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> AEDA -> m TableDiagnostics #

Command AnnotateCommand () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> AnnotateCommand -> m () #

Command CheckTableExists Bool Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CheckTableExists -> m Bool #

Command CopyTable () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CopyTable -> m () #

Command DeleteFrom () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DeleteFrom -> m () #

Command DropTable () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DropTable -> m () #

Command DropView () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> DropView -> m () #

Command GetTableKind TableKind Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> GetTableKind -> m TableKind #

Command InsertIntoQuery () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> InsertIntoQuery -> m () #

Command InsertIntoTable () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> InsertIntoTable -> m () #

Command ReadAnnotationCommand TableAnnotations Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> ReadAnnotationCommand -> m TableAnnotations #

Command RenameTable () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> RenameTable -> m () #

Command Grant () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> Grant -> m () #

Command UpdateQuery () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> UpdateQuery -> m () #

Command GetRelationSchema [BackendSchemaField Sqlite] Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> GetRelationSchema -> m [BackendSchemaField Sqlite] #

Command ListTables (Set ListedTable) Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> ListTables -> m (Set ListedTable) #

Command NormalizeTableNames (Map (Ref Table) NormalizedTable) Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #

FromJSON (DbBackendOptions Sqlite) #

Instance details

Methods

parseJSON :: Value -> Parser (DbBackendOptions Sqlite) #

parseJSONList :: Value -> Parser [DbBackendOptions Sqlite] #

omittedField :: Maybe (DbBackendOptions Sqlite) #

Generic (DbBackendOptions Sqlite) #

Instance details

Associated Types

type Rep (DbBackendOptions Sqlite)
Instance details Defined in Napkin.Run.Sqlite type Rep (DbBackendOptions Sqlite) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Sqlite" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "SqliteOptions" 'PrefixI 'False) (U1 :: Type -> Type))

Methods

from :: DbBackendOptions Sqlite -> Rep (DbBackendOptions Sqlite) x #

to :: Rep (DbBackendOptions Sqlite) x -> DbBackendOptions Sqlite #

Show (DbBackendOptions Sqlite) #

Instance details

Methods

showsPrec :: Int -> DbBackendOptions Sqlite -> ShowS #

show :: DbBackendOptions Sqlite -> String #

showList :: [DbBackendOptions Sqlite] -> ShowS #

Default (DbBackendOptions Sqlite) #

Instance details

Methods

def :: DbBackendOptions Sqlite #

Eq (DbBackendOptions Sqlite) #

Instance details

Methods

(==) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool #

(/=) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool #

Command (CreateMaterializedView SqliteMaterializedViewMeta) () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateMaterializedView SqliteMaterializedViewMeta -> m () #

Command (CreateTable ()) () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateTable () -> m () #

Command (CreateTableDDL ()) () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateTableDDL () -> m () #

Command (CreateView ()) () Sqlite #

Instance details

Methods

execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> CreateView () -> m () #

FromJSON (BackendQueryStats Sqlite) #

Instance details

Methods

parseJSON :: Value -> Parser (BackendQueryStats Sqlite) #

parseJSONList :: Value -> Parser [BackendQueryStats Sqlite] #

omittedField :: Maybe (BackendQueryStats Sqlite) #

ToJSON (BackendQueryStats Sqlite) #

Instance details

Methods

toJSON :: BackendQueryStats Sqlite -> Value #

toEncoding :: BackendQueryStats Sqlite -> Encoding #

toJSONList :: [BackendQueryStats Sqlite] -> Value #

toEncodingList :: [BackendQueryStats Sqlite] -> Encoding #

omitField :: BackendQueryStats Sqlite -> Bool #

Monoid (BackendQueryStats Sqlite) #

Instance details

Methods

mempty :: BackendQueryStats Sqlite #

mappend :: BackendQueryStats Sqlite -> BackendQueryStats Sqlite -> BackendQueryStats Sqlite #

mconcat :: [BackendQueryStats Sqlite] -> BackendQueryStats Sqlite #

Semigroup (BackendQueryStats Sqlite) #

Instance details

Methods

(<>) :: BackendQueryStats Sqlite -> BackendQueryStats Sqlite -> BackendQueryStats Sqlite #

sconcat :: NonEmpty (BackendQueryStats Sqlite) -> BackendQueryStats Sqlite #

stimes :: Integral b => b -> BackendQueryStats Sqlite -> BackendQueryStats Sqlite #

Generic (BackendQueryStats Sqlite) #

Instance details

Associated Types

type Rep (BackendQueryStats Sqlite)
Instance details Defined in Napkin.Run.Sqlite type Rep (BackendQueryStats Sqlite) = D1 ('MetaData "BackendQueryStats" "Napkin.Run.Sqlite" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "BackendQueryStats" 'PrefixI 'False) (U1 :: Type -> Type))