首页 \ 问答 \ 使用范围配置Sunspot Solr搜索(Configure Sunspot Solr search with scope)

使用范围配置Sunspot Solr搜索(Configure Sunspot Solr search with scope)

 调节器  
class GearsController < ApplicationController
  before_action :set_gear, only: [:show, :edit, :update, :destroy]

  def primary
    @gears = Gear.search do
      with(:Lab, 'Primary')
      order_by(:RU, :desc)
    end
  end
 
 模型  
class Gear < ActiveRecord::Base
  validates_uniqueness_of :Nic1mac, :Nic2mac, :Nic3mac, :IBmac, :SN, :allow_blank => true
  attr_readonly :Devtype, :Nic1mac, :Nic2mac, :Nic3mac, :IBmac, :SN

  scope :Mini, -> { where(lab: 'Mini') }
  scope :Primary, -> { where(lab: 'Primary') }
  scope :Support, -> { where(lab: 'Support') }
  scope :M5, -> { where(lab: 'M5') }
  scope :P5, -> { where(lab: 'P5') }

  searchable do
    integer :RU
    text :Devname
    text :Devtype
    string :Lab
    text :Swportib
    text :Swport1
    text :Swport2
    text :Swport3
    text :IBip
    text :Nic1
    text :Nic2
    text :Nic3
    text :Nic1mac
    text :Nic2mac
    text :Nic3mac
    text :IBmac
    text :Psu1
    text :Psu2
    text :SN
 end
end
 
 视图  
<% provide(:title, "SP4 Primary") %>
<p id="notice"><%= notice %></p>

<h1>SP4 Primary</h1>

<%= form_tag gears_path, :method => :get do %>
  <p>
    <%= text_field_tag :search, params[:search] %>
    <%= submit_tag "Search", :name => nil %>
  </p>
<% end %>

<head>
<style>
table, th, td { border: 1px solid black;}
th, td { padding: 15px;}
</style>
</head>

<table>
  <thead>
   <tr>
      <th>RU</th>
      <th>Dev Name</th>
      <th>Dev Type</th>
      <th>Lab</th>
      <th>SW PortIB</th>
      <th>SW Port1</th>
      <th>SW Port2</th>
      <th>SW Port3</th>
      <th>IB IP</th>
      <th>NIC1</th>
      <th>NIC2</th>
      <th>NIC3</th>
      <th>NIC1 Mac</th>
      <th>NIC2 Mac</th>
      <th>NIC3 Mac</th>
      <th>IB Mac</th>
      <th>PSU1</th>
      <th>PSU2</th>
      <th>SN</th>
      <th colspan="3"></th>
    </tr>
  </thead>
<tbody>
    <% @gears.each do |gear| %>
      <tr>
        <td><%= gear.RU %></td>
        <td><%= gear.Devname %></td>
        <td><%= gear.Devtype %></td>
        <td><%= gear.Lab %></td>
        <td><%= gear.Swportib %></td>
        <td><%= gear.Swport1 %></td>
        <td><%= gear.Swport2 %></td>
        <td><%= gear.Swport3 %></td>
        <td><%= gear.IBip %></td>
        <td><%= gear.Nic1 %></td>
        <td><%= gear.Nic2 %></td>
        <td><%= gear.Nic3 %></td>
        <td><%= gear.Nic1mac %></td>
        <td><%= gear.Nic2mac %></td>
        <td><%= gear.Nic3mac %></td>
        <td><%= gear.IBmac %></td>
        <td><%= gear.Psu1 %></td>
        <td><%= gear.Psu2 %></td>
        <td><%= gear.SN %></td>
        <td><%= link_to 'Show', gear %></td>
        <td><%= link_to 'Edit', edit_gear_path(gear) %></td>
        <td><%= link_to 'Destroy', gear, method: :delete, data: { confirm: 'Are you sure?' } %></td>
      </tr>
    <% end %>
  </tbody>
</table>

<br>
 
 以上是我的控制器和型号代码。 我正在尝试设置搜索，因此它只搜索指定范围内的记录。 目前它将返回所有结果，并不注意范围。 我相信我已接近使它工作，但只是没有正确的语法。 然后我可能是错的，因此欢迎任何帮助建议或不同的方式。 

Controller 
class GearsController < ApplicationController
  before_action :set_gear, only: [:show, :edit, :update, :destroy]

  def primary
    @gears = Gear.search do
      with(:Lab, 'Primary')
      order_by(:RU, :desc)
    end
  end
 
Model 
class Gear < ActiveRecord::Base
  validates_uniqueness_of :Nic1mac, :Nic2mac, :Nic3mac, :IBmac, :SN, :allow_blank => true
  attr_readonly :Devtype, :Nic1mac, :Nic2mac, :Nic3mac, :IBmac, :SN

  scope :Mini, -> { where(lab: 'Mini') }
  scope :Primary, -> { where(lab: 'Primary') }
  scope :Support, -> { where(lab: 'Support') }
  scope :M5, -> { where(lab: 'M5') }
  scope :P5, -> { where(lab: 'P5') }

  searchable do
    integer :RU
    text :Devname
    text :Devtype
    string :Lab
    text :Swportib
    text :Swport1
    text :Swport2
    text :Swport3
    text :IBip
    text :Nic1
    text :Nic2
    text :Nic3
    text :Nic1mac
    text :Nic2mac
    text :Nic3mac
    text :IBmac
    text :Psu1
    text :Psu2
    text :SN
 end
end
 
View 
<% provide(:title, "SP4 Primary") %>
<p id="notice"><%= notice %></p>

<h1>SP4 Primary</h1>

<%= form_tag gears_path, :method => :get do %>
  <p>
    <%= text_field_tag :search, params[:search] %>
    <%= submit_tag "Search", :name => nil %>
  </p>
<% end %>

<head>
<style>
table, th, td { border: 1px solid black;}
th, td { padding: 15px;}
</style>
</head>

<table>
  <thead>
   <tr>
      <th>RU</th>
      <th>Dev Name</th>
      <th>Dev Type</th>
      <th>Lab</th>
      <th>SW PortIB</th>
      <th>SW Port1</th>
      <th>SW Port2</th>
      <th>SW Port3</th>
      <th>IB IP</th>
      <th>NIC1</th>
      <th>NIC2</th>
      <th>NIC3</th>
      <th>NIC1 Mac</th>
      <th>NIC2 Mac</th>
      <th>NIC3 Mac</th>
      <th>IB Mac</th>
      <th>PSU1</th>
      <th>PSU2</th>
      <th>SN</th>
      <th colspan="3"></th>
    </tr>
  </thead>
<tbody>
    <% @gears.each do |gear| %>
      <tr>
        <td><%= gear.RU %></td>
        <td><%= gear.Devname %></td>
        <td><%= gear.Devtype %></td>
        <td><%= gear.Lab %></td>
        <td><%= gear.Swportib %></td>
        <td><%= gear.Swport1 %></td>
        <td><%= gear.Swport2 %></td>
        <td><%= gear.Swport3 %></td>
        <td><%= gear.IBip %></td>
        <td><%= gear.Nic1 %></td>
        <td><%= gear.Nic2 %></td>
        <td><%= gear.Nic3 %></td>
        <td><%= gear.Nic1mac %></td>
        <td><%= gear.Nic2mac %></td>
        <td><%= gear.Nic3mac %></td>
        <td><%= gear.IBmac %></td>
        <td><%= gear.Psu1 %></td>
        <td><%= gear.Psu2 %></td>
        <td><%= gear.SN %></td>
        <td><%= link_to 'Show', gear %></td>
        <td><%= link_to 'Edit', edit_gear_path(gear) %></td>
        <td><%= link_to 'Destroy', gear, method: :delete, data: { confirm: 'Are you sure?' } %></td>
      </tr>
    <% end %>
  </tbody>
</table>

<br>
 
Above is my Controller and Model code. I am trying to set up the search so it only searches through records within the scope specified. Currently it will return all results and does not pay attention to the scope. I believe I am close to making it work but just don't have the right syntax. Then again I may be wrong, thus any help suggestions or different ways of doing this are welcome. 

原文：https://stackoverflow.com/questions/29750694

更新时间：2022-01-11 15:01

最满意答案

 实施下一步：  
// Copy one node s, giving the copy a NULL next pointer.
struct node *copy_one(struct node *s);

// Add the given node s to an existing list.
void add(struct node *s, struct node **existing);
 
 这些用于许多目的，但在这里你将组成它们：  
add(copy_one(s), &existing_list);
 
 建立你的结果。  
 现在交叉算法是：  
set result empty
for all elements e in s1
   if e->val is contained in s2
       add a copy of e to result
 
 对于差异s1 - s2 ，它是  
set result empty
for all elements e in s1
   if e is _not_ contained in s2
       add a copy of e to result
 
 我会让你解决这个问题。我给你一个完整的答案并不好玩。  
 请注意，选择链接列表来表示集合可以很好地了解C和链接列表，但通常不是最佳选择，因为它会导致大集合的性能降低。 

Implement these next: 
// Copy one node s, giving the copy a NULL next pointer.
struct node *copy_one(struct node *s);

// Add the given node s to an existing list.
void add(struct node *s, struct node **existing);
 
These are useful for many purposes, but here you'll be composing them: 
add(copy_one(s), &existing_list);
 
to build up your result. 
Now the algorithm for intersection is: 
set result empty
for all elements e in s1
   if e->val is contained in s2
       add a copy of e to result
 
For difference s1 - s2, it's 
set result empty
for all elements e in s1
   if e is _not_ contained in s2
       add a copy of e to result
 
I will let you work out the C. There's no fun in me giving you a complete answer. 
Note that the choice of linked lists to represent sets is fine for learning about C and linked lists, but not often the best choice because it leads to slow performance for big sets.

使用范围配置Sunspot Solr搜索(Configure Sunspot Solr search with scope)

最满意答案

相关问答

Python - 多个列表的交互？(Python -Intersection of multiple lists?)[2023-11-02]

如何找到单链表的交集(How to find the intersection of a singly linked list)[2024-02-24]

查找两个列表的交集？(Find intersection of two nested lists?)[2023-11-18]

从defaultdict（列表）调用的列表的交集(intersection of lists called from defaultdict(list))[2022-08-14]

可变数量的列表的交集(Intersection of variable number of lists)[2023-08-07]

在C中设置与链接列表的交集和差异(Set intersection and difference with linked lists in C)[2023-05-04]

在字典中作为值的列表的交集[复制](Intersection of lists which are values in a dictionary [duplicate])[2023-06-08]

需要一些关于链接列表的帮助;(Need some help with Linked Lists;)[2021-07-03]

Prolog列表的交集列表(Prolog intersection list of lists)[2022-02-05]

Python列表中的交集(Intersection in Python List)[2022-11-28]

相关文章

最新问答