Patch #31485
closed
Add support for :sql ActiveRecord::Base.schema_format in redmine:plugins:migrate
Description
ActiveRecord uses db/schema.rb when ActiveRecord::Base.schema_format is :ruby and db/structure.sql when ActiveRecord::Base.schema_format is :sql.
:sql is needed to use SQL that isn't supported by Active Record's migration API.
For example, WITH of PostgreSQL's CREATE INDEX isn't supported.
I'm using SQL that isn't supported by Active Record's migration API in https://github.com/clear-code/redmine_full_text_search .
db:migrate in Rails supports :ruby and :sql.
https://github.com/rails/rails/blob/master/activerecord/lib/active_record/railties/databases.rake#L91-L93
So it's better that redmine:plugins:migrate also supports :ruby and :sql.
Files
Related issues
Updated by Go MAEDA over 6 years ago
Kouhei Sutou wrote:
db:migratein Rails supports:rubyand:sql.
https://github.com/rails/rails/blob/master/activerecord/lib/active_record/railties/databases.rake#L91-L93
It was added by this commit for Rails 3.2.0.
https://github.com/rails/rails/commit/15fb4302b6ff16e641b6279a3530eb8ed97f2899
Updated by Go MAEDA over 6 years ago
- Status changed from New to Closed
- Assignee set to Go MAEDA
Committed the patch. Thank you.
Updated by Go MAEDA almost 3 years ago
- Related to Defect #38199: Fix deprecation warning for db:structure:dump in db:migrate when using sql schema format added