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

Included in:
DynamicMigrations::Postgres::Server::Database::Differences::ToMigrations
Defined in:
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/enums.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/functions.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/columns.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/indexes.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/triggers.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/primary_key.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/validations.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/unique_constraints.rb,
lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas/tables/foreign_key_constraints.rb

Defined Under Namespace

Modules: Enums, Functions, Tables

Instance Method Summary collapse

Instance Method Details

#process_schema(schema_name, configuration_schema, database_schema) ⇒ Object 



10
11
12
13
14
15
16
17
18
19
20
21
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
 
# File 'lib/dynamic_migrations/postgres/server/database/differences/to_migrations/schemas.rb', line 10

def process_schema schema_name, configuration_schema, database_schema
  # if the schema exists in the configuration but not in the database
  # then we have to create it
  if configuration_schema[:exists] == true && !database_schema[:exists]
    log.debug "Schema `#{schema_name}` exists in configuration but not in the database"

    # a migration to create the schema
    schema = @database.configured_schema schema_name
    @generator.create_schema schema

    # we process the tables and functions after we create the schema
    # otherwise the schemas objects will not be able to be created
    process_functions schema_name, configuration_schema[:functions], {}
    process_enums schema_name, configuration_schema[:enums], {}
    process_tables schema_name, configuration_schema[:tables], {}

  # if the schema exists in the database but not in the configuration
  # then we need to delete it
  elsif database_schema[:exists] == true && !configuration_schema[:exists]
    log.debug "Schema `#{schema_name}` exists in database but not in the configuration"
    # we process the tables and functions before we drop the schema
    # as this will drop any dependencies on the schema
    process_functions schema_name, {}, database_schema[:functions]
    process_enums schema_name, {}, database_schema[:enums]
    process_tables schema_name, {}, database_schema[:tables]

    # a migration to drop the schema
    schema = @database.loaded_schema schema_name
    @generator.drop_schema schema

  # if the schema exists in both the configuration and database representations
  # then we just need to process the tables and functions
  else
    log.debug "Schema `#{schema_name}` exists in both configuration and the database"
    process_functions schema_name, configuration_schema[:functions], database_schema[:functions]
    process_enums schema_name, configuration_schema[:enums], database_schema[:enums]
    process_tables schema_name, configuration_schema[:tables], database_schema[:tables]
  end
end