guanglindu / ipams Goto Github PK

1. See Matching substrings in fulltext search.
2. Make sure to restart solr and, then, reindex before testing.
3. I implemented prefix matching with EdgeNGramFilter.

Solution 1 (The best and most responsive)

1. Twitter Bootstrap display rest of a table rows using collapse.js.
2. Demo at bootply.com

Solution 2 (Slow when there're many rows to fold/unfold)

1. Collapsible rows in a table: http://jsfiddle.net/GuanglinDu/m119vqam/
2. The JS code in CoffeeScript:
   $ ->
   $('.collapse').on 'show.bs.collapse', ->
   $('.collapse.in').collapse 'hide'

See Creating Accordion Table with Bootstrap

In-place editing based on Bootstrap X-Editable is enabled across all the views. Some views are across multiple tables, it's necessary to update a single row with AJAX after some specific in-place editing is done.

When running the functional and integration tests against search_controller.rb with some actual searching strings , this error occurs: "LoadError: Unable to autoload constant PaginatedCollectionPolicy, expected .../ipams/app/policies/paginated_collection_policy.rb to define it". However, this policy file was already created long before. The buggy testing code was commented out for the time being and labelled with FIXME.

This bug was found on Sep. 7, 2017. Before a user is removed, his associated IP addresses, if any, should be automatically recycled instead of being eliminated from the DB.

1. Repo size bloated After installing Sunspot to search, I found the latest committed folder .git size increased from around 18MB to 51MB because folder vendor was not ignored by default and a lot of cached gems were committed. After reading this, Should I commit the dependencies in my vendor directory?, I decided to ignore this folder completely. I also ignore folder log (unnecessary to commit logs) and folder solr completely, for we have to do tricks when deploying Sunspot in the production environment. See sunspot solr in rails4 production.
2. Solution After searching, testing for a lot of times on how to shrink the repo size both locally and on the github server side, this did the trick Shrinking your Git repository. I deleted folder vendor from the history, reducing folder .git to 1.4MB. The whole committed repo size is around 3.2MB. Much smaller!
3. Notices
   
   3.1 You'd better operate on the master branch, then rebase the other branches on the master, or delete and then recreate the other branches, e.g., branch develop. Have to ask your teammates to re-clone or rebase on your shrunk repo.
   
   3.2 Found out that when rebasing, there're too many conflicts. So the best way might be to re-clone.
   
   3.3 Anyway, back up your original data. Do remind your teammates of this, too.

1. Problem Description
   
   No problem to add Sunspot to the development environment with the its default configuration. After upgrading the code in the production environment, solr can be started, but the follwing problems bite:
   
   (1) Reindex cannot be executed;
   
   (2) Nothing was found when searching even after changing /solr/production to /solr/default to execute reindex successfully according to some Googled solutions.
   
2. Solution
   
   sunspot solr in rails4 production

The model uniqueness validation fails with Chinese characters. But it succeeds using ASCII. Highly possible that this is caused by the char encoding. One case is the name attribute of model User.

The memory usage keeps going up after every refresh of the pages. It can reach as high as 15G Bytes and then my PC will respond very slowly. Have to kill it and restart the app. Do not know why at present.

Implemented the prefix-matching search according to . When maxGramSize was 10, nothing would be found to search for IP address 192.168.1.1 or the alike in the Addresses view:

<filter class="solr.EdgeNGramFilterFactory" minGramSize="2" maxGramSize="10" side="front"/>

After setting it 15, the problem was solved.

To enable pagination after search, I implement like this in action index (see Will_Paginate with Sunspot – Ruby on Rails):

def index
  keywords = params[:search]
  keywords = keywords.strip if keywords

  # No keywords, no search
  @posts = nil
  if keywords && keywords != "" 
    search = Post.search do
      fulltext keywords
      # See http://www.whatibroke.com/?p=235
      paginate :page => params[:page] || 1, :per_page => 30
    end 
    # Type Sunspot::Search::PaginatedCollection < Array
    @posts = search.results
  else
    # paginate returns object os type User::ActiveRecord_Relation
    @posts = Post.paginate(page: params[:page], per_page: 100)
  end
  authorize @posts
end