<?php // init logger $mylog = MyLog::singleton(MyLog::getLevel("ALL"), "test.log"); // define the autoloader to load classes from the lib folder function __autoload($className) { if (in_array($className, array("TestConfig", "SmintTestUtils"))) { $filename = dirname(__FILE__) . '/' . $className . '.php'; } else { $filename = dirname(__FILE__) . '/../../lib/' . $className . '.php'; } if (file_exists($filename)) { require $filename; } else { throw new Exception('Class "' . $className . '" could not be autoloaded. File not found: ' . $filename); } }
protected function queryJobsBySmintFileId() { // build select statement $select_columns = " id, started, finished, status, log "; $select_tables = " smafejob_addfile "; if (is_null($this->queryFileGUID)) { $select_where_clause = " external_key = :external_key "; } else { $select_where_clause = " guid = :guid "; } if ($this->collection != $this->apiConfig["databaseconstants"]["defaultCollection"]) { $select_where_clause = $select_where_clause . " AND collection_name = :collection_name "; } $sqlquery = "SELECT " . $select_columns . " FROM " . $select_tables . " WHERE " . $select_where_clause; $dbconnection = $this->dbconnection; // prepare statement $stmt = $dbconnection->prepare($sqlquery); // bind paramters if ($this->collection != $this->apiConfig["databaseconstants"]["defaultCollection"]) { $stmt->bindParam(':collection_name', $this->collection, PDO::PARAM_INT); } if (is_null($this->queryFileGUID)) { $stmt->bindParam(':external_key', $this->queryFileExternal_Key, PDO::PARAM_STR); } else { $stmt->bindParam(':guid', $this->queryFileGUID, PDO::PARAM_STR); } $querysuccess = $stmt->execute(); if ($querysuccess) { // fetch the results $result = $stmt->fetchAll(); // log debug message MyLog::printWithDuration("Query Database with SQL: {$sqlquery} CollectionId:{$this->collection} GUID: {$this->queryFileGUID} ext_key: {$this->queryFileExternal_Key}", MyLog::getLevel("DEBUG")); } else { $this->errorMessage = implode(", ", $stmt->errorInfo()) . " querytrackid: {$this->queryFileId} externalTrackid: {$this->queryFileExternal_Key} queryTrackguid: {$this->queryFileGUID}"; $result = null; } return $result; }