Aten Software Product Data Exporter for Magento
_applyTablePrefix($TableName);
// Check if table exists in the current schema
// NOTE: Used constant TABLE_SCHEMA and TABLE_NAME to avoid directory scans
$query = "SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA=DATABASE()
AND TABLE_NAME = :table_name";
// Optionally check for columns
$MinimumColumnCount = 1;
if(isset($ColumnNames) && is_array($ColumnNames) && empty($ColumnNames) == false)
{
$query .= " AND COLUMN_NAME IN ('".implode("','", $ColumnNames)."')";
$MinimumColumnCount = count($ColumnNames);
}
// Get the number of matching columns
$CountColumns = $this->_dbi->fetchOne($query, array('table_name' => $TableName));
// Return result
return ($CountColumns >= $MinimumColumnCount);
}
// Apply prefix to table names in the query
private function _applyTablePrefix($query)
{
return str_replace('PFX_', $this->_tablePrefix, $query);
}
// Print the results of a select query to output for debugging purposes and exit
private function _debugPrintQuery($query, $params = null)
{
print '
'.htmlentities($query).'
';
if(is_null($params) == false)
{
print '
'.htmlentities(print_r($params, true)).'
';
}
print '
';
print '
';
$this->_dbi->setFetchMode(Zend_Db::FETCH_ASSOC);
print htmlentities(print_r($this->_dbi->fetchAll($query, $params), true));
print '
';
exit();
}
// Debug print a message to STDERR
// Prints execution time since last statement for profiling purposes
private function pr($message)
{
static $start = 0;
// Automatically print any non-string values
if(is_string($message) === false)
{
$message = print_r($message, true)."\n";
}
// Initialize start time, if needed.
if($start == 0)
{
$start = microtime(true);
}
// Get end time
$end = microtime(true);
// Get time elapsed
$elapsed = ($end - $start) * 1000;
// Remember end time for next call
$start = $end;
$MessageFormat = '[%06.5f]';
// Add elapsed time to the message
$message = sprintf($MessageFormat, $elapsed).$message;
fprintf(STDERR, $message);
}
}