Re: [Dbix-class] How to deal with right joins while under test/sqlite

2017-11-07 Thread James Gilbert
Indeed. I've never used a right or full join. Only ever an inner or left. James > On 7 Nov 2017, at 19:28, Trevor Leffler wrote: > > Well… nevermind this. A little searching reminding me that I can replace > right join queries with left join queries (and vice versa).

Re: [Dbix-class] How to deal with right joins while under test/sqlite

2017-11-07 Thread Trevor Leffler
...@lists.scsys.co.uk] On Behalf Of Trevor Leffler Sent: Friday, November 3, 2017 12:56 PM To: dbix-class@lists.scsys.co.uk Subject: [Dbix-class] How to deal with right joins while under test/sqlite Up until recently I've been exclusively using a mysql database. I've started writing tests using Test

[Dbix-class] How to deal with right joins while under test/sqlite

2017-11-07 Thread Trevor Leffler
Up until recently I've been exclusively using a mysql database. I've started writing tests using Test::DBIx::Class, which loads my schema into an in-memory sqlite database. I got it working after making a few minor code changes to my Result/ResultSet classes. For example, I had to replace the