ruby-on-rails - HABTM-协会Insert_sql

Question

rails 3.2.3， ruby 1.9.3p194

尝试用 HABTM 相关子项目保存一个项目，我覆盖默认生成的 SQL，调用母项目和每个相关子项目的名称属性。如何正确指定关联的子项目名称？ #{record.Name}，如示例中所示，导致名称错误: #

的未定义局部变量或方法“record”

has_and_belongs_to_many :subproject, :class_name => "Project",
:join_table => "project_subproject", :foreign_key => "projectname", :association_foreign_key => "subprojectname",
:finder_sql => proc { %{SELECT `project`.* FROM `project` INNER JOIN `project_subproject` ON `project`.`name` = `project_subproject`.`subprojectname` WHERE `project_subproject`.`projectname` = '#{self.Name}' } },
#TODO: find correct expression for insert sql
:insert_sql =>  proc { %{INSERT INTO `project_subproject` (`projectname`, `subprojectname`) VALUES ( "#{self.Name}","#{record.Name}" )} }

有什么建议吗？

Answer 1

已解决，来自 Rails 3.1。发行说明:

以前，has_and_belongs_to_many 关联上的 :insert_sql 和 :delete_sql 允许您调用“record”来获取正在插入或删除的记录。这现在作为参数传递给 proc。

因此:

:insert_sql =>  proc { |record| %{INSERT INTO `project_subproject` (`projectname`, `subprojectname`) VALUES ( "#{self.Name}","#{record.Name}" )} }