class Twb::Analysis::DashSheetsAnalyzer
Attributes
localEmit[RW]
Public Class Methods
new(**args)
click to toggle source
# File lib/twb/analysis/Sheets/dashsheetsanalyzer.rb, line 28 def initialize(**args) @args = args @recordDir = !@args.nil? && @args[:recordDir] == true @ttdocdir = @args[:ttdocdir] @csvAdd = !@args.nil? && args[:csvMode] == :add @csvMode = @csvAdd ? 'a' : 'w' init @funcdoc = {:class=>self.class, :blurb=>'Analyze Dashboard Worksheets', :description=>'Identifies the Worksheets present in Dashboards.',} #-- docFileName = docFile('DashboardSheets.csv') @dashSheetsCSV = CSV.open(docFileName,@csvMode) unless @csvAdd if @recordDir @dashSheetsCSV << ['Rec #','Workbook','Dashboard','Worksheet','Hidden','Visible', 'Workbook Dir'] else @dashSheetsCSV << ['Rec #','Workbook','Dashboard','Worksheet','Hidden','Visible' ] end end addDocFile @dashSheetsCSV, docFileName, "Workbooks, Dashboards, and their Worksheets" #-- @twbCount = 0 @dashCount = 0 @sheetCount = 0 @recNum = 0 end
Public Instance Methods
metrics()
click to toggle source
# File lib/twb/analysis/Sheets/dashsheetsanalyzer.rb, line 54 def metrics { # '# of Workbooks' => @twbCount, '# of Dashboards' => @dashCount, '# of Worksheets' => @sheetCount } end
parseDashes()
click to toggle source
# File lib/twb/analysis/Sheets/dashsheetsanalyzer.rb, line 73 def parseDashes @dashboards = @twb.dashboards @dashboards.each do |dash| emit "DASH:: #{dash.name}" @dashCount += 1 dash.worksheets.each do |sheet| @sheetCount += 1 # puts "SHEET: #{sheet} -> #{sheet.name}" recordCSV [@twbName, dash.name, sheet.name, sheet.hidden, sheet.visible ] # recordCSV [@twbName, @modTime, dash.name, sheet.name, sheet.hidden, sheet.visible ] end end end
processTWB(twb)
click to toggle source
# File lib/twb/analysis/Sheets/dashsheetsanalyzer.rb, line 62 def processTWB twb @twb = twb @twbName = @twb.name @twbDir = @twb.dir @modTime = @twb.modtime emit " -- #{@twbName}" @twbCount += 1 parseDashes finis end
Private Instance Methods
recordCSV(record)
click to toggle source
# File lib/twb/analysis/Sheets/dashsheetsanalyzer.rb, line 89 def recordCSV record numberedRec = [@recNum+=1] + record if @recordDir @dashSheetsCSV << numberedRec.push(@twbDir) else @dashSheetsCSV << numberedRec end end