rake db:schema:dump 不提供数据迁移信息 - 是否有自动方法来获取此信息？

发布于 2024-07-22 02:49:30 字数 545 浏览 1 评论 0原文

rake db:schema:dump

此命令为您提供旧数据库的架构，您可以根据生成的架构为该数据库构建迁移。

但是，如果该数据库中有数据，那么如果有一个 rake 命令来检索 Rails 生成的迁移文件中的数据，那就太好了。

也许我在做梦 - 认为 Rails 可以查看遗留数据库中的数据并从现有数据为您构建迁移可能要求太多 - 像这样：

class LoadDefaultData < ActiveRecord::Migration
  def self.up
    bopeep = User.find_by_username 'bopeep'
    BlogPost.create(:title => 'test', :content => 'test', :author_id => bopeep.id, :status => 'ok')
  end

  def self.down
  end
end

或者有办法吗？

原文

rake db:schema:dump

This command gives you the schema of a legacy database and you can build a migration for that database off the generated schema.

But if that database had data in it, it would be nice if there was a rake command to retrieve the data in a migration file generated by Rails.

Perhaps I'm dreaming - it's probably asking too much to think that Rails could look at the data in the legacy database and construct a migration for you from the existing data - something like this:

class LoadDefaultData < ActiveRecord::Migration
  def self.up
    bopeep = User.find_by_username 'bopeep'
    BlogPost.create(:title => 'test', :content => 'test', :author_id => bopeep.id, :status => 'ok')
  end

  def self.down
  end
end

Or is there a way?

分享到QQ

分享到微博