Talk Like A Duck

	# == Schema Information
	# Schema version: 14
	#
	# Table name: items
	#
	#  id          :integer(11)   not null, primary key
	#  description :string(255)   
	#  name        :string(255)   
	#  price       :integer(11)   
	#

	# Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html
	lotr1:
	  id: 1
	  name: LOTR1
	  description: The Road Goes Ever On
	lotr2:
	  id: 2
	  name: LOTR2
	  description: Introduction to Elvish

  #!/usr/bin/env ruby -w  
  #
  #  Created by Rick DeNatale on 2007-10-09.
  #  Copyright (c) 2007. You may use this under the ruby license.                    

  $LOAD_PATH << "#{ENV['TM_SUPPORT_PATH']}/lib"
  require 'exit_codes.rb'


  class FixtureSnipGen
    attr_reader :rails_root, :table_name
    def initialize(fixture_file)
      match  = %r{(.*)test/fixtures/(.*).yml}.match(ENV["TM_FILEPATH"])
      @rails_root = match[1]
      @table_name = match[2]
      @no_id = false  
    end

    def next_id
      max_id = 0     
      while line = gets
        claimed = %r{\s+id:\s+(\d+)}.match(line) 
        max_id = [max_id, claimed[1].to_i].max if claimed
      end
      max_id + 1
    end

    def gen_snippet
      cols = gen_columns
      if cols
        puts "${1:NameMe}:"
        puts "  id: #{next_id}" unless @no_id
        puts cols.join("\n")
      else 
        puts "Couldn't find #{table_name} in schema.rb"
        TextMate.exit_show_tool_tip
      end
      puts "$0"
    end

    def schema_file_name  
      "#{rails_root}db/schema.rb"
    end 

    def value_tab(text)
      @tab_stop += 1
      (@tab_stop < 10) ? "${#{@tab_stop}:#{text}}" : " # #{text}"
    end


    def gen_columns
      #    raise Exception.new("No schema file") unless File.exist?(schema_file_name)
      started = false
      @tab_stop = @no_id ? 0 : 1
      result = []
      File.new(schema_file_name).each do | line |
        if started
          break if %r{^(\s*)create_table\s+}.match(line)
          col_match = %r{\.column\s+\"(.*)\"\s*,\s*:(\w+)}.match(line)
          result << "  #{col_match[1]}: #{value_tab(col_match[2])}" if col_match
        else
          started = %r{^(\s*)create_table\s+["']#{table_name}['"]}.match(line)
          @no_id = %r{:id\s+=>\s+false}.match(line) if started
        end
      end
      return result.empty? ? nil : result    
    end
  end

  begin
    FixtureSnipGen.new(ENV["TM_FILEPATH"]).gen_snippet
  rescue Exception => ex
    puts ex
    TextMate.exit_show_tool_tip
  end

class MyTest < Test::Unit::TestCase

  def self.been_here
    result = @been_here
    @been_here = true
     result
   end

  class RowCounter < ActiveRecord::Base
  end

  def setup
    unless self.class.been_here
      File.open("#{RAILS_ROOT}/data_dump_#{Time.now.strftime("%m%d%H%M%S")}", "w") do |file|
        Account.connection.tables.each do |table_name|
          RowCounter.table_name = table_name
          file.puts "#{table_name}:  #{RowCounter.count}"
        end
      end
    end
    # The rest of your setup code goes here
  end

# And the rest of the TestCase code here
end

rails_developer@hogwarts.edu.magic.uk/cauldron_project/trunk$ cat data_dump_0717105533
students:  17
professors:  2
owls:  2
potions:  2
magical_creatures:  2
muggles:  0

  def self.been_here
    result = @been_here
    @been_here = true
    result
  end

  class RowCounter < ActiveRecord::Base
  end

  def dump_table_counts(file_name)
    File.open(file_name, "w") do |file|
      Account.connection.tables.each do |table_name|
        RowCounter.table_name = table_name
        file.puts "#{table_name}:  #{RowCounter.count}"
      end
    end
  end

  def setup
    dump_table_counts("#{RAILS_ROOT}/data_dump_#{Time.now.strftime("%m%d%H%M%S")}") unless self.class.been_here

    # rest of setup code here
  end