that's usually called unit testing. Empty the tables of all records, then add test records to verify boundary conditions, invalid conditions etc.
check that these appear in the relevant views as and when expected. Note that this is sometimes not a trivial exercise, so you should script your record deletion and insertion.
obviously take a back up of your data before starting testing, so if it all goes wrong, you can reverse the changes easily.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.