Copyright	(c) Soostone Inc 2020
License	AllRightsReserved
Stability	experimental
Portability	POSIX
Safe Haskell	None
Language	Haskell2010

Napkin.Run.Sqlite

Contents

Orphan instances

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 # Methods backendQuery :: (Katip m, MonadQueryStats m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m [Map Text Value] # backendExecute :: (Katip m, MonadQueryStats m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m () #
Backend Redshift #
Instance details Defined in Napkin.Run.Redshift Associated Types data BackendConn Redshift # Methods backendQuery :: (Katip m, MonadQueryStats m, RenderSql q Redshift) => BackendConn Redshift -> q -> m [Map Text Value] # backendExecute :: (Katip m, MonadQueryStats m, RenderSql q Redshift) => BackendConn Redshift -> q -> m () #
Backend Postgres #
Instance details Defined in Napkin.Run.Postgres Associated Types data BackendConn Postgres # Methods backendQuery :: (Katip m, MonadQueryStats m, RenderSql q Postgres) => BackendConn Postgres -> q -> m [Map Text Value] # backendExecute :: (Katip m, MonadQueryStats m, RenderSql q Postgres) => BackendConn Postgres -> q -> m () #
Backend BigQuery #
Instance details Defined in Napkin.Run.BigQuery Associated Types data BackendConn BigQuery # Methods backendQuery :: (Katip m, MonadQueryStats m, RenderSql q BigQuery) => BackendConn BigQuery -> q -> m [Map Text Value] # backendExecute :: (Katip m, MonadQueryStats m, RenderSql q BigQuery) => BackendConn BigQuery -> q -> m () #

class HasSqliteConn a #

Minimal complete definition

getSqliteConn

Instances

Instances details

HasSqliteConn Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods getSqliteConn :: BackendConn Sqlite -> Pool Connection #

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

Minimal complete definition

execCommand

Instances

Instances details

Command Grant Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> Grant -> m Int #
Command Grant Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> Grant -> m Int64 #
Command Grant Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> Grant -> m Int64 #
Command Grant () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> Grant -> m () #
Command CheckTableExists Bool Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CheckTableExists -> m Bool #
Command CheckTableExists Bool Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CheckTableExists -> m Bool #
Command CheckTableExists Bool Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CheckTableExists -> m Bool #
Command CheckTableExists Bool BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CheckTableExists -> m Bool #
Command DeleteFrom Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DeleteFrom -> m Int #
Command DeleteFrom Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> DeleteFrom -> m Int64 #
Command DeleteFrom Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DeleteFrom -> m Int64 #
Command DeleteFrom Job BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> DeleteFrom -> m Job #
Command InsertIntoQuery Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> InsertIntoQuery -> m Int #
Command InsertIntoQuery Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> InsertIntoQuery -> m Int64 #
Command InsertIntoQuery Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> InsertIntoQuery -> m Int64 #
Command InsertIntoQuery Job BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> InsertIntoQuery -> m Job #
Command DropTable Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DropTable -> m Int #
Command DropTable Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> DropTable -> m Int64 #
Command DropTable Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DropTable -> m Int64 #
Command DropTable () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> DropTable -> m () #
Command DropView Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DropView -> m Int #
Command DropView Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> DropView -> m Int64 #
Command DropView Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DropView -> m Int64 #
Command DropView () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> DropView -> m () #
Command CopyTable Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CopyTable -> m Int #
Command CopyTable Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CopyTable -> m Int64 #
Command CopyTable Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CopyTable -> m Int64 #
Command CopyTable () BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CopyTable -> m () #
Command RenameTable Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> RenameTable -> m Int #
Command RenameTable Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> RenameTable -> m Int64 #
Command RenameTable Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> RenameTable -> m Int64 #
Command RenameTable () BigQuery #	BQ implements rename via copy-then-drop
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> RenameTable -> m () #
Command GetRelationSchema (Fields Field) Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> GetRelationSchema -> m (Fields Field) #
Command GetRelationSchema (Fields Field) Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> GetRelationSchema -> m (Fields Field) #
Command GetRelationSchema (Fields Field) Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> GetRelationSchema -> m (Fields Field) #
Command GetRelationSchema (Fields Field) BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> GetRelationSchema -> m (Fields Field) #
Command (CreateMaterializedViewAs ()) Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CreateMaterializedViewAs () -> m Int64 #
Command (CreateMaterializedViewAs ()) Table BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CreateMaterializedViewAs () -> m Table #
Command (CreateMaterializedViewAs SqliteMaterializedViewMeta) Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateMaterializedViewAs SqliteMaterializedViewMeta -> m Int #
Command (CreateMaterializedViewAs MaterializedViewMeta) Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateMaterializedViewAs MaterializedViewMeta -> m Int64 #
Command (CreateViewAs ()) Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateViewAs () -> m Int #
Command (CreateViewAs ()) Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CreateViewAs () -> m Int64 #
Command (CreateViewAs ()) Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateViewAs () -> m Int64 #
Command (CreateViewAs ()) Table BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CreateViewAs () -> m Table #
Command (CreateTableAs ()) Int Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateTableAs () -> m Int #
Command (CreateTableAs ()) Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CreateTableAs () -> m Int64 #
Command (CreateTableAs ()) Job BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CreateTableAs () -> m Job #
Command (CreateTableAs TableMeta) Int64 Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CreateTableAs TableMeta -> m Int64 #
Command (CreateTableAs TableMeta) Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateTableAs TableMeta -> m Int64 #
Command (CreateTableAs TableMeta) Job BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CreateTableAs TableMeta -> m Job #

sqliteUriSyntax :: String -> IO FilePath #

withSqliteString #

Arguments

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

columnsToSchema :: [SchemaColDef] -> Schema Field #

getSqliteConn :: HasSqliteConn a => BackendConn a -> Pool Connection #

getSchema :: (Katip f, HasSqliteConn bk, Command DropView t0 bk, RenderSql Query bk, RenderSql DropView bk, Command (CreateViewAs ()) t1 bk, MonadQueryStats f, bk ~ Sqlite) => bk -> BackendConn bk -> Relation -> f (Fields Field) #

Orphan instances

FromField Value #
Instance details Methods fromField :: FieldParser Value #
Backend Sqlite #
Instance details Associated Types data BackendConn Sqlite # Methods backendQuery :: (Katip m, MonadQueryStats m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m [Map Text Value] # backendExecute :: (Katip m, MonadQueryStats m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m () #
RunBackendConn Sqlite #
Instance details Methods runBackendConn :: LogEnv -> DbBackendOptions Sqlite -> ConnectionString -> Maybe AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn Sqlite -> IO a) -> IO a #
Command Grant Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> Grant -> m Int #
Command CheckTableExists Bool Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CheckTableExists -> m Bool #
Command DeleteFrom Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DeleteFrom -> m Int #
Command InsertIntoQuery Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> InsertIntoQuery -> m Int #
Command DropTable Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DropTable -> m Int #
Command DropView Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> DropView -> m Int #
Command CopyTable Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CopyTable -> m Int #
Command RenameTable Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> RenameTable -> m Int #
Command GetRelationSchema (Fields Field) Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> GetRelationSchema -> m (Fields Field) #
Eq (DbBackendOptions Sqlite) #
Instance details Methods (==) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool # (/=) :: DbBackendOptions Sqlite -> DbBackendOptions Sqlite -> Bool #
Show (DbBackendOptions Sqlite) #
Instance details Methods showsPrec :: Int -> DbBackendOptions Sqlite -> ShowS # show :: DbBackendOptions Sqlite -> String # showList :: [DbBackendOptions Sqlite] -> ShowS #
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 #
ToJSON (DbBackendOptions Sqlite) #
Instance details Methods toJSON :: DbBackendOptions Sqlite -> Value # toEncoding :: DbBackendOptions Sqlite -> Encoding # toJSONList :: [DbBackendOptions Sqlite] -> Value # toEncodingList :: [DbBackendOptions Sqlite] -> Encoding #
FromJSON (DbBackendOptions Sqlite) #
Instance details Methods parseJSON :: Value -> Parser (DbBackendOptions Sqlite) # parseJSONList :: Value -> Parser [DbBackendOptions Sqlite] #
Default (DbBackendOptions Sqlite) #
Instance details Methods def :: DbBackendOptions Sqlite #
Command (CreateMaterializedViewAs SqliteMaterializedViewMeta) Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateMaterializedViewAs SqliteMaterializedViewMeta -> m Int #
Command (CreateViewAs ()) Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateViewAs () -> m Int #
Command (CreateTableAs ()) Int Sqlite #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CreateTableAs () -> m Int #