Class: Twb::DataSource
- Inherits:
-
Object
- Object
- Twb::DataSource
- Includes:
- TabTool
- Defined in:
- lib/twb/datasource.rb
Constant Summary collapse
- @@hasher =
Digest::SHA256.new
- @@connGNodeParamsJSON =
%q( { "csv" : { "label" : ["filename"], "id" : ["directory","filename"], "type" : "CSV" }, "excel" : { "label" : ["filename"], "id" : ["directory","filename"], "type" : "Excel" }, "dataengine" : { "label" : ["dbname" ], "id" : ["directory","filename"], "type" : "TDE" }, "msaccess" : { "label" : ["filename"], "id" : ["directory","filename"], "type" : "MS Access" }, "oracle" : { "label" : ["server" ], "id" : [ "server" ], "type" : "Oracle" }, "postgres" : { "label" : ["server" ], "id" : [ "server" ], "type" : "PostgreSQL" }, "textscan" : { "label" : ["filename"], "id" : ["directory","filename"], "type" : "CSV / TSV" }, "excel-direct" : { "label" : ["filename"], "id" : [ "filename"], "type" : "Excel" }, "salesforce" : { "label" : ["server" ], "id" : [ "server" ], "type" : "Salesforce" } } )
- @@cgNodeParams =
JSON.parse @@connGNodeParamsJSON
Instance Attribute Summary collapse
-
#aliases ⇒ Object
readonly
Returns the value of attribute aliases.
-
#allFields ⇒ Object
readonly
Returns the value of attribute allFields.
-
#attributes ⇒ Object
readonly
Returns the value of attribute attributes.
-
#calculatedField(name) ⇒ Object
readonly
Returns the value of attribute calculatedField.
-
#calculatedFieldNames ⇒ Object
readonly
Returns the value of attribute calculatedFieldNames.
-
#calculatedFieldNamesMap ⇒ Object
readonly
Returns the value of attribute calculatedFieldNamesMap.
-
#calculatedFields ⇒ Object
readonly
Returns the value of attribute calculatedFields.
-
#caption ⇒ Object
readonly
Returns the value of attribute caption.
-
#columnFields ⇒ Object
readonly
Returns the value of attribute columnFields.
-
#connAttributes ⇒ Object
readonly
Returns the value of attribute connAttributes.
-
#connection ⇒ Object
readonly
Returns the value of attribute connection.
-
#connections ⇒ Object
readonly
Returns the value of attribute connections.
-
#connHash ⇒ Object
readonly
Returns the value of attribute connHash.
-
#dbFields ⇒ Object
readonly
Returns the value of attribute dbFields.
-
#dsclass ⇒ Object
readonly
Returns the value of attribute dsclass.
-
#fieldUINames ⇒ Object
readonly
Returns the value of attribute fieldUINames.
-
#filters ⇒ Object
readonly
Returns the value of attribute filters.
-
#groups ⇒ Object
readonly
Returns the value of attribute groups.
-
#hasField ⇒ Object
readonly
Returns the value of attribute hasField.
-
#isExtract ⇒ Object
readonly
Returns the value of attribute isExtract.
-
#isPublished ⇒ Object
readonly
Returns the value of attribute isPublished.
-
#joinPairs ⇒ Object
readonly
Returns the value of attribute joinPairs.
-
#localField ⇒ Object
readonly
Returns the value of attribute localField.
-
#localFieldNames ⇒ Object
readonly
Returns the value of attribute localFieldNames.
-
#localFields ⇒ Object
readonly
Returns the value of attribute localFields.
-
#mappedFields ⇒ Object
readonly
Returns the value of attribute mappedFields.
-
#metadataFields ⇒ Object
readonly
Returns the value of attribute metadataFields.
-
#name ⇒ Object
readonly
Returns the value of attribute name.
-
#node ⇒ Object
readonly
Returns the value of attribute node.
-
#tableFieldsMap ⇒ Object
readonly
Returns the value of attribute tableFieldsMap.
-
#tables ⇒ Object
readonly
Returns the value of attribute tables.
-
#uiname ⇒ Object
readonly
Returns the value of attribute uiname.
-
#uuid ⇒ Object
readonly
Returns the value of attribute uuid.
-
#workbook ⇒ Object
readonly
Returns the value of attribute workbook.
Attributes included from TabTool
#alerts, #docDir, #docfiles, #funcdoc, #licensed, #logfilename, #logger, #loglevel, #metrics, #properties, #ttdocdir, #type
Instance Method Summary collapse
- #calculatedFieldsMap ⇒ Object
- #columnFieldsMap ⇒ Object
- #dbFieldsMap ⇒ Object
- #deAlias(fieldName, fAlias) ⇒ Object
- #field(fieldName) ⇒ Object
- #fieldAlias(fieldName, value) ⇒ Object
- #fieldAliases(fieldName) ⇒ Object
- #fieldHasAliases(fieldName) ⇒ Object
- #fieldTable(fieldName) ⇒ Object
- #fieldUIName(fieldName) ⇒ Object
- #has_field?(fieldName) ⇒ Boolean
- #id ⇒ Object
-
#initialize(dataSourceNode, workbook) ⇒ DataSource
constructor
A new instance of DataSource.
- #joinTree ⇒ Object
- #loadAliases ⇒ Object
- #loadAttributes(node) ⇒ Object
- #loadCalculatedFields ⇒ Object
- #loadColumnFields ⇒ Object
- #loadFieldUINames ⇒ Object
- #loadIsPublished ⇒ Object
- #loadJoinPairs ⇒ Object
- #loadJoinTree ⇒ Object
- #loadLocalFields ⇒ Object
- #loadMetadataFields ⇒ Object
-
#loadTableFields ⇒ Object
fields are unique in the data source by UI name.
- #loadTables(connection) ⇒ Object
- #mappedFieldsMap ⇒ Object
- #Parameters? ⇒ Boolean
- #processConnection ⇒ Object
- #processConnections ⇒ Object
- #pullTable(xml) ⇒ Object
-
#setConnectionHash ⇒ Object
Notes: - TODO: need to determine which, if any, of the connection attributes should be included in the hash in order to identify it unambiguously - without local values that obscure the data source’s ‘real’ identity - attributes with value ” don’t contribute to the hash.
- #tableauVersion ⇒ Object
- #tableFields ⇒ Object
- #updateTime ⇒ 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(dataSourceNode, workbook) ⇒ DataSource
Returns a new instance of DataSource.
65 66 67 68 69 70 71 72 73 74 75 76 77 |
# File 'lib/twb/datasource.rb', line 65 def initialize dataSourceNode, workbook @node = dataSourceNode @workbook = workbook @name = @node.attr('name') @caption = @node.attr('caption') @uiname = @caption.nil? ? @name : @caption # puts "DATASOURCE: #{@uiname}" processConnection # processFilters loadTableFields loadFieldUINames return self end |
Instance Attribute Details
#aliases ⇒ Object (readonly)
Returns the value of attribute aliases.
58 59 60 |
# File 'lib/twb/datasource.rb', line 58 def aliases @aliases end |
#allFields ⇒ Object (readonly)
Returns the value of attribute allFields.
60 61 62 |
# File 'lib/twb/datasource.rb', line 60 def allFields @allFields end |
#attributes ⇒ Object (readonly)
Returns the value of attribute attributes.
45 46 47 |
# File 'lib/twb/datasource.rb', line 45 def attributes @attributes end |
#calculatedField(name) ⇒ Object (readonly)
Returns the value of attribute calculatedField.
59 60 61 |
# File 'lib/twb/datasource.rb', line 59 def calculatedField @calculatedField end |
#calculatedFieldNames ⇒ Object (readonly)
Returns the value of attribute calculatedFieldNames.
59 60 61 |
# File 'lib/twb/datasource.rb', line 59 def calculatedFieldNames @calculatedFieldNames end |
#calculatedFieldNamesMap ⇒ Object (readonly)
Returns the value of attribute calculatedFieldNamesMap.
59 60 61 |
# File 'lib/twb/datasource.rb', line 59 def calculatedFieldNamesMap @calculatedFieldNamesMap end |
#calculatedFields ⇒ Object (readonly)
Returns the value of attribute calculatedFields.
59 60 61 |
# File 'lib/twb/datasource.rb', line 59 def calculatedFields @calculatedFields end |
#caption ⇒ Object (readonly)
Returns the value of attribute caption.
44 45 46 |
# File 'lib/twb/datasource.rb', line 44 def @caption end |
#columnFields ⇒ Object (readonly)
Returns the value of attribute columnFields.
52 53 54 |
# File 'lib/twb/datasource.rb', line 52 def columnFields @columnFields end |
#connAttributes ⇒ Object (readonly)
Returns the value of attribute connAttributes.
47 48 49 |
# File 'lib/twb/datasource.rb', line 47 def connAttributes @connAttributes end |
#connection ⇒ Object (readonly)
Returns the value of attribute connection.
47 48 49 |
# File 'lib/twb/datasource.rb', line 47 def connection @connection end |
#connections ⇒ Object (readonly)
Returns the value of attribute connections.
47 48 49 |
# File 'lib/twb/datasource.rb', line 47 def connections @connections end |
#connHash ⇒ Object (readonly)
Returns the value of attribute connHash.
47 48 49 |
# File 'lib/twb/datasource.rb', line 47 def connHash @connHash end |
#dbFields ⇒ Object (readonly)
Returns the value of attribute dbFields.
54 55 56 |
# File 'lib/twb/datasource.rb', line 54 def dbFields @dbFields end |
#dsclass ⇒ Object (readonly)
Returns the value of attribute dsclass.
46 47 48 |
# File 'lib/twb/datasource.rb', line 46 def dsclass @dsclass end |
#fieldUINames ⇒ Object (readonly)
Returns the value of attribute fieldUINames.
57 58 59 |
# File 'lib/twb/datasource.rb', line 57 def fieldUINames @fieldUINames end |
#filters ⇒ Object (readonly)
Returns the value of attribute filters.
62 63 64 |
# File 'lib/twb/datasource.rb', line 62 def filters @filters end |
#groups ⇒ Object (readonly)
Returns the value of attribute groups.
61 62 63 |
# File 'lib/twb/datasource.rb', line 61 def groups @groups end |
#hasField ⇒ Object (readonly)
Returns the value of attribute hasField.
51 52 53 |
# File 'lib/twb/datasource.rb', line 51 def hasField @hasField end |
#isExtract ⇒ Object (readonly)
Returns the value of attribute isExtract.
46 47 48 |
# File 'lib/twb/datasource.rb', line 46 def isExtract @isExtract end |
#isPublished ⇒ Object (readonly)
Returns the value of attribute isPublished.
48 49 50 |
# File 'lib/twb/datasource.rb', line 48 def isPublished @isPublished end |
#joinPairs ⇒ Object (readonly)
Returns the value of attribute joinPairs.
50 51 52 |
# File 'lib/twb/datasource.rb', line 50 def joinPairs @joinPairs end |
#localField ⇒ Object (readonly)
Returns the value of attribute localField.
51 52 53 |
# File 'lib/twb/datasource.rb', line 51 def localField @localField end |
#localFieldNames ⇒ Object (readonly)
Returns the value of attribute localFieldNames.
51 52 53 |
# File 'lib/twb/datasource.rb', line 51 def localFieldNames @localFieldNames end |
#localFields ⇒ Object (readonly)
Returns the value of attribute localFields.
51 52 53 |
# File 'lib/twb/datasource.rb', line 51 def localFields @localFields end |
#mappedFields ⇒ Object (readonly)
Returns the value of attribute mappedFields.
55 56 57 |
# File 'lib/twb/datasource.rb', line 55 def mappedFields @mappedFields end |
#metadataFields ⇒ Object (readonly)
Returns the value of attribute metadataFields.
53 54 55 |
# File 'lib/twb/datasource.rb', line 53 def @metadataFields end |
#name ⇒ Object (readonly)
Returns the value of attribute name.
44 45 46 |
# File 'lib/twb/datasource.rb', line 44 def name @name end |
#node ⇒ Object (readonly)
Returns the value of attribute node.
63 64 65 |
# File 'lib/twb/datasource.rb', line 63 def node @node end |
#tableFieldsMap ⇒ Object (readonly)
Returns the value of attribute tableFieldsMap.
56 57 58 |
# File 'lib/twb/datasource.rb', line 56 def tableFieldsMap @tableFieldsMap end |
#tables ⇒ Object (readonly)
Returns the value of attribute tables.
50 51 52 |
# File 'lib/twb/datasource.rb', line 50 def tables @tables end |
#uiname ⇒ Object (readonly)
Returns the value of attribute uiname.
44 45 46 |
# File 'lib/twb/datasource.rb', line 44 def uiname @uiname end |
#uuid ⇒ Object (readonly)
Returns the value of attribute uuid.
49 50 51 |
# File 'lib/twb/datasource.rb', line 49 def uuid @uuid end |
#workbook ⇒ Object (readonly)
Returns the value of attribute workbook.
43 44 45 |
# File 'lib/twb/datasource.rb', line 43 def workbook @workbook end |
Instance Method Details
#calculatedFieldsMap ⇒ Object
434 435 436 |
# File 'lib/twb/datasource.rb', line 434 def calculatedFieldsMap @calculatedFieldsMap ||= loadCalculatedFields end |
#columnFieldsMap ⇒ Object
232 233 234 235 |
# File 'lib/twb/datasource.rb', line 232 def columnFieldsMap loadColumnFields if @columnFieldsMap.nil? return @columnFieldsMap end |
#dbFieldsMap ⇒ Object
416 417 418 |
# File 'lib/twb/datasource.rb', line 416 def dbFieldsMap @tableFieldsMap end |
#deAlias(fieldName, fAlias) ⇒ Object
308 309 310 311 312 313 |
# File 'lib/twb/datasource.rb', line 308 def deAlias fieldName, fAlias fldAliases = aliases[fieldName] return fAlias if fldAliases.nil? dbFieldValue = fldAliases.key(fAlias) dbFieldValue.nil? ? fAlias : dbFieldValue end |
#field(fieldName) ⇒ Object
475 476 477 |
# File 'lib/twb/datasource.rb', line 475 def field fieldName dbFieldsMap[fieldName] end |
#fieldAlias(fieldName, value) ⇒ Object
300 301 302 303 304 305 306 |
# File 'lib/twb/datasource.rb', line 300 def fieldAlias fieldName, value emit "fieldAlias: #{fieldName.class} -> #{value.class}" loadAliases if @aliases.nil? return value if @aliases.nil? || @aliases[fieldName].nil? # unless fieldHasAliases(fieldName) fldAlias = @aliases[fieldName][value] fldAlias.nil? ? value : fldAlias end |
#fieldAliases(fieldName) ⇒ Object
296 297 298 |
# File 'lib/twb/datasource.rb', line 296 def fieldAliases fieldName aliases[fieldName] end |
#fieldHasAliases(fieldName) ⇒ Object
292 293 294 |
# File 'lib/twb/datasource.rb', line 292 def fieldHasAliases fieldName !aliases[fieldName].nil? end |
#fieldTable(fieldName) ⇒ Object
479 480 481 482 483 |
# File 'lib/twb/datasource.rb', line 479 def fieldTable fieldName loadTableFields if @tableFieldsMap.nil? dbField = @tableFieldsMap[fieldName] return dbField.nil? ? nil : dbField.dbtable end |
#fieldUIName(fieldName) ⇒ Object
368 369 370 371 |
# File 'lib/twb/datasource.rb', line 368 def fieldUIName fieldName loadFieldUINames if @fieldUINames.nil? @fieldUINames[fieldName].nil? ? fieldName : @fieldUINames[fieldName] end |
#has_field?(fieldName) ⇒ Boolean
471 472 473 |
# File 'lib/twb/datasource.rb', line 471 def has_field? fieldName dbFieldsMap.has_key? fieldName end |
#id ⇒ Object
97 98 99 |
# File 'lib/twb/datasource.rb', line 97 def id @id ||= @id = @name end |
#joinTree ⇒ Object
200 201 202 |
# File 'lib/twb/datasource.rb', line 200 def joinTree @joinTree ||= loadJoinTree end |
#loadAliases ⇒ Object
254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 |
# File 'lib/twb/datasource.rb', line 254 def loadAliases @aliases = {} # puts $node.xpath('.//column/aliases/..').length cnt = 0 @node.xpath('./column//aliases/..').each do |anode| # puts "anode:: #{anode}" # puts " path:: #{anode.path}" aliasMap = {} nameTech = anode.attribute('name').text.gsub(/^\[|\]$/,'') name = fieldUIName nameTech if ':Measure Names'.eql? name # puts "processing Measure Names" anode.xpath('.//alias').each do |vnode| keyCode = vnode.attribute('key').text.gsub(/^[#"%]|[#"%]$/,'') key = Twb::CodedField.new(keyCode).name field = fieldUIName key alia = vnode.attribute('value').text # puts " keyCode:: #{key}" # puts " key :: #{key}" # puts " field :: #{field}" # puts " alias :: #{alia}" aliasMap[field] = alia end else anode.xpath('.//alias').each do |vnode| key = vnode.attribute('key').text.gsub(/^[#"]|[#"]$/,'') alia = vnode.attribute('value').text # puts " key :: #{key}" # puts "alias:: #{alia}" aliasMap[key] = alia end end @aliases[name] = aliasMap end emit "FIELD ALIASES: @aliases" return @aliases end |
#loadAttributes(node) ⇒ Object
87 88 89 90 91 92 93 94 95 |
# File 'lib/twb/datasource.rb', line 87 def loadAttributes node attributes = {} unless node.nil? node.attributes.each do |k,v| attributes[k] = v.text end end return attributes end |
#loadCalculatedFields ⇒ Object
453 454 455 456 457 458 459 460 461 |
# File 'lib/twb/datasource.rb', line 453 def loadCalculatedFields @calculatedFieldsMap = {} cfnodes = @node.xpath("./column[calculation]") cfnodes.each do |node| calcField = Twb::CalculatedField.new node, self @calculatedFieldsMap[calcField.uiname] = calcField end return @calculatedFieldsMap end |
#loadColumnFields ⇒ Object
237 238 239 240 241 242 243 244 245 246 247 248 |
# File 'lib/twb/datasource.rb', line 237 def loadColumnFields @columnFields = Set.new @columnFieldsMap = {} nodes = @node.xpath('./column') nodes.each do |n| field = Twb::ColumnField.new n, self @columnFields << field @columnFieldsMap[field.uiname] = field @columnFieldsMap[field.name] = field end return @columnFields end |
#loadFieldUINames ⇒ Object
378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 |
# File 'lib/twb/datasource.rb', line 378 def loadFieldUINames # puts 'loadFieldUINames' @fieldUINames = {} # puts 'metadataFields' .each do |fld| # puts " - name:%-45s | uiname:%-45s | localName:%-45s " % [ "'#{fld.name}'", "'#{fld.uiname}'", "'#{fld.localName}'"] @fieldUINames[fld.uiname] = fld.uiname @fieldUINames[fld.localName] = fld.uiname unless fld.localName.nil? @fieldUINames[fld.name] = fld.uiname unless fld.name.nil? end # puts 'calculatedFields' calculatedFields.each do |fld| # puts " - name:%-45s | uiname:%-45s " % [ "'#{fld.name}'", "'#{fld.uiname}'"] @fieldUINames[fld.name] = fld.uiname @fieldUINames[fld.uiname] = fld.uiname end # puts 'localFields' localFields.each do |fld| # puts " - name:%-45s | uiname:%-45s " % [ "'#{fld.name}'", "'#{fld.uiname}'"] @fieldUINames[fld.name] = fld.uiname @fieldUINames[fld.uiname] = fld.uiname end # puts "columnFields: #{columnFields.length}" columnFields.each do |fld| @fieldUINames[fld.name] = fld.uiname @fieldUINames[fld.uiname] = fld.uiname end groups.each do |fld| @fieldUINames[fld.name] = fld.uiname @fieldUINames[fld.uiname] = fld.uiname end return @fieldUINames end |
#loadIsPublished ⇒ Object
173 174 175 |
# File 'lib/twb/datasource.rb', line 173 def loadIsPublished @isPublished = !node.at_xpath('./repository-location').nil? end |
#loadJoinPairs ⇒ Object
189 190 191 192 193 194 195 196 197 198 |
# File 'lib/twb/datasource.rb', line 189 def loadJoinPairs @joinPairs = Set.new mainJoin = @node.xpath("./connection/relation[@type='join']") clauses = @node.xpath(".//relation[@type='join']/clause") clauses.each do |clause| leafs = clause.xpath('.//expression[not(node())]') @joinPairs << [ pullTable(leafs[0]) , pullTable(leafs[1]) ] end return @joinPairs end |
#loadJoinTree ⇒ Object
204 205 206 207 208 209 210 211 212 213 214 215 216 217 |
# File 'lib/twb/datasource.rb', line 204 def loadJoinTree loadJoinPairs if @joinPairs.nil? # puts "LJT::#{@uiname}::joinPairs:: #{@joinPairs.inspect}" # @joinPairs.each { |jp| # puts "JP::#{jp}" } @joinTree = JoinTree.new(@name) @joinPairs.each do |from,to| # puts "from:#{from} -> to:#{to}" tableFrom = JoinTable.new(from) tableTo = JoinTable.new(to) @joinTree.add(tableFrom, tableTo) end # puts '---' return @joinTree end |
#loadLocalFields ⇒ Object
319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 |
# File 'lib/twb/datasource.rb', line 319 def loadLocalFields @localFields = Set.new unless @connection.nil? # Parameters has no connection node, & no local fields connClass = @node.at_xpath('./connection').attribute('class').text fxpath = case connClass when 'dataengine' then './column' when 'sqlserver' then './column' else './connection/relation/columns/column' end nodes = @node.xpath(fxpath) nodes.each do |node| field = Twb::LocalField.new(node) @localFields << field end end return @localFields end |
#loadMetadataFields ⇒ Object
341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 |
# File 'lib/twb/datasource.rb', line 341 def loadMetadataFields @metadataFields = Set.new unless @connection.nil? # Parameters has no connection node, & no metadata fields # nodes = @node.xpath(".//metadata-record[@class='column']") # # note: there are other nodes "<metadata-record class='capability'>" whose nature is unclear # # these nodes have no value for their <name node, so are not loaded nodes = @node.xpath("./connection//metadata-record[@class='column']") nodes.each do |node| field = Twb::MetadataField.new(node) field.source = :db @metadataFields << field end nodes = @node.xpath('./extract//metadata-record') nodes.each do |node| field = Twb::MetadataField.new(node) field.source = :extract @metadataFields << field end end return @metadataFields end |
#loadTableFields ⇒ Object
fields are unique in the data source by UI name
486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 |
# File 'lib/twb/datasource.rb', line 486 def loadTableFields # puts "DATA SOURCE FIELD TABLE LOAD" @tableFieldsMap = {} fieldNodes = @node.xpath('./connection/cols/map') fieldNodes.each do |fn| dbField = Twb::DbField.new(@uiname, fn, :map) @tableFieldsMap[dbField.uiname] = dbField end relTableNodes = @node.xpath('.//relation[@table]') relTableNodes.each do |relNode| table = relNode.attribute('name').text cols = relNode.xpath('./columns/column') cols.each do |col| dbField = Twb::DbField.new(@uiname, col, :tableColumn, table) fldName = col.attribute('name') @tableFieldsMap[dbField.uiname] = dbField end end end |
#loadTables(connection) ⇒ Object
177 178 179 180 181 182 183 |
# File 'lib/twb/datasource.rb', line 177 def loadTables connection @tables = {} nodes = connection.xpath(".//relation[@type='table']") nodes.each do |node| @tables[node.attr('name')] = node.attr('table') end end |
#mappedFieldsMap ⇒ Object
424 425 426 427 |
# File 'lib/twb/datasource.rb', line 424 def mappedFieldsMap loadTableFields if @tableFieldsMap.nil? return @tableFieldsMap end |
#Parameters? ⇒ Boolean
224 225 226 |
# File 'lib/twb/datasource.rb', line 224 def Parameters? 'Parameters'.eql? @name end |
#processConnection ⇒ Object
118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 |
# File 'lib/twb/datasource.rb', line 118 def processConnection path conns = @node.xpath(path) conns.each do |connNode| connClass = @dsclass cpath = conn.path connPath = cpath.gsub(/\[[0-9]+\]/,'') connPNum = /(\d+)/.match(cpath) # puts cpath, connPath # puts "CPATH: #{cpath}" conn.attributes.each do |name,value| # puts "\n\t\t - %-15s -> %-s" % [name, value] $csvFile << [ $recCount += 1, $twbName, $dir, $build, $version, $dsName, $dstype, $dsuiname, connClass, connPath, connPNum, name, value.value ] end end end |
#processConnections ⇒ Object
113 114 115 116 |
# File 'lib/twb/datasource.rb', line 113 def processConnections processConnection ds, './/connection' processConnection ds, './/named-connection' end |
#pullTable(xml) ⇒ Object
219 220 221 222 |
# File 'lib/twb/datasource.rb', line 219 def pullTable xml code =xml.attribute('op').text table = code.split('].[')[0][1..-1] end |
#setConnectionHash ⇒ Object
Notes:
- TODO: need to determine which, if any, of the connection attributes should be
included in the hash in order to identify it unambiguously - without
local values that obscure the data source's 'real' identity
- attributes with value '' don't contribute to the hash
155 156 157 158 159 160 161 162 163 |
# File 'lib/twb/datasource.rb', line 155 def setConnectionHash dsAttributes = @node.xpath('./connection/@*') dsConnStr = '' dsAttributes.each do |attr| dsConnStr += attr.text end @connHash = Digest::MD5.hexdigest(dsConnStr) @uuid = @connHash end |
#tableauVersion ⇒ Object
101 102 103 |
# File 'lib/twb/datasource.rb', line 101 def tableauVersion tabVersion @tableauVersion = tabVersion end |
#tableFields ⇒ Object
412 413 414 |
# File 'lib/twb/datasource.rb', line 412 def tableFields @tableFieldsMap.values end |
#updateTime ⇒ Object
363 364 365 366 |
# File 'lib/twb/datasource.rb', line 363 def updateTime attr = @node.xpath('.//@update-time').first @updateTime = attr.nil? ? nil : attr.value end |