public function testObtener() { $autorization = sprintf("BASIC + window.btoa(%s + :xxx)", "asdasdasdas"); $options = array('body' => array(), 'config' => array(), 'headers' => array()); $project = new CategoryProject(); $project->__set("apiKey", "cat952yellow"); //var_dump($project -> __get("response")); $project->obtener(); $response = $project->__get("response"); error_log(print_r($response['body'], true)); $this->assertTrue($response['status'] == 'exito'); }
$log = new Logger(basename(__FILE__, ".php")); $log->pushHandler(new StreamHandler(dirname(dirname(__FILE__)) . '/logs/your.log', Logger::DEBUG)); /* $log->pushProcessor(function ($record) { $record['extra']['dummy'] = 'Hello world!'; return $record; }); * */ // add records to the log $log->info('Inicializando proceso ', array("linea " => __LINE__)); $pdo = new \Slim\PDO\Database(DSN_, USR_, PASSWD_); $compania = new CategoryProject(); $compania->__set("apiKey", APIKEY_); $compania->obtener(); $response = $compania->__get("response"); if ($response['status'] == 'exito') { if (count($response["body"]) > 0) { foreach ($response["body"] as $key => $obj) { $log->info(print_r($obj, true)); /* $insertStatement = $pdo->insert(array('id', 'name', 'industry', 'website', 'country', 'countrycode', 'cid', 'tagid','parent_type','parentid')) ->into('lkp_companies') ->values(array($obj -> id ,$obj -> name, $obj -> industry,$obj -> website , $obj -> country,$obj -> countrycode, $obj -> cid, 123, 'lkp_companies', $obj -> id )); $insertId = $insertStatement->execute(); * */ } } else {
public function obtener() { try { $compania = new CategoryProject(); $compania->__set("apiKey", APIKEY_); $this->log->addInfo("Inicio flujo de CategoryProject", array(basename(__FILE__) . "::" . __LINE__)); $compania->obtener(); $response = $compania->__get("response"); if ($response['status'] == "exito" && count($response['body']) > 0) { $this->log->addInfo("Respuesta de api exitosa", array(basename(__FILE__) . "::" . __LINE__)); $values = array(); $pdo = new \Slim\PDO\Database(BD_DNS_, BD_USER_, BD_PWD_); //Conexion::getInstance(); foreach ($response['body'] as $key => $value) { $keys = array(); $insertValue = array(); foreach ($value as $keyB => $valueB) { array_push($keys, $keyB); array_push($insertValue, empty($valueB) || $valueB == '' ? 0 : $valueB); } $this->log->addInfo(print_r($keys, true), array(basename(__FILE__) . "::" . __LINE__)); $this->log->addInfo(print_r($insertValue, true), array(basename(__FILE__) . "::" . __LINE__)); $insertStatement = $pdo->insert($keys)->into('lkp_categories')->values($insertValue); $insertId = $insertStatement->execute(); } } else { $this->log->addInfo("Sin recursos encontrados", array(basename(__FILE__) . "::" . __LINE__)); } } catch (Exception $e) { $this->log->addInfo("Error de BD", array(basename(__FILE__) . "::" . __LINE__)); $this->log->addInfo($e->getMessage(), array(basename(__FILE__) . "::" . __LINE__)); } }