Re: [Dbix-class] Avoiding foreign key constraint on a relationship

2009-03-01 Thread Ash Berlin
On 1 Mar 2009, at 19:02, Peter Rabbitson wrote: W Snyder wrote: One of my DBIx::Class table classes has: __PACKAGE__->table("adjacents"); __PACKAGE__->add_columns( "child_id" => { ... }, "parent_id" => { ... }, ); __PACKAGE__->set_primary_key("child_id"); __PACKAGE__->b

Re: [Dbix-class] Avoiding foreign key constraint on a relationship

2009-03-01 Thread Peter Rabbitson
W Snyder wrote: > One of my DBIx::Class table classes has: > > __PACKAGE__->table("adjacents"); > __PACKAGE__->add_columns( > "child_id" => { ... }, > "parent_id" => { ... }, > ); > __PACKAGE__->set_primary_key("child_id"); > __PACKAGE__->base_has_one(parent_string => 'X::

Re: [Dbix-class] Avoiding foreign key constraint on a relationship

2009-03-01 Thread Rob Kinyon
On Sun, Mar 1, 2009 at 11:37, W Snyder wrote: > > One of my DBIx::Class table classes has: > > __PACKAGE__->table("adjacents"); > __PACKAGE__->add_columns( >    "child_id"          => { ... }, >    "parent_id"         => { ... }, > ); > __PACKAGE__->set_primary_key("child_id"); > __PACKAGE__->base

[Dbix-class] Avoiding foreign key constraint on a relationship

2009-03-01 Thread W Snyder
One of my DBIx::Class table classes has: __PACKAGE__->table("adjacents"); __PACKAGE__->add_columns( "child_id" => { ... }, "parent_id" => { ... }, ); __PACKAGE__->set_primary_key("child_id"); __PACKAGE__->base_has_one(parent_string => 'X::Schema::String', {'foreig