public function test_getQueryToSelect() { /** === Test Data === */ $sql = "SELECT `paa`.`id` AS `Id`, `paa`.`balance` AS `Balance`, `pata`.`code` AS `Asset`, (CONCAT(firstname, ' ', lastname)) AS `CustName`, `ce`.`email` AS `CustEmail` FROM `prxgt_acc_account` AS `paa`\n LEFT JOIN `prxgt_acc_type_asset` AS `pata` ON pata.id=paa.asset_type_id\n LEFT JOIN `customer_entity` AS `ce` ON ce.entity_id=paa.customer_id"; /** === Setup Mocks === */ $this->_setTableNames([EAccount::ENTITY_NAME, Cfg::ENTITY_MAGE_CUSTOMER, ETypeAsset::ENTITY_NAME]); /** === Call and asserts === */ $res = $this->obj->getQueryToSelect(); $this->assertEquals($sql, (string) $res); }
public function getQueryToSelect() { $result = parent::getQueryToSelect(); $this->_populateSelect($result); return $result; }