I'm a bit new to mocking data for testing. I'm using ruby in conjunction with watir-webdriver and I have a local version of the app. I'd like to run a script which empties the tables of the local database, and then preloads with defined values so that the browser integration suite can run and check for expected values. The problem is that I have no idea how to start.
I think i will use a pg
gem. But I'd like the data to be the same every test run, so I'd rather not have a data generator, so It looks like scripts are the way to go, but I have no idea what the best practices are around this or what it should look like.