Is it possible to load doctrine fixtures without deleting database

php symfony doctrine-orm fixtures
user1994660 picture user1994660 · Mar 5, 2014 · Viewed 18k times · Source

I have defined some fixtures in doctrine.

When i try to run using this

php app/console doctrine:fixtures:load then it asks me to purge the database.

is it possible to load it without purging database.

I remeber Django has fixtures which can be loaded in separate tables without purging existing database

Answer

Phil picture Phil · Mar 5, 2014

Use the --append option

php app/console help doctrine:fixtures:load
Usage:
 doctrine:fixtures:load [--fixtures[="..."]] [--append] [--em="..."] [--purge-with-truncate]

Options:
 --fixtures             The directory or file to load data fixtures from. (multiple values allowed)
 --append               Append the data fixtures instead of deleting all data from the database first.
 --em                   The entity manager to use for this command.
 --purge-with-truncate  Purge data by using a database-level TRUNCATE statement

Related questions

On delete cascade with doctrine2

I'm trying to make a simple example in order to learn how to delete a row from a parent table and automatically delete the matching rows in the child table using Doctrine2. Here are the two entities I'm using: Child.…

Read More
How to select distinct query using symfony2 doctrine query builder?

I have this symfony code where it retrieves all the categories related to a blog section on my project: $category = $catrep->createQueryBuilder('cc') ->Where('cc.contenttype = :type') ->setParameter('type', 'blogarticle') ->getQuery(); $categories = $category-&…

Read More
How to use a findBy method with comparative criteria

I'd need to use a "magic finder" findBy method using comparative criteria (not only exact criteria). In other words, I need to do something like this: $result = $purchases_repository->findBy(array("prize" => ">200")); so that I'd get all …

Read More