Module: GoodData::CloudConnect::Helpers
- Includes:
- GoodData::CloudConnect
- Defined in:
- lib/cloud_connect/dsl/helpers.rb,
lib/cloud_connect/dsl/es_helpers.rb,
lib/cloud_connect/dsl/sf_helpers.rb,
lib/cloud_connect/dsl/structure_helpers.rb
Class Method Summary collapse
- .create_deleted_records_meta(builder) ⇒ Object
- .create_es_write_json(tap) ⇒ Object
- .create_file_list_meta(builder) ⇒ Object
- .create_lookup_meta(builder) ⇒ Object
- .create_moving_graph(file, options = {}) ⇒ Object
- .create_read_error_meta(builder) ⇒ Object
- .create_run_graph(file, options = {}) ⇒ Object
- .create_run_graph_failure_metadata(builder) ⇒ Object
- .create_trash_meta(builder) ⇒ Object
- .csv_metadata(builder, description) ⇒ Object
- .generate_incremental_select(tap) ⇒ Object
- .generate_select(tap, options = {}) ⇒ Object
-
.loop_over_file(file, options = {}) ⇒ Object
Structural pattern loop_over_file will loop over every line provided in the file given as parameter it will run the graph given as options it will make all arrangments that the underlying graph will have access to only one line thus making a loop.
- .metadata(builder, description) ⇒ Object
- .objects_for_history(client, tap) ⇒ Object
- .property(builder, data) ⇒ Object
- .property_file(builder, data) ⇒ Object
- .save_metadata(filename, data) ⇒ Object
- .sf_connection(builder, data) ⇒ Object
-
.sink_out_gd_metadata(metadata, sink) ⇒ Object
prepares a sink for sinking into GD.
Class Method Details
.create_deleted_records_meta(builder) ⇒ Object
20 21 22 23 24 25 26 27 28 29 30 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 20 def self.(builder) builder.Metadata({:id => "deleted_records_metadata"}) do |builder| (builder, { :name => "deleted_records_metadata", :fields => [ {:type => "string", :name => "Id"}, {:type => "string", :name => "Timestamp"} ] }) end end |
.create_es_write_json(tap) ⇒ Object
5 6 7 8 9 10 11 12 13 14 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 45 46 |
# File 'lib/cloud_connect/dsl/es_helpers.rb', line 5 def self.create_es_write_json(tap) fail "Only tap should be used here. You provided \"#{tap}\"" unless tap[:type] == :tap { :entityName => tap[:id] || tap[:object], :fieldsMapping => tap[:fields].reduce({}) do |memo, f| if f.has_key?(:acts_as) f[:acts_as].each do |a| type = case a when "Id" "recordid" when "Timestamp" "timestamp" else f[:type] || "attribute" end memo[a] = { :name => a, :type => type } end else type = case f[:name] when "Id" "recordid" when "Timestamp" "timestamp" else f[:type] || "attribute" end memo[f[:meta] || f[:name]] = { :name => f[:name], :type => type } end memo end } end |
.create_file_list_meta(builder) ⇒ Object
132 133 134 135 136 137 138 139 140 141 142 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 132 def self.(builder) builder.Metadata({:id => "file_list"}) do |builder| (builder, { :name => "file_list", :fields => [ {:name => "filePath", :type => "string"}, {:name => "fileName", :type => "string"} ] }) end end |
.create_lookup_meta(builder) ⇒ Object
123 124 125 126 127 128 129 130 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 123 def self.(builder) builder.Metadata({:id => "lookup_metadata"}) do |builder| (builder, { :name => "lookup_metadata", :fields => [{:type => "string", :name => "key"}, {:type => "string", :name => "value"}] }) end end |
.create_moving_graph(file, options = {}) ⇒ Object
52 53 54 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 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 52 def self.create_moving_graph(file, ={}) source = [:source] target = [:target] operation = [:operation] force = [:force] || false File.open(file, "w") do |file| builder = Builder::XmlMarkup.new(:target=>file, :indent=>2) builder.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8" builder.Graph({ :name => "File Copy" }) do builder.Global do builder.Metadata({:id => "list_metadata"}) do |builder| CloudConnect::Helpers::(builder, { :name => "list_metadata", :fields => [{:name=>"filePath", :type=>"string"}] }) end CloudConnect::Helpers::property_file(builder, {:id => "workspace_params", :fileURL => "workspace.prm"}) end builder.Phase(:number => 0) do transformation_source = "function integer transform() {\n" + ([["filePath", "filePath"]].map {|t| "$out.0.#{t.last} = $in.0.#{t.first};"}.join("\n")) + "\nreturn OK;\n}" Core::build_node2(builder, Nodes.file_list2(:baseURL => target, :id => "file_list", :output_mapping => transformation_source)) Core::build_node2(builder, Nodes.file_delete2(:baseURL => "${filePath}", :id => "file_delete")) Core::build_node2(builder, Nodes.edge2({:toNode => "file_delete:0", :fromNode => "file_list:0", :metadata => "list_metadata"})) end builder.Phase(:number => 1) do Core::build_node2(builder, Nodes.file_copy2({:sourcePath => source, :targetPath => target, :operation => operation, :id => "file_copy"})) end end end end |
.create_read_error_meta(builder) ⇒ Object
144 145 146 147 148 149 150 151 152 153 154 155 156 157 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 144 def self.(builder) builder.Metadata({:id => "reader_error_metadata"}) do |builder| (builder, { :name => "reader_error_metadata", :fields => [ {:name => "line_number", :type => "integer"}, {:name => "field_number", :type => "integer"}, {:name => "record", :type => "string"}, {:name => "message", :type => "string"}, {:name => "file", :type => "string"} ] }) end end |
.create_run_graph(file, options = {}) ⇒ Object
174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 174 def self.create_run_graph(file, ={}) subgraphs = [:subgraphs] flow = [:flow] File.open(file, "w") do |file| builder = Builder::XmlMarkup.new(:target=>file, :indent=>2) builder.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8" builder.Graph({ :name => "Run graph" }) do builder.Global do property_file(builder, {:id => "workspace_params", :fileURL => "workspace.prm"}) property_file(builder, {:id => "params_params", :fileURL => "params.prm"}) (builder) (builder) end phase = 0 subgraphs.each do |subgraph| name = GoodData::Bam::Step.step_name(GoodData::Bam::Graph.create(:path => subgraph)) # Pathname(subgraph).basename.to_s.chomp(Pathname(subgraph).extname) builder.Phase(:number => phase+1) do id1 = GoodData::CloudConnect::Nodes.get_id id2 = GoodData::CloudConnect::Nodes.get_id ctl = "function integer generate() {$out.0.all = \"FLOW=#{flow}\";return OK;}" Core::build_node2(builder, Nodes.data_generator2({:name => id1, :id => id1, :generate => ctl})) Core::build_node2(builder, Nodes.edge2({:toNode => "#{id2}:0", :fromNode => "#{id1}:0", :metadata => "trash_metadata"})) Core::build_node2(builder, Nodes.writer2({:name => "PARAMS CSV Writer", :id => "#{id2}", :fileURL => "params.prm", :outputFieldNames => "false", :quotedStrings => "false"})) end builder.Phase(:number => phase+2) do id1 = GoodData::CloudConnect::Nodes.get_id id2 = GoodData::CloudConnect::Nodes.get_id ctl = "function integer generate() {$out.0.all = \"NAME=#{name}\";return OK;}" Core::build_node2(builder, Nodes.data_generator2({:name => id1, :id => id1, :generate => ctl})) Core::build_node2(builder, Nodes.edge2({:toNode => "#{id2}:0", :fromNode => "#{id1}:0", :metadata => "trash_metadata"})) Core::build_node2(builder, Nodes.writer2({:name => "PARAMS CSV Writer", :id => "#{id2}", :fileURL => "params.prm", :outputFieldNames => "false", :append => "true", :quotedStrings => "false"})) end builder.Phase(:number => phase+3) do Core::build_node2(builder, Nodes.run_graph2({:guiName => name, :name => name, :id => flow, :graphName => subgraph})) end phase += 4 end end end end |
.create_run_graph_failure_metadata(builder) ⇒ Object
159 160 161 162 163 164 165 166 167 168 169 170 171 172 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 159 def self.(builder) builder.Metadata({:id => "run_graph_failure_metadata"}) do |builder| (builder, { :name => "run_graph_failure_metadata", :fields => [ {:type => "string", :name => "graph"}, {:type => "string", :name => "result"}, {:type => "string", :name => "description"}, {:type => "string", :name => "message"}, {:type => "decimal", :name => "duration"} ] }) end end |
.create_trash_meta(builder) ⇒ Object
32 33 34 35 36 37 38 39 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 32 def self.(builder) builder.Metadata({:id => "trash_metadata"}) do |builder| (builder, { :name => "trash_metadata", :fields => [{:type => "string", :name => "all"}] }) end end |
.csv_metadata(builder, description) ⇒ Object
88 89 90 91 92 93 94 95 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 88 def self.(builder, description) sf_description = description.merge({ :fieldDelimiter => ",", :recordDelimiter => "\\n", :type => "delimited", }) (builder, sf_description) end |
.generate_incremental_select(tap) ⇒ Object
26 27 28 29 30 31 32 33 34 35 |
# File 'lib/cloud_connect/dsl/sf_helpers.rb', line 26 def self.generate_incremental_select(tap) if tap[:condition].blank? tap[:condition] = "SystemModstamp > ${#{tap[:id]}_START}" # AND SystemModstamp <= ${#{tap[:id]}_END} else tap[:condition] += " AND SystemModstamp > ${#{tap[:id]}_START}" # AND SystemModstamp <= ${#{tap[:id]}_END} end generate_select(tap) end |
.generate_select(tap, options = {}) ⇒ Object
11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
# File 'lib/cloud_connect/dsl/sf_helpers.rb', line 11 def self.generate_select(tap, ={}) field = [:only] fields = if field.nil? tap[:fields] else tap[:fields].find_all {|f| f[:name] == field} end fields = fields.map do |f| f.has_key?(:multi_currency) ? "convertCurrency(#{f[:name]})" : f[:name] end condition = tap[:condition].nil?() ? "" : "WHERE #{tap[:condition]}" limit = tap[:limit].nil?() ? "" : "LIMIT #{tap[:limit]}" "SELECT #{fields.join(', ')} FROM #{tap[:object]} #{condition} #{limit}" end |
.loop_over_file(file, options = {}) ⇒ Object
Structural pattern loop_over_file will loop over every line provided in the file given as parameter it will run the graph given as options it will make all arrangments that the underlying graph will have access to only one line thus making a loop
11 12 13 14 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 45 46 47 48 49 50 51 52 53 54 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 93 94 95 |
# File 'lib/cloud_connect/dsl/structure_helpers.rb', line 11 def self.loop_over_file(file, ={}) file_to_loop = [:file_to_loop] token = [:token] graph_to_run = [:graph_to_run] fail "token not defined" if token.blank? fail "file to loop if not defined" if file_to_loop.blank? fail "graph_to_run not defined" if graph_to_run.blank? File.open(file, "w") do |f| builder = Builder::XmlMarkup.new(:target=>f, :indent=>2) builder.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8" builder.Graph({ :name => "Contract Checker: File list reader" }) do builder.Global do CloudConnect::Helpers::property_file(builder, {:id => "workspace_params", :fileURL => "workspace.prm"}) CloudConnect::Helpers::property_file(builder, {:id => "skiplines_params", :fileURL => "#{token}_counter.prm"}) CloudConnect::Helpers::(builder) CloudConnect::Helpers::(builder) CloudConnect::Helpers::(builder) end reformat_func = <<HEREDOC function integer transform() { $out.0.all = "FILE=" + $in.0.filePath; return ALL; } HEREDOC builder.Phase(:number => 0) do Core::build_node2(builder, Nodes.reader2({ :id => "#{token}_reader", :guiName => "#{token}_reader", :name => "#{token}_reader", :dataPolicy => "Strict", :skipRows => "${#{token}_SKIP_LINES}", :numRecords => 1, :fileURL => file_to_loop })) Core::build_node2(builder, Nodes.reformat2({:name => "#{token} Reformat", :id => "#{token}_reformat", :transformation => reformat_func })) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_reformat:0", :fromNode => "#{token}_reader:0", :metadata => "file_list" })) Core::build_node2(builder, Nodes.writer2({:name => "PARAMS CSV Writer", :id => "#{token}_writer", :fileURL => "#{token}_item.prm" , :outputFieldNames => "false", :quotedStrings => "false"})) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_writer:0", :fromNode => "#{token}_reformat:0", :metadata => "trash_metadata" })) end builder.Phase(:number => 1) do reformat_func = <<HEREDOC function integer transform() { $out.0.all = "#{graph_to_run}"; return ALL; } HEREDOC fail_func = <<HEREDOC function integer transform() { raiseError("Graph #{graph_to_run} failed"); } HEREDOC Core::build_node2(builder, Nodes.reformat2({:name => "#{token} Reformat_graph", :id => "#{token}_reformat_graph", :transformation => reformat_func })) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_reformat_graph:0", :fromNode => "#{token}_reformat:1", :metadata => "trash_metadata" })) Core::build_node2(builder, Nodes.run_graph2({:guiName => "#{token}_validate", :name => "#{token}_validate", :id => "#{token}_validate" })) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_validate:0", :fromNode => "#{token}_reformat_graph:0", :metadata => "trash_metadata" })) Core::build_node2(builder, Nodes.reformat2({:name => "#{token} Reformat_fail", :id => "#{token}_reformat_fail", :transformation => fail_func })) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_reformat_fail:0", :fromNode => "#{token}_validate:1", :metadata => "run_graph_failure_metadata" })) Core::build_node2(builder, Nodes.trash2({:name => "#{token}_trash", :id => "#{token}_trash", :debugPrint => true})) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_trash:0", :fromNode => "#{token}_reformat_fail:0", :metadata => "run_graph_failure_metadata"})) end builder.Phase(:number => 2) do ctl = "function integer generate() {$out.0.all = \"#{token}_SKIP_LINES=\" + toString(${#{token}_SKIP_LINES} + 1);return OK;}" Core::build_node2(builder, Nodes.data_generator2({:name => "#{token}_generator", :id => "#{token}_generator", :generate => ctl})) Core::build_node2(builder, Nodes.writer2({:name => "PARAMS CSV Writer", :id => "#{token}_csv_writer", :fileURL => "#{token}_counter.prm", :outputFieldNames => "false", :quotedStrings => "false"})) Core::build_node2(builder, Nodes.edge2({:toNode => "#{token}_csv_writer:0", :fromNode => "#{token}_generator:0", :metadata => "trash_metadata" })) end end end end |
.metadata(builder, description) ⇒ Object
105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 105 def self.(builder, description) builder.Record({ :fieldDelimiter => description[:fieldDelimiter], :name => description[:name], :recordDelimiter => description[:recordDelimiter], :type => description[:type] }) do |record| description[:fields].each do |field| # binding.pry if field.has_key?(:length) cloned_field = field.clone cloned_field[:type] = "string" if cloned_field[:type].blank? cloned_field[:nullable] = "true" if cloned_field[:nullable].blank? builder.Field cloned_field end end end |
.objects_for_history(client, tap) ⇒ Object
5 6 7 8 9 |
# File 'lib/cloud_connect/dsl/sf_helpers.rb', line 5 def self.objects_for_history(client, tap) sf_module = tap[:object] modules = client.modules.map {|o| o[:name]} modules.find_all {|m| ["#{sf_module}History", "#{sf_module}FieldHistory"].include?(m) } end |
.property(builder, data) ⇒ Object
5 6 7 8 9 10 11 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 5 def self.property(builder, data) builder.Property({ :id => data[:id], :name => data[:name] || data[:id], :value => data[:value] }) end |
.property_file(builder, data) ⇒ Object
13 14 15 16 17 18 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 13 def self.property_file(builder, data) builder.Property({ :id => data[:id], :fileURL => data[:fileURL] }) end |
.save_metadata(filename, data) ⇒ Object
41 42 43 44 45 46 47 48 49 50 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 41 def self.(filename, data) dirname = File.dirname(filename) FileUtils.mkdir_p(dirname) unless File.directory?(dirname) File.open(filename, "w") do |file| builder = Builder::XmlMarkup.new(:target => file, :indent=>2) builder.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8" (builder, data) end end |
.sf_connection(builder, data) ⇒ Object
37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
# File 'lib/cloud_connect/dsl/sf_helpers.rb', line 37 def self.sf_connection(builder, data) builder.Connection({ :clientId => "${SFDC_CLIENT_ID}", :id => "SFDC", :loginHostname => "${SFDC_LOGIN_HOSTNAME}", :name => "${SFDC_NAME}", :password => "${SFDC_PASSWORD}", :passwordEncrypted => "true", :token => "${SFDC_TOKEN}", :type => "SFDC", :username => "${SFDC_USERNAME}", :passwordEncrypted => "false", :consumerKey => "${SFDC_CONSUMER_KEY}", :consumerSecret => "${SFDC_CONSUMER_SECRET}", :credentialsType => "${SFDC_CREDENTIALS_TYPE}", :refreshToken => "${SFDC_REFRESH_TOKEN}" }) end |
.sink_out_gd_metadata(metadata, sink) ⇒ Object
prepares a sink for sinking into GD. This means dealing with stuff like scientific notation which is handled bu uploading as a decimal and not string
98 99 100 101 102 103 |
# File 'lib/cloud_connect/dsl/helpers.rb', line 98 def self.(, sink) = [:fields] sink_facts = GoodData::Bam::Sink.get_fact_fields(sink).map {|f| f[:meta]} x = .map {|f| sink_facts.include?(f[:name]) ? f.merge({:type => "decimal", :length => 20, :scale => 3}) : f} GoodData::Bam::Metadata.create(.merge({:fields => x})) end |