Commit b13cc439

mo kareem <email@mokhan.ca>
2011-05-27 03:35:51
add the story of each creation to the full text search index.
1 parent 5111814
app/controllers/search_controller.rb
@@ -1,6 +1,6 @@
 class SearchController < ApplicationController
   def index
-    @creations = Creation.search params[:search], :include => :user, :match_mode => :boolean
+    @creations = Creation.search params[:q], :include => :user, :match_mode => :boolean
   end
 
 end
app/models/creation.rb
@@ -7,5 +7,6 @@ class Creation < ActiveRecord::Base
 
   define_index do
     indexes :name
+    indexes story
   end
 end
app/views/layouts/application.html.erb
@@ -21,7 +21,7 @@
         <div class="search">
           <% form_tag(search_index_path, :method => "get") do %>
             <div class="txt">
-              <%= text_field_tag(:search) %>
+              <%= text_field_tag(:q) %>
             </div>
             <div class="searchBt">
               <%= submit_tag("search") %>
config/development.sphinx.conf
@@ -18,7 +18,7 @@ source creation_core_0
   sql_pass = password
   sql_db = cakeside_development
   sql_query_pre = SET TIME ZONE 'UTC'
-  sql_query = SELECT "creations"."id" * 1::INT8 + 0 AS "id" , "creations"."name" AS "name", "creations"."id" AS "sphinx_internal_id", 0 AS "sphinx_deleted", 2929256226 AS "class_crc" FROM "creations" WHERE ("creations"."id" >= $start AND "creations"."id" <= $end) GROUP BY "creations"."id", "creations"."name", "creations"."id"
+  sql_query = SELECT "creations"."id" * 1::INT8 + 0 AS "id" , "creations"."name" AS "name", "creations"."story" AS "story", "creations"."id" AS "sphinx_internal_id", 0 AS "sphinx_deleted", 2929256226 AS "class_crc" FROM "creations" WHERE ("creations"."id" >= $start AND "creations"."id" <= $end) GROUP BY "creations"."id", "creations"."name", "creations"."story", "creations"."id"
   sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "creations" 
   sql_attr_uint = sphinx_internal_id
   sql_attr_uint = sphinx_deleted
log/searchd.development.pid
@@ -1,1 +0,0 @@
-3794
.gitignore
@@ -5,3 +5,4 @@ tmp/**/*
 *.swp
 public/uploads/
 db/sphinx/development/*
+log/*