Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-15 Thread Mike Henke
Could someone post Rick's script? I am very interested in looking @ it. Thanks, ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-15 Thread Rich
Here is the ant script that I was referring to the properties file that powers it. Also included are the caveats that I gave Janet: A few caveats: 1. It is targeted specifically to MSSQL. 2. I am using the open source JTDS drivers ( http://jtds.sourceforge.net/) to access our databases.

Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-15 Thread Mark Flewellen
http://www.barneyb.com/barneyblog/2007/07/13/schema-tool-update/ This is quite a useful tool for managing database migrations. Mark F ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active

Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-08 Thread Janet MacKay
+1 to dbunit. You also have the option of wrapping each unit test in a transaction and then rolling it back at the end. Jaime Metcher Yes, that works too. In this case dbUnit's restore capability is a better fit. I got a good quickstart to dbUnit thanks to Rich's script and I'm really liking

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-07 Thread Jaime Metcher
changes in CFCUnit/CFUnit tests Does anyone know of an article(s) explaining how to work rollbacks into unit testing? I want to test a series of DAO's, but am not sure how to incorporate this into my tests. Janet

Re: SOT: Rollback db changes in CFCUnit/CFUnit tests

2007-10-05 Thread John Paul Ashenfelter
On 10/4/07, Janet MacKay [EMAIL PROTECTED] wrote: Does anyone know of an article(s) explaining how to work rollbacks into unit testing? I want to test a series of DAO's, but am not sure how to incorporate this into my tests. Broadly speaking, depending on what you're testing, mock objects

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-05 Thread Rich
Thanks Rich. That is helpful. Off to download and review DBUnit. Thanks, Janet Janet, If you would like, I have a (work in progress) ant build file that uses dbunit's ant task to export / reset my database. I would be happy to email it to you offlist if you think it might be useful. HTH,

Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-05 Thread Janet MacKay
Rich, That would be great. Thanks. Janet ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-05 Thread Rich
Rich, That would be great. Thanks. Janet No problem. It should be on its way. Let me know if I can be of any more help. Rich Kroll ~| Get involved in the latest ColdFusion discussions, product development sharing,

SOT: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
Does anyone know of an article(s) explaining how to work rollbacks into unit testing? I want to test a series of DAO's, but am not sure how to incorporate this into my tests. Janet ~| ColdFusion 8 - Build next generation

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Rich
Does anyone know of an article(s) explaining how to work rollbacks into unit testing? I want to test a series of DAO's, but am not sure how to incorporate this into my tests. Janet You can incorporate a tool like DBUnit into your workflow (http://dbunit.sourceforge.net/). HTH, Rich Kroll

Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
You can incorporate a tool like DBUnit into your workflow (http://dbunit.sourceforge.net/). HTH, Rich Kroll Thanks. I'm new to unit testing in general, so sorry if this is a dumb question :) .. I think I understand the concept of DBUnit, but I can't visualize where it fits into picture. Are

RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Rich
Thanks. I'm new to unit testing in general, so sorry if this is a dumb question :) .. I think I understand the concept of DBUnit, but I can't visualize where it fits into picture. Are DBUnit tests something separate, written in java, or do they somehow tie into my CFUnit/CFCUnit tests? Can

Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
Thanks Rich. That is helpful. Off to download and review DBUnit. Thanks, Janet ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now