[Catalyst] Class::DBI, Controller::Root, set_sql "redefined"

[Marc Brooks]

The problem is the method doesn't exist until the query is executed using
set_sql().

When performing a query using

$c->model('MyApp::Example')->set_sql( example => qq{
    SELECT * FROM just_an_example WHERE just = 1
});

The Class::DBI inherits Ima::DBI's set_sql() to create a helper shortcut
method, by prefixing the name of the SQL fragment with "search_". Thus, the
above call to set_sql() will automatically set up the method
search_example(), which will then perform the query.

So the answer to your question is no because the method doesn't exist.

Thanks for your time

M. Brooks

-----Original Message-----
From: catalyst-bounces at lists.rawmode.org
[mailto:catalyst-bounces at lists.rawmode.org]On Behalf Of Marcello Romani
Sent: Monday, June 05, 2006 11:42 PM
To: The elegant MVC web framework
Subject: Re: [Catalyst] Class::DBI, Controller::Root, set_sql
"redefined" [heur] poss. spam[ff]


Marc Brooks ha scritto:
> This is more of any annoying error message if anything.  So bear with me.
> 
> Basically I am setting global template variables (TT) within the
> Controller::Root to be used within all the template pages within the
> application.  Everything works with exception to this annoying warning,
> "Model::CDBI::Catalog::sql_category redefined at
> /usr/lib/perl5/site_perl/5.8.3/Ima/DBI.pm".
> 
> I have narrowed the problem down to the Class::DBI set_sql() method and
how
> it temporarily creates a method sql_* within the Model::CDBI upon
execution.
> 
> Anyone experience this or know of a solution to suppress this warning?
> 
> Is this something I should be worrying about?
> 
> Thank your time, Catalyst::Rocks.
> 
> 
> 
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
> 
> 

Sorry for the silly question, but have you tried renaming the method ?

-- 

Marcello Romani
Responsabile IT
Ottotecnica s.r.l.
http://www.ottotecnica.com

_______________________________________________
Catalyst mailing list
Catalyst at lists.rawmode.org
http://lists.rawmode.org/mailman/listinfo/catalyst