<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> <html lang=‘en’ xml:lang=‘en’ xmlns=‘www.w3.org/1999/xhtml’>
<head> <title>library/generic/performance_report.rb</title> <link href="./assets/0.2.3/screen.css" media="all" rel="stylesheet" type="text/css" /> <link href="./assets/0.2.3/print.css" media="print" rel="stylesheet" type="text/css" /> <meta http-equiv="Content-type" content="text/html;charset=UTF-8" /> <script type="text/javascript" src="./assets/0.2.3/rcov.js"></script> </head> <body> <h1>Cukes C0 Coverage Information - Simploco - RCov</h1> <h2>library/generic/performance_report.rb</h2> <div class="report_table_wrapper"> <table class='report' id='report_table'> <thead> <tr> <th class="left_align">Name</th> <th class="right_align">Total Lines</th> <th class="right_align">Lines of Code</th> <th class="left_align">Total Coverage</th> <th class="left_align">Code Coverage</th> </tr> </thead> <tbody> <tr> <td class="left_align"><a href="library-generic-performance_report_rb.html">library/generic/performance_report.rb</a></td> <td class='right_align'><tt>518</tt></td> <td class='right_align'><tt>255</tt></td> <td class="left_align"><div class="percent_graph_legend"><tt class=''>54.44%</tt></div> <div class="percent_graph"> <div class="covered" style="width:54px"></div> <div class="uncovered" style="width:46px"></div> </div></td> <td class="left_align"><div class="percent_graph_legend"><tt class=''>7.45%</tt></div> <div class="percent_graph"> <div class="covered" style="width:7px"></div> <div class="uncovered" style="width:93px"></div> </div></td> </tr> </tbody> </table> </div> <h3>Key</h3> <div class="key"><pre><span class='marked'>Code reported as executed by Ruby looks like this...</span><span class='marked1'>and this: this line is also marked as covered.</span><span class='inferred'>Lines considered as run by rcov, but not reported by Ruby, look like this,</span><span class='inferred1'>and this: these lines were inferred by rcov (using simple heuristics).</span><span class='uncovered'>Finally, here's a line marked as not executed.</span></pre></div> <h3>Coverage Details</h3> <table class="details"> <tbody> <tr class="inferred"> <td><pre><a name="line2">2</a> =begin</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line3">3</a> *Name : CustomHtmlReport</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line4">4</a> *Description : class that holds performance report data generator methods</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line5">5</a> *Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line6">6</a> *Creation Date : 05/03/2015</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line7">7</a> *Updation Date :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line8">8</a> =end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line9">9</a> </pre></td> </tr> <tr class="marked"> <td><pre><a name="line10">10</a> module CUKES</pre></td> </tr> <tr class="marked"> <td><pre><a name="line11">11</a> class PerformanceReport</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line12">12</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line13">13</a> # Description : invoked automatically when an object of the class type is created</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line14">14</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line15">15</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line16">16</a> # arr_file_paths : array of html report file paths</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line17">17</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line18">18</a> def initialize(arr_file_path)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line19">19</a> @arr_file_name = arr_file_path</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line20">20</a> @num_build_duration = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line21">21</a> @bool_build_passed = true</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line22">22</a> @num_feature_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line23">23</a> @num_feature_pass_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line24">24</a> @num_feature_fail_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line25">25</a> @num_feature_skip_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line26">26</a> @str_connection_url = "DBI:SQLAnywhere:SERVER=#{DB_SERVER};DBN=#{DB_NAME}"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line27">27</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line28">28</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line29">29</a> # Description : parses the json object saves the required execution data into Sybase DB</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line30">30</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line31">31</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line32">32</a> def parse_json</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line33">33</a> @json.each_with_index do |json, index| # iterate each feature</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line34">34</a> str_feature_id, num_feature_result_id = set_feature(json["name"].to_s) # add feature name</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line35">35</a> @num_feature_count += 1</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line36">36</a> scenario_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line37">37</a> feature_duration = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line38">38</a> bool_feature_passed = true</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line39">39</a> num_scenario_pass_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line40">40</a> num_scenario_fail_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line41">41</a> num_scenario_skip_count = 0</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line42">42</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line43">43</a> json["elements"].each do |element|</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line44">44</a> # for including the first background steps duration to the first scenario background steps as Cucumber json</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line45">45</a> # report considers background for the first scenario and hence will have 0 duration for the background steps</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line46">46</a> # under first scenario and the actual duration for the background will be set for the subsequent scenarios</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line47">47</a> if index == 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line48">48</a> if element["keyword"] == "Background"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line49">49</a> element["steps"].each do |step|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line50">50</a> @arr_background_step_duration << step["result"]["duration"].to_i</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line51">51</a> @bool = true</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line52">52</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line53">53</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line54">54</a> end</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line55">55</a> num_step_pass_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line56">56</a> num_step_fail_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line57">57</a> num_step_skip_count = 0</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line58">58</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line59">59</a> if element["keyword"] == "Scenario" # take scenario for scenario level details</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line60">60</a> str_scenario_id, scenario_result_id = set_scenario(element["name"], element["tags"][0]["name"], str_feature_id) # add scenario name</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line61">61</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line62">62</a> scenario_count += 1 # as it counts only 'Scenarios' and not 'Backgrounds'</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line63">63</a> step_count = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line64">64</a> scenario_duration = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line65">65</a> bool_scenario_passed = true</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line66">66</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line67">67</a> element["steps"].each_with_index do |step, indx| # iterate each steps of the current scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line68">68</a> #num_step_id, num_step_result_id = set_step(step['keyword']+step['name'], str_scenario_id, scenario_result_id) # add step name</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line69">69</a> num_step_id = set_step(step['keyword']+step['name'], str_scenario_id, scenario_result_id) # add step name</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line70">70</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line71">71</a> step_count += 1</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line72">72</a> step_duration = 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line73">73</a> bool_step_passed = true</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line74">74</a> if (index == 0) && (indx < @arr_background_step_duration.size) && @bool</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line75">75</a> step_duration = @arr_background_step_duration[indx] # take duration from Background for the first scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line76">76</a> else</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line77">77</a> step_duration = step['result']['duration'].to_i # take usual duration</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line78">78</a> @bool = false</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line79">79</a> end</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line80">80</a> scenario_duration += step_duration</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line81">81</a> if step['result']['status'] == "passed"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line82">82</a> num_step_pass_count += 1</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line83">83</a> elsif step['result']['status'] == "failed"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line84">84</a> num_step_fail_count += 1</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line85">85</a> elsif step['result']['status'] == "skipped"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line86">86</a> num_step_skip_count += 1</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line87">87</a> end</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line88">88</a> bool_step_passed = ["passed", "pending"].include?(step['result']['status']) ? true : false</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line89">89</a> bool_scenario_passed &&= bool_step_passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line90">90</a> #puts "\t\t Step : #{step['keyword']+step['name']} - #{step_duration} - #{bool_step_passed}"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line91">91</a> #reset_step_result(bool_step_passed, step_duration, num_step_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line92">92</a> set_step_result_new(num_step_id, str_scenario_id, scenario_result_id, bool_step_passed, step_duration)</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line93">93</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line94">94</a> #puts "Scenario : #{element["tags"][0]["name"]} - #{element['name']} - #{scenario_duration} - #{bool_scenario_passed} - #{step_count}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line95">95</a> reset_scenario_result(scenario_result_id, scenario_duration, num_step_pass_count, num_step_fail_count, num_step_skip_count, bool_scenario_passed)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line96">96</a> feature_duration += scenario_duration</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line97">97</a> bool_feature_passed &&= bool_scenario_passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line98">98</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line99">99</a> if bool_scenario_passed</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line100">100</a> num_scenario_pass_count += 1 # scenario pass count</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line101">101</a> else</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line102">102</a> if num_step_pass_count == 0 && num_step_fail_count == 0 && num_step_skip_count > 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line103">103</a> num_scenario_skip_count += 1 # scenario skip count</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line104">104</a> else</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line105">105</a> num_scenario_fail_count += 1 # scenario fail count</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line106">106</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line107">107</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line108">108</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line109">109</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line110">110</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line111">111</a> #puts "Feature : #{json['name']} - #{feature_duration} - #{bool_feature_passed} - #{scenario_count}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line112">112</a> reset_feature_result(feature_duration, num_scenario_pass_count, num_scenario_fail_count, num_scenario_skip_count, bool_feature_passed, num_feature_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line113">113</a> @num_build_duration += feature_duration</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line114">114</a> @bool_build_passed &&= bool_feature_passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line115">115</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line116">116</a> if bool_feature_passed</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line117">117</a> @num_feature_pass_count += 1</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line118">118</a> else</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line119">119</a> @num_feature_fail_count += 1 # to do feature skip count</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line120">120</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line121">121</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line122">122</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line123">123</a> $log.error("Error while parsing JSON : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line124">124</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line125">125</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line126">126</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line127">127</a> # Description : sets the build data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line128">128</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line129">129</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line130">130</a> def set_build</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line131">131</a> num_host_id = get_host_data</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line132">132</a> build_name = Time.now.strftime("%d_%m_%Y-%H_%M_%S")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line133">133</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line134">134</a> str_query = "insert into BuildData(BuildName,HostDataID) values (?,?)"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line135">135</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line136">136</a> sth.execute(build_name, num_host_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line137">137</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line138">138</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line139">139</a> #puts "Added a record to BuildData table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line140">140</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line141">141</a> str_query = "select BuildID from BuildData where BuildName='#{build_name}' and HostDataID=#{num_host_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line142">142</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line143">143</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line144">144</a> @build_id = sth.fetch[0]</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line145">145</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line146">146</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line147">147</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line148">148</a> $log.error("Error in setting build data to BuildData table: #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line149">149</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line150">150</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line151">151</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line152">152</a> # Description : gets the host data from Sybase based on current execution host</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line153">153</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line154">154</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line155">155</a> # num_host_id : primary key the host</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line156">156</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line157">157</a> def get_host_data</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line158">158</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line159">159</a> str_query = "select HostDataID from HostData where HostName like '#{ENV['COMPUTERNAME'].downcase}' and OS like '#{ENV['OS'].downcase}' and Browser like '#{BROWSER.downcase}'"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line160">160</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line161">161</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line162">162</a> num_host_id = sth.fetch[0]</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line163">163</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line164">164</a> $log.info("------------host id : #{num_host_id.nil?}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line165">165</a> num_host_id.nil? ? 5 : num_host_id</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line166">166</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line167">167</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line168">168</a> $log.error("Error in getting host data from HostData table: #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line169">169</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line170">170</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line171">171</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line172">172</a> # Description : resets the build data with execution details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line173">173</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line174">174</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line175">175</a> # num_run_length : total execution time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line176">176</a> # num_pass_count : number of features passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line177">177</a> # num_fail_count : number of features failed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line178">178</a> # num_skip_count : number of features skipped</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line179">179</a> # bool_result : boolean value resembling the state of build result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line180">180</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line181">181</a> def reset_build(num_run_length, num_pass_count, num_fail_count, num_skip_count, bool_result)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line182">182</a> num_result = bool_result ? 1 : 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line183">183</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line184">184</a> sth = dbh.prepare("update BuildData set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where BuildID=?")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line185">185</a> sth.execute(convert_duration(num_run_length), num_pass_count, num_fail_count, num_skip_count, num_result, @build_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line186">186</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line187">187</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line188">188</a> #puts "Updated a record (#{@build_id}) in BuildData table successfully"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line189">189</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line190">190</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line191">191</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line192">192</a> $log.error("Error in resetting build data to BuildData table: #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line193">193</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line194">194</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line195">195</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line196">196</a> # Description : sets the feature data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line197">197</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line198">198</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line199">199</a> # str_feature_name : feature name</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line200">200</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line201">201</a> # num_feature_id : primary key the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line202">202</a> # num_feature_result_id : primary key of the feature result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line203">203</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line204">204</a> def set_feature(str_feature_name)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line205">205</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line206">206</a> str_query = "select TestFeatureID from TestFeature where FeatureName=?"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line207">207</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line208">208</a> sth.execute(str_feature_name)</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line209">209</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line210">210</a> if sth.fetch.nil? # insert only if the data is not present in the table</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line211">211</a> sth = dbh.prepare("insert into TestFeature(FeatureName) values (?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line212">212</a> sth.execute(str_feature_name)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line213">213</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line214">214</a> #puts "Added a record to TestFeature table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line215">215</a> end</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line216">216</a> str_query = "select TestFeatureID from TestFeature where FeatureName='#{str_feature_name}'"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line217">217</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line218">218</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line219">219</a> num_feature_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line220">220</a> #puts "********** Record found with Primary key '#{num_feature_id}' in TestFeature *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line221">221</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line222">222</a> num_feature_result_id = set_feature_result(num_feature_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line223">223</a> return num_feature_id, num_feature_result_id # return the feature id and feature result id of the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line224">224</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line225">225</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line226">226</a> $log.error("Error in setting feature data to TestFeature table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line227">227</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line228">228</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line229">229</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line230">230</a> # Description : sets the feature result data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line231">231</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line232">232</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line233">233</a> # str_feature_name : feature_id of the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line234">234</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line235">235</a> # num_feature_result_id : primary key of the feature result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line236">236</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line237">237</a> def set_feature_result(num_feature_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line238">238</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line239">239</a> str_query = "select TestFeatureResultID from TestFeatureResult where TestFeatureID=? and BuildID=?"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line240">240</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line241">241</a> sth.execute(num_feature_id, @build_id)</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line242">242</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line243">243</a> if sth.fetch.nil? # insert only if the data is not present in the table</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line244">244</a> sth = dbh.prepare("insert into TestFeatureResult(TestFeatureID,BuildID) values (?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line245">245</a> sth.execute(num_feature_id, @build_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line246">246</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line247">247</a> #puts "Added a record to TestFeatureResult table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line248">248</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line249">249</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line250">250</a> str_query = "select TestFeatureResultID from TestFeatureResult where TestFeatureID=#{num_feature_id} and BuildID=#{@build_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line251">251</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line252">252</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line253">253</a> num_feature_result_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line254">254</a> #puts "********** Record found with Primary key '#{num_feature_result_id}' in TestFeatureResult *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line255">255</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line256">256</a> return num_feature_result_id # return the feature result id of the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line257">257</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line258">258</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line259">259</a> $log.error("Error in setting feature result data to TestFeatureResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line260">260</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line261">261</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line262">262</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line263">263</a> # Description : resets the feature result data with execution details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line264">264</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line265">265</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line266">266</a> # num_run_length : feature execution time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line267">267</a> # num_pass_count : number of scenarios passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line268">268</a> # num_fail_count : number of scenarios failed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line269">269</a> # num_skip_count : number of scenarios skipped</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line270">270</a> # bool_result : boolean value resembling the state of build result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line271">271</a> # num_feature_result_id : primary key of the TestFeatureResult table</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line272">272</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line273">273</a> def reset_feature_result(num_run_length, num_pass_count, num_fail_count, num_skip_count, bool_result, num_feature_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line274">274</a> num_result = bool_result ? 1 : 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line275">275</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line276">276</a> sth = dbh.prepare("update TestFeatureResult set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where TestFeatureResultID=?")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line277">277</a> sth.execute(convert_duration(num_run_length), num_pass_count, num_fail_count, num_skip_count, num_result, num_feature_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line278">278</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line279">279</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line280">280</a> #puts "Updated a record (#{num_feature_result_id}) in TestFeatureResult table successfully"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line281">281</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line282">282</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line283">283</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line284">284</a> $log.error("Error in resetting feature result data to TestFeatureResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line285">285</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line286">286</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line287">287</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line288">288</a> # Description : sets the scenario data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line289">289</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line290">290</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line291">291</a> # str_scenario_name : scenario name</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line292">292</a> # str_qa_complete_id : QA Complete ID (Scenario ID) of the scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line293">293</a> # str_feature_id : primary key of the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line294">294</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line295">295</a> # num_scenario_id : primary key of the scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line296">296</a> # scenario_result_id : primary key of the scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line297">297</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line298">298</a> def set_scenario(str_scenario_name, str_qa_complete_id, str_feature_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line299">299</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line300">300</a> str_query = "select TestScenarioID from TestScenario where ScenarioName=? and TestFeatureID=?"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line301">301</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line302">302</a> sth.execute(str_scenario_name, str_feature_id.to_i)</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line303">303</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line304">304</a> if sth.fetch.nil? # insert only if the data is not present in the table</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line305">305</a> sth = dbh.prepare("insert into TestScenario(ScenarioName,QACompleteID,TestFeatureID) values (?,?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line306">306</a> sth.execute(str_scenario_name, str_qa_complete_id, str_feature_id.to_i)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line307">307</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line308">308</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line309">309</a> #puts "Added a record to TestScenario table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line310">310</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line311">311</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line312">312</a> str_query = "select TestScenarioID from TestScenario where ScenarioName='#{str_scenario_name}' and TestFeatureID=#{str_feature_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line313">313</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line314">314</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line315">315</a> num_scenario_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line316">316</a> #puts "********** Record found with Primary key '#{num_scenario_id}' in TestScenario *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line317">317</a> scenario_result_id = set_scenario_result(num_scenario_id, str_feature_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line318">318</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line319">319</a> return num_scenario_id, scenario_result_id # return the scenario id and scenario result id of the scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line320">320</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line321">321</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line322">322</a> $log.error("Error in setting scenario data to TestScenario table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line323">323</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line324">324</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line325">325</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line326">326</a> # Description : sets the scenario result data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line327">327</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line328">328</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line329">329</a> # num_scenario_id : primary key of the scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line330">330</a> # num_feature_id : primary key of the feature</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line331">331</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line332">332</a> # num_scenario_result_id : primary key of the scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line333">333</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line334">334</a> def set_scenario_result(num_scenario_id, num_feature_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line335">335</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line336">336</a> sth = dbh.prepare("insert into TestScenarioResult(TestFeatureID,TestScenarioID,BuildID) values (?,?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line337">337</a> sth.execute(num_feature_id, num_scenario_id, @build_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line338">338</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line339">339</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line340">340</a> #puts "Added a record to TestScenarioResult table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line341">341</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line342">342</a> str_query = "select TestScenarioResultID from TestScenarioResult where TestFeatureID=#{num_feature_id} and TestScenarioID=#{num_scenario_id} and BuildID=#{@build_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line343">343</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line344">344</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line345">345</a> num_scenario_result_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line346">346</a> #puts "********** Record found with Primary key '#{num_scenario_result_id}' in TestScenarioResult *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line347">347</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line348">348</a> return num_scenario_result_id # return the scenario id of the scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line349">349</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line350">350</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line351">351</a> $log.error("Error in setting scenario data to TestScenarioResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line352">352</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line353">353</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line354">354</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line355">355</a> # Description : resets the scenario result data with execution details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line356">356</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line357">357</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line358">358</a> # num_scenario_result_id : primary key of the scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line359">359</a> # num_run_length : steps execution time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line360">360</a> # num_pass_count : number of steps passed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line361">361</a> # num_fail_count : number of steps failed</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line362">362</a> # num_skip_count : number of steps skipped</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line363">363</a> # bool_result : boolean value resembling the state of steps result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line364">364</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line365">365</a> def reset_scenario_result(num_scenario_result_id, num_run_length, num_pass_count, num_fail_count, num_skip_count, bool_result)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line366">366</a> num_result = bool_result ? 1 : 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line367">367</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line368">368</a> sth = dbh.prepare("update TestScenarioResult set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where TestScenarioResultID=?")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line369">369</a> sth.execute(convert_duration(num_run_length), num_pass_count, num_fail_count, num_skip_count, num_result, num_scenario_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line370">370</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line371">371</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line372">372</a> #puts "Updated a record (#{num_scenario_result_id}) in TestScenarioResult table successfully"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line373">373</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line374">374</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line375">375</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line376">376</a> $log.error("Error in resetting scenario data to TestScenarioResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line377">377</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line378">378</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line379">379</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line380">380</a> # Description : sets the step data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line381">381</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line382">382</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line383">383</a> # str_step_name : step name</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line384">384</a> # str_scenario_id : primary key of scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line385">385</a> # num_scenario_result_id : primary key of scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line386">386</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line387">387</a> # num_step_id : primary key of step</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line388">388</a> # num_step_result_id : primary key of step result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line389">389</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line390">390</a> def set_step(str_step_name, str_scenario_id, num_scenario_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line391">391</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line392">392</a> str_query = "select TestStepID from TestStep where StepName=? and TestScenarioID=?"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line393">393</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line394">394</a> sth.execute(str_step_name, str_scenario_id)</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line395">395</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line396">396</a> if sth.fetch.nil? # insert only if the data is not present in the table</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line397">397</a> sth = dbh.prepare("insert into TestStep(StepName,TestScenarioID) values (?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line398">398</a> sth.execute(str_step_name, str_scenario_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line399">399</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line400">400</a> #puts "Added a record to TestStep table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line401">401</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line402">402</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line403">403</a> str_query = "select TestStepID from TestStep where StepName='#{str_step_name}' and TestScenarioID=#{str_scenario_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line404">404</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line405">405</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line406">406</a> num_step_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line407">407</a> #puts "********** Record found with Primary key '#{num_step_id}' in TestStep *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line408">408</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line409">409</a> return num_step_id</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line410">410</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line411">411</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line412">412</a> $log.error("Error in setting step data to TestStep table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line413">413</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line414">414</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line415">415</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line416">416</a> # Description : sets the step result data with execution details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line417">417</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line418">418</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line419">419</a> # num_step_id : primary key of step</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line420">420</a> # num_scenario_id : primary key of scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line421">421</a> # num_scenario_result_id : primary key of scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line422">422</a> # bool_result : boolean value resembling the state of step result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line423">423</a> # num_run_length : steps execution time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line424">424</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line425">425</a> def set_step_result_new(num_step_id, num_scenario_id, num_scenario_result_id, bool_result, num_run_length)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line426">426</a> num_result = bool_result ? 1 : 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line427">427</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line428">428</a> sth = dbh.prepare("insert into TestStepResult(TestScenarioResultID,Result,RunLength,TestStepID,BuildID,TestScenarioID) values (?,?,?,?,?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line429">429</a> sth.execute(num_scenario_result_id, num_result, convert_duration(num_run_length), num_step_id, @build_id, num_scenario_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line430">430</a> dbh.commit</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line431">431</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line432">432</a> #puts "Added a record to TestStepResult table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line433">433</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line434">434</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line435">435</a> $log.error("(set_step_result_new)Error in setting step data to TestStepResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line436">436</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line437">437</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line438">438</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line439">439</a> # Description : sets the step result data with default details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line440">440</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line441">441</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line442">442</a> # num_step_id : primary key of step</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line443">443</a> # str_scenario_id : primary key of scenario</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line444">444</a> # num_scenario_result_id : primary key of scenario result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line445">445</a> # Return Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line446">446</a> # num_step_result_id : primary key of step result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line447">447</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line448">448</a> def set_step_result(num_step_id, num_scenario_id, num_scenario_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line449">449</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line450">450</a> sth = dbh.prepare("insert into TestStepResult(TestScenarioResultID,TestStepID,BuildID,TestScenarioID) values (?,?,?,?)")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line451">451</a> sth.execute(num_scenario_result_id, num_step_id, @build_id, num_scenario_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line452">452</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line453">453</a> #puts "Added a record to TestStepResult table successfully"</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line454">454</a> </pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line455">455</a> str_query = "select TestStepResultID from TestStepResult where TestScenarioResultID=#{num_scenario_result_id} and TestStepID=#{num_step_id} and BuildID=#{@build_id} and TestScenarioID=#{num_scenario_id}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line456">456</a> sth = dbh.prepare(str_query)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line457">457</a> sth.execute()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line458">458</a> num_step_result_id = sth.fetch[0]</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line459">459</a> #puts "********** Record found with Primary key '#{num_step_result_id}' in TestStepResult *************"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line460">460</a> dbh.disconnect()</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line461">461</a> return num_step_result_id # return the step result id of the step</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line462">462</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line463">463</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line464">464</a> $log.error("Error in setting step data to TestStep table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line465">465</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line466">466</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line467">467</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line468">468</a> # Description : resets the step result data with execution details into Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line469">469</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line470">470</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line471">471</a> # bool_result : boolean value resembling the state of step result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line472">472</a> # num_run_length : step execution time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line473">473</a> # num_step_result_id : primary key of step result</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line474">474</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line475">475</a> def reset_step_result(bool_result, num_run_length, num_step_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line476">476</a> num_result = bool_result ? 1 : 0</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line477">477</a> DBI.connect(@str_connection_url, DB_USER_NAME, DB_PASSWORD) do |dbh|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line478">478</a> sth = dbh.prepare("update TestStepResult set Result=?, RunLength=? where TestStepResultID=?")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line479">479</a> sth.execute(num_result, convert_duration(num_run_length), num_step_result_id)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line480">480</a> sth.finish</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line481">481</a> dbh.commit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line482">482</a> #puts "Updated a record (#{num_step_result_id}) in TestStepResult table successfully"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line483">483</a> dbh.disconnect()</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line484">484</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line485">485</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line486">486</a> $log.error("Error in resetting step results data in TestStepResult table : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line487">487</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line488">488</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line489">489</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line490">490</a> # Description : converts nanoseconds to seconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line491">491</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line492">492</a> # Arguments :</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line493">493</a> # num_duration : time in nanoseconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line494">494</a> # Return Argument : time in seconds</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line495">495</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line496">496</a> def convert_duration(num_duration)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line497">497</a> num_duration/(1000*1000*1000) #.to_f # convert nanosecond to second</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line498">498</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line499">499</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line500">500</a> # Description : function that creates performance report data and stores it in Sybase</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line501">501</a> # Author : Chandra sekaran</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line502">502</a> #</pre></td> </tr> <tr class="marked"> <td><pre><a name="line503">503</a> def create_performance_report</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line504">504</a> set_build # set Build data only once for each execution (Single or Parallel)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line505">505</a> @arr_file_name.each do |path|</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line506">506</a> @arr_background_step_duration = []</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line507">507</a> file = File.read(path)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line508">508</a> @json = JSON.parse(file)</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line509">509</a> parse_json # parse each json file and extract report data</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line510">510</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line511">511</a> #puts "Build duration : #{@num_build_duration} - #{@bool_build_passed} - #{@num_feature_count}"</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line512">512</a> reset_build(@num_build_duration, @num_feature_pass_count, @num_feature_fail_count, @num_feature_skip_count, @bool_build_passed) # Update the Build data with execution summary</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line513">513</a> rescue Exception => ex</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line514">514</a> $log.error("Error while creating report : #{ex}")</pre></td> </tr> <tr class="uncovered"> <td><pre><a name="line515">515</a> exit</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line516">516</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line517">517</a> </pre></td> </tr> <tr class="inferred"> <td><pre><a name="line518">518</a> end</pre></td> </tr> <tr class="inferred"> <td><pre><a name="line519">519</a> end</pre></td> </tr> </tbody> </table> <p>Generated on 2015-05-08 10:40:30 +0530 with <a href="https://github.com/fguillen/simplecov-rcov">SimpleCov-RCov 0.2.3</a></p> </body>
</html>