| Copyright | (c) Soostone Inc 2020 |
|---|---|
| License | AllRightsReserved |
| Stability | experimental |
| Portability | POSIX |
| Safe Haskell | None |
| Language | Haskell2010 |
Napkin.Types.Commands
Description
Synopsis
- newtype GetRelationSchema = GetRelationSchema {}
- newtype CheckTableExists = CheckTableExists {}
- data DeleteFrom = DeleteFrom {}
- data InsertIntoQuery = InsertIntoQuery {}
- data DropTable = DropTable {
- _dtName :: Ref Table
- _dtIfExists :: Bool
- _dtCascade :: Bool
- data DropView = DropView {
- _dvName :: Ref Table
- _dvIfExists :: Bool
- _dvCascade :: Bool
- data CreateViewAs = CreateViewAs {}
- data CopyTable = CopyTable {}
- data RenameTable = RenameTable {}
- data CreateTableAs meta = CreateTableAs {}
- class HasCreateTableAs bk where
- type BackendTableMeta bk
- createTable :: Default d => Ref Table -> Query -> CreateTableAs d
- dropView :: Ref Table -> DropView
- dropTable :: Ref Table -> DropTable
- createToInsert :: CreateTableAs m -> InsertIntoQuery
- ctaMeta :: forall meta meta. Lens (CreateTableAs meta) (CreateTableAs meta) meta meta
- ctaName :: forall meta. Lens' (CreateTableAs meta) (Ref Table)
- ctaQuery :: forall meta. Lens' (CreateTableAs meta) Query
- cvaName :: Lens' CreateViewAs (Ref Table)
- cvaQuery :: Lens' CreateViewAs Query
- rtFrom :: Lens' RenameTable (Ref Table)
- rtTo :: Lens' RenameTable (Ref Table)
- ctFrom :: Lens' CopyTable (Ref Table)
- ctTo :: Lens' CopyTable (Ref Table)
- dtCascade :: Lens' DropTable Bool
- dtIfExists :: Lens' DropTable Bool
- dtName :: Lens' DropTable (Ref Table)
- dvCascade :: Lens' DropView Bool
- dvIfExists :: Lens' DropView Bool
- dvName :: Lens' DropView (Ref Table)
- iiqQuery :: Lens' InsertIntoQuery Query
- iiqTable :: Lens' InsertIntoQuery (Ref Table)
- dfTable :: Lens' DeleteFrom (Ref Table)
- dfWhere :: Lens' DeleteFrom SExp
- cteTable :: Iso' CheckTableExists (Ref Table)
- class Drop a b | a -> b where
- dropCommand :: a -> b
- dropCascade :: a -> Lens' b Bool
- grsRelation :: Iso' GetRelationSchema Relation
- module Napkin.Types.Commands.Grant
Documentation
newtype GetRelationSchema #
Constructors
| GetRelationSchema | |
Fields | |
Instances
newtype CheckTableExists #
Constructors
| CheckTableExists | |
Instances
data DeleteFrom #
TODO: Add in the USING clause
Instances
data InsertIntoQuery #
Instances
Drop a table
Constructors
| DropTable | |
Fields
| |
Instances
Drop a table
Constructors
| DropView | |
Fields
| |
Instances
data CreateViewAs #
Instances
Instances
| Eq CopyTable # | |
| Data CopyTable # | |
Defined in Napkin.Types.Commands Methods gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> CopyTable -> c CopyTable # gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c CopyTable # toConstr :: CopyTable -> Constr # dataTypeOf :: CopyTable -> DataType # dataCast1 :: Typeable t => (forall d. Data d => c (t d)) -> Maybe (c CopyTable) # dataCast2 :: Typeable t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c CopyTable) # gmapT :: (forall b. Data b => b -> b) -> CopyTable -> CopyTable # gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> CopyTable -> r # gmapQr :: forall r r'. (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> CopyTable -> r # gmapQ :: (forall d. Data d => d -> u) -> CopyTable -> [u] # gmapQi :: Int -> (forall d. Data d => d -> u) -> CopyTable -> u # gmapM :: Monad m => (forall d. Data d => d -> m d) -> CopyTable -> m CopyTable # gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> CopyTable -> m CopyTable # gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> CopyTable -> m CopyTable # | |
| Read CopyTable # | |
| Show CopyTable # | |
| Command CopyTable Int Sqlite # | |
Defined in Napkin.Run.Sqlite Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Sqlite -> CopyTable -> m Int # | |
| Command CopyTable Int64 Redshift # | |
Defined in Napkin.Run.Redshift Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Redshift -> CopyTable -> m Int64 # | |
| Command CopyTable Int64 Postgres # | |
Defined in Napkin.Run.Postgres Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn Postgres -> CopyTable -> m Int64 # | |
| Command CopyTable () BigQuery # | |
Defined in Napkin.Run.BigQuery Methods execCommand :: (Katip m, MonadQueryStats m) => BackendConn BigQuery -> CopyTable -> m () # | |
data RenameTable #
Instances
data CreateTableAs meta #
Create table based on a query with variable metadata type, such
as TableMeta
Instances
class HasCreateTableAs bk #
Operations like recreate often result in ambiguous types at
application site. In general, we need to be able to infer a
type for the table metadata type for each backend. Our life is
complicated by the likes of Redshift TableMeta
Associated Types
type BackendTableMeta bk #
Instances
| HasCreateTableAs Sqlite # | |
Defined in Napkin.Types.Sqlite Associated Types type BackendTableMeta Sqlite # | |
| HasCreateTableAs Redshift # | |
Defined in Napkin.Types.Redshift Associated Types type BackendTableMeta Redshift # | |
| HasCreateTableAs Postgres # | |
Defined in Napkin.Types.Postgres Associated Types type BackendTableMeta Postgres # | |
| HasCreateTableAs BigQuery # | |
Defined in Napkin.Types.BigQuery Associated Types type BackendTableMeta BigQuery # | |
createTable :: Default d => Ref Table -> Query -> CreateTableAs d #
createToInsert :: CreateTableAs m -> InsertIntoQuery #
ctaMeta :: forall meta meta. Lens (CreateTableAs meta) (CreateTableAs meta) meta meta #
ctaQuery :: forall meta. Lens' (CreateTableAs meta) Query #
dvIfExists :: Lens' DropView Bool #
dfWhere :: Lens' DeleteFrom SExp #
class Drop a b | a -> b where #
Instances
| Drop CreateViewAs DropView # | |
Defined in Napkin.Types.Commands Methods dropCommand :: CreateViewAs -> DropView # dropCascade :: CreateViewAs -> Lens' DropView Bool # | |
| Drop (CreateTableAs ()) DropTable # | |
Defined in Napkin.Types.Commands Methods dropCommand :: CreateTableAs () -> DropTable # dropCascade :: CreateTableAs () -> Lens' DropTable Bool # | |
| Drop (CreateTableAs TableMeta) DropTable # | |
Defined in Napkin.Types.Redshift Methods dropCommand :: CreateTableAs TableMeta -> DropTable # dropCascade :: CreateTableAs TableMeta -> Lens' DropTable Bool # | |
| Drop (CreateTableAs TableMeta) DropTable # | |
Defined in Napkin.Types.BigQuery Methods dropCommand :: CreateTableAs TableMeta -> DropTable # dropCascade :: CreateTableAs TableMeta -> Lens' DropTable Bool # | |
module Napkin.Types.Commands.Grant