Copyright	(c) Soostone Inc 2020
License	AllRightsReserved
Stability	experimental
Portability	POSIX
Safe Haskell	Safe-Inferred
Language	GHC2021

Napkin.Run.Sqlite

Contents

Orphan instances

Description

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 # 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 # 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 # 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 # 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 # 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 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 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 (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 #

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] #
FromJSON (DbBackendOptions MsSql) #
Instance details Defined in Napkin.Run.MsSql Methods parseJSON :: Value -> Parser (DbBackendOptions MsSql) # parseJSONList :: Value -> Parser [DbBackendOptions MsSql] #
FromJSON (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods parseJSON :: Value -> Parser (DbBackendOptions Postgres) # parseJSONList :: Value -> Parser [DbBackendOptions Postgres] #
FromJSON (DbBackendOptions Redshift) #
Instance details Defined in Napkin.Run.Redshift Methods parseJSON :: Value -> Parser (DbBackendOptions Redshift) # parseJSONList :: Value -> Parser [DbBackendOptions Redshift] #
FromJSON (DbBackendOptions Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods parseJSON :: Value -> Parser (DbBackendOptions Sqlite) # parseJSONList :: Value -> Parser [DbBackendOptions Sqlite] #
Generic (DbBackendOptions BigQuery) #
Instance details Defined in Napkin.Run.BigQuery.Types Associated Types type Rep (DbBackendOptions BigQuery) :: Type -> Type # 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) :: Type -> Type # 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) :: Type -> Type # 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) :: Type -> Type # 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) :: 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-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" '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-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" '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-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" '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-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" '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-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" 'False) (C1 ('MetaCons "SqliteOptions" 'PrefixI 'False) (U1 :: Type -> Type))

Orphan instances

Backend Sqlite #
Instance details Associated Types data BackendConn Sqlite # 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 # 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 # 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 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] #
Generic (DbBackendOptions Sqlite) #
Instance details Associated Types type Rep (DbBackendOptions Sqlite) :: 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 (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] #
ToJSON (BackendQueryStats Sqlite) #
Instance details Methods toJSON :: BackendQueryStats Sqlite -> Value # toEncoding :: BackendQueryStats Sqlite -> Encoding # toJSONList :: [BackendQueryStats Sqlite] -> Value # toEncodingList :: [BackendQueryStats Sqlite] -> Encoding #
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) :: Type -> Type # Methods from :: BackendQueryStats Sqlite -> Rep (BackendQueryStats Sqlite) x # to :: Rep (BackendQueryStats Sqlite) x -> BackendQueryStats Sqlite #
Show (BackendSchemaField Sqlite) #
Instance details Methods showsPrec :: Int -> BackendSchemaField Sqlite -> ShowS # show :: BackendSchemaField Sqlite -> String # showList :: [BackendSchemaField Sqlite] -> ShowS #
Show (BackendQueryStats Sqlite) #
Instance details Methods showsPrec :: Int -> BackendQueryStats Sqlite -> ShowS # show :: BackendQueryStats Sqlite -> String # showList :: [BackendQueryStats Sqlite] -> ShowS #
Eq (BackendSchemaField Sqlite) #
Instance details Methods (==) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool # (/=) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool #
Eq (BackendQueryStats Sqlite) #
Instance details Methods (==) :: BackendQueryStats Sqlite -> BackendQueryStats Sqlite -> Bool # (/=) :: BackendQueryStats Sqlite -> BackendQueryStats Sqlite -> Bool #
FromRow (BackendSchemaField Sqlite) #
Instance details Methods fromRow :: RowParser (BackendSchemaField Sqlite) #