Databases
StackOverflow2013
Postsdbo
PODatabase data needed in integration tests; created by API calls or using imported data?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase data needed in integration tests; created by API calls or using imported data?
    primarykey
    data
    text
    <p>This question is more or less programming language agnostic. However as I'm mostly into Java these days that's where I'll draw my examples from. I'm also thinking about the OOP case, so if you want to test a method you need an instance of that methods class.</p> <p>A <em>core rule</em> for <strong><a href="http://en.wikipedia.org/wiki/Unit_testing" rel="noreferrer">unit tests</a></strong> is that they should be autonomous, and that can be achieved by isolating a class from its dependencies. There are several ways to do it and it depends on if you inject your dependencies using <a href="http://en.wikipedia.org/wiki/Inversion_of_control" rel="noreferrer">IoC</a> (in the Java world we have Spring, EJB3 and other frameworks/platforms which provide injection capabilities) and/or if you mock objects (for Java you have <a href="http://www.jmock.org/" rel="noreferrer">JMock</a> and <a href="http://www.easymock.org/" rel="noreferrer">EasyMock</a>) to separate a class being tested from its dependencies.</p> <p>If we need to test groups of methods in different classes* and see that they are well integration, we write <strong><a href="http://en.wikipedia.org/wiki/Integration_testing" rel="noreferrer">integration tests</a></strong>. And here is my question!</p> <ul> <li>At least in web applications, state is often persisted to a database. We could use the same tools as for unit tests to achieve independence from the database. But in my humble opinion I think that there are cases when not using a database for integration tests is mocking too much (but feel free to disagree; not using a database at all, ever, is also a valid answer as it makes the question irrelevant).</li> <li><strong>When you use a database for integration tests, how do you fill that database with data?</strong> I can see two approaches: <ul> <li>Store the database contents for the integration test and load it before starting the test. If it's stored as an SQL dump, a database file, XML or something else would be interesting to know.</li> <li>Create the necessary database structures by API calls. These calls are probably split up into several methods in your test code and each of these methods <em>may</em> fail. It could be seen as your integration test having dependencies on other tests.</li> </ul></li> </ul> <p>How are you making certain that database data needed for tests is there when you need it? And why did you choose the method you choose?</p> <p><strong>Please provide an answer with a motivation</strong>, as it's in the motivation the interesting part lies. Remember that just saying "It's best practice!" isn't a <em>real</em> motivation, it's just re-iterating something you've read or heard from someone. For that case please explain <em>why</em> it's best practice.</p> <p>*I'm including one method calling other methods in (the same or other) instances of the same class in my definition of unit test, even though it might technically not be correct. Feel free to correct me, but let's keep it as a side issue.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODatabase data needed in integration tests; created by API calls or using imported data?
      1. USCommunity
      1. VTBountyStart
    2. VO
      singulars
      1. PODatabase data needed in integration tests; created by API calls or using imported data?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODatabase data needed in integration tests; created by API calls or using imported data?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI removed this same question which was posted as CW and now added it without CW. I got a helpful comment explaining that CW interferes with the reputation points system, so now it doesn't and you'll get all rewards you can get for answering! :-)
      singulars
      1. PODatabase data needed in integration tests; created by API calls or using imported data?
      1. This table or related slice is empty.
    2. COI'm starting a small bounty on this one as I would like more suggestions. Don't spare on the motivations! :-) When a week has passed I'll choose the top voted answer as my accepted answer, I'm voting too, but my vote is equal to yours.
      singulars
      1. PODatabase data needed in integration tests; created by API calls or using imported data?
      1. This table or related slice is empty.
 

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