Hi everybody,
I'm having a Catch 22 problem and I'm thinking of a best way to handle it, may be you can suggest something.
In my test class we have rollback property set to true and it automatically rolls back all SQL commands.
This is good as I don't want my tests to create new rows in the database.
Unfortunately, for the particular case I have right now I first create parent row and then in a separate method and separate command try to create a child row.
Since the original transaction was rolled back, I am getting the Foreign Key violation error and can not really test my procedure.
So, what is the best way to handle this situation - I don't really want to create extra rows, but I don't want to get the SQL error either.
Thanks in advance.
If it's not broken, fix it until it is.
My Blog