czogori/propel-postgres-hstore-behavior

Storage of key-value items using Postgres hstore.

PostgresHstoreBehavior

, _(*1)

Storage of key-value items using Postgres hstore., _(*2)

Installation

First of all you have to install postgresql-contrib and create hstore extension., _(*3)

CREATE EXTENSION hstore;

After that download code using composer:, _(*4)

{
    "require": {        
        "czogori/propel-postgres-hstore-behavior": "dev-master"
    }
}

And put undermentioned entry to your propel.ini or build.properties configuration file:, _(*5)

propel.behavior.hstore.class = path.to.PostgresHstoreBehavior

Usage

Table definition - schema.xml file:, _(*6)

<table name="book" phpName="Book">    
        <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
        <column name="title" type="varchar" size="255" required="true" />
        <column name="extra_parameters" type="varchar" required="false" />    
        <behavior name="hstore">
            <parameter name="column_name" value="extra_parameters" />       
        </behavior>
</table>

Now you can use hstore behavior., _(*7)

$book = new Book();
$book->setTitle('Foo and Bar');
// you can set params as array
$book->setExtraParameters(array('language' => 'polish'));
// or like this
$book->setLanguage('polish');
$book->save();

echo $book->getLanguage();
echo $book->getExtraParameters('language');