In Magento how do you get the database name?

Question

How do you get the database name from Magento?

I have seen functions like the one below that can get the table name.

$orderItemTable = Mage::getSingleton('core/resource')->getTableName('sales/order_item');

I was hoping that there was some sort of function like this:

Mage::getSingleton('core/resource')->getDatabaseName();

Thanks in advance for any ideas.

Answer 1

Each module can specify it's own connection so you are right to go via a model.

$config = Mage::getResourceModel('sales/order')->getConnection()->getConfig();
// $config is an array
$dbname = $config['dbname'];

If you're only interested in the default a slightly more efficient way might be:

$dbname = (string)Mage::getConfig()->getNode('global/resources/default_setup/connection/dbname');