linna/auth-mapper-mysql

Mysql mapper implementation of the authentication and authorization interfaces.

v0.2.1 2022-10-24 20:26 UTC

Requires

• php: >=8.1
• ext-mysqli: *
• ext-pdo: *
• ext-pdo_mysql: *

Requires (Dev)

• infection/infection: >=0.26
• linna/auth-mapper-test-trait: ^0.2
• linna/db-dumps: dev-master
• linna/framework: ^0.27.0
• phpstan/phpstan: >=1.8
• phpunit/phpunit: >=9.0

MIT

• Sebastian Rapetti

• php
• authorization
• Authentication
• mysql
• mapper

README

NOTE: Code porting to PHP 8.1 ongoing.

About

This package provide a concrete implementation for the authentication interfaces and for the authorization interfaces of the framework.

Mappers use as persistent storage mysql through php pdo.

Requirements

• PHP >= 8.1
• PDO extension
• MySQL extension
• linna/framework v0.28.0|next

Installation

With composer:

composer require linna/auth-mapper-mysql

Package Content

Interfaces from Framework

• Linna\Authentication\EnhancedAuthenticationMapperInterface
• Linna\Authorization\PermissionExtendedMapperInterface
• Linna\Authorization\PermissionMapperInterface
• Linna\Authorization\RoleExtendedMapperInterface
• Linna\Authorization\RoleMapperInterface
• Linna\Authorization\UserExtendedMapperInterface
• Linna\Authorization\UserMapperInterface

Implementation

• Linna\Authentication\EnhancedAuthenticationMapper
  • deleteOldLoginAttempts()
  • fetchAll()
  • fetchAttemptsWithSameIp()
  • fetchAttemptsWithSameSession()
  • fetchAttemptsWithSameUser()
  • fetchById()
  • fetchLimit()
• Linna\Authorization\PermissionExtendedMapper
• Linna\Authorization\PermissionMapper
  • fetchAll()
  • fetchById()
  • fetchByName()
  • fetchByRole()
  • fetchByRoleId()
  • fetchByRoleName()
  • fetchByUser()
  • fetchByUserId()
  • fetchByUserName()
  • fetchLimit()
  • fetchUserPermissionHashTable()
  • permissionExistById()
  • permissionExistByName()
• Linna\Authorization\RoleExtendedMapper
  • addUser()
  • addUserById()
  • addUserByName()
  • grantPermission()
  • grantPermissionById()
  • grantPermissionByName()
  • removeUser()
  • removeUserById()
  • removeUserByName()
  • revokePermission()
  • revokePermissionById()
  • revokePermissionByName()
• Linna\Authorization\RoleMapper
  • fetchAll()
  • fetchById()
  • fetchByName()
  • fetchByPermission()
  • fetchByPermissionId()
  • fetchByPermissionName()
  • fetchByUser()
  • fetchByUserId()
  • fetchByUserName()
  • fetchLimit()
• Linna\Authorization\UserExtendedMapper
  • addRole()
  • addRoleById()
  • addRoleByName()
  • grantPermission()
  • grantPermissionById()
  • grantPermissionByName()
  • removeRole()
  • removeRoleById()
  • removeRoleByName()
  • revokePermission()
  • revokePermissionById()
  • revokePermissionByName()
• Linna\Authorization\UserMapper
  • fetchAll()
  • fetchById()
  • fetchByName()
  • fetchByPermission()
  • fetchByPermissionId()
  • fetchByPermissionName()
  • fetchByRole()
  • fetchByRoleId()
  • fetchByRoleName()
  • fetchLimit()