Edit on GitHub
Jump to docs navigation

Extending / Advanced / Storage Repositories & Entity Mappings

Note: You are currently reading the documentation for Bolt 3.7. Looking for the documentation for Bolt 5.2 instead?

Bolt 3 comes with an extensible storage interface. If your extension needs to register entity and repository mappings, your extension loader class should import StorageTrait, implement the registerRepositoryMappings() function and call extendRepositoryMapping() in your extension loader class.

Example

namespace Bolt\Extension\DropBear\KoalaCatcher;

use Bolt\Extension\DropBear\KoalaCatcher\Storage\Entity;
use Bolt\Extension\DropBear\KoalaCatcher\Storage\Repository;
use Bolt\Extension\SimpleExtension;
use Bolt\Extension\StorageTrait;
use Silex\Application;

/**
 * An extension for catching koalas.
 *
 * @author Kenny Koala <kenny@dropbear.com.au>
 */
class KoalaCatcherExtension extends SimpleExtension
{
    use StorageTrait;

    /**
     * {@inheritdoc}
     */
    protected function registerServices(Application $app)
    {
        $this->extendRepositoryMapping();
    }

    /**
     * {@inheritdoc}
     */
    protected function registerRepositoryMappings()
    {
        return [
            'gumtree' => [Entity\GumTree::class => Repository\GumTree::class],
        ];
    }

Note: The above example uses "class name resolution" via the ::class keyword.

Entity / Repository and Alias.

The below code is mapping a custom entity to a custom repository with the "gumtree" alias.

protected function registerRepositoryMappings()
{
    return [
        'gumtree' => [Entity\GumTree::class => Repository\GumTree::class],
    ];
}

That alias should match the "unprefixed" table name your entity data should be stored in.

If your data are going to be stored in the bolt_foo table, you alias should be foo.

Note: The default table prefix is bolt_

Custom Repository to Manage Entity Defined in Contenttype.Yml

Sometimes it may be convenient to define content structure through the contenttype.yml file (in particular to enjoy easy field declaration and to take advantage of the backend auto generated Create/Read/Update/Delete UI ).

If you would like to manage those content entities through a custom repository: we've got you covered!

Firstly You must create a custom Entity file which represents your content type and which extends \Bolt\Storage\Entity\Content, and then map that entity to your custom repository.

Your custom repository must also extend \Bolt\Storage\Repository\ContentRepository and override the createQueryBuilder method as outlined below:

For example, if we define a "races" content type like below:

races:
    name: Races
    slug: races
    singular_name: Race
    singular_slug: race
    fields:
        title:
            type: text
            class: large
            group: Text
        description:
            type: html
            height: 150px
        racedate:
            type: datetime
            label: "Date de la course"
            required: true
            variant: inline
            group: Options
        areSubscriptionsClosed:
            type: checkbox
            label: "Are Subscription Closed?"
            default: 0
            min: 0
    default_status: publish
    title_format: ['title', 'race_date']

We must define a "Race" entity which represent our "races" content type:

namespace Bolt\Extension\ACME\Race\Storage\Entity;

class Race extends \Bolt\Storage\Entity\Content
{
    /*
     * You can, if you want (but dont have to), defined your own getters & 
     * setters. Here we are just defining one for the example, but by default
     * because we inherit the Bolt Content class, we have access to all the
     * common content type value like id/slug/datecreated/relation/taxonomy etc,
     * and also to your custom fields.
     */

    protected $areSubscriptionsClosed;

    /**
     * @return mixed
     */
    public function getAreSubscriptionsClosed()
    {
        return  $this->areSubscriptionsClosed;
    }

    /**
     * @param mixed $areSubscriptionsClosed
     */
    public function setAreSubscriptionsClosed($value)
    {
        // You can add some additional checks on $value here if you want
        $this->areSubscriptionsClosed =  $value;
    }

    /**
     * Just a quick helper function which we can then use in Twig
     */
    public function getDayLeftCountBeforeRace()
    {
        $now = new \DateTime();
        $interval = $this->racedate->diff($now);
        $dayLeftCount = $interval->format('%a');
        return $dayLeftCount;
    }
}

Then let's create a custom repository:

namespace Bolt\Extension\ACME\Race\Storage\Repository;

use Bolt\Extension\ACME\Race\Storage\Entity\Race;
use Doctrine\DBAL\Query\QueryBuilder;

class RaceRepository extends \Bolt\Storage\Repository\ContentRepository
{
    /**
     * @return Race[]
     */
    public function findOpenRaces()
    {
        $qb = $this->createQueryBuilder();
        $qb
            ->where('racedate >= CURRENT_TIMESTAMP()')
            ->andWhere('areSubscriptionsClosed = 0')
        ;
        $races = $this->findWith($qb);

        return $races;
    }

    /**
     * @param string $alias
     *
     * @return QueryBuilder
     */
    public function createQueryBuilder($alias = null)
    {
        /*
         * It's very important to override the createQueryBuilder method because
         * the parent class force the alias to "content" which is not compatible
         * with our custom entity.
         */
        if(empty($alias)){
            $alias = $this->getAlias();
        }

        return parent::createQueryBuilder($alias);
    }
}

Then, we can map this custom entity, and this custom repository, together in your extension loader file:

protected function registerRepositoryMappings()
{
    // The table generated for my "races" content type is "bolt_races" so the
    // unprefixed name is simply "races".
    return [
        'races' => [
            \Bolt\Extension\ACME\Race\Storage\Entity\Race::class => 
            \Bolt\Extension\ACME\Race\Storage\Repository\RaceRepository::class
        ],
    ];
}

Then you are ready to go! You can just retrieve your repository like below:

    $raceRepo = $app['storage']->getRepository(\Bolt\Extension\ACME\Race\Storage\Entity\Race::class);

    // You can also retrieve your repository through the previously defined alias: 
    // $raceRepo = $app['storage']->getRepository('races');

    // $openRaces contains an array of Race Entities
    $openRaces = $raceRepo->findOpenRaces();

You can also use the features of your custom entity in your Twig templates:

    {% for id, race in openRaces %}
        {{ race.getDayLeftCountBeforeRace() }} days before the race!
    {% endfor %}


Edit this page on GitHub
Couldn't find what you were looking for? We are happy to help you in the forum, on Slack or on Github.