This is actually just a reiteration of the same code I already
posted. Setting $newFoo['Foo']['id'] = 0; will have the same effect
as create(); as it will simply create a new row.
-Packgrog
On Sep 4, 3:15 pm, francky06l <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
