Module: Dbchecker::DSL
- Included in:
- Checker
- Defined in:
- lib/dbchecker/dsl.rb
Instance Method Summary collapse
- #check_duplicates(*fields) ⇒ Object
- #check_equal(*fields) ⇒ Object
- #check_negatives(*fields) ⇒ Object
- #check_nil(*fields) ⇒ Object
- #check_references(*fields) ⇒ Object
- #check_zero(*fields) ⇒ Object
- #log(msg) ⇒ Object
Instance Method Details
#check_duplicates(*fields) ⇒ Object
89 90 91 92 93 94 95 96 97 98 99 100 |
# File 'lib/dbchecker/dsl.rb', line 89 def check_duplicates(*fields) raise 'Empty fields' if fields.empty? fields_str = fields.join(', ') total = table.select(:id).group("#{fields_str}").having("COUNT(id) > ?", 1) unless total.empty? self.log "There are #{total.size} invalid rows in #{table} because #{fields_str} are duplicated" self.log "IDs: #{total}" end total.map(&:id) end |
#check_equal(*fields) ⇒ Object
75 76 77 78 79 80 81 82 83 84 85 86 87 |
# File 'lib/dbchecker/dsl.rb', line 75 def check_equal(*fields) raise 'Empty fields' if fields.empty? raise 'Two fields required' if fields.size != 2 first_field, second_field = fields[0], fields[1] total = table.select(:id).where("#{first_field} = #{second_field}") if total.size > 0 self.log "There are #{total.size} invalid rows in #{table} because #{first_field} and #{second_field} are equal" self.log "IDs: #{total}" end total.map(&:id) end |
#check_negatives(*fields) ⇒ Object
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
# File 'lib/dbchecker/dsl.rb', line 43 def check_negatives(*fields) raise 'Empty fields' if fields.empty? res = [] fields.each do |field| total = table.select(:id).where("#{field} < 0") if total.size > 0 self.log "There are #{total.size} invalid rows in #{table} because #{field} is negative" self.log "IDs: #{total}" end res.push total end res end |
#check_nil(*fields) ⇒ Object
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
# File 'lib/dbchecker/dsl.rb', line 4 def check_nil(*fields) raise 'Empty fields' if fields.empty? res = [] fields.each do |field| bad = table.select(:id).where(field => nil) total = bad.map(&:id) unless total.empty? self.log "There are #{total.size} invalid rows in #{table} because #{field} is nil" self.log "IDs: #{total}" end res.push total end res end |
#check_references(*fields) ⇒ Object
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
# File 'lib/dbchecker/dsl.rb', line 22 def check_references(*fields) raise 'Empty fields' if fields.empty? res = [] fields.each do |field| field_name = "#{field}_id" references = table.select(:id).all.map{|r| r.id } from = field.to_s.classify.constantize all = from.select(:id).all.map(&:id) total = references - all if total.size > 0 self.log "There are #{total.size} invalid rows in #{table} because #{field_name} is not existant" self.log "IDs: #{total}" end res.push total end res end |
#check_zero(*fields) ⇒ Object
59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
# File 'lib/dbchecker/dsl.rb', line 59 def check_zero(*fields) raise 'Empty fields' if fields.empty? res = [] fields.each do |field| total = table.select(:id).where("#{field} = 0") if total.size > 0 self.log "There are #{total.size} invalid rows in #{table} because #{field} is zero" self.log "IDs: #{total}" end res.push total end res end |
#log(msg) ⇒ Object
102 103 104 |
# File 'lib/dbchecker/dsl.rb', line 102 def log(msg) puts msg unless Rails.env.test? end |