Can I execute DML from within Rails?


#1

Is it possible to execute a DML statement against a MySQL database from
within Rails? I have a table I’m using for batch processing. It needs
to be
truncated to reset the primary key before each batch insert statement. I
looked at the API here:

http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532

and didn’t notice anything that looked like it would work. Thanks in
advance.


Best Regards,
-Larry
“Work, work, work…there is no satisfactory alternative.”
— E.Taft Benson