How to get the final name for a table?

dmitrii_fediuk · January 16, 2016, 1:31pm

You should call the \Magento\Framework\App\ResourceConnection::getTableName() method:

magento/magento2/blob/2.0.0/lib/internal/Magento/Framework/App/ResourceConnection.php#L130-L153


public function getTableName($modelEntity, $connectionName = self::DEFAULT_CONNECTION)
{
    $tableSuffix = null;
    if (is_array($modelEntity)) {
        list($modelEntity, $tableSuffix) = $modelEntity;
    }


    $tableName = $modelEntity;


    $mappedTableName = $this->getMappedTableName($tableName);
    if ($mappedTableName) {
        $tableName = $mappedTableName;
    } else {
        $tablePrefix = $this->getTablePrefix();
        if ($tablePrefix && strpos($tableName, $tablePrefix) !== 0) {
            $tableName = $tablePrefix . $tableName;
        }
    }


    if ($tableSuffix) {
        $tableName .= '_' . $tableSuffix;
    }
    return $this->getConnection($connectionName)->getTableName($tableName);
}

A usage example

github.com

magento/magento2/blob/2.0.0/app/code/Magento/AdvancedPricingImportExport/Model/Export/AdvancedPricing.php#L360-L364


->joinInner(
    ['ap' => $this->_resource->getTableName($table)],
    'ap.entity_id = cpe.entity_id',
    []
)