ePages 6.10 - DE_EPAGES/ProductComparison/API/Table/SessionProductCompare.pm

Package DE_EPAGES::ProductComparison::API::Table::SessionProductCompare

interface for table SessionProductCompare

@EXPORT_OK
InsertSessionProductCompare
UpdateSessionProductCompare
DeleteSessionProductCompare
GetAllPKeySessionProductCompares
GetAllInfoSessionProductCompares
GetInfoSessionProductCompare
ExistsSessionProductCompare
GetPKeySessionProductComparesByIntSessionID
GetInfoSessionProductComparesByIntSessionID
GetPKeySessionProductComparesByProductID
GetInfoSessionProductComparesByProductID

Functions

DeleteSessionProductCompare
ExistsSessionProductCompare
GetAllInfoSessionProductCompares
GetAllPKeySessionProductCompares
GetInfoSessionProductCompare
GetInfoSessionProductComparesByIntSessionID
GetInfoSessionProductComparesByProductID
GetPKeySessionProductComparesByIntSessionID
GetPKeySessionProductComparesByProductID
InsertSessionProductCompare
OnDeleteProduct
OnDeleteSession
UpdateSessionProductCompare

DeleteSessionProductCompare

Deletes a(n) SessionProductCompare.

Syntax
DeleteSessionProductCompare($IntSessionID, $ProductID);
DeleteSessionProductCompare($hSessionProductCompare); # if $hSessionProductCompare includes IntSessionID, ProductID
Input
$IntSessionID (int)
internal (integer) session id (part of primary key)
$ProductID (int)
product identifier (part of primary key)

ExistsSessionProductCompare

Returns true if the SessionProductCompare exists.

Syntax
$exists = ExistsSessionProductCompare($IntSessionID, $ProductID);
Input
$IntSessionID (int)
internal (integer) session id
$ProductID (int)
product identifier
Return
$exists (boolean)
1/0 the SessionProductCompare exists (yes/no)

GetAllInfoSessionProductCompares

Returns all objects of SessionProductCompare.

Syntax
$ahSessionProductCompareIDs = GetAllInfoSessionProductCompares();
Return
$ahSessionProductCompareIDs (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id (part of primary key)- int
  • ProductID - product identifier (part of primary key)- int
  • Position - position of product in list - int

GetAllPKeySessionProductCompares

Returns all SessionProductCompare identifiers.

Syntax
$ahSessionProductCompareIDs = GetAllPKeySessionProductCompares();
Return
$ahSessionProductCompareIDs (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id - int
  • ProductID - product identifier - int

GetInfoSessionProductCompare

Returns the SessionProductCompare by identifier.

Syntax
$hSessionProductCompare = GetInfoSessionProductCompare($IntSessionID, $ProductID);
Input
$IntSessionID (int)
internal (integer) session id (part of primary key)
$ProductID (int)
product identifier (part of primary key)
Return
$hSessionProductCompare (reference to hash)
with following keys:
  • IntSessionID - internal (integer) session id (part of primary key)- int
  • ProductID - product identifier (part of primary key)- int
  • Position - position of product in list - int

GetInfoSessionProductComparesByIntSessionID

Returns objects of SessionProductCompare by primary key element IntSessionID.

Syntax
$ahSessionProductCompares = GetInfoSessionProductComparesByIntSessionID($IntSessionID);
Input
$IntSessionID (int)
internal (integer) session id
Return
$ahSessionProductCompares (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id (part of primary key)- int
  • ProductID - product identifier (part of primary key)- int
  • Position - position of product in list - int

GetInfoSessionProductComparesByProductID

Returns objects of SessionProductCompare by alternate key ProductID.

Syntax
$ahSessionProductCompares = GetInfoSessionProductComparesByProductID($ProductID);
Input
$ProductID (int)
product identifier
Return
$ahSessionProductCompares (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id (part of primary key)- int
  • ProductID - product identifier (part of primary key)- int
  • Position - position of product in list - int

GetPKeySessionProductComparesByIntSessionID

Returns primary keys of SessionProductCompare by primary key element IntSessionID.

Syntax
$ahKeys = GetPKeySessionProductComparesByIntSessionID($IntSessionID);
Input
$IntSessionID (int)
internal (integer) session id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id - int
  • ProductID - product identifier - int

GetPKeySessionProductComparesByProductID

Returns primary keys of SessionProductCompare by alternate key ProductID.

Syntax
$ahKeys = GetPKeySessionProductComparesByProductID($ProductID);
Input
$ProductID (int)
product identifier
Return
$ahKeys (reference to array of hashes)
with following keys:
  • IntSessionID - internal (integer) session id - int
  • ProductID - product identifier - int

InsertSessionProductCompare

Creates an entry of SessionProductCompare.

Syntax
InsertSessionProductCompare($hSessionProductCompare);
Input
$hSessionProductCompare (reference to hash)
with following keys:
  • IntSessionID - internal (integer) session id (part of primary key)- int
  • ProductID - product identifier (part of primary key)- int
  • Position - position of product in list - int

OnDeleteProduct

Deletes SessionProductCompare of this model when a(n) Product is deleted.

Syntax
OnDeleteProduct($hParams);
Input
$hParams (ref.hash.*)
primary key of object Product, key is
  • ProductID

OnDeleteSession

Deletes SessionProductCompare of this model when a(n) Session is deleted.

Syntax
OnDeleteSession($hParams);
Input
$hParams (ref.hash.*)
primary key of object Session, key is
  • IntSessionID

UpdateSessionProductCompare

Updates a(n) SessionProductCompare if any element was changed.

Syntax
UpdateSessionProductCompare($IntSessionID, $ProductID, $hSessionProductCompare);
UpdateSessionProductCompare($hSessionProductCompare); # if $hSessionProductCompare includes IntSessionID, ProductID
Input
$IntSessionID (int)
internal (integer) session id (part of primary key)
$ProductID (int)
product identifier (part of primary key)
$hSessionProductCompare (reference to hash)
with following keys:
  • Position - position of product in list - int