I think with all the posts you get the answer, should look like :
if( $fooId > 0 )
{
$newFoo['Foo']['id'] = $fooId;
}
else
$this->Foo->create();
$newFoo['Foo']['name'] = $name;
$newFoo['Foo']['text'] = $text;
if( $this->Foo->save( $newFoo ) )
$retVal = ($foold ? $this->Foo->field('id') :
$this->Foo->getLastInsertID());
}
}
return $retVal;
On Sep 4, 9:03 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Almost there. I want addFooToDb() to either create a record if it
> doesn't exist or update an existing record. What you provided here
> will only update a record that's been found.
>
> I should reiterate something with my example: The first time I run it
> with the sample data, if there are no entries in the database table,
> getFooId() will ALWAYS return 0, even if the entry has already been
> successfully saved. After the script has been run, if I run it again
> with the exact same data, it will always find the id for the first
> record that was created.
>
> Is that clearer at all?
>
> -Packgrog
>
> On Sep 4, 2:11 pm, "Chris Hartjes" <[EMAIL PROTECTED]> wrote:
>
> > 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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
