Getting A Database Adapter (Read or Write)

To read:

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

To write:

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

Mike Whitby

Say thanks38

Last edit

10 years ago

Mike Whitby

Keywords

db, mysql, connection

Enabling MySQL Query Logging

In /lib/Varien/Db/Adapter/Pdo/Mysql.php change this property to true:

/**
 * Write SQL debug data to file
 *
 * @var bool
 */
protected $_debug               = false;

To enable logging for queries slower than a certain ti...

Getting A Products URL

Potentially confusing due to the 3 methods you could use, all of which are in Mage_Catalog_Model_Product:

public function getUrlPath($category=null)
public function getUrlInStore($params = array())
public function getProductUrl($use...

Show All Indexes On a DB

Again, not Magento. Very handy though!

SELECT DISTINCT
    TABLE_NAME,
    INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';

Then you can use show indexes from table_name to see more info abo...

Adding A CSS Class To The Body Tag

To add a class via layout XML:

<reference name="root">
    <action method="addBodyClass"><classname>whatever</classname></action>
</reference>

Or to add via code, from a controller or block

if ($root = $this->getLayout()->getBlo...

Creating a Datetime attribute that stores time

Magento has a Datetime backend model but formats a Zend_Date object without the time. So if you want to store datetime (actually with time) you will need to setup your own backend model.

Here is how i've done it:

class Namespace_Module_Mod...

Posted by Mike Whitby to Magento (2012-03-07 16:51)

Getting A Database Adapter (Read or Write)

Related cards: