blazer.rb 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. require "csv"
  2. require "chartkick"
  3. require "blazer/version"
  4. require "blazer/data_source"
  5. require "blazer/engine"
  6. require "blazer/tasks"
  7. module Blazer
  8. class << self
  9. attr_accessor :audit
  10. attr_reader :time_zone
  11. attr_accessor :user_name
  12. attr_accessor :user_class
  13. attr_accessor :user_method
  14. attr_accessor :from_email
  15. end
  16. self.audit = true
  17. self.user_name = :name
  18. def self.time_zone=(time_zone)
  19. @time_zone = time_zone.is_a?(ActiveSupport::TimeZone) ? time_zone : ActiveSupport::TimeZone[time_zone.to_s]
  20. end
  21. def self.settings
  22. @settings ||= YAML.load(ERB.new(File.read(Rails.root.join("config", "blazer.yml"))).result)
  23. end
  24. def self.data_sources
  25. @data_sources ||= begin
  26. ds = Hash[
  27. settings["data_sources"].map do |id, s|
  28. [id, Blazer::DataSource.new(id, s)]
  29. end
  30. ]
  31. ds.default = ds.values.first
  32. ds
  33. end
  34. end
  35. def self.run_checks
  36. Blazer::Check.includes(:query).find_each do |check|
  37. rows = nil
  38. error = nil
  39. tries = 0
  40. # try 3 times on timeout errors
  41. begin
  42. rows, error = data_sources[check.query.data_source].run_statement(check.query.statement)
  43. tries += 1
  44. end while error && error.include?("canceling statement due to statement timeout") && tries < 3
  45. check.update_state(rows, error)
  46. end
  47. end
  48. def self.send_failing_checks
  49. emails = {}
  50. Blazer::Check.includes(:query).where(state: %w[failing error]).find_each do |check|
  51. check.split_emails.each do |email|
  52. (emails[email] ||= []) << check
  53. end
  54. end
  55. emails.each do |email, checks|
  56. Blazer::CheckMailer.failing_checks(email, checks).deliver_later
  57. end
  58. end
  59. end