ePages 6.10 - DE_EPAGES/ShopTransfer/API/Delete.pm

Package DE_EPAGES::ShopTransfer::API::Delete

@EXPORT_OK
DeleteShop
DeleteAllShops

Functions

BuildDeleteStatement
DeleteAllShops
DeleteShop
DeleteTable
DeleteTableSequence

BuildDeleteStatement

Builds the delete statement for table. SQL includes temp table #export_ids.

Syntax
$SQL = BuildDeleteStatement($Table, $hOptions);
Input
$Table (string)
table name
$hOptions (ref.hash)
options used keys: storePath to save table info at ini-file
Return
$SQL (string)
delete statement

DeleteAllShops

Removes all shops.

Syntax
DeleteAllShops($hOptions);
Input
$hOptions (ref.hash)
options used keys: batchSize (default 5000), storePath

DeleteShop

Removes all data from shop. Adds countObjects to $hOptions. Creates and removes temporary tables #export_ids, #table_ids and #delete_ids.

Syntax
DeleteShop($ShopAlias, $hOptions, $ShopID);
Input
$ShopAlias (string)
alias
$hOptions (ref.hash)
options used keys: batchSize (default 5000), storePath
$ShopID (integer)
optional identifier

DeleteTable

Removes data from table of a site (shop).

Syntax
DeleteTable($Table, $SiteID, $hOptions);
Input
$Table (string)
table name
$SiteID (integer)
site identifier
$hOptions (ref.hash)
options used keys: batchSize (default 5000), countObjects, storePath

DeleteTableSequence

Removes data from table of a site (shop) in blocks of given batchSize. SQL uses temp tables #export_ids, #table_ids and #delete_ids.

Syntax
$WithoutError = DeleteTableSequence($Table, $SiteID, $hOptions, $statement);
Input
$Table (string)
table name
$SiteID (integer)
site identifier
$hOptions (ref.hash)
options used keys: batchSize (default 5000)
$statement (string)
delete statement
Return
$WithoutError (boolean)
successfully with out error