Class: ActiveRecord::Tasks::RedshiftDatabaseTasks
- Inherits:
-
Object
- Object
- ActiveRecord::Tasks::RedshiftDatabaseTasks
- Defined in:
- lib/active_record/tasks/redshift_7_0_tasks.rb,
lib/active_record/tasks/redshift_7_1_tasks.rb,
lib/active_record/tasks/redshift_7_2_tasks.rb
Overview
:nodoc:
Constant Summary collapse
- DEFAULT_ENCODING =
ENV["CHARSET"] || "utf8"
- ON_ERROR_STOP_1 =
"ON_ERROR_STOP=1"
- SQL_COMMENT_BEGIN =
"--"
Class Method Summary collapse
Instance Method Summary collapse
- #charset ⇒ Object
- #collation ⇒ Object
- #create(connection_already_established = false) ⇒ Object
- #drop ⇒ Object
-
#initialize(db_config) ⇒ RedshiftDatabaseTasks
constructor
A new instance of RedshiftDatabaseTasks.
- #purge ⇒ Object
- #structure_dump(filename, extra_flags) ⇒ Object
- #structure_load(filename, extra_flags) ⇒ Object
Constructor Details
#initialize(db_config) ⇒ RedshiftDatabaseTasks
Returns a new instance of RedshiftDatabaseTasks.
21 22 23 24 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 21 def initialize(db_config) @db_config = db_config @configuration_hash = db_config.configuration_hash end |
Class Method Details
.using_database_configurations? ⇒ Boolean
17 18 19 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 17 def self.using_database_configurations? true end |
Instance Method Details
#charset ⇒ Object
37 38 39 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 37 def charset connection.encoding end |
#collation ⇒ Object
41 42 43 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 41 def collation connection.collation end |
#create(connection_already_established = false) ⇒ Object
26 27 28 29 30 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 26 def create(master_established = false) establish_master_connection unless master_established connection.create_database(db_config.database, configuration_hash.merge(encoding: encoding)) establish_connection(db_config) end |
#drop ⇒ Object
32 33 34 35 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 32 def drop establish_master_connection connection.drop_database(db_config.database) end |
#purge ⇒ Object
45 46 47 48 49 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 45 def purge clear_active_connections! drop create true end |
#structure_dump(filename, extra_flags) ⇒ Object
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 80 81 82 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 51 def structure_dump(filename, extra_flags) search_path = \ case ActiveRecord.dump_schemas when :schema_search_path configuration_hash[:schema_search_path] when :all nil when String ActiveRecord.dump_schemas end args = ["--schema-only", "--no-privileges", "--no-owner"] args.concat(["--file", filename]) args.concat(Array(extra_flags)) if extra_flags unless search_path.blank? args += search_path.split(",").map do |part| "--schema=#{part.strip}" end end ignore_tables = ActiveRecord::SchemaDumper.ignore_tables if ignore_tables.any? args += ignore_tables.flat_map { |table| ["-T", table] } end args << db_config.database run_cmd("pg_dump", args, "dumping") remove_sql_header_comments(filename) File.open(filename, "a") { |f| f << "SET search_path TO #{connection.schema_search_path};\n\n" } end |
#structure_load(filename, extra_flags) ⇒ Object
84 85 86 87 88 89 |
# File 'lib/active_record/tasks/redshift_7_0_tasks.rb', line 84 def structure_load(filename, extra_flags) args = ["--set", ON_ERROR_STOP_1, "--quiet", "--no-psqlrc", "--output", File::NULL, "--file", filename] args.concat(Array(extra_flags)) if extra_flags args << db_config.database run_cmd("psql", args, "loading") end |