Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re^2: How can I make DBI's prepare() fail? [MySQL]

by Cody Fendant (Hermit)
on Dec 23, 2018 at 10:11 UTC ( [id://1227631]=note: print w/replies, xml ) Need Help??


in reply to Re: How can I make DBI's prepare() fail? [MySQL]
in thread How can I make DBI's prepare() fail? [MySQL]

With respect, that doesn't make sense in the context of what I'm trying to do. If I had a bad DBI object, I'd already know that from my connect() code.

  1. connect
  2. prepare
  3. execute

Your proposal is that I test number 2 by failing number 1. I'm testing all of them.

Replies are listed 'Best First'.
Re^3: How can I make DBI's prepare() fail? [MySQL]
by markong (Pilgrim) on Dec 23, 2018 at 13:53 UTC

    It does make sense indeed! As Anonymous Monk has suggested, you are trying to mock DBI's objects interface: for each test case you'd like to develop you mock the relative object methods. Look at Test::MockObject for fine grained object mocking.

[reply]
Re^3: How can I make DBI's prepare() fail? [MySQL]
by Anonymous Monk on Dec 23, 2018 at 12:09 UTC
    Let me try to reiterate. The "mock" testing strategy would mean preparing three different mock objects, one failing each particular call you want to handle failure of and succeeding others. First you would set connect() to fail, run your code and check whether the error handling subroutines are called. Then you would restore normal behaviour of connect() (see also: DBD::Mock to allow testing database error handling without a live database) but set prepare to fail and run your code again. Lather, rinse, repeat until all error conditions you want to be able to handle are tested.
[reply]
[d/l]
[select]

      I think there was a fundamental misunderstanding here, possibly caused by my wording.

      Your answers are perfectly good answers to "how should I create a test so that I can see what happens if a particular function fails?", which is one interpretation of my question.

      However my question is really "how can I make real-life code fail at the prepare() stage if the SQL code is bad?"

      kschwab's answer here is the answer to the question I was trying to ask.

[reply]
[d/l]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1227631]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others sharing their wisdom with the Monastery: (5)
As of 2024-04-24 08:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found