#A very simple script to display rails migrations in alphabetic order

lsm.rb

#!/usr/bin/ruby 
#Util to show migrations in a nice to read format
#Highlights current version of db in red
#requires term-ansicolor gem
#usage - copy to your rails root, chmod +x lsm.rb , then ./lsm or ./lsm s to sort alphabetically

require 'date'
require 'rubygems'
require 'term/ansicolor'
include Term::ANSIColor

version = `rake db:version`
sort_alphabetically = ARGV[0] == "s"

time = version.split(":")[1]
current_version = time.chomp!.strip!
time = DateTime.parse(time).to_s
date = time.split("T")[0]
time = time.split("T")[1][0..7]
puts green
puts "Current version: " + date + " " + time
puts reset


list = `ls db/migrate`
arr = []
longest=0
list.each do |i|
  name= i[15..-5] 
  time=i[0..13]
  longest = name.length if name.length > longest 
  arr << [name,time]
end

if sort_alphabetically
  arr.sort! do |a,b| 
    a[0].downcase <=> b[0].downcase
  end
end

arr.each do |details|
  name,time = details[0], details[1]
  name.gsub! "_"," "
  spaces=(longest - name.length)+5
  colorize = true if time==current_version

  time = DateTime.parse(time).to_s
  date = time.split("T")[0]
  time = time.split("T")[1][0..7]

  puts red if colorize
  puts name + (" "*spaces) + "| " + date + " " + time

  #reset colors
  if colorize
    colorize = false
    puts reset
  end
end