[Dbix-class] SQL::Abstract : adding support for two potentially MySQL-specific functions

Rob Kinyon rob.kinyon at gmail.com
Sun Mar 8 18:49:36 GMT 2009


On Sun, Mar 8, 2009 at 07:08, Spiros Denaxas <s.denaxas at gmail.com> wrote:
> Hello,
>
> I recently contacted Matt regarding SQL::Abstract and how to add support for
> two features which I *think* are MySQL specific:
>
> 1) REPLACE (more info: http://dev.mysql.com/doc/refman/6.0/en/replace.html)
> 2) UPDATE statements on multiple tables (more info:
> http://dev.mysql.com/doc/refman/6.0/en/update.html)
>
> Please correct me if I am wrong in thinking that these are MySQL specific -
> I have not really looking into other RDBMS's.

They are certainly non-standard extensions. I'm not sure if they are
limited only to MySQL. In addition, you will want to have multi-table
DELETE supported.

> He instructed me to bounce this off this list, so here I am. I am more than
> willing to do the work for these but I'm not sure what the correct way to
> proceed is. The options
> I could think of were:
>
> a) send patch for SQL::Abstract
> b) create new module which uses SQL::Abstract as a base class
> c) create a new module alltogether

The rewrite of SQL::Abstract will support the concept of SQL dialects,
so that would fit in very nicely - if it was done. I'm not one of the
current maintainers, but I think that if you were to provide a patch
off of http://dev.catalyst.perl.org/repos/bast/SQL-Abstract/1.x/trunk,
it would be taken seriously.

Rob



More information about the DBIx-Class mailing list