eavactiverecord Implements entity-attribute-value pattern and provides a simple way to work with EAV-attributes.

EavActiveRecord

  1. Requirements
  2. Installation
  3. Project on Github
  4. What's next?

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": ~~~ [php] array( 'import' => array( 'application.components.eavactiverecord.', 'application.components.eavactiverecord.datatypes.', 'application.components.eavactiverecord.helpers.*', ) ~~~

  4. 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: ~~~ [php] 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": ~~~ [php] 'components' => array(

     'eavCache' => array(
         'class' => 'system.caching.CDummyCache'
     ),
    

    ) ~~~

  5. Extend your model class from the class EavActiveRecord ~~~ [php] class Foo extends EavActiveRecord ~~~

  6. 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(); ~~~

  7. 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 The attribute set edit page

Project on Github

https://github.com/iAchilles/eavactiverecord

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
0 0
3 followers
0 downloads
Yii Version: 1.1
License: MIT
Category: Database
Developed by: iAchilles
Created on: Sep 26, 2014
Last updated: 10 years ago

Related Extensions