private function getCurrentFilters() { $result = array(); $stmtQuery = $this->connectionRead->select()->from($this->tableName, array('id', 'preg_match', 'type'))->query(); while ($filter = $stmtQuery->fetch()) { $result[$filter['id']] = $filter['preg_match'] . $this->separatorHash . $filter['type']; } return $result; }
public function getTableDataDump($tableName, $step = 100) { $sql = ''; if ($this->_read) { $quotedTableName = $this->_read->quoteIdentifier($tableName); $colunms = $this->_read->fetchRow('SELECT * FROM ' . $quotedTableName . ' LIMIT 1'); if ($colunms) { $arrSql = array(); $colunms = array_keys($colunms); $quote = $this->_read->getQuoteIdentifierSymbol(); $sql = 'INSERT INTO ' . $quotedTableName . ' (' . $quote . implode($quote . ', ' . $quote, $colunms) . $quote . ')'; $sql .= ' VALUES '; $startRow = 0; $select = $this->_read->select(); $select->from($tableName)->limit($step, $startRow); while ($data = $this->_read->fetchAll($select)) { $dataSql = array(); foreach ($data as $row) { $dataSql[] = $this->_read->quoteInto('(?)', $row); } $arrSql[] = $sql . implode(', ', $dataSql) . ';'; $startRow += $step; $select->limit($step, $startRow); } $sql = implode("\n", $arrSql) . "\n"; } } return $sql; }
/** * Run the jobs that are in the queue * * @param mixed $limit Limit of jobs to run * @return int Number of jobs run */ public function run($limit = NULL) { // Cleanup crashed jobs $pids = $this->_db->fetchCol("SELECT pid FROM {$this->_table} WHERE pid IS NOT NULL GROUP BY pid"); foreach ($pids as $pid) { // Old pid is no longer running, release it's reserved tasks if (is_numeric($pid) && !file_exists("/proc/{$pid}/status")) { Mage::log("A crashed job queue process was detected for pid {$pid}", Zend_Log::NOTICE, self::ERROR_LOG); $this->_db->update($this->_table, array('pid' => new Zend_Db_Expr('NULL')), array('pid = ?' => $pid)); } } // Reserve all new jobs since last run $pid = getmypid(); $limit = $limit ? "LIMIT {$limit}" : ''; $batchSize = $this->_db->query("UPDATE {$this->_db->quoteIdentifier($this->_table, true)} SET pid = {$pid} WHERE pid IS NULL ORDER BY job_id {$limit}")->rowCount(); // Run all reserved jobs $result = $this->_db->query($this->_db->select()->from($this->_table, '*')->where('pid = ?', $pid)->order(array('job_id'))); while ($row = $result->fetch()) { $where = $this->_db->quoteInto('job_id = ?', $row['job_id']); $data = substr($row['data'], 0, 1) == '{' ? json_decode($row['data'], TRUE) : ($data = unserialize($row['data'])); // Check retries if ($row['retries'] >= $row['max_retries']) { $this->_db->delete($this->_table, $where); Mage::log("{$row['pid']}: Mage::getSingleton({$row['class']})->{$row['method']}(" . json_encode($data) . ")\n" . $row['error_log'], Zend_Log::ERR, self::ERROR_LOG); continue; } // Run job! try { $model = Mage::getSingleton($row['class']); $method = $row['method']; $model->{$method}(new Varien_Object($data)); $this->_db->delete($this->_table, $where); Mage::log("{$row['pid']}: Mage::getSingleton({$row['class']})->{$row['method']}(" . json_encode($data) . ")", Zend_Log::INFO, self::SUCCESS_LOG); } catch (Exception $e) { // Increment retries and log error information $error = date('c') . " ERROR: " . get_class($e) . ": '{$e->getMessage()}' in {$e->getFile()}:{$e->getLine()}\n" . "Stack trace:\n" . $e->getTraceAsString(); $bind = array('pid' => new Zend_Db_Expr('NULL'), 'retries' => new Zend_Db_Expr('retries + 1'), 'error_log' => new Zend_Db_Expr('SUBSTR(CONCAT(error_log,' . $this->_db->quote($error) . ',"\\n\\n"),1,20000)')); $this->_db->update($this->_table, $bind, $where); } } return $batchSize; }
protected function getLikeExistItem($newItem, $ignoreTitle = true, $attributeSet = NULL) { $whereSql = ''; foreach ($newItem as $key => $value) { if ($ignoreTitle && $key == 'title') { continue; } if ($whereSql == '') { $whereSql .= ' '; } else { $whereSql .= ' AND '; } $whereSql .= ' `' . $key . '` '; is_null($value) && ($whereSql .= ' IS NULL '); is_string($value) && ($whereSql .= ' = ' . $this->mySqlReadConnection->quote($value) . ' '); (is_integer($value) || is_float($value)) && ($whereSql .= ' = ' . $value . ' '); } $dbSelect = $this->mySqlReadConnection->select()->from($this->tableNameNew, '*'); $whereSql != '' && $dbSelect->where($whereSql); $row = $this->mySqlReadConnection->fetchRow($dbSelect); if ($row === false) { return NULL; } if (!is_null($attributeSet)) { $templateId = (int) $row['id']; $templateType = (int) $attributeSet['template_type']; $attributeSetId = (int) $attributeSet['attribute_set_id']; $tasTable = Mage::getResourceModel('M2ePro/TemplatesAttributeSets')->getMainTable(); $dbSelect = $this->mySqlReadConnection->select()->from($tasTable, '*')->where('template_type = ?', $templateType)->where('template_id = ?', $templateId); $rowsAttributesSets = $this->mySqlReadConnection->fetchAll($dbSelect); if ($rowsAttributesSets === false || count($rowsAttributesSets) != 1) { return NULL; } $rowAttributeSet = $rowsAttributesSets[0]; if ((int) $rowAttributeSet['attribute_set_id'] != $attributeSetId) { return NULL; } } return $row; }
/** * Retrieve table status * * @param string $tableName * @return Varien_Object */ public function getTableStatus($tableName) { $row = $this->_write->showTableStatus($tableName); if ($row) { $statusObject = new Varien_Object(); $statusObject->setIdFieldName('name'); foreach ($row as $field => $value) { $statusObject->setData(strtolower($field), $value); } $cntRow = $this->_write->fetchRow($this->_write->select()->from($tableName, 'COUNT(1) as rows')); $statusObject->setRows($cntRow['rows']); return $statusObject; } return false; }
public function getValues($type) { $dbSelect = $this->mySqlReadConnection->select()->from($this->tableName, '*')->where('`type` = ?', (string) $type); return $this->mySqlReadConnection->fetchAll($dbSelect); }
/** * @param Varien_Db_Adapter_Pdo_Mysql $db * @return Varien_Db_Select */ protected function _getFilterableAttributeSelect($db) { return $db->select()->from(array('a' => $this->getTable('eav/attribute')), null)->joinInner(array('t' => $this->getTable('eav/entity_type')), "`t`.`entity_type_id` = `a`.`entity_type_id` AND `t`.`entity_type_code` = 'catalog_product'", null)->joinInner(array('ca' => $this->getTable('catalog/eav_attribute')), "`ca`.`attribute_id` = `a`.`attribute_id`", null)->where("`ca`.`is_filterable` <> 0"); }
/** * Retrieve select object for loading entity attributes values * * @param Varien_Object $object * @param mixed $rowId * @return Zend_Db_Select */ protected function _getLoadAttributesSelect($object, $table) { $select = $this->_read->select()->from($table)->where($this->getEntityIdField() . '=?', $object->getId()); return $select; }