dimaxz/simpleorm

что то вроде ORM

SimpleORM

, _(*1)

Features

• Framework agnostic
• Lazy loading
• Soft Deletes
• Value Objects
• Support Relationships

find by id, _(*2)

$Price = $PriceMapper->findById(44);
//or
$Price = $PriceMapper->useJoins()->findById(45);

save, _(*3)

$Price->getDatafile()->setIsEnabled(0);
$Price->setName('test');
if($PriceMapper->save($Price)){
  echo 'save success';
}

delete, _(*4)

if($PriceMapper->delete($Price)){
  echo 'delete success';
}

find by criteria, _(*5)

use SimpleORM\Specification;
$SearchCriteria = (new Specification())->setWhere('tablename',$tablename);
$Price = $this->PriceMapper->findBySpecification($SearchCriteria);

save with relations, _(*6)

$UserGroup = new UserGroup('admin','администратор');

$User = new User('master','mail@test.ru', '65829e542dd151f443',$UserGroup);
$User->setName('Тестовый пользюк 2');

$City = new City('Москва');
$Address = new UserAddress($City,'610110','Чернышевского');

$User->setAddress($Address);

if($UserMapper->save($User)){
    echo 'save success';
}

use ValueObject, _(*7)

use 
    SimpleORM\AbstractDataMapper, 
    ValueObject\UserPhoto;

class UserMapper extends AbstractDataMapper
{
    /**
     * Настройка полей
     */
    protected function setMappingFields() {

        //вариант 1
        $this
                ->addMappingField('id', [
                    'field'      => 'usr_id',
                    'primary'    => true
                    ]
                )
                ->addMappingField('photo',[
                    'name'      =>  'usr_photo',
                    'build'     =>  function($row){
                        return new UserPhoto($row['usr_photo']);
                    },
                    'unbuild'   =>  function(UserPhoto $UserPhoto){
                        return $UserPhoto->getPath();
                    }   
                ])
            ;

    }   
}