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

Napkin.Run.Postgres

Contents

Postgres Re-exports
Orphan instances

Description

Synopsis

withPostgresString :: Natural -> Text -> (BackendConn Postgres -> IO b) -> IO b
data family BackendSchemaField bk
data family BackendConn b

Postgres Re-exports

withPostgresString :: Natural -> Text -> (BackendConn Postgres -> IO b) -> 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 }

data family BackendConn b #

Instances

Instances details

Generic (BackendConn Postgres) #
Instance details Defined in Napkin.Run.Postgres Associated Types type Rep (BackendConn Postgres) :: Type -> Type # Methods from :: BackendConn Postgres -> Rep (BackendConn Postgres) x # to :: Rep (BackendConn Postgres) x -> BackendConn Postgres #
data BackendConn BigQuery #
Instance details Defined in Napkin.Run.BigQuery data BackendConn BigQuery = BigQueryEnv { bqeEnv :: Pool GoogleEnv bqeDefaultProject :: BQProjectId bqeJobLabels :: Labels }
data BackendConn MsSql #
Instance details Defined in Napkin.Run.MsSql data BackendConn MsSql = MsSqlConn { getConnectionString :: ConnectionString getMsSqlConn :: Pool Connection }
data BackendConn Postgres #
Instance details Defined in Napkin.Run.Postgres data BackendConn Postgres = PostgresConn { getConnectionString :: ConnectionString getPostgresConn :: Pool Connection }
data BackendConn Redshift #
Instance details Defined in Napkin.Run.Redshift data BackendConn Redshift = RedshiftConn ConnectionString (Pool Connection)
data BackendConn Sqlite #
Instance details Defined in Napkin.Run.Sqlite data BackendConn Sqlite = SqliteConn { getConnectionString :: ConnectionString getSqliteConn :: Pool Connection }
type Rep (BackendConn Postgres) #
Instance details Defined in Napkin.Run.Postgres type Rep (BackendConn Postgres) = D1 ('MetaData "BackendConn" "Napkin.Run.Postgres" "napkin-0.5.14-JrXUGmKUOt9J0meJSj0Kh4" 'False) (C1 ('MetaCons "PostgresConn" 'PrefixI 'True) (S1 ('MetaSel ('Just "getConnectionString") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ConnectionString) :*: S1 ('MetaSel ('Just "getPostgresConn") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Pool Connection))))

Orphan instances

Backend Postgres #
Instance details Associated Types data BackendConn Postgres # Methods backendQuery :: (MonadNapkin Postgres m, RenderSql q Postgres) => BackendConn Postgres -> q -> m [Map Text Value] # backendConnectionString :: BackendConn Postgres -> ConnectionString #
HasPostgresConn Postgres #
Instance details Methods getPostgresConn :: BackendConn Postgres -> Pool Connection #
RunBackendConn Postgres #
Instance details Methods runBackendConn :: LogEnv -> DbBackendOptions Postgres -> ConnectionString -> AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn Postgres -> IO a) -> IO a #
HasBackendSchemaField Postgres #
Instance details Associated Types data BackendSchemaField Postgres # Methods fieldName :: BackendSchemaField Postgres -> Text # fieldType :: BackendSchemaField Postgres -> Type #
CSVImport Postgres #
Instance details Methods chunkLimit :: Int # isEnabled :: Bool #
HasBackendQueryStats Postgres #
Instance details Associated Types data BackendQueryStats Postgres # Methods prettyPrint :: BackendQueryStats Postgres -> Maybe String #
Command AEDA TableDiagnostics Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> AEDA -> m TableDiagnostics #
Command AnnotateCommand () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> AnnotateCommand -> m () #
Command CheckTableExists Bool Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CheckTableExists -> m Bool #
Command CopyTable () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CopyTable -> m () #
Command DeleteFrom () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DeleteFrom -> m () #
Command DropTable () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DropTable -> m () #
Command DropView () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> DropView -> m () #
Command GetTableKind TableKind Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> GetTableKind -> m TableKind #
Command InsertIntoQuery () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> InsertIntoQuery -> m () #
Command ReadAnnotationCommand TableAnnotations Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> ReadAnnotationCommand -> m TableAnnotations #
Command RenameTable () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> RenameTable -> m () #
Command Grant () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> Grant -> m () #
Command UpdateQuery () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> UpdateQuery -> m () #
Command GetRelationSchema [BackendSchemaField Postgres] Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> GetRelationSchema -> m [BackendSchemaField Postgres] #
Command ListTables (Set ListedTable) Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> ListTables -> m (Set ListedTable) #
Command NormalizeTableNames (Map (Ref Table) NormalizedTable) Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #
FromJSON (DbBackendOptions Postgres) #
Instance details Methods parseJSON :: Value -> Parser (DbBackendOptions Postgres) # parseJSONList :: Value -> Parser [DbBackendOptions Postgres] #
Generic (BackendConn Postgres) #
Instance details Associated Types type Rep (BackendConn Postgres) :: Type -> Type # Methods from :: BackendConn Postgres -> Rep (BackendConn Postgres) x # to :: Rep (BackendConn Postgres) x -> BackendConn Postgres #
Generic (DbBackendOptions Postgres) #
Instance details Associated Types type Rep (DbBackendOptions Postgres) :: Type -> Type # Methods from :: DbBackendOptions Postgres -> Rep (DbBackendOptions Postgres) x # to :: Rep (DbBackendOptions Postgres) x -> DbBackendOptions Postgres #
Show (DbBackendOptions Postgres) #
Instance details Methods showsPrec :: Int -> DbBackendOptions Postgres -> ShowS # show :: DbBackendOptions Postgres -> String # showList :: [DbBackendOptions Postgres] -> ShowS #
Default (DbBackendOptions Postgres) #
Instance details Methods def :: DbBackendOptions Postgres #
Eq (DbBackendOptions Postgres) #
Instance details Methods (==) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool # (/=) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool #
Command (CreateMaterializedView MaterializedViewMeta) () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateMaterializedView MaterializedViewMeta -> m () #
Command (CreateTable TableMeta) () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateTable TableMeta -> m () #
Command (CreateView ()) () Postgres #
Instance details Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateView () -> m () #
FromJSON (BackendQueryStats Postgres) #
Instance details Methods parseJSON :: Value -> Parser (BackendQueryStats Postgres) # parseJSONList :: Value -> Parser [BackendQueryStats Postgres] #
ToJSON (BackendQueryStats Postgres) #
Instance details Methods toJSON :: BackendQueryStats Postgres -> Value # toEncoding :: BackendQueryStats Postgres -> Encoding # toJSONList :: [BackendQueryStats Postgres] -> Value # toEncodingList :: [BackendQueryStats Postgres] -> Encoding #
Monoid (BackendQueryStats Postgres) #
Instance details Methods mempty :: BackendQueryStats Postgres # mappend :: BackendQueryStats Postgres -> BackendQueryStats Postgres -> BackendQueryStats Postgres # mconcat :: [BackendQueryStats Postgres] -> BackendQueryStats Postgres #
Semigroup (BackendQueryStats Postgres) #
Instance details Methods (<>) :: BackendQueryStats Postgres -> BackendQueryStats Postgres -> BackendQueryStats Postgres # sconcat :: NonEmpty (BackendQueryStats Postgres) -> BackendQueryStats Postgres # stimes :: Integral b => b -> BackendQueryStats Postgres -> BackendQueryStats Postgres #
Generic (BackendQueryStats Postgres) #
Instance details Associated Types type Rep (BackendQueryStats Postgres) :: Type -> Type # Methods from :: BackendQueryStats Postgres -> Rep (BackendQueryStats Postgres) x # to :: Rep (BackendQueryStats Postgres) x -> BackendQueryStats Postgres #
Show (BackendSchemaField Postgres) #
Instance details Methods showsPrec :: Int -> BackendSchemaField Postgres -> ShowS # show :: BackendSchemaField Postgres -> String # showList :: [BackendSchemaField Postgres] -> ShowS #
Show (BackendQueryStats Postgres) #
Instance details Methods showsPrec :: Int -> BackendQueryStats Postgres -> ShowS # show :: BackendQueryStats Postgres -> String # showList :: [BackendQueryStats Postgres] -> ShowS #
Eq (BackendSchemaField Postgres) #
Instance details Methods (==) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool # (/=) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool #
Eq (BackendQueryStats Postgres) #
Instance details Methods (==) :: BackendQueryStats Postgres -> BackendQueryStats Postgres -> Bool # (/=) :: BackendQueryStats Postgres -> BackendQueryStats Postgres -> Bool #