[Dbix-class] DBIx giving err due to camleCase??? not sure..

[Rajeev Prasad]

that does not work.
i get this err:
DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'primary', missing values for column(s): 'nodeid' at ./test.pl line 80

when i remove the key part altogether i get new err:
DBIx::Class::Row::store_column(): No such column 'nodeName' on Mydb::Schema::Result::Node at ./test.pl line 80
and we know that column exist. so i think there is some crap happening with CamleCase in col names. I will try with changed col names. it is very frustrating.

 

    On Monday, August 21, 2017 9:38 AM, tirveni yadav <yadav.tirveni at gmail.com> wrote:
 

 On Mon, Aug 21, 2017 at 7:15 PM, Rajeev Prasad <rp.neuli at yahoo.com> wrote:
> no, nodeID is auto increment field as seen in tabel description. it is
> complaining there is no such key. i dont know why...
>
>
>
> On Monday, August 21, 2017 7:39 AM, tirveni yadav <yadav.tirveni at gmail.com>
> wrote:
>
>
> On Mon, Aug 21, 2017 at 6:50 AM, Rajeev Prasad <rp.neuli at yahoo.com> wrote:
>>
>> why am i getting this err in DBIx::Class ?
>>
>> $./update_db.pl
>> DBIx::Class::ResultSource::unique_constraint_columns(): Unknown unique
>> constraint nodeid on 'node' at ./update_from_ieds.pl line 80
>>
>>
>> relevant code:
>> ...
>> sub addNode
>> {
>>    my $node = shift; my $lcNode = lc($node);
>>    my $id = $schema
>>        ->resultset('Node')
>>        ->find_or_create
>>        (
>>            { nodeName => $lcNode },
>>            { key => 'nodeid' }
>>        );
>>    return $id;
>> }
>
>
> Are you trying to do this:
>
>
> my $id = $schema
>        ->resultset('Node')->find_or_create
>      (
>            {
>            nodeName  => $lcNode ,
>
>                nodeID    => $nodeid,
>        }
>        );
>

In my view, unique constraint naming issue:

Try this:

A.
In Node.pm:

__PACKAGE__->add_unique_constraint(node_nodeid => [ qw/nodeid/ ], );


B.
function add_node
{
  my $rs_node = $dbic->resultset('Node');

  my $row_node;
  $row_node = $rs_node->find_or_create
        (
            {
          nodename => 'October',
            nodeid => '10',
          },
            { key => 'node_nodeid' }
        );
  return $row_node;

}


-- 
Regards,

Tirveni Yadav

www.udyansh.org

www.bael.io

What is this Universe ? From what it arises ? Into what does it go?
In freedom it arises, In freedom it rests and into freedom it melts away.
Upanishads.


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20170821/b7f07a93/attachment-0001.htm>