Package DE_EPAGES::ShopTransfer::API::Delete
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
|