Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Peter Cooperx http://www.petercooper.co.uk/

« Newer Snippets
Older Snippets »
Showing 1-3 of 3 total  RSS 

Transactions in Rails / Active Record

transaction do
  david.withdrawal(100)
  mary.deposit(100)
end
to rails database activerecord transactions by peter on Jun 14, 2005

Rebuild indexes on a table with MySQL

REPAIR TABLE tbl_name QUICK;
to sql mysql database index by peter on May 09, 2005

Querying the DB directly from Rails

ActiveRecord::Base.connection.select_one('select sum(quantity) from table').to_i
arrayofhashes = ActiveRecord::Base.connection.select_all('select * from table')
to ruby rails database by peter on May 05, 2005
« Newer Snippets
Older Snippets »
Showing 1-3 of 3 total  RSS