<!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 = &quot;DBI:SQLAnywhere:SERVER=#{DB_SERVER};DBN=#{DB_NAME}&quot;</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[&quot;name&quot;].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[&quot;elements&quot;].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[&quot;keyword&quot;] == &quot;Background&quot;</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line49">49</a>               element[&quot;steps&quot;].each do |step|</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line50">50</a>                 @arr_background_step_duration &lt;&lt; step[&quot;result&quot;][&quot;duration&quot;].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[&quot;keyword&quot;] == &quot;Scenario&quot;       # 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[&quot;name&quot;], element[&quot;tags&quot;][0][&quot;name&quot;], 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 &#39;Scenarios&#39; and not &#39;Backgrounds&#39;</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[&quot;steps&quot;].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[&#39;keyword&#39;]+step[&#39;name&#39;], 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[&#39;keyword&#39;]+step[&#39;name&#39;], 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) &amp;&amp; (indx &lt; @arr_background_step_duration.size) &amp;&amp; @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[&#39;result&#39;][&#39;duration&#39;].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[&#39;result&#39;][&#39;status&#39;] == &quot;passed&quot;</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[&#39;result&#39;][&#39;status&#39;] == &quot;failed&quot;</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[&#39;result&#39;][&#39;status&#39;] == &quot;skipped&quot;</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 = [&quot;passed&quot;, &quot;pending&quot;].include?(step[&#39;result&#39;][&#39;status&#39;]) ? true : false</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line89">89</a>               bool_scenario_passed &amp;&amp;= bool_step_passed</pre></td>
      </tr>
      <tr class="inferred">
        <td><pre><a name="line90">90</a>                                                                                                                                #puts &quot;\t\t Step : #{step[&#39;keyword&#39;]+step[&#39;name&#39;]} - #{step_duration} - #{bool_step_passed}&quot;</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 &quot;Scenario : #{element[&quot;tags&quot;][0][&quot;name&quot;]} - #{element[&#39;name&#39;]} - #{scenario_duration} - #{bool_scenario_passed} - #{step_count}&quot;</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 &amp;&amp;= 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 &amp;&amp; num_step_fail_count == 0 &amp;&amp; num_step_skip_count &gt; 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 &quot;Feature : #{json[&#39;name&#39;]} - #{feature_duration} - #{bool_feature_passed} - #{scenario_count}&quot;</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 &amp;&amp;= 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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line123">123</a>       $log.error(&quot;Error while parsing JSON : #{ex}&quot;)</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(&quot;%d_%m_%Y-%H_%M_%S&quot;)</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 = &quot;insert into BuildData(BuildName,HostDataID) values (?,?)&quot;</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 &quot;Added a record to BuildData table successfully&quot;</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 = &quot;select BuildID from BuildData where BuildName=&#39;#{build_name}&#39; and HostDataID=#{num_host_id}&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line148">148</a>       $log.error(&quot;Error in setting build data to BuildData table: #{ex}&quot;)</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 = &quot;select HostDataID from HostData where HostName like &#39;#{ENV[&#39;COMPUTERNAME&#39;].downcase}&#39; and OS like &#39;#{ENV[&#39;OS&#39;].downcase}&#39; and Browser like &#39;#{BROWSER.downcase}&#39;&quot;</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(&quot;------------host id : #{num_host_id.nil?}&quot;)</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line168">168</a>       $log.error(&quot;Error in getting host data from HostData table: #{ex}&quot;)</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(&quot;update BuildData set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where BuildID=?&quot;)</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 &quot;Updated a record (#{@build_id}) in BuildData table successfully&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line192">192</a>       $log.error(&quot;Error in resetting build data to BuildData table: #{ex}&quot;)</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 = &quot;select TestFeatureID from TestFeature where FeatureName=?&quot;</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(&quot;insert into TestFeature(FeatureName) values (?)&quot;)</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 &quot;Added a record to TestFeature table successfully&quot;</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 = &quot;select TestFeatureID from TestFeature where FeatureName=&#39;#{str_feature_name}&#39;&quot;</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 &quot;********** Record found with Primary key &#39;#{num_feature_id}&#39; in TestFeature *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line226">226</a>       $log.error(&quot;Error in setting feature data to TestFeature table : #{ex}&quot;)</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 = &quot;select TestFeatureResultID from TestFeatureResult where TestFeatureID=? and BuildID=?&quot;</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(&quot;insert into TestFeatureResult(TestFeatureID,BuildID) values (?,?)&quot;)</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 &quot;Added a record to TestFeatureResult table successfully&quot;</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 = &quot;select TestFeatureResultID from TestFeatureResult where TestFeatureID=#{num_feature_id} and BuildID=#{@build_id}&quot;</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 &quot;********** Record found with Primary key &#39;#{num_feature_result_id}&#39; in TestFeatureResult *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line259">259</a>       $log.error(&quot;Error in setting feature result data to TestFeatureResult table : #{ex}&quot;)</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(&quot;update TestFeatureResult set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where TestFeatureResultID=?&quot;)</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 &quot;Updated a record (#{num_feature_result_id}) in TestFeatureResult table successfully&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line284">284</a>       $log.error(&quot;Error in resetting feature result data to TestFeatureResult table : #{ex}&quot;)</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 = &quot;select TestScenarioID from TestScenario where ScenarioName=? and TestFeatureID=?&quot;</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(&quot;insert into TestScenario(ScenarioName,QACompleteID,TestFeatureID) values (?,?,?)&quot;)</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 &quot;Added a record to TestScenario table successfully&quot;</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 = &quot;select TestScenarioID from TestScenario where ScenarioName=&#39;#{str_scenario_name}&#39; and TestFeatureID=#{str_feature_id}&quot;</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 &quot;********** Record found with Primary key &#39;#{num_scenario_id}&#39; in TestScenario *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line322">322</a>       $log.error(&quot;Error in setting scenario data to TestScenario table : #{ex}&quot;)</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(&quot;insert into TestScenarioResult(TestFeatureID,TestScenarioID,BuildID) values (?,?,?)&quot;)</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 &quot;Added a record to TestScenarioResult table successfully&quot;</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 = &quot;select TestScenarioResultID from TestScenarioResult where TestFeatureID=#{num_feature_id} and TestScenarioID=#{num_scenario_id} and BuildID=#{@build_id}&quot;</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 &quot;********** Record found with Primary key &#39;#{num_scenario_result_id}&#39; in TestScenarioResult *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line351">351</a>       $log.error(&quot;Error in setting scenario data to TestScenarioResult table : #{ex}&quot;)</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(&quot;update TestScenarioResult set RunLength=?, Passes=?, Failures=?, Skips=?, Result=? where TestScenarioResultID=?&quot;)</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 &quot;Updated a record (#{num_scenario_result_id}) in TestScenarioResult table successfully&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line376">376</a>       $log.error(&quot;Error in resetting scenario data to TestScenarioResult table : #{ex}&quot;)</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 = &quot;select TestStepID from TestStep where StepName=? and TestScenarioID=?&quot;</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(&quot;insert into TestStep(StepName,TestScenarioID) values (?,?)&quot;)</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 &quot;Added a record to TestStep table successfully&quot;</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 = &quot;select TestStepID from TestStep where StepName=&#39;#{str_step_name}&#39; and TestScenarioID=#{str_scenario_id}&quot;</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 &quot;********** Record found with Primary key &#39;#{num_step_id}&#39; in TestStep *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line412">412</a>       $log.error(&quot;Error in setting step data to TestStep table : #{ex}&quot;)</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(&quot;insert into TestStepResult(TestScenarioResultID,Result,RunLength,TestStepID,BuildID,TestScenarioID) values (?,?,?,?,?,?)&quot;)</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 &quot;Added a record to TestStepResult table successfully&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line435">435</a>       $log.error(&quot;(set_step_result_new)Error in setting step data to TestStepResult table : #{ex}&quot;)</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(&quot;insert into TestStepResult(TestScenarioResultID,TestStepID,BuildID,TestScenarioID) values (?,?,?,?)&quot;)</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 &quot;Added a record to TestStepResult table successfully&quot;</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 = &quot;select TestStepResultID from TestStepResult where TestScenarioResultID=#{num_scenario_result_id} and TestStepID=#{num_step_id} and BuildID=#{@build_id} and TestScenarioID=#{num_scenario_id}&quot;</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 &quot;********** Record found with Primary key &#39;#{num_step_result_id}&#39; in TestStepResult *************&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line464">464</a>       $log.error(&quot;Error in setting step data to TestStep table : #{ex}&quot;)</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(&quot;update TestStepResult set Result=?, RunLength=? where TestStepResultID=?&quot;)</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 &quot;Updated a record (#{num_step_result_id}) in TestStepResult table successfully&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line486">486</a>       $log.error(&quot;Error in resetting step results data in TestStepResult table : #{ex}&quot;)</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 &quot;Build duration : #{@num_build_duration} - #{@bool_build_passed} - #{@num_feature_count}&quot;</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 =&gt; ex</pre></td>
      </tr>
      <tr class="uncovered">
        <td><pre><a name="line514">514</a>       $log.error(&quot;Error while creating report : #{ex}&quot;)</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>