update_entries.rb

#require 'config/environment'
class Entry
  attr_accessor :completed_on
end

module EntryUpdate
  def delete!(id)
    if entry = Entry.find(id)
      entry.destroy
    end
  end
  
  def create(*args, &block)
    entry = Entry.new
    yield entry if block_given?
    entry.save
  end
  
  def update(*args, &block)
    entry = Entry.find(args.shift)
    yield entry if block_given?
    entry.save
  end
end

extend EntryUpdate

# Start updating stuff

# nullify completed_on for entry 378
update 378 do |entry|
  entry.completed_on = nil
end

# create an entry for diary 69
create do |entry|
  entry.entry_type_id = 11
  entry.diary_id = 69
  entry.occurred_on = DateTime.parse('08/05/2012 00:08:00')
  entry.completed_on = nil
  entry.created_at = DateTime.parse('08/06/2012 05:08:00')
  entry.entry_by = nil
end

# change entry_type_id to 12 for entry 1014
update 1014 do |entry|
  entry.entry_type_id = 12
end

# Delete entry 1045
delete! 1045

# Delete entry 1126
delete! 1126

# Update entry 1127
update 1127 do |entry|
  entry.entry_type_id = 14
end

# Update entry 1170
update 1170 do |entry|
  entry.entry_type_id = 15
end

# Update entry 1283
update 1283 do |entry|
  entry.entry_type_id = 10
end

# Update entry 1284
update 1284 do |entry|
  entry.entry_type_id = 11
end

# Update entry 1313
update 1313 do |entry|
  entry.entry_type_id = 12
end

# Update entry 1329
update 1329 do |entry|
  entry.entry_type_id = 13
end

# create a new entry for diary 87
create do |entry|
  entry.entry_type_id = 14
  entry.diary_id = 87
  entry.occurred_on = DateTime.parse('08/27/2012 03:47:00')
  entry.completed_on = nil
  entry.created_at = DateTime.parse('08/29/2012 07:47:00')
  entry.entry_by = nil
end

# delete entry 1332
delete! 1332

# delete entry 1333
delete! 1333

# delete entry 1334
delete! 1334

# delete entry 1335
delete! 1335

# update entry 1226
update 1226 do |entry|
  entry.completed_on = nil
end

create do |entry|
  entry.entry_type_id = 14
  entry.diary_id = 96
  entry.occurred_on = DateTime.parse('09/03/2012 03:00:00')
  entry.completed_on = nil
  entry.created_at = DateTime.parse('09/04/2012 08:00:00')
  entry.entry_by = nil
end

# update entry 1436
update 1436 do |entry|
  entry.entry_type_id = 15
end

# update entry 1436
update 1436 do |entry|
  entry.entry_type_id = 15
end

# delete entry 1472
delete! 1472

# update entry 1473
update 1473 do |entry|
  entry.entry_type_id = 5
end