ePages 6.11.0 - DE_EPAGES/Object/API/Table/LocalizedStringAttribute.pm

Package DE_EPAGES::Object::API::Table::LocalizedStringAttribute

interface for table LocalizedStringAttribute

@EXPORT_OK
InsertLocalizedStringAttribute
UpdateLocalizedStringAttribute
DeleteLocalizedStringAttribute
GetAllPKeyLocalizedStringAttributes
GetAllInfoLocalizedStringAttributes
GetInfoLocalizedStringAttribute
ExistsLocalizedStringAttribute
GetPKeyLocalizedStringAttributesByObjectID
GetInfoLocalizedStringAttributesByObjectID
GetPKeyLocalizedStringAttributesByAttributeID
GetInfoLocalizedStringAttributesByAttributeID
GetPKeyLocalizedStringAttributesByLanguageID
GetInfoLocalizedStringAttributesByLanguageID

Functions

DeleteLocalizedStringAttribute
ExistsLocalizedStringAttribute
GetAllInfoLocalizedStringAttributes
GetAllPKeyLocalizedStringAttributes
GetInfoLocalizedStringAttribute
GetInfoLocalizedStringAttributesByAttributeID
GetInfoLocalizedStringAttributesByLanguageID
GetInfoLocalizedStringAttributesByObjectID
GetPKeyLocalizedStringAttributesByAttributeID
GetPKeyLocalizedStringAttributesByLanguageID
GetPKeyLocalizedStringAttributesByObjectID
InsertLocalizedStringAttribute
OnDeleteAttribute
OnDeleteLanguage
OnDeleteObject
UpdateLocalizedStringAttribute

DeleteLocalizedStringAttribute

Deletes a(n) LocalizedStringAttribute.

Syntax
DeleteLocalizedStringAttribute($ObjectID, $AttributeID, $LanguageID);
DeleteLocalizedStringAttribute($hLocalizedStringAttribute); # if $hLocalizedStringAttribute includes ObjectID, AttributeID, LanguageID
Input
$ObjectID (int)
object id (part of primary key)
$AttributeID (int)
attribute id (part of primary key)
$LanguageID (int)
language id (part of primary key)

ExistsLocalizedStringAttribute

Returns true if the LocalizedStringAttribute exists.

Syntax
$exists = ExistsLocalizedStringAttribute($ObjectID, $AttributeID, $LanguageID);
Input
$ObjectID (int)
object id
$AttributeID (int)
attribute id
$LanguageID (int)
language id
Return
$exists (boolean)
1/0 the LocalizedStringAttribute exists (yes/no)

GetAllInfoLocalizedStringAttributes

Returns all objects of LocalizedStringAttribute.

Syntax
$ahLocalizedStringAttributes = GetAllInfoLocalizedStringAttributes();
Return
$ahLocalizedStringAttributes (reference to array of hashes)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

GetAllPKeyLocalizedStringAttributes

Returns all LocalizedStringAttribute identifiers.

Syntax
$ahLocalizedStringAttributeIDs = GetAllPKeyLocalizedStringAttributes();
Return
$ahLocalizedStringAttributeIDs (reference to array of hashes)
with following keys:
  • ObjectID - object id - int
  • AttributeID - attribute id - int
  • LanguageID - language id - int

GetInfoLocalizedStringAttribute

Returns the LocalizedStringAttribute by identifier.

Syntax
$hLocalizedStringAttribute = GetInfoLocalizedStringAttribute($ObjectID, $AttributeID, $LanguageID);
Input
$ObjectID (int)
object id (part of primary key)
$AttributeID (int)
attribute id (part of primary key)
$LanguageID (int)
language id (part of primary key)
Return
$hLocalizedStringAttribute (reference to hash)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

GetInfoLocalizedStringAttributesByAttributeID

Returns objects of LocalizedStringAttribute by alternate key AttributeID.

Syntax
$ahLocalizedStringAttributes = GetInfoLocalizedStringAttributesByAttributeID($AttributeID);
Input
$AttributeID (int)
attribute id
Return
$ahLocalizedStringAttributes (reference to array of hashes)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

GetInfoLocalizedStringAttributesByLanguageID

Returns objects of LocalizedStringAttribute by alternate key LanguageID.

Syntax
$ahLocalizedStringAttributes = GetInfoLocalizedStringAttributesByLanguageID($LanguageID);
Input
$LanguageID (int)
language id
Return
$ahLocalizedStringAttributes (reference to array of hashes)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

GetInfoLocalizedStringAttributesByObjectID

Returns objects of LocalizedStringAttribute by primary key element ObjectID, AttributeID.

Syntax
$ahLocalizedStringAttributes = GetInfoLocalizedStringAttributesByObjectID($ObjectID, $AttributeID);
Input
$ObjectID (int)
object id
$AttributeID (int)
attribute id (optional)
Return
$ahLocalizedStringAttributes (reference to array of hashes)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

GetPKeyLocalizedStringAttributesByAttributeID

Returns primary keys of LocalizedStringAttribute by alternate key AttributeID.

Syntax
$ahKeys = GetPKeyLocalizedStringAttributesByAttributeID($AttributeID);
Input
$AttributeID (int)
attribute id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • ObjectID - object id - int
  • AttributeID - attribute id - int
  • LanguageID - language id - int

GetPKeyLocalizedStringAttributesByLanguageID

Returns primary keys of LocalizedStringAttribute by alternate key LanguageID.

Syntax
$ahKeys = GetPKeyLocalizedStringAttributesByLanguageID($LanguageID);
Input
$LanguageID (int)
language id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • ObjectID - object id - int
  • AttributeID - attribute id - int
  • LanguageID - language id - int

GetPKeyLocalizedStringAttributesByObjectID

Returns primary keys of LocalizedStringAttribute by primary key element ObjectID, AttributeID.

Syntax
$ahKeys = GetPKeyLocalizedStringAttributesByObjectID($ObjectID, $AttributeID);
Input
$ObjectID (int)
object id
$AttributeID (int)
attribute id (optional)
Return
$ahKeys (reference to array of hashes)
with following keys:
  • ObjectID - object id - int
  • AttributeID - attribute id - int
  • LanguageID - language id - int

InsertLocalizedStringAttribute

Creates an entry of LocalizedStringAttribute.

Syntax
InsertLocalizedStringAttribute($hLocalizedStringAttribute);
Input
$hLocalizedStringAttribute (reference to hash)
with following keys:
  • ObjectID - object id (part of primary key)- int
  • AttributeID - attribute id (part of primary key)- int
  • LanguageID - language id (part of primary key)- int
  • Value - localized value <256 characters - nvarchar(255)

OnDeleteAttribute

Deletes LocalizedStringAttribute of this model when a(n) Attribute is deleted.

Syntax
OnDeleteAttribute($hParams);
Input
$hParams (ref.hash.*)
primary key of object Attribute, key is
  • AttributeID

OnDeleteLanguage

Deletes LocalizedStringAttribute of this model when a(n) Language is deleted.

Syntax
OnDeleteLanguage($hParams);
Input
$hParams (ref.hash.*)
primary key of object Language, key is
  • LanguageID

OnDeleteObject

Deletes LocalizedStringAttribute of this model when a(n) Object is deleted.

Syntax
OnDeleteObject($hParams);
Input
$hParams (ref.hash.*)
primary key of object Object, key is
  • ObjectID

UpdateLocalizedStringAttribute

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

Syntax
UpdateLocalizedStringAttribute($ObjectID, $AttributeID, $LanguageID, $hLocalizedStringAttribute);
UpdateLocalizedStringAttribute($hLocalizedStringAttribute); # if $hLocalizedStringAttribute includes ObjectID, AttributeID, LanguageID
Input
$ObjectID (int)
object id (part of primary key)
$AttributeID (int)
attribute id (part of primary key)
$LanguageID (int)
language id (part of primary key)
$hLocalizedStringAttribute (reference to hash)
with following keys:
  • Value - localized value <256 characters - nvarchar(255)
Return
1 (int)
1