/** * 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);