On Wednesday, July 29, 2015 at 5:30:11 PM UTC-7, Bill Burton wrote: > > Hello, > > I need to test the implementation of an Oracle view and wanted to use > Sequel for this purpose. Due to the environment, I can't populate the > database with my own data but have to use a copy of the production database > to work with which has over 28,000 records in the view being tested. So > instead of testing for known results in test data, I was going to use a > separate query to get the reference data that would then be compared with > the view under test. > > In looking at the Dataset class, the .except() instance method looks > helpful as a way to compare Datasets but is there a better way? > > To drive the tests, I was planning on using minitest but am open to using > RSpec. >
I think using Dataset#except would be a good way of testing this. If you want to test that the two datasets return the same results: view_dataset.except(test_dataset).count.must_equal 0 test_dataset.except(view_dataset).count.must_equal 0 Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
