Rails - :加入消毒/替换
是否可以以与 :conditions 类似的方式为 :joins 指定参数？
这是一个示例（sql 代码不相关），
named_scope :threads, {
:joins => [" LEFT JOIN groups_messages gm ON messages.id=gm.message_id AND gm.group_id IN (?) ",@group_ids_array],
:conditions => ["creator_id=? AND messages.id IN (?)", current_user_id, @message_ids_array]
}
在此示例中，:conditions 的参数将被正确插入，但是对于 :joins，我会收到错误
Association named ' LEFT JOIN groups_messages gm ON messages.id=gm.message_id and gm.group_id IN (?) ' was not found; perhaps you misspelled it?
什么函数替换 :conditions 的参数？
is it possible to specify parameters for :joins similar way as for :conditions?
here is an example (sql code is irrelevant)
named_scope :threads, {
:joins => [" LEFT JOIN groups_messages gm ON messages.id=gm.message_id AND gm.group_id IN (?) ",@group_ids_array],
:conditions => ["creator_id=? AND messages.id IN (?)", current_user_id, @message_ids_array]
}
in this example parameters for :conditions would get inserted properly, but for :joins i would get an error
Association named ' LEFT JOIN groups_messages gm ON messages.id=gm.message_id and gm.group_id IN (?) ' was not found; perhaps you misspelled it?
what function substitutes parameters for :conditions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以使用 ActiveRecord::sanitize_sql_array 方法。
You can use the ActiveRecord::sanitize_sql_array method.