public function exists($username)
{
$db = Database::getInstance($this->dbInstance);
$result = $db->prepare("SELECT id FROM users WHERE username = ?");
$result->execute(array($username));
return $result->rowCount() > 0;
}
public function exists($text)
{
$db = Database::getInstance($this->dbInstance);
$result = $db->prepare("SELECT id FROM categories WHERE categoryText = ?");
$result->execute(array($text));
return $result->rowCount() > 0;
}
public static function isUserInRole($username, $roleText)
{
$result = false;
$db = Database::getInstance(self::DB_INSTANCE);
$desiredRoleQuery = $db->prepare("select id from user_roles where roleText = ?");
$desiredRoleQuery->execute(array($roleText));
$desiredRole = $desiredRoleQuery->fetch();
if ($desiredRoleQuery->rowCount() < 1) {
throw new \Exception("Role {$roleText} does not exist");
}
$actualRoleQuery = $db->prepare("select roleId from users where username = ?");
$actualRoleQuery->execute(array($username));
$actualRole = $actualRoleQuery->fetch();
if ($desiredRole['id'] === $actualRole['roleId']) {
$result = true;
}
return $result;
}
