protected function _construct()
{
$this->_init('cleaner/magentoDatabase');
$this->coreResource = Mage::getSingleton('core/resource');
$this->dbRead = $this->coreResource->getConnection('core_read');
$this->dbWrite = $this->coreResource->getConnection('core_write');
$this->tables = $this->getTables();
}
public function __construct($name = null, array $data = [], $dataName = '')
{
parent::__construct($name, $data, $dataName);
$this->_manObj = ObjectManager::getInstance();
$this->_logger = $this->_manObj->get(\Psr\Log\LoggerInterface::class);
$this->_resource = $this->_manObj->get(\Magento\Framework\App\ResourceConnection::class);
$this->_conn = $this->_resource->getConnection();
$this->_toolPeriod = $this->_manObj->get(IPeriod::class);
/* base services */
$this->_callDownlineCustomer = $this->_manObj->get(\Praxigento\Downline\Service\ICustomer::class);
$this->_callDownlineSnap = $this->_manObj->get(\Praxigento\Downline\Service\ISnap::class);
/* set up application */
$this->_setAreaCode();
}
/**
* Init profiler during creation of DB connect
*/
public function testProfilerInit()
{
$connReadConfig = Mage::getConfig()->getResourceConnectionConfig('core_read');
$profilerConfig = $connReadConfig->addChild('profiler');
$profilerConfig->addChild('class', 'Mage_Core_Model_Resource_Db_Profiler');
$profilerConfig->addChild('enabled', 'true');
/** @var Zend_Db_Adapter_Abstract $connection */
$connection = $this->_model->getConnection('core_read');
/** @var Mage_Core_Model_Resource_Db_Profiler $profiler */
$profiler = $connection->getProfiler();
$this->assertInstanceOf('Mage_Core_Model_Resource_Db_Profiler', $profiler);
$this->assertTrue($profiler->getEnabled());
$this->assertAttributeEquals((string) $connReadConfig->host, '_host', $profiler);
$this->assertAttributeEquals((string) $connReadConfig->type, '_type', $profiler);
}
/**
* Creates a connection to resource whenever needed
*
* @param string $name
* @return Varien_Db_Adapter_Interface
*/
public function getConnection($name)
{
$connection = parent::getConnection($name);
/*
* Make sure the profiler is enabled for all requests
*/
$connection->getProfiler()->setEnabled(true);
return $connection;
}
/**
* Constructor for class instance
*
* @param Enterprise_Mview_Model_Event $eventModel
* @param Varien_Db_Adapter_Interface $connection
* @param Mage_Core_Model_Resource $resource
*/
public function __construct($eventModel = null, $connection = null, $resource = null)
{
if ($resource instanceof Mage_Core_Model_Resource) {
$this->_resource = $resource;
} else {
$this->_resource = Mage::getSingleton('core/resource');
}
if ($eventModel instanceof Mage_Core_Model_Abstract) {
$this->_eventModel = $eventModel;
} else {
$this->_eventModel = Mage::getModel('enterprise_mview/event');
}
if ($connection instanceof Varien_Db_Adapter_Interface) {
$this->_connection = $connection;
} else {
$this->_connection = $this->_resource->getConnection(Mage_Core_Model_Resource::DEFAULT_WRITE_RESOURCE);
}
}
/**
* Clean database
*
* @param SimpleXMLElement $config
* @return Mage_Install_Model_Installer_Db_Abstract
*/
public function cleanUpDatabase(SimpleXMLElement $config)
{
$resourceModel = new Mage_Core_Model_Resource();
$connection = $resourceModel->getConnection(Mage_Core_Model_Resource::DEFAULT_SETUP_RESOURCE);
$dbName = $config->dbname;
$connection->query('DROP DATABASE IF EXISTS ' . $dbName);
$connection->query('CREATE DATABASE ' . $dbName);
return $this;
}
/**
* Constructor
*
* @param array $args
*/
public function __construct(array $args = array())
{
$this->_resource = isset($args['resource']) ? $args['resource'] : Mage::getSingleton('core/resource');
$this->_connection = isset($args['connection']) ? $args['connection'] : $this->_resource->getConnection(Mage_Core_Model_Resource::DEFAULT_WRITE_RESOURCE);
$this->_config = isset($args['config']) ? $args['config'] : Mage::getConfig();
$this->_categoryModel = isset($args['categoryModel']) ? $args['categoryModel'] : Mage::getModel('catalog/category');
$this->_productHelper = isset($args['productHelper']) ? $args['productHelper'] : Mage::helper('catalog/product');
$this->_categoryHelper = isset($args['categoryHelper']) ? $args['categoryHelper'] : Mage::helper('catalog/category');
$this->_app = isset($args['app']) ? $args['app'] : Mage::app();
}
/**
* Creates a connection to resource whenever needed
*
* @param string $name
* @return Varien_Db_Adapter_Interface
*/
public function getConnection($name)
{
if (defined('XTEST_BOOTSTRAPPED')) {
static $connection;
if (!$connection) {
$connection = parent::getConnection('core_write');
}
return $connection;
}
return parent::getConnection('default_setup');
}
/**
* Get connection by name or type
*
* @param string $connectionName
* @return Zend_Db_Adapter_Abstract
*/
protected function _getConnection($connectionName)
{
if (isset($this->_connections[$connectionName])) {
return $this->_connections[$connectionName];
}
if (!empty($this->_resourcePrefix)) {
$this->_connections[$connectionName] = $this->_resources->getConnection($this->_resourcePrefix . '_' . $connectionName);
} else {
$this->_connections[$connectionName] = $this->_resources->getConnection($connectionName);
}
return $this->_connections[$connectionName];
}
public function getEstado($id)
{
$resource = new Mage_Core_Model_Resource();
$read = $resource->getConnection("core_read");
$select = $read->select()->from('directory_country_region')->where('region_id = ?', $id);
$r = $read->fetchAll($select);
if (array_key_exists(0, $r)) {
$estado = $r[0];
if (array_key_exists('default_name', $estado)) {
return $estado['default_name'];
}
}
}
/**
* Get connection by name or type
*
* @param string $connectionName
* @return Varien_Db_Adapter_Interface|bool
*/
protected function _getConnection($connectionName)
{
if (isset($this->_connections[$connectionName])) {
return $this->_connections[$connectionName];
}
$connectionNameFull = ($this->_resourcePrefix ? $this->_resourcePrefix . '_' : '') . $connectionName;
$connectionInstance = $this->_resources->getConnection($connectionNameFull);
// cache only active connections to detect inactive ones as soon as they become active
if ($connectionInstance) {
$this->_connections[$connectionName] = $connectionInstance;
}
return $connectionInstance;
}
/**
* Populate ACL with rules from external storage
*
* @param Magento_Acl $acl
*/
public function populateAcl(Magento_Acl $acl)
{
$ruleTable = $this->_resource->getTableName("admin_rule");
$adapter = $this->_resource->getConnection('read');
$select = $adapter->select()->from(array('r' => $ruleTable));
$rulesArr = $adapter->fetchAll($select);
foreach ($rulesArr as $rule) {
$role = $rule['role_type'] . $rule['role_id'];
$resource = $rule['resource_id'];
$privileges = !empty($rule['privileges']) ? explode(',', $rule['privileges']) : null;
if ($rule['permission'] == 'allow') {
if ($resource === Mage_Backend_Model_Acl_Config::ACL_RESOURCE_ALL) {
$acl->allow($role, null, $privileges);
}
$acl->allow($role, $resource, $privileges);
} else {
if ($rule['permission'] == 'deny') {
$acl->deny($role, $resource, $privileges);
}
}
}
}
/**
* Populate ACL with roles from external storage
*
* @param Magento_Acl $acl
*/
public function populateAcl(Magento_Acl $acl)
{
$roleTableName = $this->_resource->getTableName('admin_role');
$adapter = $this->_resource->getConnection('read');
$select = $adapter->select()->from($roleTableName)->order('tree_level');
foreach ($adapter->fetchAll($select) as $role) {
$parent = $role['parent_id'] > 0 ? Mage_User_Model_Acl_Role_Group::ROLE_TYPE . $role['parent_id'] : null;
switch ($role['role_type']) {
case Mage_User_Model_Acl_Role_Group::ROLE_TYPE:
$roleId = $role['role_type'] . $role['role_id'];
$acl->addRole($this->_objectFactory->getModelInstance('Mage_User_Model_Acl_Role_Group', array('roleId' => $roleId)), $parent);
break;
case Mage_User_Model_Acl_Role_User::ROLE_TYPE:
$roleId = $role['role_type'] . $role['user_id'];
if (!$acl->hasRole($roleId)) {
$acl->addRole($this->_objectFactory->getModelInstance('Mage_User_Model_Acl_Role_User', array('roleId' => $roleId)), $parent);
} else {
$acl->addRoleParent($roleId, $parent);
}
break;
}
}
}
public function deleteAction()
{
$post = $this->getRequest()->getParams();
$id = $post["id"];
$resource = new Mage_Core_Model_Resource();
$write = $resource->getConnection('core_write');
try {
$write->delete("motoboyconfig", $write->quoteInto("id=?", $id));
$this->_redirect('*/*/rangecep');
Mage::getSingleton('adminhtml/session')->addSuccess('Faixa de CEP deletada com sucesso!');
} catch (Exception $e) {
Mage::getSingleton('adminhtml/session')->addError('Erro ao deletar Faixa de CEP, contate o suporte!');
}
}
/**
* Test correct event starting and stopping in magento profile during SQL query fail
*/
public function testProfilerDuringSqlException()
{
/** @var Zend_Db_Adapter_Pdo_Abstract $connection */
$connection = $this->_model->getConnection('core_read');
try {
$connection->query('SELECT * FROM unknown_table');
} catch (Zend_Db_Statement_Exception $exception) {
}
if (!isset($exception)) {
$this->fail("Expected exception didn't thrown!");
}
/** @var Mage_Core_Model_Resource $resource */
$resource = Mage::getSingleton('Mage_Core_Model_Resource');
$testTableName = $resource->getTableName('core_resource');
$connection->query('SELECT * FROM ' . $testTableName);
/** @var Mage_Core_Model_Resource_Db_Profiler $profiler */
$profiler = $connection->getProfiler();
$this->assertInstanceOf('Mage_Core_Model_Resource_Db_Profiler', $profiler);
$queryProfiles = $profiler->getQueryProfiles(Varien_Db_Profiler::SELECT);
$this->assertCount(2, $queryProfiles);
}
/**
* Initialize resource and connection instances
*
* @param array $args
*/
public function __construct(array $args = array())
{
$this->_resource = Mage::getSingleton('core/resource');
$this->_connection = !empty($args['connection']) ? $args['connection'] : $this->_resource->getConnection(Mage_Core_Model_Resource::DEFAULT_READ_RESOURCE);
}
/**
* Constructor
*
* @param Mage_Core_Model_Resource $resource
*/
public function __construct(Mage_Core_Model_Resource $resource)
{
$this->_sessionTable = $resource->getTableName('core_session');
$this->_write = $resource->getConnection('core_write');
}
/**
Retorna endereços do cliente
*/
public function getAddressesSelect($customer_id, $scope)
{
$customer = Mage::getModel('customer/customer')->load($customer_id);
$_string_options = '';
// variável para armazenar as informações dos endereços
if (count($customer->getAddresses()) > 0) {
$default_id = 0;
if ($scope == 'billing') {
$default_billing_address = $customer->getDefaultBillingAddress();
if (method_exists($default_billing_address, 'getData')) {
$default_id = $default_billing_address->getData('entity_id');
}
} else {
if ($scope == 'shipping') {
$default_shipping_address = $customer->getDefaultShippingAddress();
if (method_exists($default_shipping_address, 'getData')) {
$default_id = $default_shipping_address->getData('entity_id');
}
}
}
foreach ($customer->getAddresses() as $address) {
$info_data = $address->getData();
if (array_key_exists('region_id', $info_data)) {
$resource = new Mage_Core_Model_Resource();
$read = $resource->getConnection('core_read');
$select = $read->select()->from('directory_country_region')->where('region_id = ?', $info_data['region_id']);
$r = $read->fetchAll($select);
$result_set = $r[0];
$region = $result_set['default_name'];
} else {
$region = "";
}
$_string_options .= "<option ";
if ($address->getData('entity_id') == $default_id) {
$_string_options .= "selected='selected'";
}
$_string_options .= "value='" . $info_data['entity_id'] . "' > " . $info_data['firstname'] . " " . $info_data['lastname'] . ",\n\t\t\t\t" . $info_data['street'] . ", " . $info_data['postcode'] . ", " . $info_data['city'] . ", " . $region . " </option> \n";
}
$_string_options .= "<option value='0'> Novo Endereço </option>";
return $_string_options;
} else {
return null;
}
}
/**
* Get a list of host names for the supplied database resource.
*
* @param \Mage_Core_Model_Resource $resource
* @return array
*/
public function getByResource(\Mage_Core_Model_Resource $resource)
{
return $this->getByConnection($resource->getConnection('core_read'));
}
protected function _construct()
{
$this->_resource = Mage::getSingleton('core/resource');
$this->_connection = $this->_resource->getConnection('core_write');
$this->_table = $this->_resource->getTableName($this->_table);
}
