[Catalyst] Database schema -- Can't locate object method "new" via package

[Sarah Berry]

I think I've got it working! I'll post my solution in a bit here. Many
thanks to Brandon for pointing out some syntax errors and showing me which
plugin I hadn't installed.

My problem now is building the queries. How can I see what SQL code is being
generated for me? According to the tutorial John so kindly pointed me
towards, the SQL that was used should be output by script/myapp_server.pl,
but that only gives me errors like

DBD::mysql::st execute failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '= 'Date' ) OR ( select COUNT 'Date' ) ) ) ORDER BY
sensorid' at line 1 at
/usr/lib/perl5/vendor_perl/5.8.7/DBIx/Class/Storage/DBI.pm line 516.

and not the whole query.

~ Sarah

On 6/19/06, Sarah Berry <berry.sarah at gmail.com> wrote:
>
> On 6/16/06, John SJ Anderson <genehack at genehack.org> wrote:
>
> > "Sarah Berry" <berry.sarah at gmail.com> writes:
> >
> > >    Can anyone point me towards some resources?
> >
> >   It sounds like you might want to grab the SVN version of the tutorial
> >   and work through that. It doesn't take long (less than a day), and it
> >   will give you a much better idea how DBIx::Class fits into Catalyst,
> >   how authentication and authorization work, and how to do basic CRUD
> >   stuff (as well as several other topics).
> >
> >   You can get it by using SVN like so:
> >
> > svn co http://dev.catalyst.perl.org/repos/Catalyst/trunk/Catalyst/lib/Catalyst/Manual
> >
> >
> >   Or use a web browser to look at:
> >
> > http://dev.catalyst.perl.org/browser/trunk/Catalyst/lib/Catalyst/Manual/Tutorial
> >
> >
> >   I've been messing around with Cat fora while, and have even given a
> >   talk on it to the local Perl group -- and after working through the
> >   tutorial, my overall understanding of the structure of the whole
> >   "Catalyst experience" is a lot better, and it's much easier to work
> >   around speedbumps when I hit them.
> >
> > chrs,
> > john.
>
>
> Thanks John, I will start going through these.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/catalyst/attachments/20060623/ac64a9b6/attachment.htm