comment on

Take a look at Test::MockObject. What you are trying to test is the script, not the database, therefore you can fake the database (and its date and dayofweek functions) using MockObjects.

Do a super search on Test::MockObject to see some other uses of mocking. It is a very powerful technique that allows you to concentrate on the main job of your code, and it allows you to keep testdata and tests in the same place.

Good luck!

pernod
--
Mischief. Mayhem. Soap.

In reply to Re: Testing and database date functions by pernod
in thread Testing and database date functions by relax99

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


go ahead... be a heretic
	PerlMonks