Safe Haskell	None
Language	GHC2021

Napkin.Run.Postgres

Contents

Postgres Re-exports
Orphan instances

Synopsis

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

Postgres Re-exports

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

data family BackendConn b #

Instances

Instances details

Generic (BackendConn Postgres) #

Instance details

Defined in Napkin.Run.Postgres

Associated Types

type Rep (BackendConn Postgres)

Instance details

Defined in Napkin.Run.Postgres

type Rep (BackendConn Postgres) = D1 ('MetaData "BackendConn" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" '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))))

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 {

}

data BackendConn MsSql #

Instance details

Defined in Napkin.Run.MsSql

data BackendConn MsSql = MsSqlConn {

connectionString :: ConnectionString
msSqlConn :: Pool Connection

}

data BackendConn Postgres #

Instance details

Defined in Napkin.Run.Postgres

data BackendConn Postgres = PostgresConn {

}

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 {

connectionString :: ConnectionString
sqliteConn :: Pool Connection

}

type Rep (BackendConn Postgres) #

Instance details

Defined in Napkin.Run.Postgres

type Rep (BackendConn Postgres) = D1 ('MetaData "BackendConn" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" '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
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 #

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
Instance details Defined in Napkin.Run.Postgres data BackendSchemaField Postgres = PostgresSchemaField PGSchemaField

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
Instance details Defined in Napkin.Run.Postgres data BackendQueryStats Postgres = BackendQueryStats

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 InsertIntoTable () Postgres #

Instance details

Methods

execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> InsertIntoTable -> 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] #

omittedField :: Maybe (DbBackendOptions Postgres) #

Generic (BackendConn Postgres) #

Instance details

Associated Types

type Rep (BackendConn Postgres)

Instance details

Defined in Napkin.Run.Postgres

type Rep (BackendConn Postgres) = D1 ('MetaData "BackendConn" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" '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))))

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

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 (CreateTableDDL TableMeta) () Postgres #

Instance details

Methods

execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> CreateTableDDL 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] #

omittedField :: Maybe (BackendQueryStats Postgres) #

ToJSON (BackendQueryStats Postgres) #

Instance details

Methods

toJSON :: BackendQueryStats Postgres -> Value #

toEncoding :: BackendQueryStats Postgres -> Encoding #

toJSONList :: [BackendQueryStats Postgres] -> Value #

toEncodingList :: [BackendQueryStats Postgres] -> Encoding #

omitField :: BackendQueryStats Postgres -> Bool #

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)
Instance details Defined in Napkin.Run.Postgres type Rep (BackendQueryStats Postgres) = D1 ('MetaData "BackendQueryStats" "Napkin.Run.Postgres" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "BackendQueryStats" 'PrefixI 'False) (U1 :: Type -> Type))