Use cloning to duplicate a table row represented as an active record

Yii 1.1 General Discussion
1

Hi,

Assume you have a model which is an instance of CActiveRecord and you have an object which represents a row in the table of the model above.

Is it possible to use object cloning to duplicate the row in the table? Something like this:




$row = MyModel::model()->find();


$row2 = clone $row;

$row2->save();

If yes, what changes should I make to the cloned object before saving it?

2

u can use like this







$row = MyModel::model()->find();


$row2 = new MyModel;


$row2->attributes = $row->attributes


$row2->save();
3

You need to do 2 things

  1. if the table has a primary key you must null out the attributes that represent it.

  2. set isNewRecord to true.

Same as Rajith R with 2 additional assignments:




$row = MyModel::model()->find();

$row2 = new MyModel;

$row2->attributes = $row->attributes

$row2->id = null; //(if it's composite it's going to need more assignments than this)

$row2->isNewRecord = true;

$row2->save();

Clone works fine too but remember that CActiveRecord doesn’t implement a __clone() method so it’ll only perform a shallow copy.

4

@Luke Jurgs

I think , that s not needed…

5

Sorry you are correct about the isNewRecord part, shouldn’t answer questions on boards when tired.

6

This is what I meant:




$row = MyModel::model()->find();

$row->id = null; //(if it's composite it's going to need more assignments than this)

$row->isNewRecord = true;

$row->save();

This way you don’t even need a new instance or a copy of the attributes.

7

How can we modify this to include related rows (one to many)?

I am trying this but is not working:




$model = $this->loadModel($id, 'Entity')->with('related1,related2,related3');


$relatedData = array(

  'related1' => $model->related1,

  'related2' => $model->related2,

  'related3' => $model->related3,

);


$model->id=null;

$model->isNewRecord = true;

$model->saveWithRelated($relatedData);

The main row works fine but not the related rows.