Ufdjrw

I am using symfony 4.2 and looking for a way to insert initial data to the database.
What I was trying to create is something like an initial setup script that do some sql inserts (like fixtures but for the production environment as well) that can be called by a console command.

I was thinking of using the postUp function in the doctrine migration class but I don’t want to rewrite this function for every production environment I set up.
Is there a way to use doctrines migration functionality for this purpose or is there a preferred way?

Example workflow:

• Install symfony by cloning the git repository


• Execute migrations to create / update the database tables


• Execute the setup script to insert the needed default values into the database tables
  

Using the doctrine fixtures bundle in production

While this is discouraged because you can accidentally drop your production database with this, I do see some valid use cases for using the dotrine fixtures bundle in a production environment.

You can edit your config/bundles.php to enable the doctrine fixtures bundle in the production environment.

Change

DoctrineBundleFixturesBundleDoctrineFixturesBundle::class => ['dev' => true, 'test' => true],

to

DoctrineBundleFixturesBundleDoctrineFixturesBundle::class => ['all' => true],

Create your own command for fixture loading

Using doctrine functionality to manually load the fixtures is also discouraged, but that way you can add additional checks, for example only populate a fresh database.

$fixtures = (new DoctrineCommonDataFixturesLoader())->loadFromDirectory(__DIR__ . '/../src/DataFixture');
$loader = new DoctrineBundleFixturesBundleLoaderSymfonyFixturesLoader(new SymfonyComponentDependencyInjectionContainer());
$loader->addFixtures(
 array_map(
 function ($fixture) 
 return [
 'fixture' => $fixture,
 'groups' => []
 ];
 ,
 $fixtures
 )
);

$purger = new DoctrineCommonDataFixturesPurgerORMPurger($entityManager);

$executor = new DoctrineCommonDataFixturesExecutorORMExecutor($entityManager, $purger);
$executor->execute(
 $loader->getFixtures()
);