THAT'S IT! cacheQueries = false was exactly the detail I was
missing! Phew!!! :)
Thanks very much everyone! Much appreciated!
-Packgrog
On Sep 4, 4:04 pm, francky06l <[EMAIL PROTECTED]> wrote:
> I think you misunderstand, having !$foold will avoid setting the id,
> so it will call create and make a new record. If record exists, the
> create is not called and your id is set... it will update.
> Unless I am completely wrong concerning your problem, I think this
> code will update as well as create new record if needed. Now that you
> mention a "loop", using $this->Foo->cacheQueries = false might help.
>
> On Sep 4, 9:50 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> > 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 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
-~----------~----~----~----~------~----~------~--~---
