/**
* @return null
*/
public function setUp()
{
$this->runDbStartupTask();
$connector = DbRegistry::getConnector('af-tester');
$this->conn = $connector->getConnection();
$this->conn->connect();
$driver = $this->conn->getDriver();
$this->stmtDriver = $driver->stmt_init();
$this->stmt = new PreparedStmt($this->stmtDriver);
}
/**
* connect()
*/
public function connect($dsninfo, $flags = 0)
{
if (!($driver = Creole::getDriver($dsninfo['phptype']))) {
throw new SQLException("No driver has been registered to handle connection type: {$type}");
}
$connectionClass = Creole::import($driver);
$this->childConnection = new $connectionClass();
$this->log("connect(): DSN: " . var_export($dsninfo, true) . ", FLAGS: " . var_export($flags, true));
return $this->childConnection->connect($dsninfo, $flags);
}
public function testConnection()
{
$this->subject->disconnect();
$result = $this->subject->connect();
$this->assertTrue($result);
// Try a reconnect
$result = $this->subject->connect();
$this->assertTrue($result);
$result = $this->subject->isConnected();
$this->assertTrue($result);
$result = $this->subject->disconnect();
$this->assertTrue($result);
$result = $this->subject->isConnected();
$this->assertFalse($result);
}
public function setNewSport($cz)
{
$db = parent::connect();
$result = $db->prepare("INSERT INTO `sport`(`cz`) VALUES ( ? )");
$result->execute(array($cz));
return $db->lastInsertId();
}
public function getAllEntryForAuthor($author)
{
$result = parent::connect()->prepare("SELECT * FROM `entries` WHERE `author` = :id AND `active` = 1 ORDER BY `id` DESC");
$result->execute(array(':id' => $author));
$pageResult = $result->fetchAll();
return $pageResult;
}
protected function setUp()
{
$host = getenv('TEST_BEANSTALKD_HOST');
$port = getenv('TEST_BEANSTALKD_PORT');
if (!$host || !$port) {
$message = 'TEST_BEANSTALKD_HOST and/or TEST_BEANSTALKD_PORT env variables not defined.';
$this->markTestSkipped($message);
}
$connection = new Connection($host, $port, false);
if (!$connection->connect()) {
$message = "Need a running beanstalkd server at {$host}:{$port}.";
$this->markTestSkipped($message);
}
$this->subject = new Client($connection);
// Clear all jobs on the server
foreach ($this->subject->listTubes() as $tube) {
$this->subject->useTube($tube);
while ($job = $this->subject->peekReady()) {
$this->subject->delete($job['id']);
}
while ($job = $this->subject->peekBuried()) {
$this->subject->delete($job['id']);
}
}
$this->subject->useTube('default');
}
public function setNewImg($name, $size, $user, $type)
{
$db = parent::connect();
$timestamp = time();
$result = $db->prepare("INSERT INTO `profile_image`(`name`, `timestamp`, `size`, `user`, `type`) VALUES (?, ?, ?, ?, ?)");
$result->execute(array($name, $timestamp, $size, $user, $type));
}
function posicionaApps($conf_apps)
{
$colunas = explode('|', $conf_apps);
foreach ($colunas as $chave => $coluna) {
$apps = explode(',', $coluna);
// Carrega estrutura HTML auxiliar
if ($chave == 0) {
require_once 'assets/htmls_auxiliares/html_box-esquerdo.php';
}
if ($chave == 1) {
require_once 'assets/htmls_auxiliares/html_box-meio.php';
}
if ($chave == 2) {
require_once 'assets/htmls_auxiliares/html_box-direito.php';
}
// Carrega cada app separadamente
$connect = Connection::connect();
foreach ($apps as $app) {
if (!empty($app)) {
require 'apps/' . $app . '.php';
}
}
// Carrega estrutura HTML auxiliar
if ($chave == 0) {
require_once 'assets/htmls_auxiliares/html_fim_box-esquerdo.php';
}
if ($chave == 1) {
require_once 'assets/htmls_auxiliares/html_fim_box-meio.php';
}
if ($chave == 2) {
require_once 'assets/htmls_auxiliares/html_fim_box-direito.php';
}
}
}
private function tryMethod($method, $args)
{
try {
return call_user_func_array([$this->connection, $method], $args);
} catch (\Exception $exception) {
$e = $exception;
while ($e->getPrevious() && !$e instanceof \PDOException) {
$e = $e->getPrevious();
}
if ($e instanceof \PDOException && $e->errorInfo[1] == self::MYSQL_CONNECTION_TIMED_WAIT_CODE) {
$this->connection->close();
$this->connection->connect();
$this->logger->notice('Connection to MySQL lost, reconnect okay.');
return call_user_func_array([$this->connection, $method], $args);
}
if (false !== strpos($exception->getMessage(), 'MySQL server has gone away') || false !== strpos($exception->getMessage(), 'Error while sending QUERY packet') || false !== strpos($exception->getMessage(), 'errno=32 Broken pipe')) {
$this->connection->close();
$this->connection->connect();
$this->logger->notice('Connection to MySQL lost, reconnect okay.');
return call_user_func_array([$this->connection, $method], $args);
}
$this->logger->critical('Connection to MySQL lost, unable to reconnect.', ['exception' => $exception]);
throw $e;
}
}
function login($email, $password)
{
$mysqli = new Connection();
$db = $mysqli->connect();
//hash the password
$password = hashPassword($password);
//prepare the query
$query = $db->prepare("SELECT id FROM users WHERE email = ? AND password = ? LIMIT 1") or die("error");
$query->bind_param('ss', $email, $password);
//excuting
$query->execute();
//store results
$query->store_result();
//bind results
$query->bind_result($id);
$query->fetch();
//get the num rows
if ($query->num_rows == 1) {
$user_browser = $_SERVER['HTTP_USER_AGENT'];
session_start();
$_SESSION['login_string'] = array();
$_SESSION['login_string']['browserInfo'] = hash('sha512', $user_browser);
$_SESSION['login_string']['id'] = hash('sha512', $id);
return TRUE;
} else {
return FALSE;
}
//close the query
$db->close();
}
public function getDBContent($page)
{
$result = parent::connect()->prepare("SELECT * FROM `pages` WHERE `url_name` = :page LIMIT 1");
$result->execute(array(':page' => $page));
$pageResult = $result->fetch();
return $pageResult;
}
public static function getConnection()
{
if (!isset(self::$connect)) {
self::$connect = new Connection();
}
return self::$connect;
}
public static function run()
{
Connection::connect();
Session::start();
Router::run();
Connection::disconnect();
}
public function getNahravkaAll()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `nahravka` ORDER BY `id` DESC");
$result->execute(array());
$nahravka = $result->fetchAll();
return $nahravka;
}
public function getEnroll($event)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `enroll` WHERE event = ?");
$result->execute(array($event));
$event = $result->fetchAll();
return $event;
}
public function showAllFriendsEntries($authors)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `entry` WHERE `author` IN (?) ORDER BY `timestamp` DESC");
$result->execute(array(implode(", ", $authors)));
$entry = $result->fetchAll();
return $entry;
}
public function getKontaktAll()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `kontakt`");
$result->execute(array());
$kontakt = $result->fetchAll();
return $kontakt;
}
public function getEntriesForEntry($id)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `forum_entry` WHERE replyToEntryNum = ? AND active=1 ORDER BY `timestamp` DESC");
$result->execute(array($id));
$entries = $result->fetchAll();
return $entries;
}
public function getPopularItem()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `item` WHERE active=1 AND presentationImage!='' ORDER BY `prodanoObjednavek` DESC, `cenaSDPH` DESC LIMIT 9");
$result->execute(array());
$items = $result->fetchAll();
return $items;
}
public function getAllAkords()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `akord` ORDER BY `number` ASC");
$result->execute(array());
$akordy = $result->fetchAll();
return $akordy;
}
public function getAllItems()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `galerie` ORDER BY `likes` DESC, `timestamp` DESC");
$result->execute(array());
$items = $result->fetchAll();
return $items;
}
public function numOfComments($entry)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `comment_entry` WHERE `entry` = ? ORDER BY `timestamp` DESC");
$result->execute(array($entry));
$num = $result->rowCount();
return $num;
}
public function getPrihlasky($category)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `prihlasky` WHERE `kategorie` = ? ");
$result->execute(array($category));
$all = $result->fetchAll();
return $all;
}
public function getAllTrainingSport()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `training_sports`");
$result->execute(array());
$sport = $result->fetchAll();
return $sport;
}
public function getTitulek()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `titulek` limit 1");
$result->execute(array());
$titulek = $result->fetch();
return $titulek;
}
public function getDayInfo($user, $timestamp)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `intim_calendar` WHERE `user` = ? && (`date` >= ? && `date` < ?) ");
$result->execute(array($user, $timestamp, $timestamp + 86400));
$events = $result->fetch();
return $events;
}
public function getItemById($id)
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `store_Items` WHERE `id`=? ");
$result->execute(array($id));
$item = $result->fetch();
return $item;
}
public function getRealitiesOrderByPrice($level = 0, $order = 'DESC')
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `reality` WHERE (`level`<=? && `in_reality_store`=?) ORDER BY `price` {$order} ");
$result->execute(array($level, 1));
$items = $result->fetchAll();
return $items;
}
public function get3Clanek()
{
$db = parent::connect();
$result = $db->prepare("SELECT * FROM `clanek` ORDER BY `id` DESC limit 3");
$result->execute(array());
$clanek = $result->fetchAll();
return $clanek;
}
/**
* @return null
*/
public function testConnectClose()
{
$this->assertTrue($this->conn->connect());
$this->assertEquals('connected', $this->conn->getStatus());
$this->assertTrue($this->conn->isConnected());
$this->assertFalse($this->conn->isError());
$this->assertTrue($this->conn->close());
$this->assertEquals('closed', $this->conn->getStatus());
$this->assertFalse($this->conn->isDriver());
$this->assertFalse($this->conn->isConnected());
$this->assertFalse($this->conn->isError());
/* lets see if we can connect again */
$this->assertFalse($this->conn->connect());
$this->assertEquals('closed', $this->conn->getStatus());
$this->assertFalse($this->conn->isConnected());
$this->assertTrue($this->conn->isError());
}
