Class Mage_Core_Model_Resource_Helper_Mysql4
Resource helper class for MySql Varien DB Adapter
- Mage_Core_Model_Resource_Helper_Abstract
-
Mage_Core_Model_Resource_Helper_Mysql4
Direct known subclasses
Mage_Backup_Model_Resource_Helper_Mysql4, Mage_Eav_Model_Resource_Helper_Mysql4, Mage_ImportExport_Model_Resource_Helper_Mysql4, Mage_Index_Model_Resource_Helper_Mysql4, Mage_Reports_Model_Resource_Helper_Mysql4, Mage_Sales_Model_Resource_Helper_Mysql4Indirect known subclasses
Mage_Catalog_Model_Resource_Helper_Mysql4, Mage_CatalogSearch_Model_Resource_Helper_Mysql4
Package: Mage\Core
Category: Mage
Copyright: Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
License: Open Software License (OSL 3.0)
Author: Magento Core Team <core@magentocommerce.com>
Located at code/core/Mage/Core/Model/Resource/Helper/Mysql4.php
Category: Mage
Copyright: Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
License: Open Software License (OSL 3.0)
Author: Magento Core Team <core@magentocommerce.com>
Located at code/core/Mage/Core/Model/Resource/Helper/Mysql4.php
public
Zend_Db_Expr
|
|
public
Zend_Db_Expr
|
#
prepareColumn( string $column, string $groupAliasName = null, string $orderBy = null )
Returns analytic expression for database column |
public
string
|
#
getQueryUsingAnalyticFunction( Varien_Db_Select $select )
Returns select query with analytic functions |
public
string
|
|
public
Varien_Db_Select
|
#
limitUnion( Varien_Db_Select $select )
Correct limitation of queries with UNION No need to do additional actions on MySQL |
protected
array
|
#
_prepareOrder( Varien_Db_Select $select, boolean $autoReset = false )
Returns array of quoted orders with direction |
protected
string
|
|
protected
array
|
#
_prepareGroup( Varien_Db_Select $select, boolean $autoReset = false )
Returns quoted group by fields |
protected
array
|
#
_prepareHaving( Varien_Db_Select $select, boolean $autoReset = false )
Prepare and returns having array |
protected
string
|
#
_assembleLimit( string $query, integer $limitCount, integer $limitOffset, array $columnList = array() )
|
public
array
|
#
prepareColumnsList( Varien_Db_Select $select, mixed $groupByCondition = null )
Prepare select column list |
public
Varien_Db_Select
|
#
addGroupConcatColumn( Varien_Db_Select $select, string $fieldAlias, string $fields, string $groupConcatDelimiter = ',', string $fieldsDelimiter = '', string $additionalWhere = '' )
Add prepared column group_concat expression |
public
Zend_Db_Expr
|
#
getDateDiff( string|Zend_Db_Expr $startDate, string|Zend_Db_Expr $endDate )
Returns expression of days passed from $startDate to $endDate |
public
Zend_Db_Expr
|
#
addLikeEscape( string $value, array $options = array() )
Escapes and quotes LIKE value. Stating escape symbol in expression is not required, because we use standard MySQL escape symbol. For options and escaping see escapeLikeValue(). |
__construct(),
_getConnection(),
_getReadAdapter(),
_getWriteAdapter(),
convertOldColumnDefinition(),
escapeLikeValue(),
getCILike()
|
$_modulePrefix,
$_readAdapter,
$_writeAdapter
|