private static function init_test_tables() { $adapter = new \common\adapters\MysqlAdapter(''); $sql = ' CREATE TABLE IF NOT EXISTS tests_table ( `id` serial primary key , `field1` varchar(255) not null default "" , `field2` bigint not null default 0 , `field3` enum("val1", "val2", "val3") default "val1" ) '; $adapter->execute($sql); $sql = ' CREATE TABLE IF NOT EXISTS tests_table2 ( `id` serial primary key , `field1` varchar(255) not null default "" , `field2` bigint not null default 0 , `field3` enum("val1", "val2", "val3") default "val1" ) '; $adapter->execute($sql); $roles = [User::credentials_admin, User::credentials_admin, User::credentials_admin, User::credentials_user, User::credentials_user, User::credentials_user, User::credentials_super_admin, User::credentials_super_admin, User::credentials_super_admin]; /** * @var $user User */ $user = Application::get_class(User::class); $mapper = $user->get_mapper(); for ($i = 0; $i < 9; $i++) { $mapper->save(new \User\models\UserModel(['login' => uniqid('test', true), 'credentials' => $roles[$i]])); } }
private function init_db() { if (defined('TESTS_ENV') || Application::is_dev()) { $adapter = new \common\adapters\MysqlAdapter(''); $sql = 'SHOW TABLES'; $tables = ['users', 'session', 'templates']; if (count(array_intersect($adapter->execute($sql)->get_arrays(), $tables)) < count($tables)) { $sql = file_get_contents(ROOT_PATH . DS . 'resource' . DS . 'initialize.sql'); $adapter->execute($sql); } } }
/** * @covers User\mappers\UserMapper::find_by_id */ public function test_find_by_id() { $adapter = new \common\adapters\MysqlAdapter('users'); $id = $adapter->select(['id'])->where(['deleted' => ['=', 0]])->limit(1)->execute()->get_result(); self::assertTrue($this->mapper->find_by_id($id)->id > 0); }