I must admit that I should have asked you about what you found about
the persistent key thingy. Should it be set to "false" in this
situation? And if so, why do you think it's the case? Sorry if it sounds
like an interview question :)
On Mon, Apr 09, 2007 at 08:49:17PM -0000, BlenderStyle wrote:
>
> You're welcome. In doing this, I learned about the persistent key, so
> everyone wins. Let us know how it goes.
>
> On Apr 9, 1:15 pm, Sergei Gerasenko <[EMAIL PROTECTED]>
> wrote:
> > Matt, thanks so much for all the time you took to test this thing. I
> > can see how it could work now. I'm off and running now.
> >
> > Thanks!!!
> >
> >
> >
> > On Mon, Apr 09, 2007 at 07:59:26PM -0000, BlenderStyle wrote:
> >
> > > Okay, I just tried it, and it worked. Here's what I did:
> >
> > > Downloaded cake_1.2.0.4798alpha, extracted it, and made app/tmp
> > > writeable.
> > > I created the following databases/users/tables:
> >
> > > database: multidbtest_a
> > > user: multidbtest_a
> > > table: users (id, name)
> >
> > > database: multidbtest_b
> > > user:multidbtest_b
> > > table: profiles (id, user_id, name)
> >
> > > I setup app/config/database.php as follows:
> > > var $default = array(
> > > 'driver' => 'mysql',
> > > 'persistent' => false,
> > > 'host' => 'localhost',
> > > 'login' => 'multidbtest_a',
> > > 'password' => 'NNJdALDhvm6Uqm8,',
> > > 'database' => 'multidbtest_a',
> > > 'prefix' => ''
> > > );
> >
> > > var $dbb = array(
> > > 'driver' => 'mysql',
> > > 'persistent' => false,
> > > 'host' => 'localhost',
> > > 'login' => 'multidbtest_b',
> > > 'password' => ':.bwaJ6wXCDQs8Q:',
> > > 'database' => 'multidbtest_b',
> > > 'prefix' => ''
> > > );
> >
> > > I created two models with two controllers. The first model is User:
> > > class User extends AppModel
> > > {
> > > var $name = 'User';
> > > var $useDbConfig = 'default';
> > > var $useTable = 'users';
> >
> > > var $hasOne = array(
> > > 'Profile' => array(
> > > 'className' => 'Profile',
> > > 'foreignKey' => 'user_id'
> > > )
> > > );
> > > }
> >
> > > The other model is Profile:
> > > class Profile extends AppModel
> > > {
> > > var $name = 'Profile';
> > > var $useDbConfig = 'dbb';
> > > var $useTable = 'profiles';
> >
> > > var $belongsTo = array(
> > > 'User' => array(
> > > 'className' => 'User',
> > > 'foreignKey' => 'user_id'
> > > )
> > > );
> > > }
> >
> > > Then, my two controllers:
> > > class UsersController extends AppController
> > > {
> > > var $name = 'users';
> > > var $scaffold;
> > > }
> >
> > > class ProfilesController extends AppController
> > > {
> > > var $name = 'profiles';
> > > var $scaffold;
> > > }
> >
> > > I browsed to somesite.com/users and created a couple of users, then
> > > went over to somesite.com/profiles and created some profiles for those
> > > users. That's it. Took about 5 minutes to get this up and running. The
> > > real key to making this work is the persistent key (ha! a pun) in the
> > > database configs. I think 1.2 defaults to persistent false, where 1.1
> > > doesn't.
> >
> > > Matt Bowden
> >
> > > On Apr 9, 10:10 am, Sergei Gerasenko <[EMAIL PROTECTED]>
> > > wrote:
> > > > > Yes, that should work. I haven't tried it, and I don't know how Cake
> > > > > queries in a situation like this, but it doesn't hurt to try. Try it
> > > > > out with scaffolding, and see if it works. Let us know.
> >
> > > > I think it would definitely stop working if database "B" has another
> > > > username/password combination. This whole issue could throw a big
> > > > wrench into
> > > > the gears. But I'll try tonight anyway and will let you know.
> >
> > --
> >
> > Sergei Gerasenko
> > IT Department
> > PublicSchoolWORKS
> > Phone: (513)-631-6111
>
>
> >
--
Sergei Gerasenko
IT Department
PublicSchoolWORKS
Phone: (513)-631-6111
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
