<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1503351235084_5446">that does not work.</div><div><br></div><div dir="ltr">i get this err:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5411"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5412">DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'primary', missing values for column(s): 'nodeid' at ./test.pl line 80</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5533"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5534"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5475">when i remove the key part altogether i get new err:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5496"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5497">DBIx::Class::Row::store_column(): No such column 'nodeName' on Mydb::Schema::Result::Node at ./test.pl line 80</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5627"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5596">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.</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5658"><br id="yui_3_16_0_ym19_1_1503351235084_5410"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503351235084_5413"><br></div><div id="yui_3_16_0_ym19_1_1503351235084_5407"><span></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Monday, August 21, 2017 9:38 AM, tirveni yadav <yadav.tirveni@gmail.com> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div dir="ltr">On Mon, Aug 21, 2017 at 7:15 PM, Rajeev Prasad <<a shape="rect" ymailto="mailto:rp.neuli@yahoo.com" href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>> wrote:<br clear="none">> no, nodeID is auto increment field as seen in tabel description. it is<br clear="none">> complaining there is no such key. i dont know why...<br clear="none">><br clear="none">><br clear="none">><br clear="none">> On Monday, August 21, 2017 7:39 AM, tirveni yadav <<a shape="rect" ymailto="mailto:yadav.tirveni@gmail.com" href="mailto:yadav.tirveni@gmail.com">yadav.tirveni@gmail.com</a>><br clear="none">> wrote:<br clear="none">><br clear="none">><br clear="none">> On Mon, Aug 21, 2017 at 6:50 AM, Rajeev Prasad <<a shape="rect" ymailto="mailto:rp.neuli@yahoo.com" href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>> wrote:<br clear="none">>><br clear="none">>> why am i getting this err in DBIx::Class ?<br clear="none">>><br clear="none">>> $./update_db.pl<br clear="none">>> DBIx::Class::ResultSource::unique_constraint_columns(): Unknown unique<br clear="none">>> constraint nodeid on 'node' at ./update_from_ieds.pl line 80<br clear="none">>><br clear="none">>><br clear="none">>> relevant code:<br clear="none">>> ...<br clear="none">>> sub addNode<br clear="none">>> {<br clear="none">>> my $node = shift; my $lcNode = lc($node);<br clear="none">>> my $id = $schema<br clear="none">>> ->resultset('Node')<br clear="none">>> ->find_or_create<br clear="none">>> (<br clear="none">>> { nodeName => $lcNode },<br clear="none">>> { key => 'nodeid' }<br clear="none">>> );<br clear="none">>> return $id;<br clear="none">>> }<br clear="none">><br clear="none">><br clear="none">> Are you trying to do this:<br clear="none">><br clear="none">><br clear="none">> my $id = $schema<br clear="none">> ->resultset('Node')->find_or_create<br clear="none">> (<br clear="none">> {<br clear="none">> nodeName => $lcNode ,<br clear="none">><br clear="none">> nodeID => $nodeid,<br clear="none">> }<br clear="none">> );<br clear="none">><br clear="none"><br clear="none">In my view, unique constraint naming issue:<br clear="none"><br clear="none">Try this:<br clear="none"><br clear="none">A.<br clear="none">In Node.pm:<br clear="none"><br clear="none">__PACKAGE__->add_unique_constraint(node_nodeid => [ qw/nodeid/ ], );<br clear="none"><br clear="none"><br clear="none">B.<br clear="none">function add_node<br clear="none">{<br clear="none"> my $rs_node = $dbic->resultset('Node');<br clear="none"><br clear="none"> my $row_node;<br clear="none"> $row_node = $rs_node->find_or_create<br clear="none"> (<br clear="none"> {<br clear="none"> nodename => 'October',<br clear="none"> nodeid => '10',<br clear="none"> },<br clear="none"> { key => 'node_nodeid' }<br clear="none"> );<br clear="none"> return $row_node;<br clear="none"><br clear="none">}<br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Regards,<br clear="none"><br clear="none">Tirveni Yadav<br clear="none"><br clear="none">www.udyansh.org<div class="yqt2997962540" id="yqtfd03090"><br clear="none"><br clear="none">www.bael.io<br clear="none"><br clear="none">What is this Universe ? From what it arises ? Into what does it go?<br clear="none">In freedom it arises, In freedom it rests and into freedom it melts away.<br clear="none">Upanishads.<br clear="none"></div></div><br><br></div> </div> </div> </div></div></body></html>