Module: Shiftzilla::Helpers

Defined in:
lib/shiftzilla/helpers.rb

Constant Summary collapse

BZ_URL = 
'https://bugzilla.redhat.com/show_bug.cgi?id='
SZA_DIR = 
File.join(ENV['HOME'],'.shiftzilla')
ARCH_DIR = 
File.join(SZA_DIR,'archive')
CFG_FILE = 
File.join(SZA_DIR,'shiftzilla_cfg.yml')
DB_FNAME = 
'shiftzilla.sqlite'
DB_FPATH = 
File.join(SZA_DIR,DB_FNAME)
THIS_PATH = 
File.symlink?(__FILE__) ? File.readlink(__FILE__) : __FILE__
HAML_TMPL = 
File.expand_path(File.join(File.dirname(THIS_PATH), '../../template.haml'))
CFG_TMPL = 
File.expand_path(File.join(File.dirname(THIS_PATH), '../../shiftzilla_cfg.yml.tmpl'))
SQL_TMPL = 
File.expand_path(File.join(File.dirname(THIS_PATH), '../../shiftzilla.sql.tmpl'))
VENDOR_DIR = 
File.expand_path(File.join(File.dirname(THIS_PATH), '../../vendor'))
GRAPH_DIMENSIONS = 
'800x400'
GRAPH_THEME = 
{
  :colors => [
    '#268bd2', # Blue
    '#cb4b16', # Orange
    '#859900', # Green
    '#2aa198', # Cyan
    '#d33682', # Magenta
    '#6c71c4', # Violet
    '#b58900', # Yellow
    '#dc322f', # Red
  ],
  :marker_color      => '#93a1a1', # Base1
  :font_color        => '#586e75', # Base01
  :background_colors => '#fdf6e3', # Base3
  :background_image  => nil,
}

Instance Method Summary collapse

Instance Method Details

#all_bugs_query(snapshot) ⇒ Object 



115
116
117
 
# File 'lib/shiftzilla/helpers.rb', line 115

def all_bugs_query(snapshot)
  return "SELECT AB.'Bug ID', AB.'Component', AB.'Target Release', AB.'Assignee', AB.'Status', AB.'Summary', AB.'Keywords', AB.'PM Score', AB.'External Bugs' FROM ALL_BUGS AB WHERE AB.'Snapshot' = date('#{snapshot}')"
end

#all_snapshots ⇒ Object 



131
132
133
134
135
136
137
138
139
 
# File 'lib/shiftzilla/helpers.rb', line 131

def all_snapshots
  @all_snapshots ||= begin
    all_snapshots = []
    dbh.execute('SELECT DISTINCT Snapshot FROM ALL_BUGS ORDER BY Snapshot ASC') do |row|
      all_snapshots << row[0]
    end
    all_snapshots
  end
end

#backup_db ⇒ Object 



67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
 
# File 'lib/shiftzilla/helpers.rb', line 67

def backup_db
  unless db_backed_up
    today = Date.today.strftime('%Y-%m-%d')
    tpath = File.join(ARCH_DIR,today)
    unless Dir.exists?(tpath)
      Dir.mkdir(tpath)
    end
    apath    = ''
    copy_idx = 0
    loop do
      copynum = "%02d" % copy_idx
      apath   = File.join(tpath,"#{copynum}-#{DB_FNAME}")
      break unless File.exists?(apath)
      copy_idx += 1
    end
    FileUtils.cp DB_FPATH, apath
    puts "Backed up the database."
    @db_backed_up = true
  end
end

#bug_url(bug_id) ⇒ Object 



92
93
94
 
# File 'lib/shiftzilla/helpers.rb', line 92

def bug_url(bug_id)
  return "#{BZ_URL}#{bug_id}"
end

#cfg_file ⇒ Object 



45
46
47
 
# File 'lib/shiftzilla/helpers.rb', line 45

def cfg_file
  @cfg_file ||= YAML.load_file(CFG_FILE)
end

#component_bugs_count(components, snapshot) ⇒ Object 



125
126
127
128
129
 
# File 'lib/shiftzilla/helpers.rb', line 125

def component_bugs_count(components,snapshot)
  rclause = list_clause(components)
  rfilter = rclause == '' ? '' : " AND AB.'Component' #{rclause}"
  return "SELECT count(*) FROM ALL_BUGS AB WHERE AB.'Snapshot' = date('#{snapshot}')#{rfilter}"
end

#component_bugs_query(components, snapshot) ⇒ Object 



119
120
121
122
123
 
# File 'lib/shiftzilla/helpers.rb', line 119

def component_bugs_query(components,snapshot)
  rclause = list_clause(components)
  rfilter = rclause == '' ? '' : " AND AB.'Component' #{rclause}"
  return "SELECT AB.'Bug ID', AB.'Component', AB.'Target Release', AB.'Assignee', AB.'Status', AB.'Summary', AB.'Keywords', AB.'PM Score', AB.'External Bugs' FROM ALL_BUGS AB WHERE AB.'Snapshot' = date('#{snapshot}')#{rfilter} ORDER BY AB.'Target Release' DESC"
end

#dbh ⇒ Object 



49
50
51
 
# File 'lib/shiftzilla/helpers.rb', line 49

def dbh
  @dbh ||= SQLite3::Database.new(DB_FPATH)
end

#field_map ⇒ Object 



145
146
147
148
149
150
151
152
153
154
155
156
157
 
# File 'lib/shiftzilla/helpers.rb', line 145

def field_map
  {
    :assigned_to      => 'Assignee',
    :component        => 'Component',
    :id               => 'Bug ID',
    :keywords         => 'Keywords',
    :cf_pm_score      => 'PM Score',
    :status           => 'Status',
    :summary          => 'Summary',
    :target_release   => 'Target Release',
    :external_bugs    => 'External Bugs',
  }
end

#haml_engine ⇒ Object 



53
54
55
 
# File 'lib/shiftzilla/helpers.rb', line 53

def haml_engine
  @haml_engine ||= Haml::Engine.new(File.read(HAML_TMPL))
end

#latest_snapshot ⇒ Object 



141
142
143
 
# File 'lib/shiftzilla/helpers.rb', line 141

def latest_snapshot
  all_snapshots[-1]
end

#new_graph(labels, max_y) ⇒ Object 



57
58
59
60
61
62
63
64
65
 
# File 'lib/shiftzilla/helpers.rb', line 57

def new_graph(labels,max_y)
  g = Gruff::Line.new(GRAPH_DIMENSIONS)
  g.theme            = GRAPH_THEME
  g.line_width       = 2
  g.labels           = labels
  g.y_axis_increment = set_axis_increment(max_y)
  g.hide_dots        = true
  return g
end

#set_axis_increment(initial_value) ⇒ Object 



96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
 
# File 'lib/shiftzilla/helpers.rb', line 96

def set_axis_increment(initial_value)
  case
  when initial_value < 10
    return 1
  when initial_value < 20
    return 2
  when initial_value < 50
    return 5
  when initial_value < 100
    return 10
  when initial_value < 200
    return 20
  when initial_value < 400
    return 25
  else
    return 100
  end
end

#timestamp ⇒ Object 



88
89
90
 
# File 'lib/shiftzilla/helpers.rb', line 88

def timestamp
  DateTime.now.to_s
end

#tmp_dir ⇒ Object 



41
42
43
 
# File 'lib/shiftzilla/helpers.rb', line 41

def tmp_dir
  @tmp_dir ||= Dir.mktmpdir('shiftzilla-reports-')
end