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_Mysql4

Indirect 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

Methods summary
`public Zend_Db_Expr`	# `castField( string $field )` Returns expresion for field unification Returns expresion for field unification Parameters `$field` `string` $field Returns `Zend_Db_Expr`
`public Zend_Db_Expr`	# `prepareColumn( string $column, string $groupAliasName = null, string $orderBy = null )` Returns analytic expression for database column Returns analytic expression for database column Parameters `$column` `string` $column `$groupAliasName` `string` $groupAliasName OPTIONAL `$orderBy` `string` $orderBy OPTIONAL Returns `Zend_Db_Expr`
`public string`	# `getQueryUsingAnalyticFunction( Varien_Db_Select $select )` Returns select query with analytic functions Returns select query with analytic functions Parameters `$select` `Varien_Db_Select` $select Returns `string`
`public string`	# `getInsertFromSelectUsingAnalytic( Varien_Db_Select $select, string $table, array $fields )` Returns Insert From Select On Duplicate query with analytic functions Parameters `$select` `Varien_Db_Select` $select `$table` `string` $table `$fields` `array` $table Returns `string`
`public Varien_Db_Select`	# `limitUnion( Varien_Db_Select $select )` Correct limitation of queries with UNION No need to do additional actions on MySQL Correct limitation of queries with UNION No need to do additional actions on MySQL Parameters `$select` `Varien_Db_Select` $select Returns `Varien_Db_Select`
`protected array`	# `_prepareOrder( Varien_Db_Select $select, boolean $autoReset = false )` Returns array of quoted orders with direction Returns array of quoted orders with direction Parameters `$select` `Varien_Db_Select` $select `$autoReset` `boolean` $autoReset Returns `array`
`protected string`	# `_truncateAliasName( string $field, boolean $reverse = false )` Truncate alias name from field. Truncate alias name from field. Result string depends from second optional argument $reverse which can be true if you need the first part of the field. Field can be with 'dot' delimiter. Parameters `$field` `string` $field `$reverse` `boolean` $reverse OPTIONAL Returns `string`
`protected array`	# `_prepareGroup( Varien_Db_Select $select, boolean $autoReset = false )` Returns quoted group by fields Returns quoted group by fields Parameters `$select` `Varien_Db_Select` $select `$autoReset` `boolean` $autoReset Returns `array`
`protected array`	# `_prepareHaving( Varien_Db_Select $select, boolean $autoReset = false )` Prepare and returns having array Prepare and returns having array Parameters `$select` `Varien_Db_Select` $select `$autoReset` `boolean` $autoReset Returns `array` Throws `Zend_Db_Exception`
`protected string`	# `_assembleLimit( string $query, integer $limitCount, integer $limitOffset, array $columnList = array() )` Parameters `$query` `string` $query `$limitCount` `integer` $limitCount `$limitOffset` `integer` $limitOffset `$columnList` `array` $columnList Returns `string`
`public array`	# `prepareColumnsList( Varien_Db_Select $select, mixed $groupByCondition = null )` Prepare select column list Prepare select column list Parameters `$select` `Varien_Db_Select` $select `$groupByCondition` `mixed` $groupByCondition OPTIONAL Returns `array` Throws `Zend_Db_Exception`
`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 Add prepared column group_concat expression Parameters `$select` `Varien_Db_Select` $select `$fieldAlias` `string` $fieldAlias Field alias which will be added with column group_concat expression `$fields` `string` $fields `$groupConcatDelimiter` `string` $groupConcatDelimiter `$fieldsDelimiter` `string` $fieldsDelimiter `$additionalWhere` `string` $additionalWhere Returns `Varien_Db_Select`
`public Zend_Db_Expr`	# `getDateDiff( string\|Zend_Db_Expr $startDate, string\|Zend_Db_Expr $endDate )` Returns expression of days passed from $startDate to $endDate Returns expression of days passed from $startDate to $endDate Parameters `$startDate` `string\|Zend_Db_Expr` $startDate `$endDate` `string\|Zend_Db_Expr` $endDate Returns `Zend_Db_Expr`
`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(). 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(). Parameters `$value` `string` $value `$options` `array` $options Returns `Zend_Db_Expr` See `Mage_Core_Model_Resource_Helper_Abstract::escapeLikeValue()`

Methods inherited from Mage_Core_Model_Resource_Helper_Abstract
`__construct(), _getConnection(), _getReadAdapter(), _getWriteAdapter(), convertOldColumnDefinition(), escapeLikeValue(), getCILike()`

Properties inherited from Mage_Core_Model_Resource_Helper_Abstract
`$_modulePrefix, $_readAdapter, $_writeAdapter`

Packages

Classes

Exceptions

Functions

Class Mage_Core_Model_Resource_Helper_Mysql4

Direct known subclasses

Indirect known subclasses

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

Parameters

Returns

See