Doctrine repository service provider for Silex

This service provider exposes an easy way to have Repositories for your silex database., _(*1)

Requirements

This service provider has ben built to work with the DoctrineServiceProvider silex extension. See Silex' DoctrineServiceProvider documentation for instruction on how to use it., _(*2)

Installation

Add insolis/repository-service-provider to your composer.json file., _(*3)

Configuration

$app->register(
    new Insolis\Provider\RepositoryServiceProvider(), array(
        'repository.repositories' => array(
            'projects' => 'MyProject\Repository\Project',
        )
    )
);

The service provider expects parameter repository.repositories to be set and to be an associative array with service names as keys and repository classes as values., _(*5)

In the example above, the projects service will be exposed by Pimple (ie, you can access it through $app['projects']) using the MyProject\Repository\Project class., _(*6)

Usage

As you might have guessed by now, you need to implement a concrete class for every repository that you want to use. That repository must extend Insolis\Repository and implement the getTableName method, that should return the database's table name bound to that repository., _(*7)

In the example above, given your projects are stored in the project table, the MyProject\Repository\Project class would look like that:, _(*8)

namespace MyProject\Repository;

use Insolis\Repository;

class Project extends Repository;
{
    public function getTableName()
    {
        return 'project';
    }
}

The default repository implementation exposes a number of methods to manipulate your database that are basically proxies to methods from Doctrine\DBAL\Connection:, _(*9)

`insert(array $data)`

$app['projects']->insert(array(
    'title'       => 'foo',
    'description' => 'A project'
));

Will insert a project in the table with title "foo" and description "A project"., _(*10)

`update(array $data, array $identifier)`

$app['projects']->update(array('title' => 'bar'), array('title' => 'foo'));

Will update all projects' title from "foo" to "bar"., _(*11)

`delete(array $identifier)`

$app['projects']->delete(array('title' => 'bar'));

Will delete all projects which title is "bar"., _(*12)

`find($id)`

$app['projects']->find(42);

Returns the project which id field is 42., _(*13)

`findAll()`

$app['projects']->findAll();

Returns the entire table content., _(*14)

`count()`

$app["projects"]->count();

Returns the count of all records in the table., _(*15)

Extending a repository

Extending a repository is as easy as adding methods to it. For example, you could add a findByTitle($title) method to return all projects based on their title:, _(*16)

public function findByTitle($title)
{
    return $this->db->fetchAll(sprintf("SELECT * FROM %s WHERE title = ?;",
        $this->getTableName()), array($title));
}