Wallogit.com
2017 © Pedro Peláez
Component provides easy way to emulate ENUM behaviour on the PHP layer instead database and convert DB value into human representation and vise versa
Component provides easy way to emulate ENUM behaviour on the PHP layer instead database by constant usage.
Convert database value into human representation and vise versa., (*1)
Open a command console, enter your project directory and execute the following command to download the latest stable version of this component:, (*2)
composer require adrenalinkin/enum-mapper
This command requires you to have Composer install globally., (*3)
For start create mapper-class and extend him from AbstractEnumMapper. For second and last step - determine list of the constants with specific prefixes: * DB_ - contains database values. * HUMAN_ - contains humanized values., (*4)
Let's say we need to store user's gender. In that case we need to create mapper-class:, (*5)
<?php
use Linkin\Component\EnumMapper\Mapper\AbstractEnumMapper;
class GenderMapper extends AbstractEnumMapper
{
const DB_UNDEFINED = 0;
const DB_MALE = 10;
const DB_FEMALE = 20;
const HUMAN_UNDEFINED = 'Undefined';
const HUMAN_MALE = 'Male';
const HUMAN_FEMALE = 'Female';
}
Get humanized value by received database value:, (*6)
<?php
$mapper = new GenderMapper();
$dbGenderValue = GenderMapper::DB_MALE; // 10
$humanValue = $mapper->fromDbToHuman($dbGenderValue);
Variable $humanValue will be contain Male value.
Note: When you will try to get value of the unregistered value will be throws UndefinedMapValueException., (*7)
Get database value by received humanized value:, (*8)
<?php
$mapper = new GenderMapper();
$humanGenderValue = GenderMapper::HUMAN_FEMALE; // Female
$dbValue = $mapper->fromHumanToDb($humanGenderValue);
Variable $dbValue will be contain 20 value.
Note: When you will try to get value of the unregistered value will be throws UndefinedMapValueException., (*9)
Get full list of the available pairs of the database and humanized values:, (*10)
<?php
$mapper = new GenderMapper();
$map = $mapper->getMap(); // [0 => 'Undefined', 10 => 'Male', 20 => 'Female']
All the time you available to use constant as is:, (*11)
<?php
if (GenderMapper::DB_UNDEFINED === $maleFromForm) {
throw new \Exception('Field "Gender" is required in this form');
}
Get list of the all available value for the database values or for the humanized values:, (*12)
<?php
$mapper = new GenderMapper();
$allowedDb = $mapper->getAllowedDbValues(); // [0, 10, 20]
$allowedHuman = $mapper->getAllowedHumanValues(); // ['Undefined', 'Male', 'Female']
// Exclude values from result
$allowedDb = $mapper->getAllowedDbValues([GenderMapper::DB_UNDEFINED]); // [10, 20]
$allowedHuman = $mapper->getAllowedHumanValues([GenderMapper::HUMAN_UNDEFINED]); // ['Male', 'Female']
Get random database or humanized value:, (*13)
<?php
$mapper = new GenderMapper();
$randomDb = $mapper->getRandomDbValue(); // 0 || 10 || 20
$randomHuman = $mapper->getRandomHumanValue(); // Undefined || Male || Female
// Exclude values from result
$randomDb = $mapper->getRandomDbValue([GenderMapper::DB_UNDEFINED]); // 10 || 20
$randomHuman = $mapper->getRandomHumanValue([GenderMapper::HUMAN_UNDEFINED]); // Male || Female
, (*14)
Component provides easy way to emulate ENUM behaviour on the PHP layer instead database and convert DB value into human representation and vise versa
MIT
database component php enum convert humanize human-readable enum-mapper humanized-values