/eavactiverecord

Implements entity-attribute-value pattern and provides a simple way to work with EAV-attributes. EAV-attributes are stored in the database as separate records but accessed and searched in such a way as if they were columns in the entity's table.

Primary LanguagePHP

EavActiveRecord

Implements entity-attribute-value pattern and provides a simple way to work with EAV-attributes. EAV-attributes are stored in the database as separate records but accessed and searched in such a way as if they were columns in the entity's table.

The following features are supported:

  • Eager and lazy loading of EAV-attributes.
  • Dynamic validation rules. The validation rules defined for the EAV-attribute will be added to the model dynamically.
  • Automatically inserting/updating/deleting EAV-attribute values.
  • Accessing and editing EAV-attributes in the same way as if they were real attributes of the model.
  • A simple search by EAV-attributes with using the find methods.

Requirements

  • Yii 1.1.2 or above
  • PHP 5.1 or above

Installation

  1. Download and extract the release files under the folder "protected/components/eavactiverecord".

  2. Run the SQL-script mysql.sql or postgresql.sql (if your DBMS is PostgreSQL) It is located in the following folder: "protected/components/eavactiverecord/schema/". It creates tables needed to work with EAV attributes: eav_set, eav_attribute, eav_attribute_set, eav_attribute_date, eav_attribute_int, eav_attribute_varchar, eav_attribute_text.

  3. Add the following lines in the file "protected/config/main.php":

array( 'import' => array( 'application.components.eavactiverecord.', 'application.components.eavactiverecord.datatypes.', 'application.components.eavactiverecord.helpers.*' )


1. It requires cache to be activated in the application: 

   ```php
array(
    …
    'components'=>array(
        …
        'cache'=>array(
            'class'=>'system.caching.CMemCache',
            'servers'=>array(
                array('host'=>'server1', 'port'=>11211, 'weight'=>60),
                array('host'=>'server2', 'port'=>11211, 'weight'=>40),
            ),
        ),
    ),
);

The extension will use own cache component if it is defined as the following:

array(
 …
 'components'=>array(
     …
     'eavCache'=>array(
         'class'=>'system.caching.CMemCache',
         'servers'=>array(
             array('host'=>'server1', 'port'=>11211, 'weight'=>60),
             array('host'=>'server2', 'port'=>11211, 'weight'=>40),
         ),
     ),
 ),
);

If you do not use cache, add the following code in the file "protected/config/main.php":

'components' => array(
     'eavCache' => array(
         'class' => 'system.caching.CDummyCache'
     ),
  )
  1. Extend your model class from the class EavActiveRecord

class Foo extends EavActiveRecord


1. Call the method Foo::addColumn(). This method must only be called once for each model that extends EavActiveRecord class. 
It adds the new column "eav_set_id" in the associated database table.

   ```php
Foo::model()->addColumn();
  1. Since v1.0.2 it includes the GUI module for user interaction (front-end module) based on the extension API. For detailed information about installing the module, reed the EavModule Installation Guide

    The screenshot of the module page is shown below EavModule screenshot


##What's next?

For detailed information on how to use the extension eavactiverecord, please read the following wiki articles:

  1. Quick Start Guide
  2. Manage EAV attributes
  3. Manage sets of EAV attributes
  4. Using EAV attributes in the model
    1. Attaching EAV attributes to the model
    2. Assigning a value to the EAV attribute
    3. Accessing the EAV attribute value
    4. Saving the EAV attribute value
    5. Deleting the EAV attribute value
    6. Eager and lazy loading of EAV attribute values
    7. Searching by EAV attributes
    8. Priority of attributes
  5. Creating form elements for EAV attributes using the widget EavForm
  6. The API documentation