[Dbix-class] Migration from Class::DBI: Delete all table entries?

Matt S Trout dbix-class at trout.me.uk
Tue Jun 27 21:07:19 CEST 2006


A. Pagaltzis wrote:
> * Steven Mackenzie <dbix at aptile.co.uk> [2006-06-27 18:45]:
>> In some Class::DBI code, I have this in my table base class:
>>
>> __PACKAGE__->set_sql("delete_all", <<"");
>> DELETE FROM __TABLE__ WHERE 1=1
> 
> Note that you can omit that `WHERE` clause completely. It’s legal
> syntax to say `DELETE FROM $table`.

Which is exactly what DBIx::Class will do given the code snippet in my last 
message :)

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list