Copyright	(c) 2014 Andreas Meingast <ameingast@gmail.com>
License	BSD-style
Maintainer	andre@andrevdm.com
Stability	experimental
Portability	GHC
Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.Simple.Migration.V1Compat

Contents

Migration actions
Migration types
Migration result actions
Migration result types

Description

A migration library for postgresql-simple.

For usage, see Readme.markdown.

Synopsis

runMigration :: MigrationContext -> IO (MigrationResult [Char])
runMigrations :: Bool -> Connection -> [MigrationCommand] -> IO (MigrationResult String)
sequenceMigrations :: Monad m => [m (MigrationResult e)] -> m (MigrationResult e)
data MigrationContext = MigrationContext {
- migrationContextCommand :: MigrationCommand
- migrationContextVerbose :: Bool
- migrationContextConnection :: Connection
}
data MigrationCommand
data MigrationResult a
- = MigrationError a
- | MigrationSuccess
type ScriptName = String
type Checksum = ByteString
getMigrations :: Connection -> IO [SchemaMigration]
data SchemaMigration = SchemaMigration {
}

Migration actions

runMigration :: MigrationContext -> IO (MigrationResult [Char]) Source #

runMigrations Source #

Arguments

:: Bool	Run in verbose mode
-> Connection	The postgres connection to use
-> [MigrationCommand]	The commands to run
-> IO (MigrationResult String)

sequenceMigrations :: Monad m => [m (MigrationResult e)] -> m (MigrationResult e) Source #

Run a sequence of contexts, stopping on the first failure

Migration types

data MigrationContext Source #

The MigrationContext provides an execution context for migrations.

Constructors

MigrationContext
Fields migrationContextCommand :: MigrationCommand The action that will be performed by `runMigration` migrationContextVerbose :: Bool Verbosity of the library. migrationContextConnection :: Connection The PostgreSQL connection to use for migrations.

data MigrationCommand Source #

MigrationCommand determines the action of the runMigration script.

Constructors

MigrationInitialization	Initializes the database with a helper table containing meta information.
MigrationDirectory FilePath	Executes migrations based on SQL scripts in the provided `FilePath` in alphabetical order.
MigrationFile ScriptName FilePath	Executes a migration based on script located at the provided `FilePath`.
MigrationScript ScriptName ByteString	Executes a migration based on the provided bytestring.
MigrationValidation MigrationCommand	Validates that the provided MigrationCommand has been executed.
MigrationCommands [MigrationCommand]	Performs a series of `MigrationCommand`s in sequence.

Instances

Instances details

Eq MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods (==) :: MigrationCommand -> MigrationCommand -> Bool # (/=) :: MigrationCommand -> MigrationCommand -> Bool #
Ord MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods compare :: MigrationCommand -> MigrationCommand -> Ordering # (<) :: MigrationCommand -> MigrationCommand -> Bool # (<=) :: MigrationCommand -> MigrationCommand -> Bool # (>) :: MigrationCommand -> MigrationCommand -> Bool # (>=) :: MigrationCommand -> MigrationCommand -> Bool # max :: MigrationCommand -> MigrationCommand -> MigrationCommand # min :: MigrationCommand -> MigrationCommand -> MigrationCommand #
Read MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods readsPrec :: Int -> ReadS MigrationCommand # readList :: ReadS [MigrationCommand] # readPrec :: ReadPrec MigrationCommand # readListPrec :: ReadPrec [MigrationCommand] #
Show MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods showsPrec :: Int -> MigrationCommand -> ShowS # show :: MigrationCommand -> String # showList :: [MigrationCommand] -> ShowS #
Semigroup MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods (<>) :: MigrationCommand -> MigrationCommand -> MigrationCommand # sconcat :: NonEmpty MigrationCommand -> MigrationCommand # stimes :: Integral b => b -> MigrationCommand -> MigrationCommand #
Monoid MigrationCommand Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods mempty :: MigrationCommand # mappend :: MigrationCommand -> MigrationCommand -> MigrationCommand # mconcat :: [MigrationCommand] -> MigrationCommand #

data MigrationResult a Source #

A sum-type denoting the result of a migration.

Constructors

MigrationError a	There was an error in script migration.
MigrationSuccess	All scripts have been executed successfully.

Instances

Instances details

Functor MigrationResult Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods fmap :: (a -> b) -> MigrationResult a -> MigrationResult b # (<$) :: a -> MigrationResult b -> MigrationResult a #
Foldable MigrationResult Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods fold :: Monoid m => MigrationResult m -> m # foldMap :: Monoid m => (a -> m) -> MigrationResult a -> m # foldMap' :: Monoid m => (a -> m) -> MigrationResult a -> m # foldr :: (a -> b -> b) -> b -> MigrationResult a -> b # foldr' :: (a -> b -> b) -> b -> MigrationResult a -> b # foldl :: (b -> a -> b) -> b -> MigrationResult a -> b # foldl' :: (b -> a -> b) -> b -> MigrationResult a -> b # foldr1 :: (a -> a -> a) -> MigrationResult a -> a # foldl1 :: (a -> a -> a) -> MigrationResult a -> a # toList :: MigrationResult a -> [a] # null :: MigrationResult a -> Bool # length :: MigrationResult a -> Int # elem :: Eq a => a -> MigrationResult a -> Bool # maximum :: Ord a => MigrationResult a -> a # minimum :: Ord a => MigrationResult a -> a # sum :: Num a => MigrationResult a -> a # product :: Num a => MigrationResult a -> a #
Traversable MigrationResult Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods traverse :: Applicative f => (a -> f b) -> MigrationResult a -> f (MigrationResult b) # sequenceA :: Applicative f => MigrationResult (f a) -> f (MigrationResult a) # mapM :: Monad m => (a -> m b) -> MigrationResult a -> m (MigrationResult b) # sequence :: Monad m => MigrationResult (m a) -> m (MigrationResult a) #
Eq a => Eq (MigrationResult a) Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods (==) :: MigrationResult a -> MigrationResult a -> Bool # (/=) :: MigrationResult a -> MigrationResult a -> Bool #
Ord a => Ord (MigrationResult a) Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods compare :: MigrationResult a -> MigrationResult a -> Ordering # (<) :: MigrationResult a -> MigrationResult a -> Bool # (<=) :: MigrationResult a -> MigrationResult a -> Bool # (>) :: MigrationResult a -> MigrationResult a -> Bool # (>=) :: MigrationResult a -> MigrationResult a -> Bool # max :: MigrationResult a -> MigrationResult a -> MigrationResult a # min :: MigrationResult a -> MigrationResult a -> MigrationResult a #
Read a => Read (MigrationResult a) Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods readsPrec :: Int -> ReadS (MigrationResult a) # readList :: ReadS [MigrationResult a] # readPrec :: ReadPrec (MigrationResult a) # readListPrec :: ReadPrec [MigrationResult a] #
Show a => Show (MigrationResult a) Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods showsPrec :: Int -> MigrationResult a -> ShowS # show :: MigrationResult a -> String # showList :: [MigrationResult a] -> ShowS #

type ScriptName = String Source #

The name of a script. Typically the filename or a custom name when using Haskell migrations.

type Checksum = ByteString Source #

The checksum type of a migration script.

Migration result actions

getMigrations :: Connection -> IO [SchemaMigration] Source #

Produces a list of all executed SchemaMigrations in the default schema_migrations table

Migration result types

data SchemaMigration Source #

A product type representing a single, executed SchemaMigration.

Constructors

SchemaMigration
Fields schemaMigrationName :: ByteString The name of the executed migration. schemaMigrationChecksum :: Checksum The calculated MD5 checksum of the executed script. schemaMigrationExecutedAt :: LocalTime A timestamp without timezone of the date of execution of the script.

Instances

Instances details

Eq SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods (==) :: SchemaMigration -> SchemaMigration -> Bool # (/=) :: SchemaMigration -> SchemaMigration -> Bool #
Ord SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods compare :: SchemaMigration -> SchemaMigration -> Ordering # (<) :: SchemaMigration -> SchemaMigration -> Bool # (<=) :: SchemaMigration -> SchemaMigration -> Bool # (>) :: SchemaMigration -> SchemaMigration -> Bool # (>=) :: SchemaMigration -> SchemaMigration -> Bool # max :: SchemaMigration -> SchemaMigration -> SchemaMigration # min :: SchemaMigration -> SchemaMigration -> SchemaMigration #
Read SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods readsPrec :: Int -> ReadS SchemaMigration # readList :: ReadS [SchemaMigration] # readPrec :: ReadPrec SchemaMigration # readListPrec :: ReadPrec [SchemaMigration] #
Show SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods showsPrec :: Int -> SchemaMigration -> ShowS # show :: SchemaMigration -> String # showList :: [SchemaMigration] -> ShowS #
FromRow SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods fromRow :: RowParser SchemaMigration
ToRow SchemaMigration Source #
Instance details Defined in Database.PostgreSQL.Simple.Migration Methods toRow :: SchemaMigration -> [Action]