SaveAll and Save inserting two rows instead of one

In my app I have users, stats and subscriptions

users hasMany subscriptions
stats hasMany subscriptions
subscription belongsTo user and statistic

I've determined all users should be required to subscribe to some
statistics. And am attempting to make an action I can run (just once,
other logic will take care of the rest) to create all the required
subscriptions.

To do this I get a list of the stats where
Statistic.required_subscription = 1 and list of each user account and
then build the array to insert or insert each row individually.

I'm using this code to put together the data and insert. At the end n
is equal to the number of elements in the array, (441) however the
number of records in the DB is 882.

$n = 0;
foreach($users as $k => $user) {
foreach($stats as $stat) {
$this->Subscription->create();
$this->Subscription->set('statistic_id', $stat['Statistic']
['id']);
$this->Subscription->set('user_id', $k);
$this->Subscription->save();
$n++;
debug($n);
}
}

I also attempted to package all the data up into an array in the
following format:

$data['subscription'][] = array('user_id' => $uid, 'statistic_id' =>
$sid);
then $this->Subscription->saveAll($data['Subscription']

This method worked as well but also doubled the amount of records I
expected to be inserted.

What could I possibly be doing wrong? Could this be caused by a
"feedback look" with in how the models are related; the relations
seems ok to me...

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en