Re: [Dbix-class] table-per-subclass - how it works?

2012-06-15 Thread Darius Jokilehto
On 15/06/12 07:04, Alex Erzin wrote: Hello, [ ... ] CREATE TABLE `mydb`.`target` ( `target_id` INT NOT NULL , `description` VARCHAR(45) NULL , PRIMARY KEY (`target_id`) ) CREATE TABLE `mydb`.`host` ( `target_id` INT NOT NULL , `hostname` VARCHAR(45) NULL , `ip` VARCHAR(45

[Dbix-class] Is columns to cols as +columns is to +cols

2013-03-18 Thread Darius Jokilehto
Hello, Just wanted to point out an issue I ran with cols/+cols when chaining a couple of DBIC queries. I was trying to do the following: $schema->resultset('CD')->search({}, { cols => 'me.cola'})->search{}, { '+cols' => 'me.colb' });  - and was finding that 'colb' wasn't appearing in my query

[Dbix-class] Is columns to cols as +columns is to +cols

2013-03-18 Thread Darius Jokilehto
Hello, Just wanted to point out an issue I ran with cols/+cols when chaining a couple of DBIC queries. I was trying to do the following: $schema->resultset('CD')->search({}, { cols => 'me.cola'})->search{}, { '+cols' => 'me.colb' });  - and was finding that 'colb' wasn't appearing in my query

Re: [Dbix-class] Is columns to cols as +columns is to +cols

2013-03-19 Thread Darius Jokilehto
- Original Message - > From: Peter Rabbitson > To: Darius Jokilehto ; DBIx::Class user and > developer list > Cc: > Sent: Monday, 18 March 2013, 18:13 > Subject: Re: [Dbix-class] Is columns to cols as +columns is to +cols > > On Mon, Mar 18, 2013 at

Re: [Dbix-class] update and join

2014-11-13 Thread Darius Jokilehto
On Thursday, 13 November 2014, 11:36, RAPPAZ Francois wrote: [...] > > >I have two tables joined by a "belongs to" and a "has many" relationship > Ddref > idref iduser finished created > nn--+ > ^ ¦ > ¦

Re: [Dbix-class] foreign keys in fixtures for Test::DBIx::Class

2014-11-22 Thread Darius Jokilehto
You haven't specified the id columns, you need to do this explicitly, or like you said you won't be able to reference them. In other words: fixture_sets => { 'basic' => [ { Person => [ [ 'id', 'first_name', 'last_name', 'company_id'

Re: [Dbix-class] Dynamic/Flexible DBIC views

2014-11-22 Thread Darius Jokilehto
> On Friday, 21 November 2014, 15:35, Christian Lackas > wrote: [...] > > Thus, just adding another bind value that overrules the search for a > specific customer. > And this quickly becomes quite complicated if I know also want to add an > optional 'customer.type = ?' to work on project

Re: [Dbix-class] Schema Components

2016-09-19 Thread Darius Jokilehto
Hello Dave, This might be what you're looking for: https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Component.pod Darius On Friday, 16 September 2016, 17:09, Dave Cross wrote: In the documentation of DBIx::Class::Schema::Loader::Base there is a  reference to a

Re: [Dbix-class] Schema Components

2016-09-20 Thread Darius Jokilehto
but I could, of course, be wrong) that components which are  loaded into Schema objects would follow different rules. Cheers, Dave... Quoting Darius Jokilehto : > Hello Dave, > This might be what you're looking for:  > https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/