Class: Dbsketch::Rendering::SQL::DatabaseRenderer

Inherits:
Object
  • Object
show all
Defined in:
lib/dbsketch/rendering/sql/database_renderer.rb

Instance Method Summary collapse

Constructor Details

#initialize(index_renderer: nil, operation_renderer: nil, table_renderer: nil, trigger_renderer: nil, view_renderer: nil, options: {}) ⇒ DatabaseRenderer

Returns a new instance of DatabaseRenderer.

Raises:

  • (ArgumentError) 


19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/dbsketch/rendering/sql/database_renderer.rb', line 19

def initialize index_renderer: nil, operation_renderer: nil, table_renderer: nil, trigger_renderer: nil, view_renderer: nil, options: {}
  ### Preconditions

  raise ArgumentError, "index_renderer is not a Dbsketch::Rendering::SQL::IndexRenderer" unless nil == index_renderer or index_renderer.is_a? IndexRenderer
  raise ArgumentError, "operation_renderer is not a Dbsketch::Rendering::SQL::OperationRenderer" unless nil == operation_renderer or operation_renderer.is_a? OperationRenderer
  raise ArgumentError, "table_renderer is not a Dbsketch::Rendering::SQL::TableRenderer" unless nil == table_renderer or table_renderer.is_a? TableRenderer
  raise ArgumentError, "trigger_renderer is not a Dbsketch::Rendering::SQL::TriggerRenderer" unless nil == trigger_renderer or trigger_renderer.is_a? TriggerRenderer
  raise ArgumentError, "view_renderer is not a Dbsketch::Rendering::SQL::ViewRenderer" unless nil == view_renderer or view_renderer.is_a? ViewRenderer
  raise ArgumentError, "options is not a Hash" unless options.is_a? Hash
  raise ArgumentError, "options[:drop_if_exists] has not a value in [:before, :inline]" unless [nil, :before, :inline].include? options[:drop_if_exists]
  raise ArgumentError, "options[:order_by_dependencies] == true is not compatible with options[:drop_if_exists] == :inline" if options[:order_by_dependencies] and :inline == options[:drop_if_exists]
  ###

  @options = {
    :drop_if_exists     => nil,
    :go_statements      => true,
    :order_by_dependencies  => true,
    :pretty         => false,
  }.merge options
  @index_renderer = (nil == index_renderer ? IndexRenderer.new : index_renderer)
  @operation_renderer = (nil == operation_renderer ? OperationRenderer.new : operation_renderer)
  @table_renderer = (nil == table_renderer ? TableRenderer.new(:options => @options) : table_renderer)
  @trigger_renderer = (nil == trigger_renderer ? TriggerRenderer.new : trigger_renderer)
  @view_renderer = (nil == view_renderer ? ViewRenderer.new : view_renderer)
end

Instance Method Details

#alter(database_diff) ⇒ Object

Raises:

  • (ArgumentError) 


57
58
59
60
61
62
63
64
65
66
67
68
69
 
# File 'lib/dbsketch/rendering/sql/database_renderer.rb', line 57

def alter database_diff
  ### Preconditions

  raise ArgumentError, "database_diff is not a Dbsketch::Comparison::DatabaseDiff" unless database_diff.is_a? Dbsketch::Comparison::DatabaseDiff
  ###

  separator = ";\n" + (@options[:go_statements] ? "go\n" : '')

  diffs = database_diff.indexes + database_diff.operations + database_diff.tables + database_diff.triggers + database_diff.views
  deletions = diffs.select { |d| d.deletion? }.map { |i| drop_item i.old_value }
  changes = diffs.select { |d| d.change? }.map { |i| alter_item(i) }
  creations = diffs.select { |d| d.addition? }.map { |i| create_item i.new_value }

  (deletions + changes + creations).flatten.compact.join(separator) + separator
end

#create(database) ⇒ Object

Raises:

  • (ArgumentError) 


43
44
45
46
47
48
49
50
51
52
53
54
55
 
# File 'lib/dbsketch/rendering/sql/database_renderer.rb', line 43

def create database
  ### Preconditions

  raise ArgumentError, "database is not a Dbsketch::Model::Database" unless database.is_a? Dbsketch::Model::Database
  ###

  database.order_items! if @options[:order_by_dependencies]
  if :before == @options[:drop_if_exists]
    drop_before_and_create database
  elsif :inline == @options[:drop_if_exists]
    drop_inline_and_create database
  else
    only_create database
  end
end