[Dynapi-CVS] CVS: dynapi3x/test/scripts config.php,NONE,1.1 create_tables.sql,NONE,1.1 displayTest.p

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/dynapi/dynapi3x/test/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10083/scripts

Added Files:
	config.php create_tables.sql displayTest.php editTest.php 
	saveTest.php showResults.php storeResult.php testForm.php 
Log Message:
Initial version

--- NEW FILE ---
<?php

$test_database_server="mysql-d.sourceforge.net";
$test_database_name="dynapi";
$test_database_user="dynapi";
$test_database_password="a58SiNIi";

?>

--- NEW FILE ---
-- 
-- Table structure for table `testresult`
-- 

CREATE TABLE `testresult` (
  `id` int(11) NOT NULL auto_increment,
  `testcase_name` varchar(64) NOT NULL,
  `testcase_date` timestamp NULL default NULL,
  `dynapi_version` varchar(128) default NULL,
  `passed` tinyint(4) default NULL,
  `comments` text,
  `user_agent` varchar(128) default NULL,
  `test_date` timestamp NOT NULL,
  `tester` varchar(64) default NULL,
  PRIMARY KEY  (`id`)
);

--- NEW FILE ---

<head>
<title>DynAPI - Test Suite</title>
</head>

<frameset cols="30%, 70%">
<?php
$name = $_REQUEST['name'];

echo "<frame src=\"testForm.php?";
echo "name=", urlencode($name);
echo "\"/>\n";
echo "<frame src=\"../" . $name . ".html\"/>\n";

?>
</frameset>

--- NEW FILE ---
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
  <title>DynAPI - Test Suite</title>
 </head>
<?php
$name = $_REQUEST['name'];
if ($name) {
  $code_filename = "../" . $name . ".html";
  if (file_exists($code_filename))
    $test_code = file_get_contents($code_filename);
  $result_filename = "../" . $name . ".txt";
  if (file_exists($result_filename))
    $expected_result = file_get_contents($result_filename);
}
?>
 <body>
   <p>
     <a href="../index.php">Top</a>
   </p>
   <form action="saveTest.php" method="post">
     <b>Test name:</b> max length <code>64 bytes</code>, allowed chars <code>a-zA-Z0-9._-</code>
     <br/>
     <input type="text" name="name" size="64" maxlength="64" value="<?=$name?>"/>
     <br/>
     <br/>

     <b>Test code:</b> max length <code>10KB</code>
     <br/>
     <textarea name="test_code" cols="64" rows="15"><?=htmlspecialchars($test_code)?></textarea>
     <br/>
     <br/>

     <b>Expected results:</b> max length <code>2KB</code>
     <br/>
     <textarea name="expected_result" cols="64" rows="10"><?=$expected_result?></textarea>
     <br/>
     <br/>
     <br/>
     <input type="submit" value="Save"/>
   </form>
 </body>
</html>

--- NEW FILE ---
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

  <head>
    <title>DynAPI - Test Suite</title>
  </head>
  <body>

<?php

echo "<p><a href=\"../index.php\">Top</a></p>\n";

$name = $_REQUEST["name"];
$expected_result = $_REQUEST["expected_result"];
$test_code = $_REQUEST["test_code"];

if ($name == "") {
  die("<p>Name is required (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}
if (strlen($name) > 64) {
  die("<p>Name too long, max length = 64 bytes (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}
if (!preg_match('/^[a-zA-Z0-9\._-]+$/i', $name)) {
  die('<p>Bad name: $name (<a href=\"javascript:history.back()\">back</a>).</p>\n"</p>\n');
}

if ($test_code == "") {
  die("<p>Test code is required (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}
if (strlen($test_code) > (1024 * 10)) {
  die("<p>Test code too long, max length = 10KB (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}

if ($expected_result == "") {
  die("<p>Expected result is required (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}
if (strlen($expected_result) > (1024 * 2)) {
  die("<p>Expected result too long, max length = 2KB (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}

$code_filename = "../" . $name . ".html";
$result_filename = "../" . $name . ".txt";

$handle = fopen($code_filename, "w+");
$rv1 = fwrite($handle, $test_code);
fclose($handle);

$handle = fopen($result_filename, "w+");
$rv2 = fwrite($handle, $expected_result);
fclose($handle);

printf("<p>Code: %d bytes, result: %d bytes</p>\n", $rv1, $rv2);

?>

  </body>
</html>

--- NEW FILE ---
<html>
<head>
<title>DynAPI - Test Suite</title>
</head>

<body>
<?php

require("config.php");

$name = $_REQUEST['name'];

$test_database_connection = mysql_connect("$test_database_server",
                                          "$test_database_user",
                                          "$test_database_password")
  or die("Could not connect to database: " . mysql_error());

mysql_select_db("$test_database_name")
  or die("Could not select database $test_database_name");

// Performing SQL query
$query = "SELECT dynapi_version, testcase_date, passed, comments, user_agent, test_date, tester  FROM testresult WHERE testcase_name = '" . $name . "' ORDER BY id";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num_rows = mysql_num_rows($result);

echo "<p><a href=\"../index.php\">Top</a></p>\n";
echo "<p>Previous test results for <b>$name</b></p>\n";
// List test cases in a table
echo "<table border=\"1\" cellspacing=\"0\">\n";
echo "<tr>\n";
echo " <th>DynAPI Version</th>\n";
echo " <th>Testcase created</th>\n";
echo " <th>Passed</th>\n";
echo " <th>Comments</th>\n";
echo " <th>User agent</th>\n";
echo " <th>Test Date</th>\n";
echo " <th>Tester</th>\n";
echo "</tr>\n";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  if ($line["passed"])
    $style = "";
  else
    $style = "style=\"background-color:pink;\"";
  echo "<tr $style>\n";
  echo " <td>" . $line["dynapi_version"] . "</td>\n";
  echo " <td>" . $line["testcase_date"] . "</td>\n";
  echo " <td>" . ($line["passed"] ? "<font color=\"green\">Yes</font>" : "<font color=\"red\">No</font>") . "</td>\n";
  echo " <td>" . $line["comments"] . "</td>\n";
  echo " <td>" . $line["user_agent"] . "</td>\n";
  echo " <td>" . $line["test_date"] . "</td>\n";
  echo " <td>" . $line["tester"] . "</td>\n";
  echo "</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($test_database_connection);
?>
</body>
</html>

--- NEW FILE ---
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

  <head>
    <title>DynAPI - Test Suite</title>
  </head>
  <body>

<?php

echo "<a href=\"../index.php\">Top</a>\n";

$name = $_REQUEST['name'];
$passfail = $_REQUEST['passfail'];
$comments = $_REQUEST['comments'];
$tester = $_REQUEST['tester'];
$agent = $_SERVER['HTTP_USER_AGENT'];
$dynapiVersion = getDynAPIVersion();
$now = date("YmdHis");
$fileMod = stat("../" . $name . ".html");
$fileMod = strftime("%Y-%m-%d %H:%M:%S", $fileMod[9]);

if ($passfail!='P' and $passfail!='F'){
  die("<p>You must select either pass or fail (<a href=\"javascript:history.back()\">back</a>).</p>\n");
}

if ($passfail=='P'){
     $passfail=1;
}
else{
  $passfail=0;
}

require("config.php");
$test_database_connection = mysql_connect("$test_database_server",
                                          "$test_database_user",
                                          "$test_database_password")
  or die("Could not connect to database: " . mysql_error());

mysql_select_db("$test_database_name")
  or die("Could not select database $test_database_name");

$query = "INSERT INTO testresult (testcase_name, dynapi_version, testcase_date, passed, comments, user_agent, test_date, tester) VALUES ('$name', 'dynapi$version', '$fileMod', $passfail, '$comments', '$agent', '$now', '$tester')";
mysql_query($query) or die('Query failed: ' . mysql_error());

printf("<p>Records stored: %d</p>\n", mysql_affected_rows());

mysql_close($test_database_connection);

function getDynAPIVersion() {
  $major = 0;
  $minor = 0;
  $revision = 0;
  $handle = fopen("../../src/version.xml", "r");
  while (!feof($handle)) {
    $line = fgets($handle, 4096);
    preg_match("/<major>([^<]+)/", $line, $matches);
    if (count($matches) > 1)
      $major = $matches[1];
    preg_match("/<minor>([^<]+)/", $line, $matches);
    if (count($matches) > 1)
      $minor = $matches[1];
    preg_match("/<revision>([^<]+)/", $line, $matches);
    if (count($matches) > 1)
      $revision = $matches[1];
  }
  fclose($handle);

  return $major . "." . $minor . "." . $revision;
}
?>

  </body>
</html>

--- NEW FILE ---
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

  <head>
    <title>DynAPI - Test Suite</title>
  </head>
  <body>

    <form action="storeResult.php" target="_top">

<?php

$name = $_REQUEST['name'];

require("config.php");

$fileMod = stat("../" . $name . ".html");
$fileMod = strftime("%Y-%m-%d %H:%M:%S", $fileMod[9]);

echo "<a href=\"../index.php\" target=\"_TOP\">Top</a>\n";

echo "<table>\n";

echo " <tr>\n";
echo "  <td align=\"right\">Test Name:</td>\n";
echo "  <td>" . $name . "</td>\n";
echo " </tr>\n";

echo " <tr>\n";
echo "  <td align=\"right\">Last modified:</td>\n";
echo "  <td>" . $fileMod . "</td>\n";
echo " </tr>\n";

echo "</table>\n";

echo "<h4>Expected result:</h4>\n";
echo file_get_contents("../" . $name . ".txt");
echo "</p>\n";

echo "<h4>Observed result:</h4>\n";

echo "<input type=\"radio\" name=\"passfail\" value=\"P\"\">Pass</input>";
echo "<input type=\"radio\" name=\"passfail\" value=\"F\"\">Fail</input>";
echo "<br/>\n";

echo "Testers name: ";
echo "<input type=\"text\" name=\"tester\"/>\n";
echo "<br/>\n";

echo "Comments / observations:";
echo "<br/>\n";
echo "<textarea name=\"comments\" rows=\"10\" cols=\"32\"></textarea>\n";
echo "<br/>\n";

echo "<input type=\"submit\" value=\"Save test result\"/>\n";
echo "<input type=\"hidden\" name=\"name\" value=\"" . $name . "\"/>\n";

?>
    </form>

  </body>
</html>

[Dynapi-CVS] CVS: dynapi3x/test/scripts config.php,NONE,1.1 create_tables.sql,NONE,1.1 displayTest.p

[Dynapi-CVS] CVS: dynapi3x/test/scripts config.php,NONE,1.1 create_tables.sql,NONE,1.1 displayTest.php,NONE,1.1 editTest.php,NONE,1.1 saveTest.php,NONE,1.1 showResults.php,NONE,1.1 storeResult.php,NONE,1.1 testForm.php,NONE,1.1