On 7/8/06 11:22 AM, Ash Berlin wrote:
> John Siracusa wrote:
>> Another alternative is:
>>
>> INSERT INTO foo (anycol) VALUES (DEFAULT);
>>
>> That works in MySQL and Postgres, where anycol is literally any column in
>> the table.
>>
>> That said, so far, I haven't found a syntax that works "everywhere." This
>> type of thing has to be constructed on a case-by-case basis for each db.
>
> To do that in DBIx:
>
> $rs->create({ anycol => \'DEFAULT' });
>
> But still not portable
When I said "constructed on a case-by-case basis," I meant by the library,
not the user. So you'd do this:
$rs->create({});
and it'd Do The Right Thing for whatever db $rs is connected to.
(or $rs->create(), if that's not too scary for some people :)
-John
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
