Contents

# Copyright (c) 2011 - 2013, SoundCloud Ltd., Rany Keddo, Tobias Bielohlawek, Tobias
# Schmidt

require File.expand_path(File.dirname(__FILE__)) + '/integration_helper'

describe Lhm, "cleanup" do
  include IntegrationHelper
  before(:each) { connect_master! }

  describe "changes" do
    before(:each) do
      table_create(:users)
      simulate_failed_migration do
        Lhm.change_table(:users, :atomic_switch => false) do |t|
          t.add_column(:logins, "INT(12) DEFAULT '0'")
          t.add_index(:logins)
        end
      end
    end

    after(:each) do
      Lhm.cleanup(true)
    end

    it "should show temporary tables" do
      output = capture_stdout do
        Lhm.cleanup
      end
      output.must_include("Existing LHM backup tables")
      output.must_match(/lhma_[0-9_]*_users/)
    end

    it "should show temporary triggers" do
      output = capture_stdout do
        Lhm.cleanup
      end
      output.must_include("Existing LHM triggers")
      output.must_include("lhmt_ins_users")
      output.must_include("lhmt_del")
      output.must_include("lhmt_upd_users")
    end

    it "should delete temporary tables" do
      Lhm.cleanup(true).must_equal(true)
      Lhm.cleanup.must_equal(true)
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
lhm-2.1.0	spec/integration/cleanup_spec.rb