How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set::fetchAttributeSetData() work?

dmitry_fedyuk · May 2, 2016, 12:52am

Context: How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set::getSetInfo() work?

magento/magento2/blob/958164/app/code/Magento/Eav/Model/ResourceModel/Entity/Attribute/Set.php#L212-L218


/**
 * Returns data from eav_entity_attribute table for given $setId (or all if $setId is null)
 *
 * @param int $setId
 * @return array
 */
protected function fetchAttributeSetData($setId = null)

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/ResourceModel/Entity/Attribute/Set.php#L220-L233


$connection = $this->getConnection();
$select = $connection->select()->from(
    ['entity' => $this->getTable('eav_entity_attribute')],
    ['attribute_id', 'attribute_set_id', 'attribute_group_id', 'sort_order']
)->joinLeft(
    ['attribute_group' => $this->getTable('eav_attribute_group')],
    'entity.attribute_group_id = attribute_group.attribute_group_id',
    ['group_sort_order' => 'sort_order']
);
$bind = [];
if (is_numeric($setId)) {
    $bind[':attribute_set_id'] = $setId;
    $select->where('entity.attribute_set_id = :attribute_set_id');
}

$select->assemble():

SELECT 
	`entity`.`attribute_id`
	, `entity`.`attribute_set_id`
	, `entity`.`attribute_group_id`
	, `entity`.`sort_order`
	, `attribute_group`.`sort_order` AS `group_sort_order` 
FROM 
		`eav_entity_attribute` AS `entity`
	LEFT JOIN 
		`eav_attribute_group` AS `attribute_group` 
	ON entity.attribute_group_id = attribute_group.attribute_group_id 
WHERE (entity.attribute_set_id = :attribute_set_id)

github.com

magento/magento2/blob/958164/app/code/Magento/Eav/Model/ResourceModel/Entity/Attribute/Set.php#L234-L234


return $connection->fetchAll($select, $bind);