[Zope] ZSQL unit testing with gadfly?

[Terry Hancock]

Well, I am continuing my learning process with the 
unit-testing concept using ZopeTestCase.  I need to test a 
product that in real-life uses a MySQL database connection, 
managed entirely by ZSQL methods.

For unit-testing, I really should create a "toy" database. 
I'm presently thinking that it would be smarter to use
Zope's built-in gadfly / ZGadflyDA support.

Has anyone else done this before?  Are there caveats
I should be aware of?  Is it an unsafe idea to test with 
Gadfly, when I'm probably going to be using MySQL in 
production?

Is there anything special about loading a DB connection
in ZTC?

Thanks,
Terry

--
Terry Hancock ( hancock at anansispaceworks.com )
Anansi Spaceworks  http://www.anansispaceworks.com