Hi Vivek,<div><br></div><div>Try removing create=static from the command. This parameter is used to create the table structure automatically from the database.</div><div><br></div><div>Just to cross check whether you app is in working try doing following.</div>
<div>1) Create a table class in lib->Apty->Schema->Result->Table.pm</div><div>2) In Schema directory add Schema.pm with following </div><div> package Apty::Schema;<div><br></div><div>use strict;</div><div>
use warnings;</div><div><br></div><div>use base 'DBIx::Class::Schema';</div><div><br></div><div>__PACKAGE__->load_namespaces;</div><div><br></div><div><br></div><div># Created by DBIx::Class::Schema::Loader v0.04006 @ 2011-02-22 16:47:06</div>
<div># DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:foYv+STv7emsvGCJ4mWjIg</div><div><br></div><div><br></div><div># You can replace this text with custom content, and it will be preserved on regeneration</div><div>1;</div>
<div><br></div><div>3) Table.pm </div><div> package Apty::Schema::Result::Table.pm</div><div>use strict;</div><div>use warnings;</div><div><br></div><div>use base 'DBIx::Class';</div><div><br></div><div>__PACKAGE__->load_components("InflateColumn::DateTime", "Core");</div>
<div>__PACKAGE__->table("Table");</div><div>__PACKAGE__->add_columns(</div><div> "id",</div><div> { data_type => "INT", default_value => undef, is_nullable => 0, size => 20 },</div>
<div> "value",</div><div> {</div><div> data_type => "TEXT",</div><div> default_value => undef,</div><div> is_nullable => 0,</div><div> size => 65535,</div><div> },</div><div>
);</div><div><br></div><div># Created by DBIx::Class::Schema::Loader v0.04006 @ 2011-02-22 16:47:06</div><div># DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oogTrnt1wIwBbA7hgj7axA</div><div><br></div><div><br></div><div># You can replace this text with custom content, and it will be preserved on regeneration</div>
<div>1;</div><div><br></div><div>If above thing works out then there is certainly problem with db side. May be relations are not properly set.</div><div><br></div><div>Also if it doesn't work try comment out __Package=>immutable thing.</div>
<div><br></div><div>Hope this works..</div><div><br></div><br><div class="gmail_quote">On Sat, Apr 23, 2011 at 1:04 AM, Vivek Chhikara <span dir="ltr"><<a href="mailto:vivek@chhikara.org">vivek@chhikara.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<p>I just checked my app trace and below warning also added to list.</p>
<pre><br>Not inlining a constructor for Apty::Schema since its parent DBIx::Class::Schema doesn't contain a 'new' method. <br>If you are certain you don't need to inline your constructor, specify inline_constructor => 0 in your call to Apty::Schema->meta->make_immutable</pre>
<div><div></div><div class="h5">
<pre> </pre>
<p>On Sat, 23 Apr 2011 00:08:45 +0530, Vivek Chhikara wrote:</p>
<blockquote type="cite" style="padding-left:5px;border-left:#1010ff 2px solid;margin-left:5px;width:100%">
<p>Folks,</p>
<p>I added a few columns to one of my mysql table and tried to reload the DB model. </p>
<p>But it hangs ofter displaying below output.</p>
<pre>-bash-3.2$ ./<a href="http://apty_create.pl" target="_blank">apty_create.pl</a> model DB DBIC::Schema Apty::Schema create=static dbi:mysql:database user password<br> exists "/home/apty/script/../lib/Apty/Model"<br>
exists "/home/apty/script/../t"<br><br>^C<br>-bash-3.2$</pre>
<pre> </pre>
<pre>I tried to connect to the db using mysql with above user+password and I am able to connnect.</pre>
<pre> </pre>
<pre>Any clue is appreciated. </pre>
<div> </div>
</blockquote>
<p> </p>
<div> </div>
</div></div></div>
<br>_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><span style="font-size:large;line-height:32px">रोहन मल्लेल्रवार</span><div><span style="line-height:32px;font-size:large"><br></span></div>b
</div>