Module: DynamicMigrations::Postgres::Server::Database::Differences::ToMigrations::Schemas::Tables::ForeignKeyConstraints

Included in:
DynamicMigrations::Postgres::Server::Database::Differences::ToMigrations
Defined in:
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/foreign_key_constraints.rb

Instance Method Summary collapse

Instance Method Details

#process_foreign_key_constraint(schema_name, table_name, foreign_key_constraint_name, configuration_foreign_key_constraint, database_foreign_key_constraint) ⇒ Object 



22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
 
# File 'lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/foreign_key_constraints.rb', line 22

def process_foreign_key_constraint schema_name, table_name, foreign_key_constraint_name, configuration_foreign_key_constraint, database_foreign_key_constraint
  # If the foreign_key_constraint exists in the configuration but not in the database
  # then we have to create it.
  if configuration_foreign_key_constraint[:exists] == true && !database_foreign_key_constraint[:exists]
    log.debug "    Foreign Key Constraint `#{foreign_key_constraint_name}` exists in configuration but not in the database"

    # a migration to create the foreign_key_constraint
    foreign_key_constraint = @database.configured_schema(schema_name).table(table_name).foreign_key_constraint(foreign_key_constraint_name)
    @generator.add_foreign_key_constraint foreign_key_constraint

  # If the schema exists in the database but not in the configuration
  # then we need to delete it.
  elsif database_foreign_key_constraint[:exists] == true && !configuration_foreign_key_constraint[:exists]
    log.debug "    Foreign Key Constraint `#{foreign_key_constraint_name}` exists in database but not in the configuration"

    # a migration to create the foreign_key_constraint
    foreign_key_constraint = @database.loaded_schema(schema_name).table(table_name).foreign_key_constraint(foreign_key_constraint_name)
    @generator.remove_foreign_key_constraint foreign_key_constraint

  # If the foreign_key_constraint exists in both the configuration and database representations
  # but the definition (except description, which is handled seeprately below) is different
  # then we need to update the definition.
  elsif configuration_foreign_key_constraint.except(:exists, :description).filter { |name, attributes| attributes[:matches] == false }.any?
    log.debug "    Foreign Key Constraint `#{foreign_key_constraint_name}` exists in both configuration and the database"

    log.debug "      Foreign Key Constraint `#{foreign_key_constraint_name}` is different"
    # recreate the foreign_key_constraint
    original_foreign_key_constraint = @database.loaded_schema(schema_name).table(table_name).foreign_key_constraint(foreign_key_constraint_name)
    updated_foreign_key_constraint = @database.configured_schema(schema_name).table(table_name).foreign_key_constraint(foreign_key_constraint_name)
    @generator.recreate_foreign_key_constraint original_foreign_key_constraint, updated_foreign_key_constraint
    # does the description also need to be updated
    if configuration_foreign_key_constraint[:description][:matches] == false
      # if the description was removed
      if configuration_foreign_key_constraint[:description].nil?
        log.debug "      Foreign Key Constraint `#{foreign_key_constraint_name}` description exists in database but not in the configuration"
        @generator.remove_foreign_key_constraint_comment updated_foreign_key_constraint
      else
        log.debug "      Foreign Key Constraint `#{foreign_key_constraint_name}` does not match"
        @generator.set_foreign_key_constraint_comment updated_foreign_key_constraint
      end
    end

  # If the foreign_key_constraint exists in both the configuration and database representations
  # but the description is different then we need to update the description.
  elsif configuration_foreign_key_constraint[:description][:matches] == false
    log.debug "    Foreign Key Constraint `#{foreign_key_constraint_name}` exists in both configuration and the database"

    foreign_key_constraint = @database.configured_schema(schema_name).table(table_name).foreign_key_constraint(foreign_key_constraint_name)
    # if the description was removed
    if configuration_foreign_key_constraint[:description].nil?
      log.debug "      Foreign Key Constraint `#{foreign_key_constraint_name}` description exists in database but not in the configuration"
      @generator.remove_foreign_key_constraint_comment foreign_key_constraint
    else
      log.debug "      Foreign Key Constraint `#{foreign_key_constraint_name}` description does not match"
      @generator.set_foreign_key_constraint_comment foreign_key_constraint
    end
  end
end

#process_foreign_key_constraints(schema_name, table_name, configuration_foreign_key_constraints, database_foreign_key_constraints) ⇒ Object 



12
13
14
15
16
17
18
19
20
 
# File 'lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/foreign_key_constraints.rb', line 12

def process_foreign_key_constraints schema_name, table_name, configuration_foreign_key_constraints, database_foreign_key_constraints
  # process all the foreign_key_constraints
  log.debug "    Processing Foreign Key Constraints"
  foreign_key_constraint_names = (configuration_foreign_key_constraints.keys + database_foreign_key_constraints.keys).uniq
  foreign_key_constraint_names.each do |foreign_key_constraint_name|
    log.debug "    Processing Foreign Key Constraint #{foreign_key_constraint_name}"
    process_foreign_key_constraint schema_name, table_name, foreign_key_constraint_name, configuration_foreign_key_constraints[foreign_key_constraint_name] || {}, database_foreign_key_constraints[foreign_key_constraint_name] || {}
  end
end