Class: Twb::Analysis::GoogleSheetDataSourcesAnalyzer
- Inherits:
-
Object
- Object
- Twb::Analysis::GoogleSheetDataSourcesAnalyzer
- Includes:
- TabTool
- Defined in:
- lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb
Instance Attribute Summary collapse
-
#localEmit ⇒ Object
Returns the value of attribute localEmit.
-
#twbcount ⇒ Object
readonly
Returns the value of attribute twbcount.
-
#twbname ⇒ Object
readonly
Returns the value of attribute twbname.
Attributes included from TabTool
#alerts, #docDir, #docfiles, #funcdoc, #id, #licensed, #logfilename, #logger, #loglevel, #properties, #ttdocdir, #type, #uuid
Instance Method Summary collapse
-
#initialize(**args) ⇒ GoogleSheetDataSourcesAnalyzer
constructor
A new instance of GoogleSheetDataSourcesAnalyzer.
- #metrics ⇒ Object
- #processTWB(twb) ⇒ Object
Methods included from TabTool
#addDocFile, #alert, #closeDocFiles, #config, #docFile, #docFileMaxNameLen, #docfilesdoc, #docfilesdocto_s, #emit, #emitCSV, #finis, #hasConfig, #init, #initCSV, #initDocDir, #initLogger, #license=, #licensed?, #loadConfig
Constructor Details
#initialize(**args) ⇒ GoogleSheetDataSourcesAnalyzer
Returns a new instance of GoogleSheetDataSourcesAnalyzer.
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 30 def initialize(**args) @args = args #-- TODO move @csvAdd * #csvMode resolution to TabTool @csvAdd = args[:csvMode] == :add @csvMode = @csvAdd ? 'a' : 'w' emit "@csvAdd : #{@csvAdd}" emit "@csvMode: #{@csvMode}" #-- init #-- set up metrics @twbcount = 0 @dscount = 0 @filecount = 0 @sheetcount = 0 #-- @funcdoc = {:class=>self.class, :blurb=>'Analyze Google Sheet Data Sources', :description=>nil,} docFileName = docFile('GoogleSheetDataSources.csv') @csv = CSV.open(docFileName, 'w') unless @csvAdd @csv << ["Workbook",'Data Source','Connection','File Name','Type','Table Name','Field'] end # @docfiles = [{:name=>docFileName,:description=>"CSV File containing the data relating Google Sheet-based Data Sources."}] addDocFile @dashSheetsCSV, docFileName, "Workbooks, Dashboards, and their Worksheets" end |
Instance Attribute Details
#localEmit ⇒ Object
Returns the value of attribute localEmit.
27 28 29 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 27 def localEmit @localEmit end |
#twbcount ⇒ Object (readonly)
Returns the value of attribute twbcount.
28 29 30 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 28 def twbcount @twbcount end |
#twbname ⇒ Object (readonly)
Returns the value of attribute twbname.
28 29 30 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 28 def twbname @twbname end |
Instance Method Details
#metrics ⇒ Object
94 95 96 97 98 99 100 101 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 94 def metrics { # '# of Workbooks' => @twbcount, '# of Data Sources' => @dscount, '# of Google Docs' => @filecount, '# of Worksheets' => @sheetcount } end |
#processTWB(twb) ⇒ Object
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 |
# File 'lib/twb/analysis/datasources/googlesheetdatasourcesanalyzer.rb', line 55 def processTWB twb if Twb::Workbook != twb.class @twb = Twb::Workbook.new twb else @twb = twb end @twbname = @twb.name emit "Workbook:: #{@twbname}" @twbcount += 1 dss = twb.datasources dss.each do |ds| emit ds.uiname @dscount += 1 conns = ds.node.xpath(".//connection[@class='google-sheets']") if conns.length > 0 @relation = ds.node.at_xpath('./connection/relation') @relName = @relation.nil? ? 'n/a - no relation in connection' : @relation['name'] @relType = @relation.nil? ? 'n/a - no relation in connection' : @relation['type'] @fileName = ds.node.at_xpath('.//named-connection/connection')['filename'] @filecount += 1 emit "FILENAME: #{@fileName}" tables = ds.node.xpath(".//relation[@type='table']") # emit "# Tables: #{tables.length}" tables.each do |table| @sheetcount += 1 tableName = table.attribute('name') columns = table.xpath('.//column') columns.each do |column| emit [@twbname,ds.uiname,@relName,@fileName,@relType,tableName,column.attribute('name')].to_csv @csv << [@twbname,ds.uiname,@relName,@fileName,@relType,tableName,column.attribute('name')] emit '' end end end emit " " end finis end |