Rails:从现有表创建模型? [英] Rails: Creating models from existing tables?

问题描述

我已经从不同的项目创建了表.他们的名字的格式类似于 aaa_bbb_ccc_ddd(所有非复数和某些部分不是约定词).通过阅读 这个.但现在我必须制作实际模型.我查看了 RMRE，但他们在我的表上强制执行 ActiveRecord 约定并更改了它们的名称，我不想这样做，因为其他应用程序依赖于这些表.

I have tables already created from a different project. Their names are formatted like aaa_bbb_ccc_ddd (all non plural and some parts aren't a convention word). I have successfully created a schema from the database by reading this. But now I have to make the actual models. I've looked at RMRE, but they enforce the ActiveRecord convention on my tables and change their names, which I don't want to do because other apps depend on those tables.

从现有表自动创建模型和架构的最佳方法是什么?

What is the best way to automatically create models and a schema from existing tables?

推荐答案

只是一个理论，不确定这在实际应用中如何工作:

just a theory, not sure how this would work in real app:

create models 命名为 ActiveRecord 约定需要，例如对于表 aaa_bbb_ccc_ddd 你将创建一个模型 AaaBbb> 并将此模型映射到您的表:

create models named as ActiveRecord convention requires, for example for table aaa_bbb_ccc_ddd you'll create a model AaaBbb and map this model to your table:

class AaaBbb < ActiveRecord::Base
    self.table_name = "aaa_bbb_ccc_ddd"
end

或更人性化的例子:

class AdminUser < ActiveRecord::Base
    self.table_name = "my_wonderfull_admin_users"
end

现在你将有 AaaBbb 作为路由中的资源，这意味着你将有一个像:

Now you'll have AaaBbb as resource in routes meaning you'll have a url like:

 .../aaa_bbb/...

如果你想在 url 中使用表名，我想你可以重写路由:

and if you want to use the table name name in url I guess you could rewrite the route:

get 'aaa_bbb_ccc_ddd/:id', "aaa_bbb#show", as: "aaa_bbb"

再说一次，这只是一个可能对你有帮助的理论.我还没有处理过这样的案例，但会从这个开始.

again, just a theory that might help you out. I haven't worked with such cases yet but would've start from this.

编辑

从数据库自动化模型创建:

https://github.com/bosko/rmre

但我认为这将按照 Rails 约定创建具有奇怪名称的模型，您必须将其用作应用程序中的资源.

but I think this will create models by rails convention with wierd names that you'll have to use as resource in your app.

我在 SO 上找到的一个很好的模板，以防您想使用与表名不同的模型名:

A good template that I found on SO in case you want to use a model name different from table name:

class YourIdealModelName < ActiveRecord::Base
  self.table_name = 'actual_table_name'
  self.primary_key = 'ID'

  belongs_to :other_ideal_model, 
    :foreign_key => 'foreign_key_on_other_table'

  has_many :some_other_ideal_models, 
    :foreign_key => 'foreign_key_on_this_table', 
    :primary_key => 'primary_key_on_other_table'
end

这篇关于Rails:从现有表创建模型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！