/** * Sets up the fixture, for example, open a network connection. * This method is called before a test is executed. */ protected function setUp() { parent::setUp(); $this->connection = Connection::get(); $this->userBook = new UserBook($this->connection); $this->providerInfoBook = new ProviderInfoBook($this->connection); $this->providerUserBook = new ProviderUserBook($this->connection); foreach ($this->providerInfoBook->get() as $providerInfo) { $this->providerInfoBook->delete($providerInfo); } foreach ($this->userBook->get() as $user) { $this->userBook->delete($user); } for ($k = 0; $k < 10; $k++) { $user = new User(); $user->setEnabled(RandomBook::getRandomBoolean())->setEnabledDate(RandomBook::getRandomDate())->setAccessFailedCount(rand(1, 5))->setEmail(RandomBook::getRandomEmail())->setPassword(RandomBook::getRandomString())->setPhoneNumber(RandomBook::getRandomPhoneNumber())->setTwoFactorEnabled(RandomBook::getRandomBoolean())->setUserName(RandomBook::getRandomString()); $user->setId($this->userBook->save($user)); $this->userList[] = $user; for ($k = 0; $k < 10; $k++) { $providerInfo = new ProviderInfo(); $providerInfo->setName(RandomBook::getRandomString())->setAppKey(RandomBook::getRandomString())->setSecretKey(RandomBook::getRandomString()); $providerInfo->setId((int) $this->providerInfoBook->save($providerInfo)); $this->providerInfoList[] = $providerInfo; $providerUser = new ProviderUser(); $providerUser->setUserId($user->getId())->setProviderId($providerInfo->getId())->setProviderName($providerInfo->getName())->setProviderUserId(RandomBook::getRandomString()); $this->providerUserList[] = $providerUser; } } }
/** * Sets up the fixture, for example, open a network connection. * This method is called before a test is executed. */ protected function setUp() { parent::setUp(); $this->connection = Connection::get(); $this->providerInfoBook = new ProviderInfoBook($this->connection); for ($k = 0; $k < 10; $k++) { $providerInfo = new ProviderInfo(); $providerInfo->setName(RandomBook::getRandomString())->setAppKey(RandomBook::getRandomString())->setSecretKey(RandomBook::getRandomString()); $this->providerInfoList[] = $providerInfo; } }
/** * @param int $providerId * @return ProviderInfo[] * @throws \Exception */ public function get($providerId = null) { MDataType::mustBe(array(MDataType::INT)); $toReturn = array(); $sql = "CALL mt_provider_get(?);"; $query = new MPDOQuery($sql, $this->connection); $query->bindValue($providerId); $queryResult = $query->exec(); if ($queryResult == false || $query->getResult()->rowCount() <= 0) { return $toReturn; } foreach ($query->getResult() as $row) { $userLogins = new ProviderInfo(); $userLogins->setName($row['name'])->setAppKey($row['app_key'])->setSecretKey($row['secret_key'])->setId((int) $row['id']); $toReturn[] = $userLogins; } return $toReturn; }