/**
* Set up test configuration
*
* @return void
*/
public function setUp()
{
$this->_db = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => TESTS_ZEND_AUTH_ADAPTER_DBTABLE_PDO_SQLITE_DATABASE));
$sqlCreate = 'CREATE TABLE [users] ( ' . '[id] INTEGER NOT NULL PRIMARY KEY, ' . '[username] VARCHAR(50) UNIQUE NOT NULL, ' . '[password] VARCHAR(32) NULL, ' . '[real_name] VARCHAR(150) NULL)';
$this->_db->query($sqlCreate);
$sqlInsert = 'INSERT INTO users (username, password, real_name) ' . 'VALUES ("my_username", "my_password", "My Real Name")';
$this->_db->query($sqlInsert);
$this->_adapter = new Zend_Auth_Adapter_DbTable($this->_db, 'users', 'username', 'password');
}
protected function _setupDbAdapter($optionalParams = array())
{
$params = array('dbname' => TESTS_ZEND_AUTH_ADAPTER_DBTABLE_PDO_SQLITE_DATABASE);
if (!empty($optionalParams)) {
$params['options'] = $optionalParams;
}
$this->_db = new Zend_Db_Adapter_Pdo_Sqlite($params);
$sqlCreate = 'CREATE TABLE [users] ( ' . '[id] INTEGER NOT NULL PRIMARY KEY, ' . '[username] VARCHAR(50) NOT NULL, ' . '[password] VARCHAR(32) NULL, ' . '[real_name] VARCHAR(150) NULL)';
$this->_db->query($sqlCreate);
$sqlInsert = 'INSERT INTO users (username, password, real_name) ' . 'VALUES ("my_username", "my_password", "My Real Name")';
$this->_db->query($sqlInsert);
}
function deleteUser($user)
{
// Crée une connexion de base de données SQLite en mémoire
require_once 'Zend/Db/Adapter/Pdo/Sqlite.php';
$dbAdapter = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => 'logins'));
// Construit la requête pour insérer une ligne pour laquelle
// l'authentification pourra réussir
$sqlInsert = 'DELETE FROM logins WHERE login="******"';
// Insertion des données
$dbAdapter->query($sqlInsert);
echo "done";
}
function addUser($user, $pwd)
{
// Crée une connexion de base de données SQLite en mémoire
require_once 'Zend/Db/Adapter/Pdo/Sqlite.php';
$dbAdapter = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => 'logins'));
// Construit la requête pour insérer une ligne pour laquelle
// l'authentification pourra réussir
$sqlInsert = 'INSERT INTO logins (login, password) values ("' . $user . '", "' . substr(crypt($pwd, '$6$$'), 4) . '")';
// Insertion des données
$dbAdapter->query($sqlInsert);
echo "done";
}
/**
* Ensures expected behavior for for authentication failure
* reason: Identity not found.
*
*/
public function testAuthenticateFailureIdentityAmbigious()
{
$sql_insert = 'INSERT INTO users (username, password, real_name) VALUES ("my_username", "my_password", "My Real Name")';
$this->_db->query($sql_insert);
$this->_adapter->setIdentity('my_username');
$this->_adapter->setCredential('my_password');
try {
$result = $this->_adapter->authenticate();
$this->assertEquals($result->getCode(), Zend_Auth_Result::FAILURE_IDENTITY_AMBIGUOUS);
} catch (Zend_Auth_Exception $e) {
$this->fail('Exception should have been thrown');
}
}
/**
*
* @see Spizer_Logger_Interface::__construct()
*/
public function __construct($config = array())
{
if (!extension_loaded('pdo_sqlite')) {
require_once 'Spizer/Logger/Exception.php';
throw new Spizer_Logger_Exception("The PDO_SQLITE extension is required in order to use the Sqlite logger");
}
if (!isset($config['dbfile'])) {
require_once 'Spizer/Logger/Exception.php';
throw new Spizer_Logger_Exception("The Sqlite logger requires a real DB output file to be set");
}
// Instantiate the adapter
$this->_db = Zend_Db::factory('PDO_SQLITE', array('dbname' => $config['dbfile']));
// Set up the database and tables
if (!(isset($config['append']) && $config['append'])) {
$this->_db->query("DROP TABLE IF EXISTS requests");
$this->_db->query("DROP TABLE IF EXISTS request_headers");
$this->_db->query("DROP TABLE IF EXISTS responses");
$this->_db->query("DROP TABLE IF EXISTS response_headers");
$this->_db->query("DROP TABLE IF EXISTS messages");
}
$this->_db->query("CREATE TABLE IF NOT EXISTS requests(\n \t\t\t\t\tid INTEGER NOT NULL PRIMARY KEY, \n \t\t\t\t\tmicrotime REAL NOT NULL, \n \t\t\t\t\turl TEXT NOT NULL,\n \t\t\t\t\treferrer TEXT, \n \t\t\t\t\tmethod VARCHAR(10) NOT NULL)");
$this->_db->query("CREATE TABLE IF NOT EXISTS request_headers(\n \t\t\t\t\tid INTEGER NOT NULL PRIMARY KEY, \n \t\t\t\t\trequest_id INTEGER NOT NULL, \n \t\t\t\t\theader VARCHAR(50) NOT NULL, \n \t\t\t\t\tvalue TEXT)");
$this->_db->query("CREATE TABLE IF NOT EXISTS responses(\n \t\t\t\t\tid INTEGER NOT NULL PRIMARY KEY, \n \t\t\t\t\trequest_id INTEGER NOT NULL, \n \t\t\t\t\tmicrotime REAL NOT NULL, \n \t\t\t\t\tstatuscode INTEGER NOT NULL, \n \t\t\t\t\tmessage VARCHAR(30) NOT NULL)");
$this->_db->query("CREATE TABLE IF NOT EXISTS response_headers(\n \t\t\t\t\tid INTEGER NOT NULL PRIMARY KEY, \n \t\t\t\t\trequest_id INTEGER NOT NULL, \n \t\t\t\t\theader VARCHAR(50) NOT NULL, \n \t\t\t\t\tvalue TEXT)");
$this->_db->query("CREATE TABLE IF NOT EXISTS messages(\n \t\t\t\t\tid INTEGER NOT NULL PRIMARY KEY, \n \t\t\t\t\trequest_id INTEGER NOT NULL, \n \t\t\t\t\thandler VARCHAR(30) NOT NULL, \n \t\t\t\t\tkey VARCHAR(30) NOT NULL, \n \t\t\t\t\tvalue TEXT)");
}
<?php
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
// Crée une connexion de base de données SQLite en mémoire
require_once 'Zend/Db/Adapter/Pdo/Sqlite.php';
$dbAdapter = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => 'logins'));
// Construit une requête de création de table
$sqlCreate = 'CREATE TABLE [logins] ( ' . '[login] VARCHAR(10) NOT NULL PRIMARY KEY, ' . '[password] CHAR(128) NULL)';
// Crée la table de crédits d'authentification
$dbAdapter->query($sqlCreate);
// Construit la requête pour insérer une ligne pour laquelle
// l'authentification pourra réussir
$sqlInsert = 'INSERT INTO logins (login, password) ' . 'VALUES ("mosioj", "MdB3G8Ym1rKNhS8mD8fTXhRu2tWlHH5A406Lg5jaI5i.eQbgpk8Z3B5boV3I1QjEUjCpxmyxsMsvkQrr3WOyQ/")';
// Insertion des données
$dbAdapter->query($sqlInsert);
$sqlInsert = 'INSERT INTO logins (login, password) ' . 'VALUES ("lauramosio", "W0.k8vp2N4eMX74PhkNpeEn/uSoTiPSENEY3FvcSS0BJNGh2KWpmREb33MmexrBblSVpoOzLAdUM6BUgSE.l80")';
// Insertion des données
$dbAdapter->query($sqlInsert);
