<?php /** * SET FOREIGN_KEY_CHECKS=0; TRUNCATE team; TRUNCATE player; */ require_once 'vendor/autoload.php'; use Subash\Classes\CSVFile; use Subash\Classes\Teams; use Subash\Classes\Player; use Subash\Classes\UploadFileLog; while (true) { logme("polling"); $objFileLog = new UploadFileLog(); $isQueuedItem = $objFileLog->getQueuedItem('PLD'); if (count($isQueuedItem) > 0) { $objTeam = new Teams(); $teams = $objTeam->getTeamIds(); print_r($teams); $objPlayer = new Player(); $players = $objPlayer->getPlayerIds(); $filePath = $isQueuedItem['filename']; $uploadId = $isQueuedItem['id']; $fileObject = new CSVFile(__DIR__ . "/" . $filePath, true, ',', '"', '\\', true); $insertArray = []; $indexCount = 1; $fileObject->seek(PHP_INT_MAX); $totalCount = $fileObject->key(); $fileObject->seek(0); $proccessed = 0;
<?php /** * SET FOREIGN_KEY_CHECKS=0; TRUNCATE team; TRUNCATE player; */ require_once 'vendor/autoload.php'; use Subash\Classes\CSVFile; use Subash\Classes\Teams; use Subash\Classes\Player; use Subash\Classes\UploadFileLog; while (true) { logme("polling"); $objFileLog = new UploadFileLog(); $isQueuedItem = $objFileLog->getQueuedItem('FX'); if (count($isQueuedItem) > 0) { $objTeam = new Teams(); $teams = $objTeam->getTeamIds(); //print_r ( $teams ); $filePath = $isQueuedItem['filename']; $uploadId = $isQueuedItem['id']; $fileObject = new CSVFile(__DIR__ . "/" . $filePath, true, ',', '"', '\\', true); $insertArray = []; $indexCount = 1; $fileObject->seek(PHP_INT_MAX); $totalCount = $fileObject->key(); $fileObject->seek(0); $proccessed = 0; $objFileLog->startProcessing($uploadId, $totalCount, 'IP'); logme("Start Processing on " . date('Y-M-d H:i:s'));