Exemple #1
0
define('MAX_DELETE_RECORDS', 1000);
define('DEPLOY_LOG_FILE', 'oem-import.log');
$currentDir = dirname(__FILE__);
$rootDir = dirname(dirname($currentDir)) . '/';
require $rootDir . 'Vic.php';
$debugSQLDump = isset($_GET['debug_sqldump']) && $_GET['debug_sqldump'];
$debugImitateQuery = isset($_GET['debug_imitateQuery']) && $_GET['debug_imitateQuery'];
$debugDumpSrcData = isset($_GET['debug_dumpSrcData']) && $_GET['debug_dumpSrcData'];
$debugDumpColAssignment = isset($_GET['debug_cols']) && $_GET['debug_cols'];
require_once $currentDir . '/functions.php';
require_once $currentDir . '/Deployer.php';
$deployer = new Deployer();
$deployer->initLog($rootDir . 'var/log/' . DEPLOY_LOG_FILE);
require_once $currentDir . '/creds.php';
if ($deployer->initDb($dbhost, $dbUser, $dbPass, $dbName)) {
    $deployer->logMessage("DB init successful\n");
} else {
    die('DB init not successful');
}
$params = $_GET;
$fileName = $rootDir . ltrim($params['file'], ' /');
$rowsInsertedTotal = 0;
$rowsTotal = 0;
$rowsProcessed = 0;
$rowsProcessedTotal = 0;
$dataString = '';
$deployer->logMessage("Processing {$fileName}");
$handle = fopen($fileName, "rb");
if (false === $handle) {
    $deployer->logMessage("Could not open {$fileName} for reading");
    die;
Exemple #2
0
ini_set('memory_limit', '1024M');
ini_set('max_execution_time', '600');
set_time_limit(0);
define('MAX_QUERY_ROWS', 100);
define('DEPLOY_LOG_FILE', 'oem-import.log');
$currentDir = dirname(__FILE__);
$rootDir = dirname(dirname($currentDir)) . '/';
require $rootDir . 'Vic.php';
$sqlDump = isset($_GET['sqldump']) && $_GET['sqldump'];
require_once $currentDir . '/Deployer.php';
$deployer = new Deployer();
$deployer->initLog($rootDir . 'var/log/' . DEPLOY_LOG_FILE);
require_once $currentDir . '/creds.php';
if ($deployer->initDb($dbhost, $dbUser, $dbPass, $dbName)) {
    $deployer->logMessage('DB init successful');
} else {
    die('DB init not successful');
}
$files = array();
$importDir = $rootDir . 'var/import/pulliver/oem/';
if ($handle = opendir($importDir)) {
    while ($file = readdir($handle)) {
        $pathinfo = pathinfo($file);
        if ('csv' == @$pathinfo['extension']) {
            $files[] = $file;
        }
    }
    closedir($handle);
} else {
    die('cannot open source directory');
Exemple #3
0
define('MAX_QUERY_ROWS', 100);
define('DEPLOY_LOG_FILE', 'import.log');
$rootDir = dirname(dirname(dirname(__FILE__))) . '/';
require $rootDir . 'Vic.php';
$debugMode = isset($_GET['debug']);
require_once 'Deployer.php';
$deployer = new Deployer();
$deployer->initLog($rootDir . 'var/log/' . DEPLOY_LOG_FILE);
require_once 'creds.php';
@(include_once 'credslocal.php');
// to override remote settings with the local ones
if ($debugMode) {
    echo "HOST: {$dbhost}.<br/>USER: {$dbUser}<br/>DBNAME: {$dbName}<br/>";
}
if ($deployer->initDb($dbhost, $dbUser, $dbPass, $dbName)) {
    $deployer->logMessage('DB init successful');
} else {
    $deployer->logMessage('DB init not successful');
    die;
}
$tableFields = array('sku', 'd_punlim', 'd_trocky', 'd_wpower', 'd_polaris', 'd_canam', 'd_fox', 'd_hhouse', 'd_honda', 'd_kawasaki', 'd_seadoo', 'd_suzuki', 'd_yamaha', 'd_troylee', 'd_oakley', 'd_motonation', 'd_leatt', 'd_bellhelm');
$sourceDir = $rootDir . 'var/import/pulliver/sku/source';
$files = array();
if ($handle = opendir($sourceDir)) {
    while ($file = readdir($handle)) {
        $pathinfo = pathinfo($file);
        if ('csv' == @$pathinfo['extension']) {
            $files[] = $file;
        }
    }
    closedir($handle);
Exemple #4
0
ini_set('memory_limit', '1024M');
ini_set('max_execution_time', '600');
set_time_limit(0);
define('DEPLOY_LOG_FILE', 'oem-import.log');
define('IMPORT_MODE_REMOVE', 1);
define('IMPORT_MODE_UPDATE', 2);
$currentDir = dirname(__FILE__);
$rootDir = dirname(dirname($currentDir)) . '/';
require $rootDir . 'Vic.php';
$sqlDump = isset($_GET['sqldump']) && $_GET['sqldump'];
require_once $currentDir . '/Deployer.php';
$deployer = new Deployer();
$deployer->initLog($rootDir . 'var/log/' . DEPLOY_LOG_FILE);
require_once $currentDir . '/creds.php';
if ($deployer->initDb($dbhost, $dbUser, $dbPass, $dbName)) {
    $deployer->logMessage('DB init successful');
} else {
    die('DB init not successful');
}
$files = array();
$importDir = $rootDir . 'var/import/pulliver/oem/';
if ($handle = opendir($importDir)) {
    while ($file = readdir($handle)) {
        $pathinfo = pathinfo($file);
        if ('csv' == @$pathinfo['extension'] && 0 === strpos($file, 'remove-')) {
            $files[] = $file;
        }
    }
    closedir($handle);
} else {
    die('cannot open source directory');