Database.PostgreSQL.PQTypes.Model.Table

Documentation

data TableColumn

Constructors

TableColumn

Fields

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

Instances

Show TableColumn

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

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

data Table

Constructors

Table

Fields

• tblName :: RawSQL ()
• tblVersion :: Int32
• tblColumns :: [TableColumn]
• tblPrimaryKey :: Maybe PrimaryKey
• tblChecks :: [Check]
• tblForeignKeys :: [ForeignKey]
• tblIndexes :: [TableIndex]
• tblInitialSetup :: Maybe TableInitialSetup

tblTable :: Table

sqlCreateTable :: RawSQL () -> RawSQL ()

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

data TableInitialSetup

Constructors

TableInitialSetup

Fields

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