How do I generate Symfony fixtures YML from exising database data?

database build symfony1 yaml fixtures
frodosghost picture frodosghost · Nov 26, 2009 · Viewed 13k times · Source

I was wondering if anyone knew how to generate a fixture.yml from data that is already existing in the database?

As you can use the build-schema to generate a schema, is there a way to do that for data?

symfony propel:build-schema

Answer

tuffo19 picture tuffo19 · Apr 26, 2010

In symfony 1.4 you just need to write:

./symfony doctrine:data-dump

and you get the file data/fixtures/data.yml

:-)

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More