Zikula version: 1.3.2
In config.php is provided to configure second (external) database.
Please advice (sample code or idea) how to make queries against this database.
Tank you in advance.
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- rallek responded to »What's going on with 1. the documentation | 2. the AppStore« 24. May
- Paustian responded to »Shared user database« 23. May
- Paustian responded to »Problems: module "htmlpages« 23. May
- bronto responded to »Forcing a theme for particular URLs« 22. May
- Paustian created topic »Dealing with a Huge User List« 21. May
- Paustian responded to »Manual Zikula 1.2.9 (dev) to Zikula 1.3.5 update« 21. May
- krator responded to »Refresh Templates/Cache« 19. May
Login
Connect to external database
-
- Rank: Developer
- Registered: Nov 23, 2002
- Last visit: Jul 26, 2004
- Posts: 59
Posted: Feb 29, 2012 - 02:04 AM
-
- Rank: Softmore
- Registered: Aug 08, 2002
- Last visit: May 21, 2010
- Posts: 124
Posted: Mar 02, 2012 - 06:28 PM
funny, I was looking for the same answer :)
I would like to share the same tables of itsNews on another site... -
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2447
Posted: Mar 04, 2012 - 04:48 PM
It seems that you need to invoke the event: doctrine.init_connection
and you will get the connection as the data, like the core does:
Code
$args = array('name' => 'yourConfigName', 'lazy' => true/false);
$dbEvent = new Zikula_Event('doctrine.init_connection', null, $args);
$myConnection = $this->eventManager->notify($dbEvent)->getData();
My guess is that the connection is available from there for the Doctrine_Records and DBUtil.
When you finish it, you may need to close the connection or restore the current one to the default:
Code
$doctrineManager = Doctrine_Manager::getInstance();
$doctrineManager->closeConnection($doctrineManager->getConnection('yourConfigName'));
// if you have more than two opened, it's good to be sure to restore the default
$doctrineManager->setCurrentConnection('default');
This is what I conclude by reading the code, I haven't used this feature.
Greetz
--
- Mateo T. -
Mis principios... son mis fines -
- Rank: Developer
- Registered: Nov 23, 2002
- Last visit: Jul 26, 2004
- Posts: 59
Posted: Mar 05, 2012 - 01:28 AM
Thank you Mateo, using your suggestions and exploring the code, managed to write some code that works.
Code
// Init new connection to external database (do once)
$ConfigConnectionName = 'test'; # connection name as specified in config.php
$dbEvent = new Zikula_Event('doctrine.init_connection', null, array('lazy' => false, 'name' => $ConfigConnectionName));
$NewConnection = EventUtil::getManager()->notify($dbEvent)->getData();
// Make queries to external database
// Set current connection to external db
$doctrineManager = Doctrine_Manager::getInstance();
$doctrineManager->setCurrentConnection($ConfigConnectionName);
// now can query external database
$query = "SHOW TABLES";
$result = DBUtil::executeSQL($query);
if ($result) {
$resitems = $result->fetchAll();
print_r($resitems);
}
// restore default connection (important)
$doctrineManager->setCurrentConnection('default');
Maybe there is better solution, but this works for now. -
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2447
Posted: Mar 05, 2012 - 04:11 AM
Nice
FYI I guess that the Manager sets the latest opened connection as the current one, so, you don't need to make it explicit, but restore the default or close your connection if you won't use it again ;)
--
- Mateo T. -
Mis principios... son mis fines -
- Rank: Developer
- Registered: Nov 23, 2002
- Last visit: Jul 26, 2004
- Posts: 59
Posted: Mar 05, 2012 - 07:57 PM
It is true that latest opened connection become current one. I put setCurrentConnection in the example, just in case, if this piece of code use as function to call many times, and between is possible to call zikula queries against default database.
BTW first piece of code (opening connection) I expected to already done by Zikula, when opening default connection (in init Zikula code). -
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2447
Posted: Mar 06, 2012 - 05:07 PM
You mean you want Zikula open your 'test' connection everytime?
You can do it with EventHandlers too, check the docs inside the package, in the /docs folder
--
- Mateo T. -
Mis principios... son mis fines -
- Rank: Registered User
- Registered: Feb 06, 2012
- Last visit:
- Posts: 1
Posted: Mar 13, 2012 - 06:29 AM
nikp, where would you put this code above? I am new to the Zikula platform, and just trying to display certain tables in an external DB based on user credentials. Do I need to create an entirely new module to do this or is there something out there that will aid in developing this kind of procedure? -
- Rank: Developer
- Registered: Nov 23, 2002
- Last visit: Jul 26, 2004
- Posts: 59
Posted: Mar 13, 2012 - 07:00 AM
If you like to make something usable to website visitors, you have to make new module, or additions to existing one.
But if you like to test only, you can create a PHP file, for example test_zikula.php, put the above code in it, and upload in main Zikula directory, and then point with browser www.zikulasite.xyz/test_zikula.php
Content of the file can be something like this:
Code
// Zikula init
include 'lib/bootstrap.php';
$core->init();
// Init new connection to external database (do once)
$ConfigConnectionName = 'test'; # connection name as specified in config.php
$dbEvent = new Zikula_Event('doctrine.init_connection', null, array('lazy' => false, 'name' => $ConfigConnectionName));
$NewConnection = EventUtil::getManager()->notify($dbEvent)->getData();
// Make queries to external database
// Set current connection to external db
$doctrineManager = Doctrine_Manager::getInstance();
$doctrineManager->setCurrentConnection($ConfigConnectionName);
// now can query external database
$query = "SHOW TABLES";
$result = DBUtil::executeSQL($query);
if ($result) {
$resitems = $result->fetchAll();
print_r($resitems);
}
// restore default connection (important)
$doctrineManager->setCurrentConnection('default');
// Zikula footer and shutdown (uncomment if you like to see header and footer)
//Zikula_View_Theme::getInstance()->themefooter();
system::shutdown();
In this example parameters for connection 'test' you have to enter in your config/config.php file, as second (not 'default').
Edited by nikp on Mar 13, 2012 - 11:06 AM. -
- Rank: Team Member
- Registered: Sep 06, 2006
- Last visit: May 09, 2010
- Posts: 2447
Posted: Mar 13, 2012 - 03:03 PM
Hi David! Welcome to the forums :)
You can also code a Block, cloning an existing one and putting in inside anothe module in the meanwhile.
Blocks are simpler, but currently I don't remember what's the standard to put those pieces of code on /config/Blocks
/config is the difectory where all your custom stuff should be
so if you update the system, or a module, you have your code and your overrides there with no problem
Greetings
--
- Mateo T. -
Mis principios... son mis fines -
- Rank: Developer
- Registered: Nov 23, 2002
- Last visit: Jul 26, 2004
- Posts: 59
Posted: Mar 13, 2012 - 06:30 PM
Solution with block is nice, particularry if the task is quite simple and don't need complicated admin and user interface.
Even Zikula provides very useful native block: "Simple file include". Place above code in a PHP file (without Zikula init/shutdown), create such a block, enter path to the file, and all is done
Edited by nikp on Mar 13, 2012 - 10:32 PM. -
- Rank: Developer
- Registered: Aug 23, 2003
- Last visit: May 31, 2010
- Posts: 1662
Posted: Mar 13, 2012 - 07:07 PM
Hey that are great ideas for some testing and including external parts indeed.
And all within Zikula itself.
--
campertoday.nl, Module development, Dutch Zikula Community
- Moderated by:
- Support
