ePages 6.11.0 - DE_EPAGES/Database/API/OrderFile.pm

Package DE_EPAGES::Database::API::OrderFile

@EXPORT_OK
CreateOrderFile
GetDirectoryFileOrder
GetSqlFileOrder
ReadOrderFile

Functions

CreateOrderFile
GetDirectoryFileOrder
GetSqlFileOrder
ReadOrderFile

CreateOrderFile

Searches the database directory for files, determines the processing order and writes them to a file.

Syntax
CreateOrderFile( $DatabaseDir, $OrderFileName );
Example
CreateOrderFile( 'Database', 'order.txt' );
Input
$DatabaseDir (string)
directory with SQL and template files
$OrderFileName (string)
order file name

GetDirectoryFileOrder

Returns a list of SQL files sorted by processing order from a single directory, such as '/tmp/database/epagesdirectorydb/Procedures'.

Syntax
$aFiles = GetDirectoryFileOrder( $Dir )
Input
$Dir (string)
database directory
Return
$aFiles (array ref)
list of file names

GetSqlFileOrder

Returns a list of SQL files sorted by processing order from a single database directory, such as '/tmp/database/epagesdirectorydb'.

Syntax
$aFiles = GetSqlFileOrder( $Dir )
Input
$Dir (string)
database directory
Return
$aFiles (array ref)
list of file names

ReadOrderFile

Reads the order.txt file and returns the files to be processed.

Syntax
$aDBFiles = ReadOrderFile( $FileName );
Example
$aDBFiles = ReadOrderFile( 'order.txt' );
Input
$FileName
order file name
Return
(files to be processed.
[ { Database => $DBName, Files => [ file1, files2, .. ] }, ... ])
$aDBFiles