tests now checking for the existence of records in the database
added test for manual user registration