Hi everybody,
I tried to setup multiple db in my application.ini, then instanciate $db object
with the following line of code
$db =
Zend_Controller_Front::getInstance()->getParam('bootstrap')->getResource('multidb')->getDb('db1');
but I get "Call to a member function on a non-object" for getResource if I call
it in "My_Acl extends Zend_Acl".
Please, can anybody give any advices?
Do I have to add some init function in the bootstrap?
Thanks
Sergio Rinaudo
From: [email protected]
Date: Fri, 19 Mar 2010 08:12:48 -0700
To: [email protected]
CC: [email protected]
Subject: Re: [fw-general] Using an external database for user credential
The only thing that is "automatic" regarding the DB is Zend_Db_Table and its
default adapter. You can specify the default by using this confing option:
resources.multidb.db2.default = true
For everything else, you'll need to inject the db instance into your models
(for example, by injecting into a data mapper) or access it statically with:
$db =
Zend_Controller_Front::getInstance()->getParam('bootstrap')->getResource('multidb')->getDb('db2');
Injection is preferred because it makes unit testing easier.
--
Hector
On Fri, Mar 19, 2010 at 2:15 AM, Sergio Rinaudo <[email protected]>
wrote:
Thank you very much for your advices Hector.
I have one more question, is anything changing on models management using
multidb?
How do a model know which database resource must use?
Thanks
Sergio
From: [email protected]
Date: Tue, 16 Mar 2010 09:23:26 -0700
Subject: Re: [fw-general] Using an external database for user credential
To: [email protected]
CC: [email protected]
Take a look at the "multidb" resource:
http://framework.zend.com/manual/en/zend.application.available-resources.html
You could then inject your authentication adapter with the correct db:
// in controller
$db =
$this->getInvokeArg('bootstrap')->getResource('multidb')->getDb('db2')$authAdapter
= new Zend_Auth_Adapter_DbTable(
$db, $tabUsers, 'username',
'password');
This would eliminate the need for you to construct your own db adapter from the
config.
Also, you'll want to use boolean false for isDefaultTableAdapter -- when it's
set to true, that db instance will be used for all Zend_Db_Table instances by
default.
--
Hector
On Tue, Mar 16, 2010 at 2:34 AM, Sergio Rinaudo <[email protected]>
wrote:
Hello,
I am in a situation where I have to use an external database to check
credential for user.
Is there any right way to do this in the application ini?
I thoughts something like
resources.db2.adapter = // external db adapter
resources.db2.params.host = // external db host
resources.db2.params.username = // external db user
resources.db2.params.password = // external db pass
resources.db2.params.dbname = // external db name
resources.db2.isDefaultTableAdapter = // what am I supposed to put here?
resources.db2.params.charset = UTF8
resources.db2.profiler.enabled = true
Save it in the registry whitin bootstrap
$db2 = // some code
$registry->db2 = $db2;
Use $db2 to check credential in auth controller
$db2 = Zend_Registry::get('db2');
$authAdapter = new Zend_Auth_Adapter_DbTable(
$db2,
$tabUsers,
'username',
'password',
"SHA1(CONCAT('".$salt."',?)) AND status_id = '".$status_id."' "
);
Is that a correct way to do or there is something better?
Thanks in advance for all your advices.
Sergio
Lo spazio su Hotmail aumente con le tue esigenze... Vai oltre i 5GB
Lo spazio su Hotmail aumente con le tue esigenze... Vai oltre i 5GB
_________________________________________________________________
Proteggi i tuoi segreti con internet Explorer 8
http://www.microsoft.com/italy/windows/internet-explorer/features/stay-safer-online.aspx
