describe 'Gratan::Client#apply' do
  context 'when create user with auto identify' do
    let(:auto_identifier) do
      identifier = Gratan::Identifier::Auto.new('/dev/null')
      allow(identifier).to receive(:mkpasswd) { 'foobarzoo' }
      identifier
    end

    subject { client(identifier: auto_identifier) }

    it do
      apply(subject) {
        <<-RUBY
user 'scott', 'localhost' do
  on '*.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end

  on 'test.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end
end
        RUBY
      }

      expect(show_grants).to match_array [
        "GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'scott'@'localhost' IDENTIFIED BY PASSWORD '*6F498C84277BCC2089932690304BD4EDABC74547'",
        "GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'scott'@'localhost'",
      ]
    end
  end

  context 'when create user with csv identify' do
    let(:csv_identifier) do
      identifier = nil

      csv = <<-CSV
scott@localhost,foobarzoo
      CSV

      tempfile(csv) do |f|
        identifier = Gratan::Identifier::CSV.new(f.path)
      end

      identifier
    end

    subject { client(identifier: csv_identifier) }

    it do
      apply(subject) {
        <<-RUBY
user 'scott', 'localhost' do
  on '*.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end

  on 'test.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end
end
        RUBY
      }

      expect(show_grants).to match_array [
        "GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'scott'@'localhost' IDENTIFIED BY PASSWORD '*6F498C84277BCC2089932690304BD4EDABC74547'",
        "GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'scott'@'localhost'",
      ]
    end
  end

  context 'when create user with csv identify (there is no password)' do
    let(:logger) do
      logger = Logger.new('/dev/null')
      expect(logger).to receive(:warn).with('[WARN] password for `scott@localhost` can not be found')
      logger
    end

    let(:csv_identifier) do
      identifier = nil

      csv = <<-CSV
scott2@localhost,foobarzoo
      CSV

      tempfile(csv) do |f|
        identifier = Gratan::Identifier::CSV.new(f.path, logger: logger)
      end

      identifier
    end

    subject do
      client(
        identifier: csv_identifier,
        logger: logger
      )
    end

    it do
      apply(subject) {
        <<-RUBY
user 'scott', 'localhost' do
  on '*.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end

  on 'test.*' do
    grant 'SELECT'
    grant 'INSERT'
    grant 'UPDATE'
    grant 'DELETE'
  end
end
        RUBY
      }

      expect(show_grants).to match_array [
        "GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'scott'@'localhost'",
        "GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'scott'@'localhost'",
      ]
    end
  end
end