Databases
StackOverflow2013
Postsdbo
PORe-using datasets in PHPUnit
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORe-using datasets in PHPUnit
    primarykey
    data
    text
    <p>I have a user object with property 1, property 2, and property 3. I have a separate function to edit each property. Therefore, I'll need to test each edit property function. So I'll create 3 different expected datasets for the tests of successful property edits. However, what if I end up adding a 4th property down the line? Won't this force me to now add this property/value to all of the other datasets? Should I just create 1 template dataset file, and then extract the data from the file and use a php array dataset? This way, if I add a new property, I won't have to modify all of the previous datasets?</p> <p>Concrete example:</p> <p>Let's say I want to test that my edit email function works properly, and only changes the email. My setup fixture would be:</p> <p>setup-fixture.xml:</p> <pre><code>&lt;dataset&gt; &lt;table name="users"&gt; &lt;column&gt;id&lt;/column&gt; &lt;column&gt;email&lt;/column&gt; &lt;column&gt;password&lt;/column&gt; &lt;row&gt; &lt;value&gt;1&lt;/value&gt; &lt;value&gt;user1@email.com&lt;/value&gt; &lt;value&gt;password&lt;/value&gt; &lt;/row&gt; &lt;/table&gt; &lt;/dataset&gt; </code></pre> <p>And my expected dataset would be:</p> <p>edit-email-expected-dataset.xml:</p> <pre><code>&lt;dataset&gt; &lt;table name="users"&gt; &lt;column&gt;id&lt;/column&gt; &lt;column&gt;email&lt;/column&gt; &lt;column&gt;password&lt;/column&gt; &lt;row&gt; &lt;value&gt;1&lt;/value&gt; &lt;value&gt;user1-changed-his-email@email.com&lt;/value&gt; &lt;value&gt;password&lt;/value&gt; &lt;/row&gt; &lt;/table&gt; &lt;/dataset&gt; </code></pre> <p>However, if I later added another property called "notes" to this user object, my setup fixture would now be: new-setup-fixture.xml:</p> <pre><code>&lt;dataset&gt; &lt;table name="users"&gt; &lt;column&gt;id&lt;/column&gt; &lt;column&gt;email&lt;/column&gt; &lt;column&gt;password&lt;/column&gt; &lt;column&gt;notes&lt;/column&gt; &lt;row&gt; &lt;value&gt;1&lt;/value&gt; &lt;value&gt;user1@email.com&lt;/value&gt; &lt;value&gt;password&lt;/value&gt; &lt;value&gt;notes&lt;/value&gt; &lt;/row&gt; &lt;/table&gt; &lt;/dataset&gt; </code></pre> <p>Therefore, I would also have to amend my expected dataset file in the edit e-mail function test to include this new "notes" property.</p> <p>edit-email-expected-dataset.xml:</p> <pre><code>&lt;dataset&gt; &lt;table name="users"&gt; &lt;column&gt;id&lt;/column&gt; &lt;column&gt;email&lt;/column&gt; &lt;column&gt;password&lt;/column&gt; &lt;column&gt;notes&lt;/column&gt; &lt;row&gt; &lt;value&gt;1&lt;/value&gt; &lt;value&gt;user1-changed-his-email@email.com&lt;/value&gt; &lt;value&gt;password&lt;/value&gt; &lt;value&gt;notes&lt;/value&gt; &lt;/row&gt; &lt;/table&gt; &lt;/dataset&gt; </code></pre> <p>My question is, how do I avoid having to edit all my expected datasets everytime I add an extra field?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USblacktie24
    1. USblacktie24
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PORe-using datasets in PHPUnit
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODoes property 1 or 2 affect property 3's result? How about in any other order? With Unit Tests you should really only be testing small portions of code any way. When you add a new property you should be adding new tests entirely to make sure that doesn't break the rest. Make sense?
      singulars
      1. PORe-using datasets in PHPUnit
      1. USAaron Hathaway
    2. COTo add to that, you can have a setup function or function that creates some Object for you that each of the unit tests can call.
      singulars
      1. PORe-using datasets in PHPUnit
      1. USAaron Hathaway
    3. COProperty 1 and 2 do not affect property 3's result, and the order does not matter either. My issue is that I'm testing against a database, so if I add a new property in the setup fixture, I'll now have to add it to all of my expected dataset files as well.
      singulars
      1. PORe-using datasets in PHPUnit
      1. USblacktie24
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload