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

Napkin.Run.Postgres

Contents

Postgres Re-exports
Orphan instances

Description

Synopsis

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

Postgres Re-exports

withPostgresString :: Natural -> String -> (BackendConn Postgres -> IO b) -> IO b #

data family BackendSchemaField bk #

Instances

Instances details

Command GetRelationSchema [BackendSchemaField Sqlite] Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> GetRelationSchema -> m [BackendSchemaField Sqlite] #
Command GetRelationSchema [BackendSchemaField Redshift] Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> GetRelationSchema -> m [BackendSchemaField Redshift] #
Command GetRelationSchema [BackendSchemaField Postgres] Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> GetRelationSchema -> m [BackendSchemaField Postgres] #
Command GetRelationSchema [BackendSchemaField BigQuery] BigQuery #
Instance details Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> GetRelationSchema -> m [BackendSchemaField BigQuery] #
Eq (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods (==) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool # (/=) :: BackendSchemaField Sqlite -> BackendSchemaField Sqlite -> Bool #
Eq (BackendSchemaField Redshift) #
Instance details Defined in Napkin.Run.Redshift Methods (==) :: BackendSchemaField Redshift -> BackendSchemaField Redshift -> Bool # (/=) :: BackendSchemaField Redshift -> BackendSchemaField Redshift -> Bool #
Eq (BackendSchemaField Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods (==) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool # (/=) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool #
Eq (BackendSchemaField BigQuery) #
Instance details Defined in Napkin.Run.BigQuery Methods (==) :: BackendSchemaField BigQuery -> BackendSchemaField BigQuery -> Bool # (/=) :: BackendSchemaField BigQuery -> BackendSchemaField BigQuery -> Bool #
Show (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods showsPrec :: Int -> BackendSchemaField Sqlite -> ShowS # show :: BackendSchemaField Sqlite -> String # showList :: [BackendSchemaField Sqlite] -> 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 Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods showsPrec :: Int -> BackendSchemaField Postgres -> ShowS # show :: BackendSchemaField Postgres -> String # showList :: [BackendSchemaField Postgres] -> ShowS #
Show (BackendSchemaField BigQuery) #
Instance details Defined in Napkin.Run.BigQuery Methods showsPrec :: Int -> BackendSchemaField BigQuery -> ShowS # show :: BackendSchemaField BigQuery -> String # showList :: [BackendSchemaField BigQuery] -> ShowS #
FromRow (BackendSchemaField Sqlite) #
Instance details Defined in Napkin.Run.Sqlite Methods fromRow :: RowParser (BackendSchemaField Sqlite) #
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 BackendSchemaField Redshift #
Instance details Defined in Napkin.Run.Redshift data BackendSchemaField Redshift = RedshiftSchemaField PGSchemaField
data BackendSchemaField Postgres #
Instance details Defined in Napkin.Run.Postgres data BackendSchemaField Postgres = PostgresSchemaField PGSchemaField
data BackendSchemaField BigQuery #
Instance details Defined in Napkin.Run.BigQuery data BackendSchemaField BigQuery = BigQuerySchemaField TableFieldSchema

data family BackendConn b #

Instances

Instances details

data BackendConn Sqlite #
Instance details Defined in Napkin.Run.Sqlite data BackendConn Sqlite = SqliteConn (Pool Connection)
data BackendConn Redshift #
Instance details Defined in Napkin.Run.Redshift data BackendConn Redshift = RedshiftConn (Pool Connection)
data BackendConn Postgres #
Instance details Defined in Napkin.Run.Postgres data BackendConn Postgres = PostgresConn { getPostgresConn :: Pool Connection }
data BackendConn BigQuery #
Instance details Defined in Napkin.Run.BigQuery data BackendConn BigQuery = BigQueryEnv { bqeEnv :: Pool GoogleEnv bqeProjectId :: BQProjectId bqeDatasetId :: Maybe BQDataSetId bqeJobLabels :: Labels }

Orphan instances

Backend Postgres #
Instance details 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 () #
RunBackendConn Postgres #
Instance details Methods runBackendConn :: LogEnv -> DbBackendOptions Postgres -> ConnectionString -> Maybe AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn Postgres -> IO a) -> IO a #
HasPostgresConn Postgres #
Instance details Methods getPostgresConn :: BackendConn Postgres -> Pool Connection #
Command UpdateQuery () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> UpdateQuery -> m () #
Command Grant () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> Grant -> m () #
Command CheckTableExists Bool Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CheckTableExists -> m Bool #
Command DeleteFrom () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DeleteFrom -> m () #
Command InsertIntoQuery () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> InsertIntoQuery -> m () #
Command DropTable () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DropTable -> m () #
Command DropView () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DropView -> m () #
Command CopyTable () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CopyTable -> m () #
Command RenameTable () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> RenameTable -> m () #
Command GetRelationSchema [BackendSchemaField Postgres] Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> GetRelationSchema -> m [BackendSchemaField Postgres] #
Eq (DbBackendOptions Postgres) #
Instance details Methods (==) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool # (/=) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool #
Show (DbBackendOptions Postgres) #
Instance details Methods showsPrec :: Int -> DbBackendOptions Postgres -> ShowS # show :: DbBackendOptions Postgres -> String # showList :: [DbBackendOptions Postgres] -> ShowS #
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 #
ToJSON (DbBackendOptions Postgres) #
Instance details Methods toJSON :: DbBackendOptions Postgres -> Value # toEncoding :: DbBackendOptions Postgres -> Encoding # toJSONList :: [DbBackendOptions Postgres] -> Value # toEncodingList :: [DbBackendOptions Postgres] -> Encoding #
FromJSON (DbBackendOptions Postgres) #
Instance details Methods parseJSON :: Value -> Parser (DbBackendOptions Postgres) # parseJSONList :: Value -> Parser [DbBackendOptions Postgres] #
Default (DbBackendOptions Postgres) #
Instance details Methods def :: DbBackendOptions Postgres #
HasBackendSchemaField Postgres #
Instance details Associated Types data BackendSchemaField Postgres # Methods fieldName :: BackendSchemaField Postgres -> Text # fieldType :: BackendSchemaField Postgres -> Type #
Command (CreateMaterializedViewAs MaterializedViewMeta) () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateMaterializedViewAs MaterializedViewMeta -> m () #
Command (CreateViewAs ()) () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateViewAs () -> m () #
Command (CreateTableAs TableMeta) () Postgres #
Instance details Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateTableAs TableMeta -> m () #
Eq (BackendSchemaField Postgres) #
Instance details Methods (==) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool # (/=) :: BackendSchemaField Postgres -> BackendSchemaField Postgres -> Bool #
Show (BackendSchemaField Postgres) #
Instance details Methods showsPrec :: Int -> BackendSchemaField Postgres -> ShowS # show :: BackendSchemaField Postgres -> String # showList :: [BackendSchemaField Postgres] -> ShowS #