function generator($levels)
{
$this->levels = $levels;
$return = '';
$this->enforceUniquenessOnLevel(0);
for ($i = 0; $i < $this->levelCount(); $i++) {
$return .= $this->createLevel($i);
}
$return .= $this->createMappingsTable();
$return .= $this->addUniqueOnMappingsTable();
$return .= $this->createDefinitionTable();
$return .= $this->addUniqueOnDefinitionsTable();
$return .= $this->createSchemaTable();
$return .= $this->createVersionTable();
if (file_exists(ELITE_PATH . '/Vafwheel')) {
$generator = new Elite_Vafwheel_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafwheeladapter')) {
$generator = new Elite_Vafwheeladapter_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vaftire')) {
$generator = new Elite_Vaftire_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafpaint')) {
$generator = new Elite_Vafpaint_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafnote')) {
$generator = new Elite_Vafnote_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafimporter')) {
$generator = new Elite_Vafimporter_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafgarage')) {
$generator = new Elite_Vafgarage_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafdiagram')) {
$generator = new Elite_Vafdiagram_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
return $return;
}
function generator($levels)
{
$this->levels = $levels;
$return = '-- Schema for ' . $this->id() . "--\n";
//$this->enforceUniquenessOnLevel(0);
for ($i = 0; $i < $this->levelCount(); $i++) {
$return .= $this->createLevel($i);
}
$return .= $this->createMappingsTable();
$return .= $this->addUniqueOnMappingsTable();
$return .= $this->createDefinitionTable();
$return .= $this->addUniqueOnDefinitionsTable();
if ($this->id != 1) {
return $return;
}
$return .= $this->createSchemaTable();
$return .= $this->createVersionTable();
$generator = new VF_Wheel_Schema_Generator();
$return .= $generator->generator($levels);
$generator = new VF_Wheeladapter_Schema_Generator();
$return .= $generator->generator($levels);
$generator = new VF_Tire_Schema_Generator();
$return .= $generator->generator($levels);
if (file_exists(ELITE_PATH . '/Vafpaint')) {
$generator = new Elite_Vafpaint_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
$generator = new VF_Note_SchemaGenerator();
$return .= $generator->generator($levels);
$generator = new VF_Import_Schema_Generator();
$return .= $generator->generator($levels);
if (file_exists(ELITE_PATH . '/Vafgarage')) {
$generator = new Elite_Vafgarage_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
if (file_exists(ELITE_PATH . '/Vafdiagram')) {
$generator = new Elite_Vafdiagram_Model_Schema_Generator();
$return .= $generator->generator($levels);
}
return $return;
}
" /> (ex. "make,model, year")
<br />
<input id="generateDB" type="checkbox" name="generateDb" value="1" checked="checked" /> Generate Database SQL
<br />
<input id="runDB" type="checkbox" name="runDb" value="1" /> Run Database SQL
<?php
if (isset($_REQUEST['levels']) && isset($_REQUEST['runDb'])) {
$generator = new VF_Schema_Generator();
$generator->dropExistingTables();
$sql = $generator->generator(explode(',', $_REQUEST['levels']));
if (file_exists(ELITE_PATH . '/Vafpaint')) {
$generator = new Elite_Vafpaint_Model_Schema_Generator();
$sql .= $generator->install();
}
if (file_exists(ELITE_PATH . '/Vafgarage')) {
$generator = new Elite_Vafgarage_Model_Schema_Generator();
$sql .= $generator->install();
}
foreach (explode(';', $sql) as $statement) {
if (!trim($statement)) {
continue;
}
try {
$helper->getReadAdapter()->query($statement);
} catch (Exception $e) {
echo '<br /><span style="color:red;">ERROR: ' . $e->getMessage() . ' in SQL: ' . $statement . '</span>';
}
}
echo '<br /><b style="color:green">Ok! Database created!</b>';
} else {
if (isset($_REQUEST['levels']) && isset($_REQUEST['generateDb'])) {
