A good reason for keep the test with MsSql is that he is the main db for AR's users. Maybe testing against sqlite or other in memory db can hide some issues.
Cheers, Henry Conceição On Sat, Feb 6, 2010 at 10:49 AM, Markus Zywitza <[email protected]> wrote: > That's right. I only added the category nosqlite to the offending > tests, added a commented out section to app.config and a batch file > that executes the build with the options required for testing with > Sqlite. > > Currently, my plan is to keep MsSql as primary database system for > testing due to a number of reasons: > - Testing with Sqlite is much slower than with MsSql > - 15 Tests simply don't work with Sqlite > - One LINQ test doesn't work with Sqlite indicating a problem in the > NHLinq implementation. > > As a result, testing with SQLite is a workaround for the problems we > have with TeamCity, but not the ideal solution. The plan is to change > the most tests to use InMemoryTesting, and to test the rest only > explicitly. This will however take some time to change. > > -Markus > > 2010/2/6 John Simons <[email protected]>: >> Markus, just tried to run the unit tests from inside VS (using >> resharper), and it still expects a physical sql server, are you >> planning to make the sqllite the default? >> >> Cheers >> John >> >> On Feb 6, 5:20 am, Markus Zywitza <[email protected]> wrote: >>> The same dir in which NUnit creates the XML result file... >>> >>> -Markus >>> >>> 2010/2/5 Rafael Teixeira <[email protected]>: >>> >>> > Just a guess, Sqlite needs to write your "relational" data to a file >>> > (from the process you're running: NUnit in this case) so be sure your >>> > database path is accessible from the build user account. >>> >>> > Rafael "Monoman" Teixeira >>> > --------------------------------------- >>> > "To be creative means to be in love with life. You can be creative >>> > only if you love life enough that you want to enhance its beauty, you >>> > want to bring a little more music to it, a little more poetry to it, a >>> > little more dance to it." >>> > Osho >>> >>> > On Fri, Feb 5, 2010 at 2:27 PM, Markus Zywitza <[email protected]> >>> > wrote: >>> >> Any idea anybody why the d****d thing now dies with a security >>> >> exception in nunit-console.exe? >>> >>> >> -Markus >>> >>> >> 2010/2/5 Markus Zywitza <[email protected]>: >>> >>> I now changed AR to have a category called nosqlite for tests that >>> >>> don't run with SQLite. Someone has to check why they are problematic, >>> >>> but I don't have time for it right now. >>> >>> >>> There is also a batch file called builtwithsqlite.cmd for running that >>> >>> configuration. The default config still tests against SQL-Server. >>> >>> >>> I also changed both CI-Tests to test against SQLite. >>> >>> >>> -Markus >>> >>> >>> 2010/2/4 John Simons <[email protected]>: >>> >>>> Markus, are you also able to convert all the other projects that have >>> >>>> db >>> >>>> tests. >>> >>>> From the top of my head: >>> >>>> Monorail >>> >>>> Nhibernate integration >>> >>>> ActiveRecordIntegration >>> >>> >>>> Cheers John >>> >>>> On 05/02/2010, at 4:00, Markus Zywitza <[email protected]> >>> >>>> wrote: >>> >>> >>>> I'm about to change the buildscript and the problematic tests. >>> >>> >>>> -Markus >>> >>> >>>> 2010/2/4 James Curran <[email protected]>: >>> >>> >>>> On Thu, Feb 4, 2010 at 10:01 AM, Markus Zywitza >>> >>> >>>> <[email protected]> wrote: >>> >>> >>>> nunit-console.exe /exclude=MsSql >>> >>> >>>> But wouldn't that be part of a script that I don't have control over? >>> >>> >>>> Truth, >>> >>> >>>> James >>> >>> >>>> -- >>> >>> >>>> You received this message because you are subscribed to the Google >>> >>>> Groups >>> >>>> "Castle Project Development List" group. >>> >>> >>>> To post to this group, send email to >>> >>>> [email protected]. >>> >>> >>>> To unsubscribe from this group, send email to >>> >>>> [email protected]. >>> >>> >>>> For more options, visit this group at >>> >>>>http://groups.google.com/group/castle-project-devel?hl=en. >>> >>> >>>> -- >>> >>>> You received this message because you are subscribed to the Google >>> >>>> Groups >>> >>>> "Castle Project Development List" group. >>> >>>> To post to this group, send email to >>> >>>> [email protected]. >>> >>>> To unsubscribe from this group, send email to >>> >>>> [email protected]. >>> >>>> For more options, visit this group at >>> >>>>http://groups.google.com/group/castle-project-devel?hl=en. >>> >>> >>>> ________________________________ >>> >>>> Yahoo!7: Catch-up on your favourite Channel 7 TV shows easily, >>> >>>> legally, and >>> >>>> for free at PLUS7. Check it out. >>> >>> >>>> -- >>> >>>> You received this message because you are subscribed to the Google >>> >>>> Groups >>> >>>> "Castle Project Development List" group. >>> >>>> To post to this group, send email to >>> >>>> [email protected]. >>> >>>> To unsubscribe from this group, send email to >>> >>>> [email protected]. >>> >>>> For more options, visit this group at >>> >>>>http://groups.google.com/group/castle-project-devel?hl=en. >>> >>> >> -- >>> >> You received this message because you are subscribed to the Google >>> >> Groups "Castle Project Development List" group. >>> >> To post to this group, send email to >>> >> [email protected]. >>> >> To unsubscribe from this group, send email to >>> >> [email protected]. >>> >> For more options, visit this group >>> >> athttp://groups.google.com/group/castle-project-devel?hl=en. >>> >>> > -- >>> > You received this message because you are subscribed to the Google Groups >>> > "Castle Project Development List" group. >>> > To post to this group, send email to >>> > [email protected]. >>> > To unsubscribe from this group, send email to >>> > [email protected]. >>> > For more options, visit this group >>> > athttp://groups.google.com/group/castle-project-devel?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Castle Project Development List" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/castle-project-devel?hl=en. >> >> > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Development List" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/castle-project-devel?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Development List" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-devel?hl=en.
