Preparing test data Insert is the database equivalent of Set Up Fixture , and can be used to populate tables with data quickly. Specify the table name as the first fixture argument, then define the data structure in the second row and specify data in subsequent rows: !|Insert|Users| |username|name| |pete|Peter Pan| |mike|Michael Jordan| The Insert fixture can also return automatically generated columns, such as primary key values. Use a question mark after the column name to specify that a column should be read from the database. You can store the output into fixture symbols for later use:
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!