Symfony 4 routing from DB

Question

I'm creating a simple CMS with Symfony 4. Where it it's possible to create pages. When creating a page a Doctrine EvenSubscriber is being called. This subscriber creates an PageRoute.

<?php
#src/Doctrine/EvenListener 

/**
 * PageRouteSubscriber
 */

namespace App\Doctrine\EventListener;


use App\Controller\PageController;
use App\Entity\Page;
use App\Entity\Route;
use Doctrine\Common\EventSubscriber;
use Doctrine\Common\Persistence\Event\LifecycleEventArgs;

/**
 * Class PageRouteSubscriber
 * @package App\Doctrine\EventListener
 */
class PageRouteSubscriber implements EventSubscriber {
    /**
     * Returns an array of events this subscriber wants to listen to.
     * @return array
     */
    public function getSubscribedEvents() {
        return [
            'postPersist',
            'postUpdate',
        ];
    }

    public function postPersist(LifecycleEventArgs $args){
        $this->index($args);
    }

    public function postUpdate(LifecycleEventArgs $args){
        $this->index($args);
    }

    public function index(LifecycleEventArgs $args)
    {
        $entity = $args->getObject();
        if($entity instanceof Page){
            $route = new Route();
            $route->setController(PageController::class);
            $route->setRouteContentId(get_class($entity) . '#' . $entity->getId());
            $route->setLocale($entity->getLocale());
            $route->setSlug($entity->getSlug());

            $entityManager = $args->getObjectManager();
            $entityManager->persist($route);
            $entityManager->flush();
        }
    }
}

So when the page is created there also is an route created. See images for database page and route examples.

Page

Route

I don't know this is the best way to store routes and pages in DB. Because they have both the same slug. I was thinking, only set slugs in route table. And per entity checking the unique slug based on all slugs in the route table (if this is possible?).

For routing: I don't now how to grep the routes and use them with Symfony Route Collection. Also is it possible to cache te routes just like Symfony does and created on big file called: srcDevDebugProjectContainerUrlGenerator

When i've got routes working i could create the frontend menu. Where a page menu item is coupled to an page. That page has an route. With this route the menu url could be created (is the the right way of thinking?).

RE cache routes: i assume that you use the DynamicRouter. the point of that router is that the routes are stored in the database and queried at runtime. the cache file would need to be rebuilt each time one of the routes is edited, which would be very inefficient. — dbu
If you can generate the routes from the content without manual interaction, you could look at the route provider of the cmf routing bundle - you could generate them on the fly from your content, to not need to store separate routes in the database. — dbu

Iwan Wijaya Iwan Wijaya · Accepted Answer · 2018-06-03T15:42:52

I think you should avoid storing class names in your database. If you change your namespace then they worn't work anymore. And I don't see why you need a route table?

You can just do it similar to how most CMSs are doing it: just use slug from your page entity, and let symfony param converter handle the rest, or load it manually.

/**
 * @Route("/page/{slug}")
 * @ParamConverter("page")
 */
public function showAction(Page $page)
{
}

You can get locale trough urls like this.

for your menu, you can just create a "menu" entity and add a relation to your page entity or hardcore a slug/url field in it.

Symfony 4 routing from DB

3 Answers