On 9/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Say I have an input file that takes in data that gets parsed into
> $name and $text which I then pass to addFooToDb(). My uniqueness key
> here is $name, and say we're assuming that the file is sorted by a
> timestamp, and we want to overwrite existing entries with the same
> name with any new ones that are encountered. Say our data looks
> something like this:
> -------------------------------------------------------------
>
> "Bob Jones", "04/05/2007 12:00:00"
> "Sam Smith", "04/05/2007 12:01:24"
> "Bob Jones", "04/05/2007 01:38:02"
>
> -------------------------------------------------------------
>
> If there was no entry for "Bob Jones" when the loop starts, TWO
> entries will be created, because each successive call to getFooId will
> return '0' for the id, even though the entry has been created. The
> getLastInsertId() method won't help here since it won't be the proper
> reference once we add the "Sam Smith" record.
Aha! I think I may understand what the problem is. You don't want to
create new records, you want to simply update an existing one, right?
If that's the case, then what you need to do is make sure that you are
adding the primary key to your $data array and then executing a save.
Let me show you an example using your own function with a few
tweaks...
function getFooId( $name )
{
$foo = $this->Foo->find("Foo.name LIKE '%$name%'");
if ($foo) {
return $foo['Foo']['id'];
}
return 0;
}
function addFooToDb($name, $ext) {
$retVal = 0;
$fooId = $this->getFooId( $name );
if( $fooId > 0 )
{
$newFoo['Foo']['id'] = $fooId;
$newFoo['Foo']['name'] = $name;
$newFoo['Foo']['text'] = $text;
if( $this->Foo->save( $newFoo ) )
{
$retVal = $this->Foo->field('id');
}
}
return $retVal;
}
Try that out, that might fix the problem. My apologies if I have
misunderstood the problem.
--
Chris Hartjes
Senior Developer
Cake Development Corporation
My motto for 2007: "Just build it, damnit!"
@TheBallpark - http://www.littlehart.net/attheballpark
@TheKeyboard - http://www.littlehart.net/atthekeyboard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
