Ideally you wouldn't be using a real database in your tests. Let me know if you'd like more information on how to create "Dummy" classes to avoid using the live database.
-Matt www.sep.com/mcterry On Thursday, March 22, 2012 9:50:12 AM UTC-4, Dirk Vranckaert wrote: > > I did not really found the answer, but I did find a solution (or another > way to reach my target :) ). > See my answer at StackOverflow.com => > http://stackoverflow.com/questions/9804917/android-testing-start-with-clean-database-for-every-test/9823600#9823600<http://stackoverflow.com/questions/9804917/android-testing-start-with-clean-database-for-every-test/9823600#9823600> > > > Op woensdag 21 maart 2012 09:26:56 UTC+1 schreef Dirk Vranckaert het > volgende: >> >> I'm testing my application with Android Instrumentation tests. >> >> So I have a test-class extending ActivityInstrumentationTestCase2 which >> contains multiple tests. The code looks like this: >> http://pastebin.com/0Di3Hwug <http://pastebin.com/0Di3Hwug> >> >> So the activity which is under test has a list of projects. The list of >> projects is retrieved from the database. And when no database is available, >> so when the DB is created, I insert one default project. >> >> What I want it to do is to delete the database before every test is run >> (that's why I have the delete in the setUp() method), and so if there is >> no database available the onCreate for the database should be called on >> creation of my activity (when loading the list of projects). >> >> What it does, it deletes the DB, it creates the DB, then runs my first >> test, then it deletes the DB, but does not create it, and runs the second >> test. >> >> In the test that is first run, I create (add) a project to the DB. In the >> second test, as I delete the DB, I don't want to see that project anymore >> but it's there!! No idea how that can happen but it seems that the >> instrumentation tests are keeping a DB instance in memory... >> Or even an instance of the activity? Because when I put a breakpoint in >> the onCreate of my activity I only get there once for both the tests... >> >> For the maintaining the DB I use ORMLite. You can see my helper class >> here: >> http://code.google.com/p/worktime/source/browse/trunk/android-app/src/eu/vranckaert/worktime/dao/utils/DatabaseHelper.java<http://code.google.com/p/worktime/source/browse/trunk/android-app/src/eu/vranckaert/worktime/dao/utils/DatabaseHelper.java> >> >> So how can I work around this or is there another way to achieve what I >> want? >> > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en