public function install()
{
try {
$this->queryBuilder->createDatabase(Config::getDatabaseName())->useDatabase(Config::getDatabaseName())->createTable('users', ['user_id' => 'smallint(6) NOT NULL PRIMARY KEY AUTO_INCREMENT', 'user_name' => 'varchar(30) NOT NULL', 'email' => 'varchar(30) NOT NULL', 'user_password' => 'char(60) NOT NULL'], ['ENGINE=InnoDB', 'DEFAULT CHARSET=utf8']);
} catch (\Exception $e) {
echo $e->getMessage();
}
}
/**
* @param string $attribute
* @param string $value
* @return UserVO
* @throws \Exception
*/
public function findBy(string $attribute, string $value)
{
$params = [$attribute => $value];
$row = $this->queryBuilder->useDatabase(Config::getDatabaseName())->select()->from(self::TABLE)->where($attribute, '=')->execute($params)->getRow();
$userVO = new UserVO();
$userVO->setEmail($row['email']);
$userVO->setUserName($row['user_name']);
$userVO->setUserPassword($row['user_password']);
return $userVO;
}
