sdcc-web/regtests.php

   1 <?php
   2 /*-------------------------------------------------------------------------
   3    regtests.php - regression tests page
   4
   5    Copyright (C) 2011, 2012, Borut Razem <borut.razem AT gmail.com>
   6
   7    This program is free software; you can redistribute it and/or modify it
   8    under the terms of the GNU General Public License as published by the
   9    Free Software Foundation; either version 2.1, or (at your option) any
  10    later version.
  11
  12    This library is distributed in the hope that it will be useful,
  13    but WITHOUT ANY WARRANTY; without even the implied warranty of
  14    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15    GNU General Public License for more details.
  16
  17    You should have received a copy of the GNU General Public License
  18    along with this library; see the file COPYING. If not, write to the
  19    Free Software Foundation, 51 Franklin Street, Fifth Floor, Boston,
  20    MA 02110-1301, USA.
  21 -------------------------------------------------------------------------*/
  22
  23 $ini = parse_ini_file('sdcc.ini');
  24 $regTestDb = new mysqli($ini['host'], $ini['username'], $ini['passwd'], $ini['dbname']);
  25
  26 $query = 'SELECT DISTINCT `platform` FROM `regtest_results`';
  27
  28 $result = $regTestDb->query($query);
  29
  30 $platforms = array();
  31 if ($result) {
  32   while ($row = $result->fetch_array(MYSQLI_NUM)) {
  33     $platforms[] = $row[0];
  34   }
  35   $result->free();
  36 }
  37
  38 $query = 'SELECT DISTINCT `target` FROM `regtest_results`';
  39
  40 $result = $regTestDb->query($query);
  41
  42 $targets = array();
  43 if ($result) {
  44   while ($row = $result->fetch_array(MYSQLI_NUM)) {
  45     $targets[] = $row[0];
  46   }
  47   $result->free();
  48 }
  49
  50 $regTestDb->close();
  51
  52 function genForm($id, $platforms, $targets)
  53 {
  54   echo('          <form action="" class="diff" id="' . $id . "\" method=\"post\">\n");
  55   echo <<<EOT
  56             <table>
  57               <tr>
  58                 <td align="right"><label for="date">Build date:</label></td>
  59                 <td><input name="date" id="{$id}_date" class="date-pick" /></td>
  60               </tr>
  61               <tr>
  62                 <td align="right">Build number:</td>
  63                 <td>
  64                   <select name="build">
  65                     <option></option>
  66                   </select>
  67                 </td>
  68               </tr>
  69               <tr>
  70                 <td align="right">Platform:</td>
  71                 <td>
  72                   <select name="platform">
  73 EOT;
  74
  75   foreach ($platforms as $platform) {
  76     echo('                    <option value="' . $platform . '">' . $platform . "</option>\n");
  77   }
  78
  79  echo <<<EOT
  80                   </select>
  81                 </td>
  82               </tr>
  83               <tr>
  84                 <td align="right">Target:</td>
  85                 <td>
  86                   <select name="target">
  87 EOT;
  88
  89   foreach ($targets as $target) {
  90     echo('                    <option value="' . $target . '">' . $target . "</option>\n");
  91   }
  92
  93   echo <<<EOT
  94                   </select>
  95                 </td>
  96               </tr>
  97             </table>
  98 <!--            <button class="button positive"> <img src="../images/icons/tick.png" alt=""> Add Client </button> -->
  99           </form>
 100 EOT;
 101 }
 102 ?>
 103 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 104 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 105 <head>
 106   <meta content="text/html; charset=UTF-8" http-equiv="content-type" />
 107   <title>SDCC - Regression Tests</title>
 108   <link type="text/css" href="styles/style.css" rel="stylesheet" />
 109   <link rel="shortcut icon" type="image/x-icon" href="/images/sdcc.ico" />
 110   <link rel="icon" type="image/svg+xml" href="/images/sdcc.svg">
 111   <!-- jQuery -->
 112   <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
 113   <!-- required plugins -->
 114   <script type="text/javascript" src="scripts/date.js"></script>
 115   <!-- jquery.datePicker.js -->
 116   <script type="text/javascript" src="scripts/jquery.datePicker.js"></script>
 117   <!-- datePicker required styles -->
 118   <link rel="stylesheet" type="text/css" media="screen" href="styles/datePicker.css"></link>
 119   <!-- jquery.tablesorter.js -->
 120   <script type="text/javascript" src="scripts/jquery.tablesorter.js"></script>
 121   <!-- tablesorter required styles -->
 122   <link rel="stylesheet" type="text/css" media="screen" href="styles/tablesorter.css"></link>
 123   <!-- page specific scripts -->
 124   <script type="text/javascript" charset="utf-8">
 125 //<!--
 126 Date.format = 'yyyy-mm-dd';
 127 $(function()
 128 {
 129   $('.date-pick').datePicker(
 130     {
 131       startDate: '1970-01-01',
 132       endDate: (new Date()).asString()
 133     }
 134   );
 135 });
 136
 137 function validateBuildDate(date)
 138 {
 139   // validate the build date
 140   if (!/^\d{4}-\d{2}-\d{2}$/.test(date)) {
 141     alert("Bad build date!\n");
 142     return false;
 143   }
 144   return true;
 145 }
 146
 147 function validateBuildNumber(build)
 148 {
 149   // validate the build number
 150   if (!/^\d+$/.test(build)) {
 151     alert("Bad build number!\n");
 152     return false;
 153   }
 154   return true;
 155 }
 156
 157 function validateTarget(target)
 158 {
 159   // validate the target
 160   var targets = [ <?php echo('"' . implode('", "', $targets) . '"'); ?> ];
 161
 162   var is_target = false;
 163   for (var i = 0; i < targets.length; ++i) {
 164     if (targets[i] == target) {
 165       is_target = true;
 166       break;
 167     }
 168   }
 169   if (!is_target) {
 170     alert("Bad / unknown target!\n");
 171     return false;
 172   }
 173   return true;
 174 }
 175
 176 function validateFormOnSubmit(theForm)
 177 {
 178   var date = theForm.date.value;
 179   var build = theForm.build.value;
 180   var platform = theForm.platform.value;
 181
 182   if (validateBuildDate(date) && validateBuildNumber(build)) {
 183     // validate the platform
 184     var platforms = [ <?php echo('"' . implode('", "', $platforms) . '"'); ?> ];
 185
 186     var is_platform = false;
 187     for (var i = 0; i < platforms.length; ++i) {
 188       if (platforms[i] == platform) {
 189         is_platform = true;
 190         break;
 191       }
 192     }
 193
 194     return {
 195       date: date,
 196       build_number: build,
 197       platform: platform
 198     };
 199   }
 200   else
 201     return false;
 202 }
 203
 204 function validateFormOnSubmitTarget(theForm)
 205 {
 206   var target = theForm.target.value;
 207
 208   ret = validateFormOnSubmit(theForm);
 209
 210   if (ret && validateTarget(target)) {
 211     ret['target'] = target;
 212     return ret;
 213   }
 214   else {
 215     return false;
 216   }
 217 }
 218
 219 function keyArray(obj) {
 220   var rv = [];
 221   $.each(obj, function(key)
 222   {
 223     rv.push(key);
 224   });
 225   return rv;
 226 }
 227
 228 function genHiddenWhere(theForm)
 229 {
 230   var val = validateFormOnSubmit(theForm);
 231   var where = '';
 232   var whereFirst = true;
 233   $.each(val, function(key)
 234   {
 235     if (!whereFirst) {
 236       where += 'AND ';
 237     }
 238     else {
 239       whereFirst = false;
 240     }
 241     where += '`' + key + "` = '" + val[key] + "' ";
 242   });
 243
 244   theForm.where.value = where;
 245
 246   return true
 247 }
 248
 249 /*
 250 // http://www.webtoolkit.info/scrollable-html-table-plugin-for-jquery.html
 251 jQuery.fn.Scrollable = function(tableHeight, tableWidth) {
 252   this.each(function(){
 253     if (jQuery.browser.msie || jQuery.browser.mozilla) {
 254       var table = new ScrollableTable(this, tableHeight, tableWidth);
 255     }
 256   });
 257 }
 258 */
 259
 260 function htmlTable (data)
 261 {
 262   var ret = '';
 263   if (data) {
 264     ret += '<table id="dataTable" class="tablesorter"><thead><tr>';
 265     var keys = keyArray(data[0]);
 266     for (var i = 0; i < keys.length; ++i) {
 267       ret += '<th>' + keys[i] + '</th>';
 268     }
 269     ret += '</tr></thead>';
 270     ret += '<tbody>';
 271     for (var i = 0; i < data.length; ++i) {
 272       ret += '<tr>';
 273       $.each(data[i], function(key)
 274       {
 275         ret += '<td>' + data[i][key] + '</td>';
 276       });
 277       ret += '</tr>';
 278     }
 279     ret += '<tbody>';
 280     ret += '</table>';
 281   }
 282   return ret;
 283 }
 284
 285 function composeQuery(data)
 286 {
 287   var fields = [ 'failures', 'tests', 'cases', 'bytes', 'ticks' ];
 288
 289   var select = 'SELECT `t0`.`regtest_name`, ';
 290   var from = ' FROM `regtest_results` AS t0 ';
 291   var on = 'ON ';
 292   var where = 'WHERE ';
 293
 294   var first = true;
 295   var whereFirst = true;
 296   for (var i = 0; i < data.length; ++i) {
 297     for (var j = 0; j < fields.length; ++j) {
 298       if (!first) {
 299         select += ', ';
 300       }
 301       else {
 302         first = false;
 303       }
 304       select += '`t' + i + '`.`' + fields[j] + '` AS `' + fields[j] + i + '`'
 305     }
 306     if (i > 0) {
 307       from += 'JOIN `regtest_results` AS t' + i + ' ';
 308       if (i > 1) {
 309         on += 'AND ';
 310       }
 311       on += '`t' + i + '`.`regtest_name` = `t0`.`regtest_name` ';
 312     }
 313
 314     $.each(data[i], function(key)
 315     {
 316       if (!whereFirst) {
 317         where += 'AND ';
 318       }
 319       else {
 320         whereFirst = false;
 321       }
 322       where += '`t' + i + '`.`' + key + "` = '" + data[i][key] + "' ";
 323     });
 324   }
 325   query = select + from + on + where;
 326
 327   return query;
 328 }
 329
 330 function buttonClick()
 331 {
 332   $('body').css('cursor', 'wait')
 333
 334   var params = [];
 335   $('form.diff').each(function()
 336   {
 337     params.push(validateFormOnSubmitTarget(this));
 338   });
 339
 340   var query = composeQuery(params);
 341
 342   if (query) {
 343     $.ajax({
 344       type: 'POST',
 345       url: 'get_regtest.php',
 346       dataType: 'json',
 347       data: { query: query },
 348       success: function(data) {
 349         $('div.success').replaceWith('<div class="success">' + ((data.length > 0) ? htmlTable(data) : 'No data available!') + '</div>');
 350         $('body').css('cursor','auto');
 351         $("#dataTable").tablesorter({
 352          // striping looking
 353          widgets: ['zebra']
 354         });
 355       }
 356     });
 357   }
 358   return false;
 359 }
 360
 361 /*
 362 $(document).ready(function()
 363 {
 364   jQuery('table').Scrollable(200, 800);
 365 });
 366 */
 367
 368 $(function() {
 369   $("input.date-pick").change(function() {
 370     if (this.value != '' && validateBuildDate(this.value)) {
 371       var me = this.form.build;
 372
 373       // delete previous content
 374       me.innerHTML = '';
 375       $.ajax({
 376         type: 'POST',
 377         url: 'get_regtest.php',
 378         dataType: 'json',
 379         data: {query: 'SELECT DISTINCT `build_number` FROM `regtest_results` WHERE `date` = \'' + this.value +'\''},
 380         success: function(data) {
 381           var options = '';
 382           for (var i = 0; i < data.length; i++) {
 383             options += '<option value="' + data[i].build_number + '">' + data[i].build_number + '</option>';
 384           }
 385           me.innerHTML = options;
 386         }
 387       })
 388     }
 389   });
 390 });
 391 // -->
 392   </script>
 393   <style type="text/css">
 394 /* located in demo.css and creates a little calendar icon
 395  * instead of a text link for "Choose date"
 396  */
 397 a.dp-choose-date {
 398   float: left;
 399   width: 22px;
 400   height: 22px;
 401   padding: 0;
 402   margin: 2px 3px 0;
 403   display: block;
 404   text-indent: -2000px;
 405   overflow: hidden;
 406   background: url(images/timespan.png) no-repeat;
 407 }
 408 a.dp-choose-date.dp-disabled {
 409   background-position: 0 -20px;
 410   cursor: default;
 411 }
 412 /* makes the input field shorter once the date picker code
 413  * has run (to allow space for the calendar icon
 414  */
 415 input.dp-applied {
 416   width: 140px;
 417   float: left;
 418 }
 419   </style>
 420 </head>
 421 <body bgcolor="white" link="teal" vlink="#483d8b">
 422   <div align="left">
 423     <h1>SDCC - Regression Tests</h1>
 424     <table border="0" cellpadding="2" cellspacing="1" width="100%" bgcolor="white">
 425     <tbody>
 426       <tr>
 427         <td width="15%" valign="top"><?php echo(file_get_contents('./left_menu.inc'));?></td>
 428         <td valign="top" width="85%">
 429           <h2><a name="Database"></a>Regression Tests Database</h2>
 430           <p>
 431 Download full <a href="download_regtests_db.php?compress=bz2">regression test results database</a> in csv.bz2 format.
 432           </p>
 433           <form name="regtest" onsubmit="return genHiddenWhere(this)" action="download_regtests_db.php" method="post">
 434             Download regression test results in csv format for<br />
 435             <table>
 436               <tr>
 437                 <td align="right"><label for="date">Build date:</label></td>
 438                 <td><input name="date" id="date" class="date-pick" /></td>
 439               </tr>
 440               <tr>
 441                 <td align="right">Build number:</td>
 442                 <td>
 443                   <select name="build">
 444                     <option></option>
 445                   </select>
 446                 </td>
 447               </tr>
 448               <tr>
 449                 <td align="right">Platform:</td>
 450                 <td>
 451                   <select name="platform">
 452 <?php
 453   foreach ($platforms as $platform) {
 454     echo('                    <option value="' . $platform . '">' . $platform . "</option>\n");
 455   }
 456 ?>
 457                   </select>
 458                 </td>
 459               </tr>
 460             </table>
 461             <input type="hidden" name="where" />
 462             <input type="submit" value="Download CSV" />
 463           </form>
 464           <h2><a name="Diffs"></a>Regression Tests Diffs</h2>
 465           <table>
 466             <tr>
 467               <td>
 468 <?php
 469   genForm('form1', $platforms, $targets);
 470 ?>
 471               </td>
 472               <td>
 473 <?php
 474   genForm('form2', $platforms, $targets);
 475 ?>
 476               </td>
 477             </tr>
 478           </table>
 479           <button id="form" class="button positive" onclick="return buttonClick()">Show table</button>
 480           <!-- placeholder for table -->
 481           <div class="success"></div>
 482 <?php include('./footer.php')?>
 483         </td>
 484       </tr>
 485     </tbody>
 486     </table>
 487   </div>
 488   </body>
 489 </html>