Using Fixtures

Fixtures are used to easily insert values into your database. The most common use for a fixture is to insert example record into your database

You fixtures the same way you run migrate:

cake fixtures help

If you wanted to create a fixture for your users table, it would be in the file @app/config/fixtures/users.php@ and it would look like this:

<pre><code>---

user:

id: 1
name: My user!!
description: foo bar
created: 2008-11-13 21:03:40
modified: 2008-11-13 21:03:40

• contests: id: 2 name: Lorem description: Lorem ipsum dolor sit amet, consectetur created: 2008-11-13 21:21:39 modified: 2008-11-13 21:21:39</code></pre>

If you have to reset your database or need to reinsert data for any reason, you can "dump" all your current data to fixtures like so:

cake fixtures g fromdb -force

(The -force option overwrites any existing files in @app/config/fixtures@)

Then you can load them back into the database simply by calling:

cake fixtures