Fixtures are a way of organizing data that you want to test against; in short, sample data. To export your Panorama database in YML fixture format (the preferred Rails format) simply choose Export Database.yml from the Fixtures submenu in the Rails menu.
Track Magic will automatically place the resulting YML file in the test/fixtures folder.
Note: All of the visible (selected) Rails data in the current database will be included in the exported YML file. You may want to use the Select All command (in the Search menu) to make sure that all records are visible. You probably also want to make sure that all of the Rails fields are included in the current database, use the Field Configuration dialog (Rails menu) if that is not the case.
If you want to look at or manually edit the YML file you just exported, choose Open Database.yml in TextMate from the Fixtures submenu of the Rails menu.
Manually Loading Fixtures into a Rails Database
You can set up the test code in your Rails application to automatically load fixture data when tests are run. You can also manually load fixture data from Track Magic. From the database window, select Load Database.yml into Rails from the Fixture submenu of the Rails menu.
You can also load fixtures using the Track Magic window, even if the Panorama database is not currently open. To load ALL of the fixtures for all tables in the current application, choose Load Fixtures from the Application menu.
To load only a fixture for a single table, select the table and choose Load Fixture from the Table menu.