/** * 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; } } }
public function get($userId = null, $providerId = null, $providerUserId = null) { MDataType::mustBeNullableInt($userId); MDataType::mustBeNullableInt($providerId); MDataType::mustBeNullableString($providerUserId); $providerUserList = array(); $sql = "CALL mt_provider_user_get(?, ?, ?);"; $query = new MPDOQuery($sql, $this->connection); $query->bindValue($userId); $query->bindValue($providerId); $query->bindValue($providerUserId); $queryResult = $query->exec(); if ($queryResult == false || $query->getResult()->rowCount() <= 0) { return $providerUserList; } foreach ($query->getResult() as $row) { $providerUser = new ProviderUser(); $providerUser->setProviderName($row['name'])->setProviderUserId($row['provider_user_id'])->setProviderId((int) $row['id'])->setUserId((int) $row['user_id']); $providerUserList[] = $providerUser; } return $providerUserList; }