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

Napkin.Types.Postgres

Description

Synopsis

data Postgres = Postgres
data SetTableSchema = SetTableSchema {
- _rtFrom :: Ref Table
- _rtNewSchema :: Text
}

Documentation

data Postgres #

Constructors

Postgres

Instances

Instances details

Eq Postgres #
Instance details Defined in Napkin.Types.Postgres Methods (==) :: Postgres -> Postgres -> Bool # (/=) :: Postgres -> Postgres -> Bool #
Data Postgres #
Instance details Defined in Napkin.Types.Postgres Methods gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> Postgres -> c Postgres # gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c Postgres # toConstr :: Postgres -> Constr # dataTypeOf :: Postgres -> DataType # dataCast1 :: Typeable t => (forall d. Data d => c (t d)) -> Maybe (c Postgres) # dataCast2 :: Typeable t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c Postgres) # gmapT :: (forall b. Data b => b -> b) -> Postgres -> Postgres # gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> Postgres -> r # gmapQr :: forall r r'. (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> Postgres -> r # gmapQ :: (forall d. Data d => d -> u) -> Postgres -> [u] # gmapQi :: Int -> (forall d. Data d => d -> u) -> Postgres -> u # gmapM :: Monad m => (forall d. Data d => d -> m d) -> Postgres -> m Postgres # gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> Postgres -> m Postgres # gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> Postgres -> m Postgres #
Ord Postgres #
Instance details Defined in Napkin.Types.Postgres Methods compare :: Postgres -> Postgres -> Ordering # (<) :: Postgres -> Postgres -> Bool # (<=) :: Postgres -> Postgres -> Bool # (>) :: Postgres -> Postgres -> Bool # (>=) :: Postgres -> Postgres -> Bool # max :: Postgres -> Postgres -> Postgres # min :: Postgres -> Postgres -> Postgres #
Show Postgres #
Instance details Defined in Napkin.Types.Postgres Methods showsPrec :: Int -> Postgres -> ShowS # show :: Postgres -> String # showList :: [Postgres] -> ShowS #
ReifiesBackend Postgres #
Instance details Defined in Napkin.Types.Postgres Methods reifyBackend :: Postgres #
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 () #
ParseSQL Postgres #
Instance details Defined in Napkin.Parse.Postgres Methods parseSQLStatement :: ParseSQLFun Postgres Query # parseSQLSExp :: ParseSQLFun Postgres SExp # parseSQLSelExps :: ParseSQLFun Postgres [Alias SExp] # parseSQLFrom :: ParseSQLFun Postgres From # parseSQLRelation :: ParseSQLFun Postgres (Alias Relation) #
HasPostgresConn Postgres #
Instance details Defined in Napkin.Run.Postgres Methods getPostgresConn :: BackendConn Postgres -> Pool Connection #
RunBackendEffect Postgres #
Instance details Defined in Napkin.Run.Effects.Interpreters.Backend.Postgres Methods runBackendEffectReal :: forall (r :: [(Type -> Type) -> Type -> Type]) a. (Members Core r, Member (Embed IO) r) => BackendConn Postgres -> Sem (BackendSpecificEffect Postgres ': r) a -> Sem r a # runBackendEffectFake :: forall (r :: [(Type -> Type) -> Type -> Type]) a. (Members Core r, Member (Embed IO) r) => Sem (BackendSpecificEffect Postgres ': r) a -> Sem r a #
RunBackendConn Postgres #
Instance details Defined in Napkin.Run.Postgres Methods runBackendConn :: LogEnv -> DbBackendOptions Postgres -> ConnectionString -> Maybe AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn Postgres -> IO a) -> IO a #
CommandDescr Grant Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> Grant -> String #
CommandDescr DeleteFrom Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DeleteFrom -> String #
CommandDescr InsertIntoQuery Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> InsertIntoQuery -> String #
CommandDescr DropTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DropTable -> String #
CommandDescr DropView Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DropView -> String #
CommandDescr CreateViewAs Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> CreateViewAs -> String #
CommandDescr RenameTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> RenameTable -> String #
RenderSql String Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> String -> Doc #
RenderSql Query Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Query -> Doc #
RenderSql From Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> From -> Doc #
RenderSql Relation Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Relation -> Doc #
RenderSql SExp Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> SExp -> Doc #
RenderSql Grant Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Grant -> Doc #
RenderSql Actor Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Actor -> Doc #
RenderSql Object Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Object -> Doc #
RenderSql Privilege Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Privilege -> Doc #
RenderSql DeleteFrom Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DeleteFrom -> Doc #
RenderSql InsertIntoQuery Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> InsertIntoQuery -> Doc #
RenderSql DropTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DropTable -> Doc #
RenderSql DropView Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DropView -> Doc #
RenderSql CreateViewAs Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> CreateViewAs -> Doc #
RenderSql RenameTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> RenameTable -> Doc #
RenderSql SetTableSchema Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> SetTableSchema -> Doc #
Command Grant Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> Grant -> m Int64 #
Command CheckTableExists Bool Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CheckTableExists -> m Bool #
Command DeleteFrom Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DeleteFrom -> 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 DropTable Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> DropTable -> 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 CreateViewAs Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateViewAs -> 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 RenameTable Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> RenameTable -> m Int64 #
Command GetRelationSchema (Fields Field) Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> GetRelationSchema -> m (Fields Field) #
Eq (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods (==) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool # (/=) :: DbBackendOptions Postgres -> DbBackendOptions Postgres -> Bool #
Show (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods showsPrec :: Int -> DbBackendOptions Postgres -> ShowS # show :: DbBackendOptions Postgres -> String # showList :: [DbBackendOptions Postgres] -> ShowS #
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 #
ToJSON (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods toJSON :: DbBackendOptions Postgres -> Value # toEncoding :: DbBackendOptions Postgres -> Encoding # toJSONList :: [DbBackendOptions Postgres] -> Value # toEncodingList :: [DbBackendOptions Postgres] -> Encoding #
FromJSON (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods parseJSON :: Value -> Parser (DbBackendOptions Postgres) # parseJSONList :: Value -> Parser [DbBackendOptions Postgres] #
Default (DbBackendOptions Postgres) #
Instance details Defined in Napkin.Run.Postgres Methods def :: DbBackendOptions Postgres #
HasCreateTableAs Postgres #
Instance details Defined in Napkin.Types.Postgres Associated Types type BackendTableMeta Postgres #
ReplaceReference Postgres #	Reference replacement
Instance details Defined in Napkin.Render.Postgres Methods replaceReference :: Proxy Postgres -> Ref Table -> Ref Table -> Text -> Text #
CommandDescr (CreateTableAs ()) Postgres #	Command descriptions
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> CreateTableAs () -> String #
RenderSql a Postgres => RenderSql (Alias a) Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Alias a -> Doc #
RenderSql (CreateTableAs ()) Postgres #	Commands
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> CreateTableAs () -> Doc #
ToDbBackend Postgres #
Instance details Defined in Napkin.Backends.Types Methods toDbBackend :: DbBackend #
Command (CreateTableAs ()) Int64 Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CreateTableAs () -> m Int64 #
ToJSON (YamlBackendTableMeta Postgres) #
Instance details Defined in Napkin.Spec.Yaml.Types Methods toJSON :: YamlBackendTableMeta Postgres -> Value # toEncoding :: YamlBackendTableMeta Postgres -> Encoding # toJSONList :: [YamlBackendTableMeta Postgres] -> Value # toEncodingList :: [YamlBackendTableMeta Postgres] -> Encoding #
FromJSON (YamlBackendTableMeta Postgres) #
Instance details Defined in Napkin.Spec.Yaml.Types Methods parseJSON :: Value -> Parser (YamlBackendTableMeta Postgres) # parseJSONList :: Value -> Parser [YamlBackendTableMeta Postgres] #
RenderSql (Ref t) Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Ref t -> Doc #
data BackendSpecificEffect Postgres m a #
Instance details Defined in Napkin.Run.Effects.Languages.Backend.Postgres data BackendSpecificEffect Postgres m a where Vacuum :: forall (m :: Type -> Type). Ref Table -> PostgresExtra m ()
data BackendConn Postgres #
Instance details Defined in Napkin.Run.Postgres data BackendConn Postgres = PostgresConn { getPostgresConn :: Pool Connection }
newtype DbBackendOptions Postgres #
Instance details Defined in Napkin.Run.Postgres newtype DbBackendOptions Postgres = PostgresOptions { _postgresOptions_connectionPool :: 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.11-AmFJpcsQ4Ny8ZeMMGxUvw7" 'True) (C1 ('MetaCons "PostgresOptions" 'PrefixI 'True) (S1 ('MetaSel ('Just "_postgresOptions_connectionPool") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))
type BackendTableMeta Postgres #
Instance details Defined in Napkin.Types.Postgres type BackendTableMeta Postgres = ()

data SetTableSchema #

In Postgres it's not possible to RENAME and SET SCHEMA in a single query

Constructors

SetTableSchema
Fields _rtFrom :: Ref Table _rtNewSchema :: Text

Instances

Instances details

Eq SetTableSchema #
Instance details Defined in Napkin.Types.Postgres Methods (==) :: SetTableSchema -> SetTableSchema -> Bool # (/=) :: SetTableSchema -> SetTableSchema -> Bool #
Data SetTableSchema #
Instance details Defined in Napkin.Types.Postgres Methods gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> SetTableSchema -> c SetTableSchema # gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c SetTableSchema # toConstr :: SetTableSchema -> Constr # dataTypeOf :: SetTableSchema -> DataType # dataCast1 :: Typeable t => (forall d. Data d => c (t d)) -> Maybe (c SetTableSchema) # dataCast2 :: Typeable t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c SetTableSchema) # gmapT :: (forall b. Data b => b -> b) -> SetTableSchema -> SetTableSchema # gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> SetTableSchema -> r # gmapQr :: forall r r'. (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> SetTableSchema -> r # gmapQ :: (forall d. Data d => d -> u) -> SetTableSchema -> [u] # gmapQi :: Int -> (forall d. Data d => d -> u) -> SetTableSchema -> u # gmapM :: Monad m => (forall d. Data d => d -> m d) -> SetTableSchema -> m SetTableSchema # gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> SetTableSchema -> m SetTableSchema # gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> SetTableSchema -> m SetTableSchema #
Show SetTableSchema #
Instance details Defined in Napkin.Types.Postgres Methods showsPrec :: Int -> SetTableSchema -> ShowS # show :: SetTableSchema -> String # showList :: [SetTableSchema] -> ShowS #
RenderSql SetTableSchema Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> SetTableSchema -> Doc #
RenderSql SetTableSchema Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> SetTableSchema -> Doc #