Re: Testing databases with DBIx::Class

2012-01-11 Thread 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

Re: Testing databases with DBIx::Class

2012-01-11 Thread Aaron Trevena
On 10 January 2012 17:07, David Cantrell da...@cantrell.org.uk wrote: On Tue, Jan 10, 2012 at 04:01:23PM +, 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

Testing databases with DBIx::Class

2012-01-10 Thread Ian Knopke
Hi, I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was wondering what approaches others are currently using for this. DBD::Mock seems ok but not especially well suited for use with DBIx. What

Re: Testing databases with DBIx::Class

2012-01-10 Thread Aaron Trevena
On 10 January 2012 09:56, Ian Knopke ian.kno...@gmail.com wrote: Hi, I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was wondering what approaches others are currently using for this.

Re: Testing databases with DBIx::Class

2012-01-10 Thread Gareth Harper
On 10 January 2012 10:12, Aaron Trevena aaron.trev...@gmail.com wrote: On 10 January 2012 09:56, Ian Knopke ian.kno...@gmail.com wrote: Hi, I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was

Re: Testing databases with DBIx::Class

2012-01-10 Thread Dagfinn Ilmari Mannsåker
Ian Knopke ian.kno...@gmail.com writes: Hi, I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was wondering what approaches others are currently using for this. DBD::Mock seems ok but not

Re: Testing databases with DBIx::Class

2012-01-10 Thread David Cantrell
On Tue, Jan 10, 2012 at 09:56:04AM +, Ian Knopke wrote: I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was wondering what approaches others are currently using for this. DBD::Mock seems

Re: Testing databases with DBIx::Class

2012-01-10 Thread Peter Sergeant
On Tue, Jan 10, 2012 at 9:56 AM, Ian Knopke ian.kno...@gmail.com wrote: I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was wondering what approaches others are currently using for this.

Re: Testing databases with DBIx::Class

2012-01-10 Thread Nicholas Clark
On Tue, Jan 10, 2012 at 12:19:19PM +, Peter Sergeant wrote: On Tue, Jan 10, 2012 at 9:56 AM, Ian Knopke ian.kno...@gmail.com wrote: I need to test some DBIx::Class code where the database may not be available. I can set up something to generate a small, temporary SQlite db, but I was

Re: Testing databases with DBIx::Class

2012-01-10 Thread Paul Makepeace
On Tue, Jan 10, 2012 at 12:41, Nicholas Clark n...@ccl4.org wrote: On Tue, Jan 10, 2012 at 12:19:19PM +, Peter Sergeant wrote: On Tue, Jan 10, 2012 at 9:56 AM, Ian Knopke ian.kno...@gmail.com wrote: I need to test some DBIx::Class code where the database may not be available. I can set

Re: Testing databases with DBIx::Class

2012-01-10 Thread Egor Shipovalov
If it's MySQL, it can be run embedded, which is what we have been doing at work. -- Best regards, Egor Shipovalov. On Tue, Jan 10, 2012 at 9:56 AM, Ian Knopke ian.kno...@gmail.com wrote: Hi, I need to test some DBIx::Class code where the database may not be available. I can set up something

Re: Testing databases with DBIx::Class

2012-01-10 Thread Leo Lapworth
On 10 January 2012 12:53, Paul Makepeace pa...@paulm.com wrote: On Tue, Jan 10, 2012 at 12:41, Nicholas Clark n...@ccl4.org wrote: On Tue, Jan 10, 2012 at 12:19:19PM +, Peter Sergeant wrote: On Tue, Jan 10, 2012 at 9:56 AM, Ian Knopke ian.kno...@gmail.com wrote: I need to test some

Re: Testing databases with DBIx::Class

2012-01-10 Thread the hatter
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

Re: Testing databases with DBIx::Class

2012-01-10 Thread Leo Lapworth
On 10 January 2012 16:01, the hatter london...@bang.meep.org 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

Re: Testing databases with DBIx::Class

2012-01-10 Thread ian docherty
On 10 January 2012 16:01, the hatter london...@bang.meep.org 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

Re: Testing databases with DBIx::Class

2012-01-10 Thread David Cantrell
On Tue, Jan 10, 2012 at 04:01:23PM +, 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