Class: Twb::Analysis::DataSources::DataSourceFieldsCSVEmitter
- Inherits:
-
Object
- Object
- Twb::Analysis::DataSources::DataSourceFieldsCSVEmitter
- 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.
Class Method Summary collapse
Instance Method Summary collapse
-
#cleanup ⇒ Object
- def emitTech dataSource, fieldName, type, properties # puts “XX #dataSourcedataSource.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.
-
#initialize ⇒ DataSourceFieldsCSVEmitter
constructor
@@techFileType = ‘TwbDataSourceFieldsTech’ @@techFileName = @@techFileType + ‘.csv’ @@techHeader = [‘Field #’, ‘Workbook’, ‘Workbook Dir’, ‘Data Source’, ‘Field’, ‘Field Type’, ‘Property - Name’, ‘Property - Value’ ].
- #processTwb(twb) ⇒ Object
-
#recordFieldFull(field, source) ⇒ Object
def processTwb twb.
Constructor Details
#initialize ⇒ DataSourceFieldsCSVEmitter
@@techFileType = ‘TwbDataSourceFieldsTech’ @@techFileName = @@techFileType + ‘.csv’ @@techHeader = [‘Field #’,
'Workbook',
'Workbook Dir',
'Data Source',
'Field',
'Field Type',
'Property - Name',
'Property - Value'
]
70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 70 def initialize # @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 |
Instance Attribute Details
#csvFileName ⇒ Object (readonly)
Returns the value of attribute csvFileName.
25 26 27 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 25 def csvFileName @csvFileName end |
#csvRecords ⇒ Object (readonly)
Returns the value of attribute csvRecords.
25 26 27 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 25 def csvRecords @csvRecords end |
#dsCount ⇒ Object (readonly)
Returns the value of attribute dsCount.
26 27 28 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 26 def dsCount @dsCount end |
#fieldsCount ⇒ Object (readonly)
Returns the value of attribute fieldsCount.
26 27 28 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 26 def fieldsCount @fieldsCount end |
Class Method Details
.csvFileNaame ⇒ Object
97 98 99 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 97 def self.csvFileNaame @@csvFileName end |
.csvFileType ⇒ Object
93 94 95 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 93 def self.csvFileType @@csvFileType end |
.csvHeader ⇒ Object
89 90 91 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 89 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
241 242 243 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 241 def cleanup @csvFile.close unless @csvFile.nil? end |
#processTwb(twb) ⇒ Object
101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 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 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 101 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
157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 |
# File 'lib/twb/analysis/DataSources/DataSourceFieldsCSVEmitter.rb', line 157 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 |