Location: PHPKode > scripts > POG - PHP Code Generator > pog-php-code-generator/setup_factory/setup.php
<?php
/**
* @author  Joel Wan & Mark Slemko.  Designs by Jonathan Easton
* @link  http://www.phpobjectgenerator.com
* @copyright  Offered under the  BSD license
*
* This setup file does the following:
* 1. Checks if configuration file is present
* 2. Checks if the data in the configuration file is correct
* 3. Checks if the database and table exist
* 4. Create table if not present
* 5. Tests 5 CRUD functions and determine if everything is OK for all objects within the current directory
* 6. When all tests pass, provides an interface to the database and a way to manage objects.
*/
include_once("setup_library/setup_misc.php");
if(file_exists("../configuration.php"))
{
	include_once("../configuration.php");
}
else
{
	echo "configuration file missing<br/>";
}
if(!isset($_SESSION['diagnosticsSuccessful']) || (isset($_GET['step']) && $_GET['step']=="diagnostics"))
{
	$_SESSION['diagnosticsSuccessful'] = false;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Php Object Generator Setup</title>
<link rel="stylesheet" href="./setup.css" type="text/css" />
<link rel="stylesheet" type="text/css" href="./setup_library/xPandMenu.css"/>
<script src="./setup_library/xPandMenu.js"></script>
</head>
<body>
<div class="header">
<?php include "setup_library/inc.header.php";?>
</div>
<form action="./index.php" method="POST">
<?php
ini_set("error_reporting", 0);
if(count($_POST) > 0 && $_SESSION['diagnosticsSuccessful']==false)
{
?>
<div class="container">
<div class="left">
	<div class="logo2"></div>
	<div class="text"><div class="gold">POG setup diagnostics</div>
	<br/>Setup performs unit tests on all your objects in the object directory and makes sure they're OK. <br/>This makes sure that your objects can talk to your database correctly. This can also be useful if you modify / customize the objects manually and want to make sure they still work once you're done.
	<br/><br/>The diagnostics screen on the right shows the results of those tests.
	</div>
</div>
<div class="middle">
	<div id="tabs">
		<a href="./index.php?step=diagnostics"><img src="./setup_images/tab_setup.gif"/></a>
		<img src="./setup_images/tab_separator.gif"/>
		<img src="./setup_images/tab_diagnosticresults_on.gif"/>
		<img src="./setup_images/tab_separator.gif"/>
		<img src="./setup_images/tab_manageobjects.gif"/>
	</div><div class="subtabs">&nbsp;</div><a href="./index.php?step=diagnostics"><img src="./setup_images/setup_recheck.jpg" border="0"/></a><div class="middle2">
<?php
	//perform diagnostics
	if (isset($GLOBALS['configuration']['pdoDriver']))
	{

	}
	else
	{
		if(file_exists("../objects/class.database.php"))
		{
			include "../objects/class.database.php";
			//try connecting to the database
			try
			{
				$database = new DatabaseConnection();
				//success
				//scan for generated objects.
				$dir = opendir('../objects/');
				$objects = array();
				while(($file = readdir($dir)) !== false)
				{
					if(strlen($file) > 4 && substr(strtolower($file), strlen($file) - 4) === '.php' && !is_dir($file) && $file != "class.database.php" && $file != "configuration.php" && $file != "setup.php")
					{
						$objects[] = $file;
					}
				}
				closedir($dir);
				$objectNameList = array();
				$errors = 0;
				$diagnostics = "";
				$_SESSION['links'] = array();
				foreach ($objects as $object)
				{
					include("../objects/{$object}");
				}
				foreach($objects as $object)
				{
					$content = file_get_contents("../objects/".$object);
					$contentParts = split("<b>",$content);
					if (isset($contentParts[1]))
					{
						$contentParts2 = split("</b>",$contentParts[1]);
					}
					if (isset($contentParts2[0]))
					{
						$className = trim($contentParts2[0]);
					}
					if (isset($className))
					{
						$diagnostics .= "TESTING $className...\n";
						$objectNameList[] = $className;

						//get sql
						$sqlParts = split(";",$contentParts[0]);
						$sqlPart = split("CREATE",$sqlParts[0]);
						$sql = "CREATE ".$sqlPart[1].";";

						$linkParts1 = split("\*\/", $contentParts[1]);
						$linkParts2 = split("\@link", $linkParts1[0]);
						$link = $linkParts2[1];

						eval('$instance = new '.$className.'();');

						$attributeList = array_keys(get_object_vars($instance));
						$type_value = InitializeTestValues($instance->pog_attribute_type);

      					foreach($attributeList as $attribute)
  						{
  							if (isset($instance->pog_attribute_type[strtolower($attribute)]))
  							{
	  							if (isset($type_value[strtolower($attribute)]))
		  						{
		 							$instance->{$attribute} = $type_value[strtolower($attribute)];
								}
	  							else
	  							{
	  								$instance->{$attribute} = "1";
	  							}
  							}
  						}
      					//Test Save()
      					try
      					{
      						$instanceId = false;
      						$instance->{strtolower($className)."Id"} = 0;
      						$instanceId = $instance->Save();
	      					if(!$instanceId)
	      					{
	      						$diagnostics .= "ERROR: Save() could not be performed\n";
	      						$diagnostics .= $instance->pog_query."\n";
	      						$errors++;
	      					}
	      					else
	      					{
	      						$diagnostics .=  "Testing Save()....OK\n";
	      					}
      					}
      					catch(Exception $e)
      					{
      						if(substr($e->getMessage(),0,4) == "1146")
      						{
      							//table doesn't exist
      							//try to create table
      							$database = new DatabaseConnection();
      							try
      							{
      								$database->Query($sql);
      								$diagnostics .= "Created Table $className successfully\n";
      							}
      							catch (Exception $e)
      							{
      								$diagnostics .= "Could not create table.";
      							}
      							$instanceId = $instance->Save();
		      					if(!$instanceId)
		      					{
		      						$diagnostics .= "ERROR: Save() could not be performed\n";
		      						$diagnostics .= $instance->pog_query."\n";
		      						$errors++;
		      					}
		      					else
		      					{
		      						$diagnostics .= "Testing Save()....OK\n";
		      					}
      						}
      					}

      					//Test SaveNew()
      					if(!$instance->SaveNew())
      					{
      						$diagnostics .= "ERROR: SaveNew() could not be performed\n";
      						$diagnostics .= $instance->pog_query."\n";
      						$errors++;
      					}
      					else
      					{
      						$instance->SaveNew();
      						$diagnostics .= "Testing SaveNew()....OK\n";
      					}

      					//Test GetList();
      					//GetList() implicitly tests Get(),
      					$instanceList = $instance->GetList(array(array(strtolower($className)."Id",">",0)));
      					if($instanceList == null)
      					{
      						$diagnostics .= "ERROR: GetList() could not be performed\n";
      						$diagnostics .= $instance->pog_query."\n";
      						$errors++;
      					}
      					else
      					{
	  						$diagnostics .= "Testing Get()....OK\n";
	  						$diagnostics .= "Testing GetList()....\n";
	  						$oldCount = count($instanceList);
	  						//Test Multiple Conditions
	  						$instanceList = $instance->GetList(array(array(strtolower($className)."Id", ">=",$instanceId), array(strtolower($className)."Id", "<=", $instanceId+2)), strtolower($className)."Id", false, 2);
	  						$diagnostics .= "\tTesting Limit....";
	  						if (sizeof($instanceList) != 2)
	  						{
	  							//Test Limit
	  							$diagnostics .= "ERROR: GetList() :sizeof(list) != \$limit\n";
		  						$diagnostics .= $instance->pog_query."\n";
		  						$errors++;
	  						}
	  						else
	  						{
	  							$diagnostics .= "OK\n";
	  						}
	  						$diagnostics .= "\tTesting Sorting....";
	  						if ($instanceList[1]->{strtolower($className)."Id"} > $instanceList[0]->{strtolower($className)."Id"})
	  						{
	  							//Test Sorting
	  							$diagnostics .= "ERROR: GetList() :list is not properly sorted\n";
		  						$diagnostics .= $instance->pog_query."\n";
		  						$errors++;
	  						}
	  						else
	  						{
	  							$diagnostics .= "OK\n";
	  						}
	  						if ($errors == 0)
	  						{
	  							$diagnostics .= "Testing GetList()....OK\n";
		  						$instanceList = $instance->GetList(array(array(strtolower($className)."Id", ">=",$instanceId), array(strtolower($className)."Id", "<=", $instanceId+2)), strtolower($className)."Id", false, 3);
	  							foreach ($instanceList as $instance)
		  						{
		  							$attributeList = array_keys(get_object_vars($instance));
		  							foreach ($attributeList as $attribute)
		  							{
				      					if (isset($instance->pog_attribute_type[strtolower($attribute)]))
			  							{
				  							if (isset($type_value[strtolower($attribute)]))
				  							{
			      								if ($instance->{$attribute} != $type_value[strtolower($attribute)])
			      								{
			      									$diagnostics .= "WARNING: Failed to retrieve attribute `$attribute`. Expecting `".$type_value[strtolower($attribute)]."`; found `".$instance->{$attribute}."`. Check that column `$attribute` in the `$className` table is of type `".$instance->pog_attribute_type[strtolower($attribute)][1]."`\n";
			      								}
				  							}
			  							}
		  							}
	  								$instance->Delete();
		  						}
	  						}
	  						else
	  						{
	  							$diagnostics .= "Testing GetList()....Failed\n";
	  						}
      						$instanceList = $instance->GetList(array(array(strtolower($className)."Id",">",0)));
      						if ($instanceList == null)
      						{
      							$instanceList = array();
      						}
      						$newCount = count($instanceList);
      						if($oldCount-3 == $newCount)
      						{
      							$diagnostics .= "Testing Delete()....OK\n";
      						}
      						else
      						{
      							$diagnostics .= "ERROR: Delete() could not be performed\n";
      							$diagnostics .= $instance->pog_query."\n";
      							$errors++;
      						}
      					}
      					if ($errors == 0)
						{
							$database->Query("optimize table ".strtolower($className));
							$diagnostics .= "Optimizing ".$className."....OK\n-----\n";
							$_SESSION['links'][$className] = $link;
						}
   						$contentParts2 = null;
						$className = null;
					}
				}
				$diagnostics .= "\nFOUND & CHECKED ".count($objectNameList)." OBJECT(S)\n";
				$_SESSION['fileNames'] = serialize($objects);
				$_SESSION['objectNameList'] = serialize($objectNameList);
				echo "<textarea>$diagnostics</textarea></div>";
				if ($errors == 0)
				{
					$_SESSION['diagnosticsSuccessful'] = true;
					echo '<input type="image" src="./setup_images/setup_proceed.gif" name="submit"/>';
				}
				else
				{
					$diagnostics .= "FOUND $errors ERROR(S)\n";
					//echo "<input type='submit' name='submit' value='Retry'/>";
				}

			}
			catch (Exception $e)
			{
				echo $e->getMessage();
			}
		}
		else
		{
			echo "database wrapper (class.database.php) missing<br/>";
		}
	}
$_POST = null;
?>
</div></div>
<?php
}
else if($_SESSION['diagnosticsSuccessful'] == true)
{
?>
<div class="container">
	<div class="left">
		<div class="logo3"></div>
		<div class="text"><div class="gold">POG documentation summary</div>
		<br/>The following 3 documents summarize what POG is all about:<br/><br/>
		1. <a href="http://www.phpobjectgenerator.com/plog/file_download/15">POG Essentials</a><br/><br/>
		2. <a href="http://www.phpobjectgenerator.com/plog/file_download/21">POG Object Relations</a><br/><br/>
		3. <a href="http://www.phpobjectgenerator.com/plog/file_download/18">POG SOAP API</a>
		</div><!--text-->
	</div>
<div class="middle33">
	<div id="tabs3">
		<a href="./index.php?step=diagnostics"><img src="./setup_images/tab_setup.gif"/></a>
		<img src="./setup_images/tab_separator.gif"/>
		<img src="./setup_images/tab_diagnosticresults.gif"/>
		<img src="./setup_images/tab_separator.gif"/>
		<a href="./index.php"><img src="./setup_images/tab_manageobjects_on.gif"/></a>
	</div><div class="subtabs">
<?php
	//provide interface to the database
	include "./setup_library/xPandMenu.php";
	$root = new XMenu();
	if(file_exists("configuration.php"))
	{
		include "../configuration.php";
	}
	if(file_exists("../objects/class.database.php"))
	{
		include "../objects/class.database.php";
	}

	$fileNames = unserialize($_SESSION['fileNames']);
	foreach($fileNames as $filename)
	{
		include("../objects/{$filename}");
	}
	$objectNameList = unserialize($_SESSION['objectNameList']);
	if (isset($_GET['objectName']))
	{
		$_SESSION['objectName'] = $_GET['objectName'];
	}
	$objectName = (isset($_SESSION['objectName'])?$_SESSION['objectName']:$objectNameList[0]);

	?>
	<div id="header">
  	<ul>
  	<li id='inactive'>My Tables:</li>
	<?php
	if (!isset($_SESSION['objectName']))
	{
		$_SESSION['objectName'] = $objectNameList[0];
	}
	for($i=0; $i<count($objectNameList); $i++)
	{
		echo "<li ".($_SESSION['objectName']==$objectNameList[$i]?"id='current'":'')."><a href='./index.php?objectName=".$objectNameList[$i]."'>".$objectNameList[$i]."</a></li>";
		//echo "<a href='./index.php?objectName=".$objectNameList[$i]."'".(isset($_SESSION['objectName']) && $_SESSION['objectName']==$objectNameList[$i]?"class='activetab'":(!isset($_SESSION['objectName'])&&$i==0?"class='activetab'":"inactivetab")).">".$objectNameList[$i]."</a> ";
	}
	?>
	</ul>
	</div><!--header-->
	</div><!--subtabs-->
	<div class="toolbar"><a href="<?php echo $_SESSION['links'][$_SESSION['objectName']]?>" target="_blank" title="modify and regenerate object"><img src="./setup_images/setup_regenerate.jpg" border="0"/></a><a href="./?thrashall=true" title="Delete all objects"><img src='./setup_images/setup_deleteall.jpg' alt='delete all' border="0"/></a><a href="#" onclick="javascript:expandAll();return false;" title="expand all nodes"><img src='./setup_images/setup_expandall.jpg' alt='expand all' border="0"/></a><a href="#" onclick="javascript:collapseAll();return false;" title="collapse all nodes"><img src='./setup_images/setup_collapseall.jpg' alt='collapse all' border="0"/></a><a href="./setup_library/upgrade.php" target="_blank" title="update all objects to newest POG version"><img src='./setup_images/setup_updateall.jpg' alt='update all objects' border='0'/></a></div><div class="middle3">
	<?php
	//is there an action to perform?
	if (isset($_GET['thrashall']))
	{
		eval('$instance = new '.$objectName.'();');
		$instanceId = strtolower(get_class($instance))."Id";
		$instanceList = $instance->GetList(array(array($instanceId, ">", "0")));
		foreach ($instanceList as $instance)
		{
			$instance->Delete();
		}
		$_GET = null;
	}
	echo "<script>sndReq('GetList', '', '$objectName', '', '', '');</script>";
	echo '<div id="container"></div>';
	$_SESSION['fileNames'] = serialize($fileNames);
	$_SESSION['objectNameList'] = serialize($objectNameList);
?>
</div><div class="bottom3"><img src="./setup_images/setup_bottom3.jpg"/></div></div></div>
<?php
}
else
{
	//welcome screen
?>
<div class="container">
	<div class="left">
		<div class="logo"></div>
		<div class="text"><div class="gold">What is POG Setup?</div>POG Setup is an extension of the online Php Object Generator. It is meant to help the veteran POG user and the novice alike.
		<br/><br/>POG Setup is a 3 step process which:<br/><br/>
		1. Creates tables for your generated objects.<br/><br/>
		2. Performs diagnostics tests on all objects within your 'objects' directory.<br/><br/>
		3. Provides a light interface to your object tables.</div>
	</div>
	<div class="middle">
		<div id="tabs">
			<img src="./setup_images/tab_setup_on.gif" height="20px" width="70px"/>
			<img src="./setup_images/tab_separator.gif" height="20px" width="17px"/>
			<img src="./setup_images/tab_diagnosticresults.gif" height="20px" width="137px"/>
			<img src="./setup_images/tab_separator.gif" height="20px" width="17px"/>
			<img src="./setup_images/tab_manageobjects.gif" height="20px" width="129px"/>
		</div>
		<div id="nifty">
			<div style="height:500px">
			<img src="./setup_images/setup_welcome.jpg" height="47px" width="617px"/>
			<div class="col1"><img src="./setup_images/pog_setup_closed.jpg"/><div class="gold">What is POG?</div>POG generates PHP objects with integrated CRUD methods to dramatically accelerate web application development in PHP. <br/>
			<br/>POG allows developers to easily map object attributes onto columns of a database table without having to write SQL queries.</div>
			<div class="col2"><img src="./setup_images/pog_setup_open.jpg"/><div class="gold">What is POG Setup?</div>You've generated one or more objects using Php Object Generator ... Now what?<br/>
			<br/>POG SETUP is an answer to this question and takes the POG experience one step further. The Setup process automates <b>table creation</b>, <b>unit testing</b> and provides a light <b>scaffolding</b> environment.</div>
			<div class="col3">
			<div class="gold">If you are ready to get POG'd up, click on thebutton below to proceed. Doing this will:</div>
			<br/>1. Establish a database connection.<br/>
			2. Create table(s) for your objec(s), if required.<br/>
			3. Perform diagnostics tests on your object(s).<br/>
			4. Provide you with the test results.<br/><input type="image" src="./setup_images/setup_pogmeup.gif" name="submit"/></div>
			</div>
			<b class="rbottom"><b class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b>
		</div>
	</div>
</div>
<?php
}
?>
</form>
<div class="footer">
<?php include "setup_library/inc.footer.php";?>
</div>
</body>
</html>
Return current item: POG - PHP Code Generator