lynx/lynx

Awesome Mapper on top of DBAL/Doctrine2

Lynx

, _(*1)

An awesome Mapper on top of Doctrine 2 components, _(*2)

How to work?

First you need to setup EntityManager ($em) :, _(*3)

$configuration = new Configuration();
$configuration->setResultCacheImpl($di->getCache());
$configuration->setMetadataDriverImpl(
    new \Doctrine\ORM\Mapping\Driver\AnnotationDriver(
        new AnnotationReader(),
        realpath(APP_ROOT_PATH . '/src/BlaBla/User/Model/')
    )
);
$configuration->setMetadataCacheImpl(
    new \Doctrine\Common\Cache\ApcCache()
);

$em = new \Lynx\EntityManager(
    $di->getDb(),
    $configuration
);

Working with repository

You can get a Repository for Model by using method getRepository from EntityManager:, _(*4)

$repository = $em->getRepository(User::class);

For example, you can get one row by using:, _(*5)

$repository = $em->getRepository(User::class);
/** User|null $user */
$user = $repository->findOne(1);

You can count all rows from table:, _(*6)

$repository = $em->getRepository(User::class);
$count = $repository->count();

Testing

PostgresSQL

sudo docker run --name lynx-test -p 5432:5432 -e POSTGRES_PASSWORD= -d postgres
psql -p 5432 -h 127.0.0.1 -U postgres -c 'create database lynx_test;'
psql -p 5432 -h 127.0.0.1 -U postgres -d lynx_test -f tests/schemas/pqsql/lynx_test.sql

LICENSE

MIT, _(*7)