Best practices on running functional tests against the staging server when data initialization is needed?

I'm working on writing functional tests for an web application I'm building. I'm fairly new to testing and trying to get to grips with best practices. The application has a moderate amount of complexity, and I'm trying to write a functional test for a process that is part of a bigger process.

Re: DB relations and delete question

I'm not asking about certain DB engine but how django would behave in presence of foriegn key? II will give an exampel of what arised this concern. http://www.djangoproject.com/documentation/db-api/ One-to-many relationships Forward If a model has a ForeignKey, instances of that model will

DB relations and delete question

Lets say we have Accounts that is referenced profile, group, interest tables. If I delete the account ID 1 would the related data to that account in profile, group and interest table be deleted in all cases of relation? One to one, one to many, many to many? same question applies to update