Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

This queue is for tickets about the Class-DBI-Plugin-Backtickify CPAN distribution.

Report information
The Basics
Id: 18519
Status: open
Priority: 0/
Queue: Class-DBI-Plugin-Backtickify

People
Owner: Nobody in particular
Requestors: nechaev [...] technodesign.ru
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.02
Fixed in: (no value)



Subject: Not worked with Class::DBI::Sweet ?
Download (untitled) / with headers
text/plain 970b
I have "Class::DBI::Sweet" class that use mysql table "Order". To avoid sql syntax error, i unsuccessfully try use "Class::DBI::Plugin:: Backtickify" module. I use search method. When i turn on mysql query log i see wrong query FROM clause: ---------------------------------------------------------------- SELECT `me`.`iduseragent`, `me`.`txtlog`, `me`.`intcount`, `me`. `lsttype`, `me`.`lstname` FROM order me WHERE ( me.lstType = 'mobile' ) ---------------------------------------------------------------- If i change use base 'Class::DBI::Sweet'; with old use base 'Class::DBI'; i get correct query: ---------------------------------------------------------------- SELECT `iduseragent`, `txtlog`, `intcount`, `lsttype`, `lstname` FROM `order` WHERE `lsttype` = 'mobile' ---------------------------------------------------------------- Is this a bug or "Class::DBI::Plugin::Backtickify" just unsupport "Class::DBI::Sweet"? Thanks. Maxim Nechaev
Subject: Re: [rt.cpan.org #18519] Not worked with Class::DBI::Sweet ?
Date: Fri, 14 Apr 2006 19:16:35 +0100
To: bug-Class-DBI-Plugin-Backtickify [...] rt.cpan.org
From: "David Baird" <dave [...] zerofive.co.uk>
Download (untitled) / with headers
text/plain 1.7k
On 4/4/06, Guest via RT <bug-Class-DBI-Plugin-Backtickify@rt.cpan.org> wrote: Show quoted text
> > Tue Apr 04 01:48:19 2006: Request 18519 was acted upon. > Transaction: Ticket created by guest > Queue: Class-DBI-Plugin-Backtickify > Subject: Not worked with Class::DBI::Sweet ? > Owner: Nobody > Requestors: nechaev@technodesign.ru > Status: new > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=18519 > > > > I have "Class::DBI::Sweet" class that use mysql table "Order". To avoid > sql syntax error, i unsuccessfully try use "Class::DBI::Plugin:: > Backtickify" module. > > I use search method. When i turn on mysql query log i see wrong query > FROM clause: > ---------------------------------------------------------------- > SELECT `me`.`iduseragent`, `me`.`txtlog`, `me`.`intcount`, `me`. > `lsttype`, `me`.`lstname` > FROM order me > WHERE ( me.lstType = 'mobile' ) > ---------------------------------------------------------------- > > If i change > use base 'Class::DBI::Sweet'; > with old > use base 'Class::DBI'; > i get correct query: > ---------------------------------------------------------------- > SELECT `iduseragent`, `txtlog`, `intcount`, `lsttype`, `lstname` > FROM `order` > WHERE `lsttype` = 'mobile' > ---------------------------------------------------------------- > > Is this a bug or "Class::DBI::Plugin::Backtickify" just unsupport > "Class::DBI::Sweet"? >
Hi Maxim, I've never used Class::DBI::Sweet, and if it works OK with Class::DBI, I'd say it just doesn't support CDBI::Sweet. But if you can come up with a fix, I'd be glad to apply it. From what I can remember, Backtickify is a reasonably ugly hack. It is probably overriding methods that are also overridden by CDBI::Sweet. Cheers, Dave.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.