class Qa::Local::TablesGenerator

Public Instance Methods

migrations() click to toggle source
# File lib/generators/qa/local/tables/tables_generator.rb, line 7
def migrations # rubocop:disable Metrics/MethodLength
  if defined?(ActiveRecord::ConnectionAdapters::Mysql2Adapter) && ActiveRecord::Base.connection.instance_of?(ActiveRecord::ConnectionAdapters::Mysql2Adapter)
    message = "Use the mysql table based generator if you are using mysql 'rails generate qa:local:tables:mysql'"
    say_status("error", message, :red)
    return 0
  end
  generate "model qa/local_authority name:string:uniq"
  generate "model qa/local_authority_entry local_authority:references label:string uri:string:uniq"
  migration_file = Dir.entries(File.join(destination_root, 'db/migrate/'))
                      .reject { |name| !name.include?('create_qa_local_authority_entries') }.first
  migration_file = File.join('db/migrate', migration_file)
  gsub_file migration_file,
            /t\.references :local_authority.*/,
            't.references :local_authority, foreign_key: { to_table: :qa_local_authorities }, index: true'
  message = "Rails doesn't support functional indexes in migrations, so you'll have to add this manually:\n" \
            "CREATE INDEX \"index_qa_local_authority_entries_on_lower_label\" ON \"qa_local_authority_entries\" (local_authority_id, lower(label))\n" \
            "   OR on Sqlite: \n" \
            "CREATE INDEX \"index_qa_local_authority_entries_on_lower_label\" ON \"qa_local_authority_entries\" (local_authority_id, label collate nocase)\n"
  say_status("info", message, :yellow)
end