ruby on rails - Sum of counts for nested models -


i have 2 models: category , ad. category has_many :ads + added counter cache :ads_count. use gem awesome_nested_set make nested categories, category1 can parent/child of category2 can parent of category3 etc. need categories#index calculate total sum of ads belong category or child category(or "grandchild" etc). solution is: some_nested_categories.sum(:ads_count). let's if have many many categories in index page, makes many queries retrieve data , takes long. how can make more efficiently? help!

you extend idea of counter_cache manually sort of sum_cache, lets call nested_ads_count.

then there 4 general cases need handled

  • a category gets new add
  • a category "moved/added" new parent category"
  • a category gets deleted (or removed parent)"

an after_update callback updates parent's nested_ads_count when either current's nested_ads_count or ads_count updates. solves first case.

awesome_nested_set solves other 2 cases

using after_add , after_remove callbacks recalculate nested_ads_count.

the method calculate , cache nested_ads_count this

def reset_nested_ads_count   self.nested_ads_count = some_nested_categories.sum(:nested_ads_count) + self.ads_count end

this method optimal when frequency count used greater frequency updated, time expensive queries when number updated, , not when number needs seen.

there 1 possible pitfall can happen , if have loop in nesting (a > b > a, or more insidious > b > c > ... > a) can in infinite loop. have not seen explicitly stating awesome_nested_set blocks case.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more