Class: Chef::Provider::Database::SqlServer

Inherits:
Chef::Provider show all
Includes:
Mixin::ShellOut
Defined in:
lib/cookbooks/database/libraries/provider_database_sql_server.rb

Direct Known Subclasses

SqlServerUser

Instance Method Summary collapse

Instance Method Details

#action_create ⇒ Object 



35
36
37
38
39
40
41
42
43
44
45
 
# File 'lib/cookbooks/database/libraries/provider_database_sql_server.rb', line 35

def action_create
  unless exists?
    begin
      Chef::Log.debug("#{@new_resource}: Creating database #{new_resource.database_name}")
      db.execute("CREATE DATABASE [#{new_resource.database_name}]").do
      @new_resource.updated_by_last_action(true)
    ensure
      close
    end
  end
end

#action_drop ⇒ Object 



47
48
49
50
51
52
53
54
55
56
57
 
# File 'lib/cookbooks/database/libraries/provider_database_sql_server.rb', line 47

def action_drop
  if exists?
    begin
      Chef::Log.debug("#{@new_resource}: Dropping database #{new_resource.database_name}")
      db.execute("DROP DATABASE #{new_resource.database_name}").do
      @new_resource.updated_by_last_action(true)
    ensure
      close
    end
  end
end

#action_query ⇒ Object 



59
60
61
62
63
64
65
66
67
68
69
70
 
# File 'lib/cookbooks/database/libraries/provider_database_sql_server.rb', line 59

def action_query
  if exists?
    begin
      #db.select_db(@new_resource.database_name) if @new_resource.database_name
      Chef::Log.debug("#{@new_resource}: Performing query [#{new_resource.sql_query}]")
      db.execute(@new_resource.sql_query).do
      @new_resource.updated_by_last_action(true)
    ensure
      close
    end
  end
end

#load_current_resource ⇒ Object 



27
28
29
30
31
32
33
 
# File 'lib/cookbooks/database/libraries/provider_database_sql_server.rb', line 27

def load_current_resource
  Gem.clear_paths
  require 'tiny_tds'
  @current_resource = Chef::Resource::Database.new(@new_resource.name)
  @current_resource.database_name(@new_resource.database_name)
  @current_resource
end