Testing databases with DBIx::Class

[Richard Foley]

Running a one-way data-munger on the data would be a fair way to anonymize the
client sensitive content.  This has the benefit of using near-perfect data for
testing.

And while using "fixtures" and SQLlite is a great drop-in fudge, it's still a
fudge because it's not the same database system, the database functionality is
different, and the perl DBIx code is not the same either.  It's similar, but
it's not the same.  You end up testing apples and pears, similar perhaps, but
definitely not the same.

-- 
Ciao

Richard Foley

http://www.rfi.net/books.html

On Tue, Jan 10, 2012 at 04:01:23PM +0000, the hatter wrote:
> On Tue, 10 Jan 2012, Leo Lapworth wrote:
> 
> >A full dump of live is imported to dev every sunday, when we're running on
> >a dev server
> 
> Except that if this includes personal data, and your customers
> didn't sign up to agree to be test subjects, then it's a breach of
> data protection laws to reuse data gathered for another purpose.  A
> lot of companies do this (either a full copy or some subset to make
> processing lighter) but few have the right words in their statement.
> 
> 
> the hatter