MSTest unit tests and database access without touching the actual database -

-

in code interact database (not part of solution file). database owned separate team of dba's, , code developers write allowed access stored procs. have full view of database's procs, tables, , columns (it's definition). code dependent upon data, write unit tests dumb-up data in tables (and tear down/remove rows after unit test done), can run unit tests exercise code interacts db. of code in test file (especially in classinitialize() , classcleanup() functions). i've been given amount of grief new coworkers call style of unit tests "destructive" because read/write dev database inserting , removing rows. @ time code unit tests, database design not stable, many times can find issues in stored proc code before unleash qa department on our programs (saves resources). tell me there's way clone database memory @ time mstest unit tests run, don't know how it. i've researched around web , cannot find way coworkers need me do.

can tell me sure whether or not can happen in environment shown above? if so, can point me in right direction?

do have sql scripts can used create database? should have, , should under version control. if so, can following:

in test setup code:

  • create 'temporary' database using sql scripts. use unique name, example unittestdatabase_[timestamp].
  • setup data require test in test database. ideally using public api functions (eg createuser, addnewcustomer), required api not exist, use sql commands. using api set test data makes tests more robust against changes low-level implementation (i.e. database schema). 1 reason why write unit tests, ensure changes implementation not break functionality.
  • run unit tests, using dependency injection pass test database connection string test code code under test.

and in test teardown code, delete database. ideally should done using database uninstall scripts, should under version control.

you can control how want create unit test database: e.g. per test project, test class or test method, or combination, creating database in either [assemblyinitialize], [classinitialize] or [testinitialize] method.

this technique use great success. advantages are:

  • every time run unit tests, testing our database installation scripts work code.
  • test isolation, tests affect test database. , doesn't matter if rollback code goes wrong, not touching else's data.
  • confidence in code. is, because using real database, unit tests give me more confidence code works if mocking database. of course, depends on how suite of higher level integration/component tests are.

disadvantages:

  • the unit tests dependant on external system (the dbms). need find name of dbms in test setup code. can done using config file or looking @ run time running local dbms.
  • tests may slowed down database installation scripts. in our experience, tests still running enough, , there plenty of opportunities optimize. run our test suite of approx 400 unit tests in approx 1 min, includes creating 5 separate database on local installation of sqlserver 2008.

Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have
Read more

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

-
i'm using devexpress grid , i'm trying 'country' column display header filter properly: <dx:gridviewdatacolumn caption="country" fieldname="countryname" showincustomizationform="true" visible="false"> <settings allowheaderfilter="true"/> </dx:gridviewdatacolumn> if 'country' column set visible='true', header filter displayed should(it shows value option list). however, want 'country' column hidden, available in customization window(like in code above). in case, when column dragged outside customization window , grid , header filter clicked, javascript error encountered: element null element.addeventlistener(eventname, func, true); is known bug? there workarounds? set aspxgridview.settings.showheaderfilterbutton property true resolve problem. the following markup works fine me (i using dxperience 10.1.7): <asp:accessdatasource id="accessda
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj
Read more