require File.dirname(__FILE__) + '/test_helper'
require File.dirname(__FILE__) + '/../lib/mysql_routine_migration'


# mock
# don't save to db
class MysqlRoutine
  def save!
    self
  end
end

class MysqlRoutineMigrationTest < Test::Unit::TestCase
  
  def setup
    assert File.exists?(MysqlRoutineMigration::PROC_DIR + 'usp_test.sql'), 'Missing the test sql file in ' + MysqlRoutineMigration::PROC_DIR
  end
  
  def test_migrate_missing_files_declaration
    m = MysqlRoutineMigration
    m.script_file_names = []
	
    assert_raise(RuntimeError) { m.up }
  end
  
  def test_migrate_up
    m = MysqlRoutineMigration
    m.script_file_names = %w{ usp_test.sql }
    assert m.script_file_names.size == 1
    assert m.script_file_names[0].include?(m::PROC_DIR)
    
    assert_nothing_raised { m.up }
  end
	
  def test_migrate_down
    m = MysqlRoutineMigration
    m.script_file_names = %w{ usp_test.sql }
    assert m.script_file_names.size == 1
    assert m.script_file_names[0].include?(m::PROC_DIR)
    
    assert_nothing_raised { m.down }
  end
end