IHP Api Reference| Safe Haskell | None |
|---|
IHP.IDE.SchemaDesigner.Controller.Columns
Contents
Synopsis
- updateColumnInTable :: Text -> Column -> Bool -> Int -> Statement -> Statement
- updatePrimaryKeyConstraint :: Column -> Bool -> PrimaryKeyConstraint -> PrimaryKeyConstraint
- toggleUniqueInColumn :: Text -> Int -> Statement -> Statement
- deleteColumnInTable :: Text -> Int -> Statement -> Statement
- updateForeignKeyConstraint :: Text -> Text -> Text -> Text -> OnDelete -> Int -> [Statement] -> [Statement]
- deleteForeignKeyConstraint :: Text -> [Statement] -> [Statement]
- deleteTableIndex :: Text -> [Statement] -> [Statement]
- getCreateTable :: [Statement] -> [CreateTable]
- getCreateEnum :: [Statement] -> [Statement]
- isCreateEnumType :: Statement -> Bool
- nameList :: HasField "name" model b => [model] -> [b]
- validateColumn :: Validator Text
- referencingColumnForeignKeyConstraints :: Foldable t => Text -> Text -> t Statement -> Maybe Statement
- findIndicesReferencingColumn :: [Statement] -> (Text, Text) -> [Statement]
Documentation
updatePrimaryKeyConstraint :: Column -> Bool -> PrimaryKeyConstraint -> PrimaryKeyConstraint Source #
Add or remove a column from the primary key constraint
updateForeignKeyConstraint :: Text -> Text -> Text -> Text -> OnDelete -> Int -> [Statement] -> [Statement] Source #
getCreateTable :: [Statement] -> [CreateTable] Source #
getCreateEnum :: [Statement] -> [Statement] Source #
isCreateEnumType :: Statement -> Bool Source #
referencingColumnForeignKeyConstraints :: Foldable t => Text -> Text -> t Statement -> Maybe Statement Source #
findIndicesReferencingColumn :: [Statement] -> (Text, Text) -> [Statement] Source #
Returns the list of CreateIndex statements that reference a specific column
E.g. given a schema like this: > CREATE TABLE users ( > email TEXT NOT NULL > ); > > CREATE UNIQUE INDEX users_email_index ON users (LOWER(email)); >
You can find all indices to the email column of the users table like this:
>>>findIndicesReferencingColumn database ("users", "email")[CreateIndex { indexName = "users_email", unique = True, tableName = "users", expressions = [CallExpression "LOWER" [VarEpression "email"]] }]