% 不能用作 ActiveRecord default_scope 查询的通配符？

发布于 2024-11-29 07:20:11 字数 562 浏览 0 评论 0原文

我在 Rails 项目中使用 ActiveRecord，我的一个类如下所示：

class ServerModel < ActiveRecord::Base

  set_table_name "S985_947_MODELS_VW"
  set_primary_key "model_barcode"

  default_scope :conditions => ["FULLNAME like '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%' OR FULLNAME like '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%'"]

  acts_as_reportable
  acts_as_entity
end

我的 default_scope 方法返回格式错误的格式字符串 - %' 错误。我认为是 % 通配符造成了所有的麻烦。我也尝试过不转义 / ，所以不是这样......

你能帮我吗？

谢谢

原文

I am using ActiveRecord in my Rails project and one of my classes looks like this:

class ServerModel < ActiveRecord::Base

  set_table_name "S985_947_MODELS_VW"
  set_primary_key "model_barcode"

  default_scope :conditions => ["FULLNAME like '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%' OR FULLNAME like '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%'"]

  acts_as_reportable
  acts_as_entity
end

My default_scope method returns a malformed format string - %' error. I think it is the % wildcard that causes all the trouble. I also tried without escaping the /, so that's not it...

Could you help me?

Thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

人生戏 2024-12-06 07:20:11

将其更改为：

default_scope :conditions => ["FULLNAME like ? OR FULLNAME like ?", '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%', '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%']

Change it to:

default_scope :conditions => ["FULLNAME like ? OR FULLNAME like ?", '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%', '\/IT INFRASTRUCTURE\/HARDWARE\/SERVER\/PHYSICAL\/%']

回复收藏 0 原文

~没有更多了~