FuelPHP Forums

toxxxa

Hi, could you tell me please, how to remove already exists EAV properties?


class Model_Model extends \Orm\Model
{
    protected static $_has_many = array('properties');
    protected static $_eav = array(
        'properties' => array(
            'attribute' => 'name',
            'value' => 'value')
    );
}
$model = Model_Model::find(1);
$model->new_properties = 'value';
$model->old_properties = NULL; // don't delete from DB
unset($model->old_properties); // not working

Harro

Unset is the way to do it. But with all changes to the model, you need to save the model to save it's changes, and that includes EAV data.

toxxxa

Sorry for necroposting, but the same problem again.

I need to delete all eav properties from DB rather then break relations:

// Here is break relation (project_id = null), 
// but not physically delete
$project = Model_Project::find(1);
unset($project->settings);
$project->save();

// Here is delete settings from DB, 
// but re-created it after $project->save()
$project = Model_Project::find(1);
foreach($project->settings as $s) 
{
    $s->delete();
}
$project->save();

// Hooray, everything as expected
$project = Model_Project::find(1);
foreach($project->settings as $s) 
{
    $s->delete();
}
unset($project->settings);
$project->save();

So, my question is: "Is it normal behavior for Has Many relations"?

Here is my models:

class Model_Project extends \Orm\Model
{
    protected static $_has_many = array(
        'settings' => array(
            'key_from' => 'id',
            'model_to' => 'Model_Settings',
            'key_to' => 'project_id',
            'cascade_save' => true,
            'cascade_delete' => true,
        ),
    );

    protected static $_eav = array(
        'settings' => array(
            'attribute' => 'key',
            'value' => 'value',
        )
    );
}

class Model_Settings extends \Orm\Model
{
    protected static $_belongs_to = array(
        'project' => array(
            'key_from' => 'project_id',
            'model_to' => 'Model_Project',
            'key_to' => 'id',
            'cascade_save' => true,
            'cascade_delete' => false,
        ),
    );
}

Harro

It is logical the first attempt doesn't work. That deletes setting records in the table, but doesn't delete the related objects from the project, so when you save the project, the ORM sees the still related setting objects as new, and saves them.

It's probably quicker to do:

// disconnect the settings from the project

$project = Model_Project::find(1);

unset($project->settings);

$project->save();

// delete the settings for this project

Model_Settings::query()->where('project_id', '=', $project->id)->delete();

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion