public function testCreate()
{
$dbInstance = \Magento\TestFramework\Helper\Bootstrap::getInstance()->getBootstrap()->getApplication()->getDbInstance();
$dbConfig = ['host' => $dbInstance->getHost(), 'username' => $dbInstance->getUser(), 'password' => $dbInstance->getPassword(), 'dbname' => $dbInstance->getSchema(), 'active' => true];
$connection = $this->model->create($dbConfig);
$this->assertInstanceOf('\\Magento\\Framework\\DB\\Adapter\\AdapterInterface', $connection);
}
public function testFunctional()
{
$pdo = $this->factory->getConnection();
$this->assertInstanceOf('PDO', $pdo);
$pdo->exec("CREATE TABLE `foo`(`id` int,`name` varchar)");
$pdo->exec("insert into `foo` VALUES (1,'foo')");
$repo = new FooRepository($this->factory);
$entity = $repo->getById(1);
$expected = new FooEntity();
$expected->id = 1;
$expected->name = 'foo';
$this->assertEquals($expected, $entity);
}
public function dispatch()
{
$connection = ConnectionFactory::getDataConnection();
$bookmarks = $connection->getBookmarks();
$template = new BookmarksTemplate($bookmarks, "Bookmarks");
$template->showTemplate();
}
/**
* @param int $userId
* @param Captions $captions
* @return array
*/
public function GetUserGrants($userId, Captions $captions)
{
$queryBuilder = new SelectCommand($this->connectionFactory->CreateEngCommandImp());
$queryBuilder->AddField($this->usersTable, $this->users_UserId, FieldType::Number, 'users_user_id');
$queryBuilder->AddField($this->usersTable, $this->users_UserName, FieldType::String, 'users_user_name');
$queryBuilder->AddField($this->userPermsTable, $this->userPerms_UserId, FieldType::Number, 'userperms_user_id');
$queryBuilder->AddField($this->userPermsTable, $this->userPerms_PageName, FieldType::String, 'userperms_pagename');
$queryBuilder->AddField($this->userPermsTable, $this->userPerms_Grant, FieldType::String, 'userperms_grant');
$queryBuilder->SetSourceTableName($this->userPermsTable);
$queryBuilder->AddJoin(JoinKind::LeftOuter, $this->usersTable, 'userperms_user_id', $this->users_UserId);
$queryBuilder->AddFieldFilter('userperms_user_id', new FieldFilter($userId, '='));
$dataset = new QueryDataset($this->connectionFactory, $this->connectionOptions, $queryBuilder->GetSQL(), array(), array(), array(), 'user_grants');
$dataset->AddField(new StringField('userperms_grant'), false);
$dataset->AddField(new StringField('userperms_pagename'), false);
$dataset->Open();
$pages = array();
$pages[''] = array('name' => '', 'caption' => $captions->GetMessageString('Application'), 'selectGrant' => false, 'updateGrant' => false, 'insertGrant' => false, 'deleteGrant' => false, 'adminGrant' => false);
foreach ($this->tableCaptions as $name => $caption) {
$pages[$name] = array('name' => $name, 'caption' => $captions->RenderText($caption), 'selectGrant' => false, 'updateGrant' => false, 'insertGrant' => false, 'deleteGrant' => false, 'adminGrant' => false);
}
while ($dataset->Next()) {
$grant = $dataset->GetFieldValueByName('userperms_grant');
$pageName = $dataset->GetFieldValueByName('userperms_pagename');
if (isset($pages[$pageName])) {
$pages[$pageName]['selectGrant'] = $pages[$pageName]['selectGrant'] || StringUtils::SameText($grant, 'select');
$pages[$pageName]['updateGrant'] = $pages[$pageName]['updateGrant'] || StringUtils::SameText($grant, 'update');
$pages[$pageName]['insertGrant'] = $pages[$pageName]['insertGrant'] || StringUtils::SameText($grant, 'insert');
$pages[$pageName]['deleteGrant'] = $pages[$pageName]['deleteGrant'] || StringUtils::SameText($grant, 'delete');
$pages[$pageName]['adminGrant'] = $pages[$pageName]['adminGrant'] || StringUtils::SameText($grant, 'admin');
}
}
$dataset->Close();
return array_values($pages);
}
public static function getConnection()
{
if (is_null(self::$conn)) {
self::$conn = new PDO(self::$tipo . ':host=' . self::$host . ';dbname=' . self::$db, self::$usuario, self::$senha, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET Names UTF8'));
}
return self::$conn;
}
public function check()
{
$this->setView('reclaim/index');
if (Session::isLoggedIn()) {
return Error::set('You\'re logged in!');
}
$this->view['valid'] = true;
$this->view['publicKey'] = Config::get('recaptcha:publicKey');
if (empty($_POST['recaptcha_challenge_field']) || empty($_POST['recaptcha_response_field'])) {
return Error::set('We could not find the captcha validation fields!');
}
$recaptcha = Recaptcha::check($_POST['recaptcha_challenge_field'], $_POST['recaptcha_response_field']);
if (is_string($recaptcha)) {
return Error::set(Recaptcha::$errors[$recaptcha]);
}
if (empty($_POST['username']) || empty($_POST['password'])) {
return Error::set('All forms are required.');
}
$reclaims = new reclaims(ConnectionFactory::get('mongo'));
$good = $reclaims->authenticate($_POST['username'], $_POST['password']);
if (!$good) {
return Error::set('Invalid username/password.');
}
$reclaims->import($_POST['username'], $_POST['password']);
$users = new users(ConnectionFactory::get('mongo'));
$users->authenticate($_POST['username'], $_POST['password']);
header('Location: ' . Url::format('/'));
}
public static function handler($data = null)
{
if (isset($_SESSION['done_autoauth'])) {
return;
}
if (empty($_SERVER['SSL_CLIENT_RAW_CERT'])) {
return self::done();
}
if (Session::isLoggedIn()) {
return self::done();
}
$certs = new certs(ConnectionFactory::get('mongo'), ConnectionFactory::get('redis'));
$userId = $certs->check($_SERVER['SSL_CLIENT_RAW_CERT']);
if ($userId == NULL) {
return self::done();
}
$users = new users(ConnectionFactory::get('mongo'));
$user = $users->get($userId, false);
if (empty($user)) {
return;
}
if (!in_array('autoauth', $user['auths'])) {
return self::done();
}
if ($user['status'] == users::ACCT_LOCKED) {
return self::done();
}
Session::setBatchVars($user);
return self::done();
}
private static function getModel()
{
if (empty(self::$missions)) {
self::$missions = new missions(ConnectionFactory::get('mongo'));
}
return self::$missions;
}
public function basic($arguments)
{
$missions = new missions(ConnectionFactory::get('mongo'));
if (!empty($arguments[0])) {
// A specific mission has been requested.
$mission = $missions->get('basic', intval($arguments[0]));
if (empty($mission)) {
return Error::set('Mission does not exist.');
}
$this->view['valid'] = true;
$this->view['num'] = $arguments[0];
$this->view['basic'] = new BasicMissions();
$this->view['name'] = $mission['name'];
$this->view['next'] = $arguments[0] != 6;
$good = call_user_func(array($this->view['basic'], 'validateMission' . $this->view['num']));
if ($good !== null) {
// BALANCED. TERNARY.
if (!$good) {
return Error::set('Wrong!');
}
$this->view['valid'] = false;
$this->view['good'] = true;
}
} else {
// Just show a listing of possible missions.
$this->view['valid'] = true;
$this->view['missions'] = $missions->getMissionsByType('basic');
$this->setView('missions/base');
}
}
public function index($arguments)
{
$news = new news(ConnectionFactory::get('mongo'));
$articles = new articles(ConnectionFactory::get('mongo'));
$notices = new notices(ConnectionFactory::get('redis'));
$irc = new irc(ConnectionFactory::get('redis'));
$quotes = new quotes(ConnectionFactory::get('mongo'));
$forums = new forums(ConnectionFactory::get('redis'));
// Set all site-wide notices.
foreach ($notices->getAll() as $notice) {
Error::set($notice, true);
}
// Fetch the easy data.
$this->view['news'] = $news->getNewPosts();
$this->view['shortNews'] = $news->getNewPosts(true);
$this->view['newArticles'] = $articles->getNewPosts('new', 1, 5);
$this->view['ircOnline'] = $irc->getOnline();
$this->view['randomQuote'] = $quotes->getRandom();
$this->view['fPosts'] = $forums->getNew();
// Get online users.
$apc = new APCIterator('user', '/' . Cache::PREFIX . 'user_.*/');
$this->view['onlineUsers'] = array();
while ($apc->valid()) {
$current = $apc->current();
array_push($this->view['onlineUsers'], substr($current['key'], strlen(Cache::PREFIX) + 5));
$apc->next();
}
// Set title.
Layout::set('title', 'Home');
}
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new ConnectionFactory();
}
return self::$instance;
}
public function CheckUsernameAndPassword($username, $password, &$errorMessage)
{
$this->connectionOptions['username'] = $username;
$this->connectionOptions['password'] = $password;
$connection = $this->connectionFactory->CreateConnection($this->connectionOptions);
$connection->Connect();
if ($connection->Connected()) {
$errorMessage = null;
$connection->Disconnect();
return true;
} else {
$errorMessage = $connection->LastError();
//'The username/password combination you entered was invalid.';
return false;
}
}
/**
* Retrieve favourite sites and fill data in template.
*/
private function parseFavouriteSites($template)
{
try {
$connection = ConnectionFactory::getDataConnection();
$favourites = $connection->getWebsiteFavourites();
foreach ($favourites as $id => $favourite) {
$name = $favourite->getName();
$link = SERVER_HOST_AND_PATH . "php/scraper" . $favourite->getLink();
switch ($favourite->getType()) {
case "movie":
$template->setFavouriteMovieWebsite(array($name, $link));
break;
case "serie":
$template->setFavouriteSerieWebsite(array($name, $link));
break;
case "documentary":
$template->setFavouriteDocumentaryWebsite(array($name, $link));
break;
case "anime":
$template->setFavouriteAnimeWebsite(array($name, $link));
break;
}
}
} catch (Exception $e) {
//Ignored exception
}
}
/**
* Searches for the configuration for the connection and creates it. If the configuration is not found then it will
* return NULL
*
* @param string $name
* @return null|\PDO
*/
protected function createConnection($name)
{
if (!isset($this->config[$name]['pdo'])) {
return null;
}
return ConnectionFactory::factory($this->config[$name]['pdo']);
}
public static function transactionIdExists($transaction_id)
{
$conditions = array();
$conditions['transaction_id'] = $transaction_id;
$success = ConnectionFactory::SelectValue("transaction_id", "diamond_purchased_history", $conditions);
return $success;
}
public static function getFactory()
{
if (!self::$factory) {
self::$factory = new ConnectionFactory();
}
return self::$factory;
}
public function queryAllSelect()
{
$sql = "SELECT id_area, nome FROM {$this->table}";
$stmt = ConnectionFactory::prepare($sql);
$stmt->execute();
return $stmt->fetchAll();
}
/**
* Retorna um objeto da classe ConnectionFactory
* @return ConnectionFactory object
*/
public static function getInstance()
{
if (!isset(self::$instance)) {
$c = __CLASS__;
self::$instance = new $c();
}
return self::$instance;
}
/**
* atualiza um registro da tabela
*
* @parametro TematicaMySql tematica
*/
public function update(Log $log)
{
$sql = "UPDATE {$this->table} SET tabela = :tabela, acao = :acao, descricao=:descricao WHERE id_log = :id";
$id = $log->getIdLog();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id_log', $id);
return $stmt->execute();
}
public function queryAllAreaAvaliador($id)
{
$sql = "SELECT aa.fk_area as area FROM area a JOIN avaliador_area aa ON a.id_area = aa.fk_area AND fk_avaliador = :id";
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$stmt->execute();
return $stmt->fetch();
}
public function getJsonResponse($cidade, $bairro, $rua)
{
$this->connection = ConnectionFactory::getInstance()->createConnection(false);
$locEspecificaBI = new LocEspecificaBI($this->connection);
$jsonResponse = $locEspecificaBI->getJsonResponse($cidade, $bairro, $rua);
$locEspecificaBI->releaseConnection($this->connection);
return $jsonResponse;
}
public function getJsonResponse($lat, $long, $distance)
{
$this->connection = ConnectionFactory::getInstance()->createConnection(false);
$posicaoAtualBI = new PosicaoAtualBI($this->connection);
$jsonResponse = $posicaoAtualBI->createJSONResponse($lat, $long, $distance);
$posicaoAtualBI->releaseConnection($this->connection);
return $jsonResponse;
}
/**
* atualiza um registro da tabela
*
* @parametro UsuarioPermissaoMySql usuarioPermissao
*/
public function update(UsuarioPermissao $UsuarioPermissao)
{
$sql = "UPDATE {$this->table} SET WHERE fk_usuario = :id";
$id = $UsuarioPermissao->getFkUsuario();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id);
return $stmt->execute();
}
public static function listTasks()
{
$db = ConnectionFactory::getDB();
$tasks = array();
foreach ($db->tasks() as $task) {
//vai para o banco de dados dentro da tabela tasks
$tasks[] = array('id' => $task['id'], 'description' => $task['description'], 'done' => $task['done']);
}
}
public static function delete($id)
{
$db = ConnectionFactory::getDB();
$task = $db->tasks[$id];
if ($task) {
$task->delete();
return true;
}
return false;
}
public function index()
{
$lectures = new lectures(ConnectionFactory::get('mongo'));
$this->view['lectures'] = $lectures->getNew();
if (is_string($this->view['lectures'])) {
return Error::set($this->view['lectures']);
}
$this->view['valid'] = true;
Layout::set('title', 'Lectures');
}
/**
* atualiza um registro da tabela
*
* @parametro CategoriaMySql categoria
*/
public function update(Categoria $Categoria)
{
$sql = "UPDATE {$this->table} SET nome = :nome WHERE id_categoria = :id";
$id = $Categoria->getIdCategoria();
$nome = $Categoria->getNome();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id);
$stmt->bindParam(':nome', $nome);
return $stmt->execute();
}
public static function delete($id)
{
$db = ConnectionFactory::getDB();
$cart = $db->carts[$id];
if ($cart) {
$cart->delete();
return true;
}
return false;
}
/**
* atualiza um registro da tabela
*
* @parametro PermissaoMySql permissao
*/
public function update(Permissao $Permissao)
{
$sql = "UPDATE {$this->table} SET nome_permissao = :nome_permissao WHERE id_permissao = :id";
$id = $Permissao->getIdPermissao();
$nomePermissao = $Permissao->getNomePermissao();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id);
$stmt->bindParam(':nomePermissao', $nomePermissao);
return $stmt->execute();
}
public static function delete($id)
{
$db = ConnectionFactory::getDB();
$guest = $db->guests[$id];
if ($guest) {
$guest->delete();
return true;
}
return false;
}
