15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
# File 'lib/dbdb_builder.rb', line 15
def DatabaseDatabaseBuilder.get_data_sources(doc)
data_sources = {}
data_source_container = doc.xpath("//DataSources")
data_source_count = data_source_container.attribute("count")
data_source_container.xpath("./*").each do |data_source_node|
name = data_source_node.xpath("Name").text
column_container = data_source_node.xpath("Columns")
columns = []
column_container.xpath("./value").each do |column|
columns << column.text.split(",")[0]
end
sql = data_source_node.xpath("SqlCommand").text
sql.gsub!("\n", " ")
data_source = {}
data_source["columns"] = columns
data_source["sql"] = sql
data_sources[name] = data_source
end
return data_sources
end
|