Skip to content

Latest commit

 

History

History
31 lines (21 loc) · 982 Bytes

README.md

File metadata and controls

31 lines (21 loc) · 982 Bytes

ActiveRecord::Mysql::Structure

This gem improves ActiveRecord's dumping of MySQL schema to a structure.sql file.

  • AUTO_INCREMENT values will not be written, preventing noisy diffs
  • comments starting with -- will not be written
  • MySQL SET directives starting with /* will not be written
  • removes extra newline at the bottom of the file

Installation

Add this line to your application's Gemfile:

gem 'activerecord-mysql-structure'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-mysql-structure

For rails projects, there is no additional step; activerecord-mysql-structure will hook into your application automagically. For non-rails projects, you can use the structure.sql sanitizing utility manually as follows:

sanitized_content = ActiveRecordMySqlStructure::StructureSqlSanitizer.sanitize(path_to_default_structure_sql)
File.write(path_to_sanitized_structure_sql, sanitized_content)