I hereby claim:
- I am dolan on github.
- I am ddolan (https://keybase.io/ddolan) on keybase.
- I have a public key ASAlOUW79qborZe18zFLGsVsEThOWG1RSK7X-a6EWMk3igo
To claim this, I am signing this object:
Dave dolan
dolan
/ keybase.md
Created
June 17, 2021 14:06
dolan
/ create_item_children_count.rb
Created
December 10, 2013 06:28
— forked from jasoncodes/create_item_children_count.rb
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class CreateItemChildrenCountView < ActiveRecord::Migration | |
| def self.up | |
| execute <<-SQL | |
| CREATE VIEW item_children_count AS | |
| SELECT parent_id AS item_id, COUNT(*) as children_count | |
| FROM items GROUP BY parent_id; | |
| SQL | |
| end | |
| def self.down |