/**
* Tests creating the table.
*
* @covers empire\framework\mvc\model\DbStorageModel::create
*/
public function testCreate()
{
$this->instance->create();
$this->assertTrue(self::$db->tableExists('mod_mock_testdbstorage'));
$tables = self::$db->getFieldNames('mod_mock_testdbstorage');
$this->assertContains('name', $tables);
$this->assertContains('length', $tables);
}
/**
* Creates the table.
*/
private function createTable()
{
$table = new Table($this->table);
$table->addField(new Field('role', new Type(Field::TYPE_VARCHAR, 255), '', false, false));
$table->addField(new Field('page', new Type(Field::TYPE_VARCHAR, 255), '', false, false));
$table->addField(new Field('task', new Type(Field::TYPE_VARCHAR, 255), '', false, false));
$table->setPrimaryKey(new PrimaryKey($this->table, array('role', 'page', 'task')));
$this->db->createTable($table);
}
/**
* Creates the table.
*
* @param string $name the table name
*/
private function createTable($name)
{
$table = new Table($name);
$table->addField(new Field('idx', Field::TYPE_INT, '', false, true));
$table->addField(new Field('id', new Type(Field::TYPE_VARCHAR, 32), '', false, false));
$table->addField(new Field('role', Field::TYPE_TEXT, '', false, false));
$table->setPrimaryKey(new PrimaryKey($name, array('idx')));
$this->db->createTable($table);
}
private function getEntireSize()
{
if ($this->db->tableExists($this->tableName)) {
$query = 'SELECT count(id) AS numberOfEntries FROM :::table';
$bindings = array(':::table' => $this->tableName);
$res = $this->db->fetch($query, $bindings);
return (int) $res[0]['numberOfEntries'];
}
return 0;
}
/**
* Creates the table.
*
* @param string $name the table name
*/
private function createTable()
{
$name = $this->table;
$table = new Table($name, '');
$table->addField(new Field('idx', new Type(Field::TYPE_VARCHAR, 255), '', false, false));
$table->addField(new Field('data', new Type(Field::TYPE_BLOB), '', false, false));
if ($this->useTimestamps) {
$table->addField(new Field('ts', new Type(Field::TYPE_INT, 10), '', false, false));
}
$table->setPrimaryKey(new PrimaryKey($name, array('idx')));
$this->db->createTable($table);
}
/**
* Tests removing the storage.
*
* @covers empire\framework\authorization\rolebased\DbRoleStorage::remove
*/
public function testRemove()
{
$this->instance->addRole('peterchen', 'editor');
$this->instance->addRole('fritzchen', 'editor');
$this->instance->addRole('fritzchen', 'admin');
$this->instance->addRole('fritzchen', 'reader');
$this->instance->addRole('hänschen', 'reader');
$this->instance->remove();
$this->assertEmpty($this->instance->getRoles('fritzchen'));
$this->assertEmpty($this->instance->getRoles('peterchen'));
$this->assertEmpty($this->instance->getRoles('hänschen'));
$this->assertFalse($this->db->tableExists(self::TABLE));
}
/**
* Creates the table.
*
* @param string $name the table name
*/
private function createTable($name)
{
$table = new Table($name);
$table->addField(new Field('id', new Type(Field::TYPE_VARCHAR, 32), '', false, false));
$table->addField(new Field('username', new Type(Field::TYPE_VARCHAR, 255), null, true, false));
$table->addField(new Field('fullName', Field::TYPE_TEXT, null, true, false));
$table->addField(new Field('email', new Type(Field::TYPE_VARCHAR, 255), null, true, false));
$table->addField(new Field('birthdate', Field::TYPE_DATE, null, true, false));
$table->addField(new Field('gender', new Type(Field::TYPE_VARCHAR, 255), '', true, false));
$table->addField(new Field('timezoneOffset', new Type(Field::TYPE_SMALLINT, 4), 0, false, false));
$table->addField(new Field('locale', new Type(Field::TYPE_VARCHAR, 10), 'en-US', false, false));
$table->addField(new Field('lastLogin', new Type(Field::TYPE_INT, 12), -1, false, false));
$table->addField(new Field('secret', Field::TYPE_TEXT, '', false, false));
$table->setPrimaryKey(new PrimaryKey($name, array('id')));
$table->addIndex(new Index('username', $name, true, array('username')));
$table->addIndex(new Index('email', $name, true, array('email')));
$this->db->createTable($table);
}
public function tearDown()
{
if ($this->db->databaseExists(self::DB_ID)) {
$this->db->dropDatabase(self::DB_ID);
}
}
/**
* Tests whether a DB object can be constructed from a DSN string using the connection objects
* provided by the <code>setUpBeforeClass()</code> method.
*
* @covers empire\framework\db\DB::constructFromDSN
*/
public function testConstructFromDSN()
{
foreach (self::$connections as $connection) {
$dsn = $connection->getDSN();
$db = DB::constructFromDSN($dsn);
$this->assertInstanceOf('empire\\framework\\db\\DB', $db);
}
}
