/**
* Builds a system db for the test environment
*
* @todo This replicates some code in Command/System/Build - needs to be much more DRY
*/
protected function buildTestSystemDatabase()
{
// Load the Meshing_Test_Paths class
$projectRoot = Meshing_Utils::getProjectRoot();
require_once $projectRoot . '/tests/unit/Meshing_Test_Paths.php';
Meshing_Utils::reinitialise(new Meshing_Test_Paths());
$paths = Meshing_Utils::getPaths();
// Build a system connection file
$task = new Meshing_Propel_ConfBuilder();
$task->addSchemas($projectRoot . $paths->getPathDbConfig(), $paths->getLeafStandardSchema());
$task->setXmlFile($projectRoot . $paths->getFileRuntimeXml());
$task->setPropelConnection(Meshing_Utils::CONN_SYSTEM_TEST);
$task->setOutputDir($projectRoot . $paths->getPathConnsSystem());
$task->setOutputFile($paths->getLeafRuntimePhp());
$task->run();
// Build the SQL for a test system database
$task = new Meshing_Propel_SqlBuilder();
$task->addSchemas($projectRoot . $paths->getPathDbConfig(), $paths->getLeafStandardSchema());
$task->setOutputDir($projectRoot . $paths->getPathSqlSystem());
$task->setPropelConnection(Meshing_Utils::CONN_SYSTEM_TEST);
$task->run();
// Run the sql
$task = new Meshing_Propel_SqlRunner();
$task->setSqlDir($projectRoot . $paths->getPathSqlSystem());
$task->setMapFile($projectRoot . $paths->getFileDbMap());
$task->setPropelConnection(Meshing_Utils::CONN_SYSTEM_TEST);
$task->run();
}
protected function useVersionStrategy()
{
$paths = Meshing_Utils::getPaths();
$strategy = new Meshing_Hash_Strategy_Version($this->conNode);
$paths->setHashProvider($strategy);
$this->clearProviderCache();
return $strategy;
}
/**
* Testing syncing node 1 containing a few rows with node 2, which is empty
*/
public function testSimpleSync1()
{
// Set up data in node 1
$fixtures = $this->projectRoot . Meshing_Utils::getPaths()->getFixturesPath();
$data = (require_once $fixtures . '/simpleSync1.php');
$dbUtils = new Meshing_Database_Utils();
$dbUtils->writeVersionableData($data, $this->node1, $this->conNode);
// @todo Sync data into node 2 here :)
}
/**
* Takes an XML config file and converts it to PHP config files
*
* @param string $runTime Full pathname of the XML config file
* @param string $outputDir Path of the output directory
* @param string $outputFile Base leafname of the output PHP file
*/
protected function convertConf($runTime, $outputDir, $outputFile)
{
$schemaDir = $this->projectRoot . Meshing_Utils::getPaths()->getPathDbConfig();
$schemas = "schema.xml";
$task = new Meshing_Propel_ConfBuilder();
$task->addSchemas($schemaDir, $schemas);
$task->setXmlFile($runTime);
$task->setOutputDir($outputDir);
$task->setOutputFile($outputFile);
$task->setPropelConnection();
$task->run();
}
/**
* Specify which connection on which to carry out the schema task
*
* @param strings $connName Optional connection name (defaults to system connection)
*/
public function setPropelConnection($connName = Meshing_Utils::SYSTEM_CONNECTION)
{
// Grab the db details directly out of the Propel config file
$xmlPath = Meshing_Utils::getProjectRoot() . Meshing_Utils::getPaths()->getFileRuntimeXml();
$conf = simplexml_load_file($xmlPath);
/* @var $conf SimpleXMLElement */
$entry = $conf->xpath('/config/propel/datasources/datasource[@id="' . $connName . '"]');
// If an element doesn't exist here, we've probably got the connection name wrong
if (!array_key_exists(0, $entry)) {
throw new Exception("Connection name '{$connName}' not found");
}
$entry = $entry[0];
$this->setDatabaseCredentials((string) $entry->adapter, (string) $entry->connection->dsn, (string) $entry->connection->user, (string) $entry->connection->password);
}
protected function deleteDirectories()
{
$projectRoot = Meshing_Utils::getProjectRoot();
$schemaDir = $projectRoot . Meshing_Utils::getPaths()->getPathSchemasNodes() . '/' . $this->opts->name;
$modelDir = $projectRoot . Meshing_Utils::getPaths()->getPathModelsNodes() . '/' . $this->opts->name;
echo "Done.\n";
$ok = @rmdir($schemaDir);
$ok = $ok && @rmdir($modelDir);
if (!$ok) {
echo "Not (yet) deleting empty dirs. Please run these, if safe:\n";
echo "rm -rf " . $schemaDir . "\n";
echo "rm -rf " . $modelDir . "\n";
}
}
protected static function readCommands($incHidden = false)
{
static $commands = array();
static $hidden = array();
if (!$commands) {
$projectRoot = Meshing_Utils::getProjectRoot();
$consoleRoot = $projectRoot . Meshing_Utils::getPaths()->getPathMeshingCommands();
$directory = new RecursiveDirectoryIterator($consoleRoot);
$iterator = new RecursiveIteratorIterator($directory);
$regex = new RegexIterator($iterator, '/^.+\\.php$/i', RecursiveRegexIterator::GET_MATCH);
$regex->next();
$i++;
while ($regex->valid()) {
// For safety!
if ($i > 50) {
break;
}
// Get the full pathname of the class
$item = $regex->current();
$item = $item[0];
// Strip out the full path bit, and generally tidy
$item = str_replace($consoleRoot . DIRECTORY_SEPARATOR, '', $item);
$item = str_replace('.php', '', $item);
$className = 'Meshing_Console_Command_' . str_replace(DIRECTORY_SEPARATOR, '_', $item);
$item = strtolower(str_replace(DIRECTORY_SEPARATOR, ':', $item));
// Classes without this method are not commands at all
$realCommand = method_exists($className, 'getDescription');
// We consult a special method to determine whether to show the command
if ($realCommand) {
$cmdClass = new $className();
$commands[$className] = $item;
if ($cmdClass->isHiddenCommand()) {
$hidden[] = $className;
}
}
$regex->next();
}
// Preserve the keys when sorting
asort($commands);
}
// Strip out hidden commands
if (!$incHidden) {
foreach ($hidden as $removeClass) {
unset($commands[$removeClass]);
}
}
return $commands;
}
/**
* Initialisation for all tests
*
* We're using the constructor rather than setUp() as the latter is called once
* per test, and we want an init to be called once for all tests here.
*/
public function __construct($package, $label = false)
{
parent::__construct($label);
$this->package = $package;
$this->projectRoot = realpath(dirname(__FILE__) . '/../../..');
$this->paths = Meshing_Utils::getPaths();
$this->schemaDir = $this->projectRoot . $this->paths->getPathTestSchema();
$this->outputSchemaDir = $this->projectRoot . $this->paths->getPathSchemasNodes() . '/' . $package;
$this->schemas = 'test_schema1.xml';
$this->modelDir = $this->projectRoot . $this->paths->getPathModelsNodes();
$this->sqlDir = $this->projectRoot . $this->paths->getPathSqlNodes() . '/' . $package;
$this->connSystemDir = $this->projectRoot . $this->paths->getPathConnsSystem();
$this->connNodeDir = $this->projectRoot . $this->paths->getPathConnsNodes($package);
// These all use the package name as a subfolder (the model one is done by Propel)
$this->deleteFolderContents($this->outputSchemaDir, 'schema');
$this->deleteFolderContents($this->modelDir . '/' . $package, 'model');
$this->deleteFolderContents($this->sqlDir, 'sql');
// This is common to all db tests (note also: the system dir contains the node dir)
$this->deleteFolderContents($this->connSystemDir, 'connections');
$this->createSchemaDir($this->outputSchemaDir);
}
public function testMaxContention()
{
// If Windows, we can't test
if (substr(PHP_OS, 0, 3) == 'WIN') {
user_error("Can't currently test locking on the Windows platform", E_USER_WARNING);
return;
}
// Append errors to this log file
$logDir = Meshing_Utils::getProjectRoot() . Meshing_Utils::getPaths()->getTestLogPath();
$childCount = 10;
for ($id = 0; $id < $childCount; $id++) {
$command = 'php "' . __FILE__ . '" ' . CHILD_TOKEN . ' ' . $id;
$background = '>> ' . $logDir . '/' . LOCKING_TEST_LOG . ' 2>&1 &';
$return = null;
$output = system($command . ' ' . $background, $return);
// @todo Need to find a way to detect if the process launch failed
// (no $output is returned even if errors are output to stdout)
if ($output === false) {
user_error('There was a problem executing a background task', E_USER_WARNING);
break;
}
}
// Wait for all children to finish
$iter = 0;
$okCount = null;
do {
sleep(1);
$iter++;
$completed = $this->allChildrenFinished($childCount, $okCount);
// Time limit
if ($iter > 20 && !$completed) {
user_error("Time limit expired, but only {$okCount} of {$childCount} children finished", E_USER_WARNING);
break;
}
} while (!$completed);
$this->assertEqual($okCount, $childCount, 'Check that all inserts have completed without race condition problems');
}
protected function createConf()
{
$paths = Meshing_Utils::getPaths();
$configName = $paths->getLeafRuntimePhp();
$this->convertConf($this->projectRoot . $paths->getFileRuntimeXml(), $this->projectRoot . $paths->getPathConnsNodes($this->opts->name), $configName);
// We only want the autoloading file, not the connections file... deleting to be tidy!
$configPath = $this->projectRoot . Meshing_Utils::getPaths()->getPathConnsNodes($this->opts->name) . '/' . $configName;
@unlink($configPath);
}
public function testCreateChangeTables()
{
$paths = Meshing_Utils::getPaths();
$snippetsPath = Meshing_Utils::getProjectRoot() . $paths->getPathSystemSnippets();
$tables = $this->xml->getTables();
$changeTables = $this->xml->createChangeTables($snippetsPath . '/change_table.xml', $tables);
$this->assertEqual(count($tables), count($changeTables), 'Ensure there is a change table for each real table');
// @todo Check that the prefix is the same for each change table
// @todo Check that the FKs in each change table are mapped to current table PK equivs
}
public function __construct($inFilename, $outFilename)
{
$this->xml = simplexml_load_file($inFilename, 'Meshing_Schema_Element');
$this->filename = $outFilename;
$this->snippetDir = Meshing_Utils::getProjectRoot() . Meshing_Utils::getPaths()->getPathSystemSnippets();
}
/**
* Gets an instance of the hashing object
*
* It is possible that Meshing will connect to several connections, either in a production
* nodeset where several databases are in use, or in testing. To ensure our provider uses
* the right connection, we cache hash providers per connection.
*
* @staticvar Meshing_Hash_Base $hashProvider
* @param PropelPDO $con
* @return Meshing_Hash_Base
*/
protected function getHashProvider(Meshing_Database_Connection $con)
{
$key = (string) $con;
if (!array_key_exists($key, self::$hashProviders)) {
self::$hashProviders[$key] = Meshing_Utils::getPaths()->getHashProvider($con);
}
return self::$hashProviders[$key];
}
protected function runFixtures($verbose)
{
$fixturesFile = $this->projectRoot . Meshing_Utils::getPaths()->getPathSystemFixtures() . '/fixtures.php';
if (file_exists($fixturesFile)) {
$runner = new Meshing_Propel_FixturesRunner($fixturesFile);
$runner->run();
}
}
/**
* Runs the already-built SQL for the system db (deletes the existing system tables)
*
* @todo This is similar to system:build, fix this?
*
* @param string $projectRoot
*/
protected function runSql($projectRoot)
{
$sqlDir = $projectRoot . Meshing_Utils::getPaths()->getPathSqlNodes() . '/' . $this->opts->name;
$mapFile = $projectRoot . Meshing_Utils::getPaths()->getFileDbMap();
$task = new Meshing_Propel_SqlRunner();
$task->setSqlDir($sqlDir);
$task->setMapFile($mapFile);
// Set build properties (@todo switch this to use setPropelConnection)
$task->addProperty('propel.database', $this->connection->getAdaptor());
$task->addProperty('propel.database.url', $this->connection->getCalculatedDsn());
$task->addProperty('propel.database.user', $this->connection->getUsername());
$task->addProperty('propel.database.password', $this->connection->getPassword());
$task->run();
}
