Database.PostgreSQL.PQTypes.Model.Table

Documentation

data TableColumn

Constructors

TableColumn

Fields

• colName :: RawSQL ()
• colType :: ColumnType
• colNullable :: Bool
• colDefault :: Maybe (RawSQL ())

Instances

Show TableColumn

Defined in Database.PostgreSQL.PQTypes.Model.Table

Methods

showsPrec :: Int -> TableColumn -> ShowS

show :: TableColumn -> String

showList :: [TableColumn] -> ShowS

tblColumn :: TableColumn

sqlAddColumn :: TableColumn -> RawSQL ()

sqlAlterColumn :: RawSQL () -> RawSQL () -> RawSQL ()

sqlDropColumn :: RawSQL () -> RawSQL ()

data Rows

Constructors

forall row.(Show row, ToRow row) => Rows [ByteString] [row]

data Table

Constructors

Table

Fields

• tblName :: RawSQL ()

  Must be in lower case.

• tblVersion :: Int32
• tblColumns :: [TableColumn]
• tblPrimaryKey :: Maybe PrimaryKey
• tblChecks :: [Check]
• tblForeignKeys :: [ForeignKey]
• tblIndexes :: [TableIndex]
• tblTriggers :: [Trigger]
• tblInitialSetup :: Maybe TableInitialSetup

tblTable :: Table

sqlCreateTable :: RawSQL () -> RawSQL ()

sqlAlterTable :: RawSQL () -> [RawSQL ()] -> RawSQL ()

data DropTableMode

Whether to also drop objects that depend on the table.

Constructors

DropTableCascade

Automatically drop objects that depend on the table (such as views).

DropTableRestrict

Refuse to drop the table if any objects depend on it. This is the default.

sqlDropTable :: RawSQL () -> DropTableMode -> RawSQL ()

data TableInitialSetup

Constructors

TableInitialSetup

Fields

• checkInitialSetup :: forall m. (MonadDB m, MonadThrow m) => m Bool
• initialSetup :: forall m. (MonadDB m, MonadThrow m) => m ()