summaryrefslogtreecommitdiffstats
path: root/plugins/puppet/provider/mysql_schema/mysql.rb
blob: 2b582c1a21ad901f0658698f3e4a526db89234d5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
require 'puppet/provider/package'

Puppet::Type.type(:mysql_schema).provide(:mysql) do

  desc "Create a Mysql schema."
  commands :mysqladmin => '/usr/bin/mysqladmin'
  commands :mysql => '/usr/bin/mysql'

  def create
    # Pipe the ddl to mysql
    open("| #{command(:mysql)} -u root -p#{@resource[:rootpw]} #{@resource[:db]}", "w") do |pipe|
      pipe.puts(File.read(@resource[:name]))
    end
  end

  def destroy
    #noop
  end

  def exists?
    if mysql("-u", "root", "-p", @resource[:rootpw], "-NBe", "show tables", @resource[:db]).empty?
      false
    else
      true
    end
  end
end