Class: Twb::Analysis::DataSources::DataSourceFieldsCSVEmitter
- Inherits:
-
Object
- Object
- Twb::Analysis::DataSources::DataSourceFieldsCSVEmitter
- Includes:
- TabTool
- Defined in:
- lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb
Constant Summary collapse
- @@fullFileType =
@@csvHeader = [‘Record #’,
'Workbook', 'Workbook Dir', 'Data Source', 'Field', 'Twb Type', 'Hidden', # props[:hidden], 'Type - Column', # props[:columnField], 'Type - Calculated', # props[:calculatedField], 'Type - Db', # props[:dbField], 'Type - Mapped', # props[:mappedField] 'Type - MetaData', # props[:mappedField] ]
@@csvFileType = ‘TwbDataSourceFields’ @@csvFileName = @@csvFileType + ‘.csv’
'TwbDataSourceFieldsDetails'
- @@fullFileName =
@@fullFileType + '.csv'
- @@fullHeader =
['Field #', 'Workbook', 'Workbook Dir', 'Data Source', 'Field', 'Field - source', 'Field - class', 'Field - path', 'Property - Name', 'Property - Value' ]
Instance Attribute Summary collapse
-
#csvFileName ⇒ Object
readonly
Returns the value of attribute csvFileName.
-
#csvRecords ⇒ Object
readonly
Returns the value of attribute csvRecords.
-
#dsCount ⇒ Object
readonly
Returns the value of attribute dsCount.
-
#fieldsCount ⇒ Object
readonly
Returns the value of attribute fieldsCount.
Attributes included from TabTool
#alerts, #docDir, #docfiles, #funcdoc, #id, #licensed, #logfilename, #logger, #loglevel, #metrics, #properties, #ttdocdir, #type, #uuid
Class Method Summary collapse
Instance Method Summary collapse
-
#cleanup ⇒ Object
- def emitTech dataSource, fieldName, type, properties # puts “XX #dataSourcedataSource.uiname
- #fieldName #{}
- #TabTool#type
-
#TabTool#properties“ @recNum+=1 properties.each do |name,value| @csvFileTech << [ @recNum, @twb.name, @twb.dir, dataSource.uiname, fieldName, type, name, value ] end end.
-
#initialize(**args) ⇒ DataSourceFieldsCSVEmitter
constructor
@@techFileType = ‘TwbDataSourceFieldsTech’ @@techFileName = @@techFileType + ‘.csv’ @@techHeader = [‘Field #’, ‘Workbook’, ‘Workbook Dir’, ‘Data Source’, ‘Field’, ‘Field Type’, ‘Property - Name’, ‘Property - Value’ ].
- #initializeX ⇒ Object
- #processTwb(twb) ⇒ Object
-
#recordFieldFull(field, source) ⇒ Object
def processTwb twb.
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) ⇒ DataSourceFieldsCSVEmitter
@@techFileType = ‘TwbDataSourceFieldsTech’ @@techFileName = @@techFileType + ‘.csv’ @@techHeader = [‘Field #’,
'Workbook',
'Workbook Dir',
'Data Source',
'Field',
'Field Type',
'Property - Name',
'Property - Value'
]
72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 72 def initialize(**args) @args = args # puts "@args: #{@args}" @recordDir = !@args.nil? && @args[:recordDir] == true @ttdocdir = @args[:ttdocdir] @csvAdd = args[:csvMode] == :add @csvMode = @csvAdd ? 'a' : 'w' init @funcdoc = {:class=>self.class, :blurb=>'Analyze Worksheet Filters', :description=>'Documents Quick Filters and the values they employ, if any. Work in progess.',} #-- docFileName = docFile(@@fullFileName) @sheetFieldsCSV = CSV.open( docFileName,@csvMode) unless @csvAdd if @recordDir @sheetFieldsCSV << ['Rec #','Workbook','Workbook Modified','Worksheet','Filter Type','Operation','Data Source','Field','Value','Alias', 'Alias?','Operation Mode','Include Null?','Kind','Workbook Dir'] else @sheetFieldsCSV << ['Rec #','Workbook','Workbook Modified','Worksheet','Filter Type','Operation','Data Source','Field','Value','Alias', 'Alias?','Operation Mode','Include Null?','Kind'] end end addDocFile @sheetFieldsCSV, docFileName, "Workbooks, Worksheets and the sheets' Quick Filters" #-- @sheetCount = 0 @filterCount = 0 @recNum = 0 end |
Instance Attribute Details
#csvFileName ⇒ Object (readonly)
Returns the value of attribute csvFileName.
27 28 29 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 27 def csvFileName @csvFileName end |
#csvRecords ⇒ Object (readonly)
Returns the value of attribute csvRecords.
27 28 29 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 27 def csvRecords @csvRecords end |
#dsCount ⇒ Object (readonly)
Returns the value of attribute dsCount.
28 29 30 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 28 def dsCount @dsCount end |
#fieldsCount ⇒ Object (readonly)
Returns the value of attribute fieldsCount.
28 29 30 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 28 def fieldsCount @fieldsCount end |
Class Method Details
.csvFileNaame ⇒ Object
125 126 127 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 125 def self.csvFileNaame @@csvFileName end |
.csvFileType ⇒ Object
121 122 123 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 121 def self.csvFileType @@csvFileType end |
.csvHeader ⇒ Object
117 118 119 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 117 def self.csvHeader @@csvHeader end |
Instance Method Details
#cleanup ⇒ Object
def emitTech dataSource, fieldName, type, properties
# puts "XX #{dataSource.uiname} :: #{fieldName} #{} :: #{type} :: #{properties}"
@recNum+=1
properties.each do |name,value|
@csvFileTech << [ @recNum,
@twb.name,
@twb.dir,
dataSource.uiname,
fieldName,
type,
name,
value
]
end
end
269 270 271 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 269 def cleanup @csvFile.close unless @csvFile.nil? end |
#initializeX ⇒ Object
98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 98 def initializeX # @csvFile = CSV.open(@@csvFileName,'w') # @csvFile << @@csvHeader # @csvRecords = Set.new # puts "Opened: #{[email protected]?} - #{@@csvFileName}" # -- @csvFileFull = CSV.open(@@fullFileName,'w') @csvFileFull << @@fullHeader puts "Opened: #{!@csvFileFull.nil?} - #{@@fullFileName} " # -- # @csvFileTech = CSV.open(@@techFileName,'w') # @csvFileTech << @@techHeader # puts "Opened: #{[email protected]?} - #{@@techFileName}" # -- @recNum = 0 @dsCount = 0 @fieldsCount = 0 end |
#processTwb(twb) ⇒ Object
129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 129 def processTwb twb @twb = nil @twb = twb if twb.instance_of? Twb::Workbook @twb = Twb::Workbook.new(twb) if twb.instance_of? String raise ArgumentError.new("ERROR in Workbok processing: '#{twb}' must be a Workbook (class) or the name of a Workbook (String), is a #{twb.class} \n ") unless @twb.is_a? Twb::Workbook # -- dss = @twb.datasources @fieldCnt = 0 dss.each do |ds| @dsname = ds.uiname # puts "\n -- #{ds.uiname} " # tables = Set.new # fields = {} @dsCount += 1 fclasses = Set.new ds.localFields.each do |field| recordFieldFull field, :local # recordField( fields, field, {:type=>:local,:columnField=>true,:hidden=>field.hidden} ) # emitTech( ds, field.uiname, 'Local', field.properties) # recordTech( field, 'LocalA') end ds.columnFields.each do |field| recordFieldFull field, :column # recordField( fields, field, {:type=>'column',:columnField=>true,:hidden=>field.hidden} ) # emitTech( ds, field.uiname, 'Column', field.properties) # recordTech( field, 'ColumnA') end ds.calculatedFields.each do |field| recordFieldFull field, :calc # puts "WWW #{field.class} :: #{field} ::prop:: #{field.properties.class} :: #{field.properties}" # recordField( fields, field, {:type=>'calc',:calculatedField=>true,:hidden=>field.hidden} ) # emitTech( ds, field.uiname, 'Calculated', field.properties) # recordTech( field, 'CalcA') end ds..each do |field| recordFieldFull field, :metadata # recordField( fields, field, {:type=>'metadata',:metadataField=>true} ) # emitTech( ds, field.uiname, 'MetaData', field.properties) # recordTech( field, 'MetadataA') end ds.dbFields.each do |field| recordFieldFull field, :db # recordField( fields, field, {:type=>'database',:dbField=>true} ) # emitTech( ds, field.uiname, 'Db', field.properties) # recordTech( field, 'DbA') end ds.mappedFields.each do |field| recordFieldFull field, :mapped # recordField( fields, field, {:type=>'mapped',:mappedField=>true} ) # emitTech( ds, field.uiname, 'Mapped', field.properties) # recordTech( field, 'MappedA') end # emitFields(fields) end end |
#recordFieldFull(field, source) ⇒ Object
def processTwb twb
185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 |
# File 'lib/twb/analysis/datasources/datasourcefieldscsvemitter.rb', line 185 def recordFieldFull field, source # print field.properties.nil? ? '-' : ":#{field.properties.length}" # puts field.properties @fieldCnt+=1 field.properties.each do |name,value| # print name @csvFileFull << [ @recNum+=1, @twb.name, @twb.dir, @dsname, field.uiname, source, field.class, field.node.path.to_s.gsub(/[0-9]/,'').gsub('[]',''), name, value ] # @csvFileFull << csvRec end end |