Listing Magento DB Resources / Connections

Magento #datenbank #magento #resourcen 
<?php

require_once 'app/Mage.php';

Mage::app();

$xml = Mage::app()->getConfig()->getNode('global/resources');
foreach ($xml->children() as $node) {
    echo $node->getName() . PHP_EOL;
}

This produces a list of the defined DB resources:

  • default_setup
  • default_write
  • default_read
  • core_setup
  • core_write
  • core_read
  • db
  • eav_setup
  • admin_setup
  • adminnotification_setup
  • cron_setup
  • directory_setup
  • dataflow_setup
  • cms_setup
  • index_setup
  • customer_setup
  • catalog_setup
  • catalogrule_setup

....