DoctrineExtensions: Sluggable

Wouldn't a better practice be to append genus-id rather than adding a new column to the database?

Hey @Daniel

What you mean by "Append genus-id"? It's a common practice to store the slug in a field so you can ensure two things
1) All slugs are unique
2) A slug won't change if you edit such record

Cheers!

Hello,
I'm trying to start that code on symfony 4, but I got this error:

Cannot autowire service "App\Service\MarkdownTransformer": argument "$cache" of method "__construct()" references interface "Doctrine\Common\Cache\Cache" but no such service exists. You should maybe
alias this interface to one of these existing services: "annotations.filesystem_cache", "annotations.cache", "doctrine_cache.providers.doctrine.orm.default_metadata_cache", "doctrine_cache.provider
s.doctrine.orm.default_result_cache", "doctrine_cache.providers.doctrine.orm.default_query_cache".

Does anybody know what to do?

Hey Dariusz!

Hmm. So, in Symfony 4, we take advantage of a lot of autowiring, which is really great, except that if you try to use some older code on Symfony 4, some things will need to change to get everything working :). If you've copied the code from this project into a Symfony 4 project (including copying the services.yml file into services.yaml) and you are getting this error, then the cause is probably that you need to remove these lines from your new services.yaml file: https://github.com/symfony/...

If you remove those lines, then you are effectively using the "Symfony 3" coding style inside a Symfony 4 project. If you're serious about learning Symfony 4, I'd definitely recommend checking into the new autowiring stuff - we cover it all in our Symfony 4 series. If you just want to learn more about the specific topics in *this* tutorial, then I might recommend just coding through this tutorial using the code download on this page (so, in Symfony 3). Both options are fine - it just depends on what's more important to you and how much you want to learn the new Symfony 4 stuff versus the actual content in this tutorial :).

Cheers!

Is there anything inherently wrong in this code. I ask because after running for 18 hours it has set 20 SLUGS..... Note I use the unit of work as setting slug to null wouldnt trigger persistance as it defaults to null.

class Version20170723121131 extends AbstractMigration implements ContainerAwareInterface
{

    use ContainerAwareTrait;

    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE person ADD slug VARCHAR(255) DEFAULT NULL');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_34DCD176989D9B62 ON person (slug)');

    }

    public function postUp(Schema $schema)
    {
        $em = $this->container->get("doctrine.orm.entity_manager");

        $people = $em->getRepository(Person::class)->findAll();

        foreach ($people as $person) {
            $uow = $em->getUnitOfWork();
            $uow->propertyChanged($person, 'slug', NULL, NULL);
            $uow->scheduleForUpdate($person);
            $em->flush();
        }

        parent::postUp($schema); // TODO: Change the autogenerated stub

    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
        $this->addSql('ALTER TABLE person DROP slug');
    }

    /**
     * Sets the container.
     *
     * @param ContainerInterface|null $container A ContainerInterface instance or null
     */
    public function setContainer(ContainerInterface $container = null)
    {
        $this->container = $container;
    }
}

Hey Richard ,

Take a look at my comment here: https://knpuniversity.com/s...
The main idea is do not use Doctrine migrations for such a big and complex tasks like populating slugs in production where you have a lot of entities. Use one-time Symfony commands for it.

Cheers!

This would not work for me until I set "nullable=true" on the $slug field in Genus entity. Since it wasn't working I was just going to allow it to be null and then manually fix things just to keep going. Once I did so then all worked without further manual intervention. Strange!

Ah, strange indeed! We'll have to see if anyone has a similar issue as you in the future :).

Hey guys,
I dont understand why I can't install the stof bundle since I started with the course code. This is what I get from the terminal :
- Installation request for symfony/symfony (locked at v3.1.4, required as 3.1.*) -> satisfiable by symfony/symfony[v3.1.4].
Any clue?
thx

I figure out a way to fix the problem. I just installed the 1.2 version by running composer require stof/doctrine-extensions-bundle ~1.2
It may help others ;)

Helped me. Thanks!

Hey ugo .p!

Ah, thanks for the note! Yea, it looks like the latest version of the bundle doesn't support the version of Symfony we use in this tutorial (even though it would work just fine, actually). I'll add an issue on our end to add a note to help others :).

Cheers!