Home / server / Questions / 785499
Accepted
A1001
Asked: 2016-06-23 01:28:42 +0800 CST

serverspec if statement for mysql version on server

  • 772

Is there a way to check which package installed on server by command output?

describe command('mysql -e "select version();"') do
  if its(:stdout) { should =~ /5.6.27-76.0-log/ } 
    describe package('MySQL-client') do
    it { should be_installed }
  else
    describe package('Percona-client') do
    it { should be_installed }
  end
end

Thanks,

mysql testing automated-testing serverspec

1 Answers

  1. Best Answer

    Well, I could not invent a way better then this:

    def mysql_version
  command('mysql -e "select version();"').stdout
end

def plain_mysql?
  mysql_version =~ /5.6.27-76.0-log/
end

def mysql_package_name
  if plain_mysql?
    'MySQL-client'
  else
    'Percona-client'
  end
end

describe package(mysql_package_name) do
  it { should be_installed }
end
    • 1