[Dbix-class] DBIx giving err due to camleCase??? not sure..
tirveni yadav
yadav.tirveni at gmail.com
Mon Aug 21 14:38:41 GMT 2017
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.
More information about the DBIx-Class
mailing list