ruby-on-rails - Ruby 函数搜索栏
问题描述
我的搜索栏功能有问题,我希望它通过我的食谱模型属性“成分”进行搜索。当我把这段代码放进去时,搜索后只给我一个空白的食谱页面没有给我任何结果。任何帮助都会很棒。我在食谱表中有成分作为文本。
这是在配方 index.html 中
<%= form_for "", url: recipes_path, role: "search", method: :get do %>
<%= text_field_tag :search, @search_term, placeholder: "Seach..." %>
<% 结束 %>
这是配方控制器
def index
@recipes = Recipe.all
# @recipes =Recipe.search(params[:search])
if params[:search]
@search_term = params[:search]
@recipes = @recipes.search_by(@search_term)
end
结尾
这是食谱模型功能
def self.search_by(search_term)
where("LOWER(ingredients) LIKE :search_term OR LOWER(title) LIKE :search_term",
search_term: "%{search_term.downcase}%")
end
这也是我进行搜索时的命令行:
Started GET "/recipes?search=chicken" for 127.0.0.1 at 2021-07-09 07:52:57 -0400
Processing by RecipesController#index as HTML
Parameters: {"search"=>"chicken"}
Rendering layout layouts/application.html.erb
Rendering recipes/index.html.erb within layouts/application
User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC LIMIT ? [["id", 3], ["LIMIT", 1]]
↳ app/views/recipes/index.html.erb:13
Recipe Load (0.2ms) SELECT "recipes".* FROM "recipes" WHERE (LOWER(ingredients) LIKE '%{search_term.downcase}%' OR LOWER(title) LIKE '%{search_term.downcase}%')
↳ app/views/recipes/index.html.erb:70
Rendered recipes/index.html.erb within layouts/application (Duration: 5.0ms | Allocations: 2463)
[Webpacker] Everything's up-to-date. Nothing to do
Rendered layouts/_alerts.html.erb (Duration: 0.1ms | Allocations: 41)
Rendered layout layouts/application.html.erb (Duration: 11.0ms | Allocations: 7781)
Completed 200 OK in 12ms (Views: 11.1ms | ActiveRecord: 0.3ms | Allocations: 8360)
有谁知道为什么不搜索食谱成分?先感谢您。
解决方案
search_by 方法中的插值是错误的。
你写"%{search_term.downcase}%"
的时候正确的是"%#{search_term.downcase}%"
。错过了#
!
def self.search_by(search_term)
where("LOWER(ingredients) LIKE :search_term OR LOWER(title) LIKE :search_term",
search_term: "%#{search_term.downcase}%")
end
推荐阅读
- python - 如何在python中创建一个以参数为条件的嵌套列表
- python - 将 pytorch 模型转换为 Coreml 时出错。层有 1 个输入,但预计至少有 2 个
- angular - Angular 11 Ngxs-Storage-Plugin 恢复日期
- c - 访问被拒绝 c 程序
- python - 使用任何关键字都不是按要求过滤
- byte-buddy - ByteBuddy 调用生成类的构造函数
- javascript - 用“Normalizr”可视化 API 响应的更好方法
- html - 我到底怎么把这个 div 放在前面
- python - 将 Python 脚本与不同的 GUI 相结合
- php - 如何在 MacOS XAMPP 中启用 intl 扩展(PHP 版本 7.4.14)