Beispiel #1
0
 /**
  * @param string $name Index name.
  */
 function __construct($name = '')
 {
     parent::__construct($name);
     $this->columns = new Collection();
     $this->indexes = new Collection();
     $this->constraints = new Collection();
     $this->triggers = new Collection();
 }
Beispiel #2
0
 /**
  * @param BaseObject $source Source object.
  * @param BaseObject $target Target object.
  *
  * @return void
  */
 protected function handleChange(BaseObject $source, BaseObject $target)
 {
     if ($source instanceof Sequence || $source instanceof Procedure) {
         $this->conditions[""][] = $this->multiLinePhp("\t\t\$DB->Query(\"", $source->getDropDdl($this->dbType), "\", true);\n") . $this->multiLinePhp("\t\t\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\", true);\n");
         $dropStmt = $this->createStatement("\$DB->Query(\"", $source->getDropDdl($this->dbType), "\", true);");
         $createStmt = $this->createStatement("\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\", true);");
         $stmt = new Php\Statement();
         $stmt->merge($dropStmt);
         $stmt->merge($createStmt);
         $stmt->addCondition("\$updater->CanUpdateDatabase()");
         $stmt->addCondition("\$DB->type == \"" . EscapePHPString($this->dbType) . "\"");
         $stmt->addCondition("\$updater->TableExists(\"" . EscapePHPString($this->tableCheck->getLowercasedName()) . "\")");
     } elseif ($target instanceof Column) {
         $ddl = $source->getModifyDdl($target, $this->dbType);
         $predicate = "\$updater->TableExists(\"" . EscapePHPString($source->parent->name) . "\")";
         $cond = "\t\tif ({$predicate})\n";
         $predicate2 = "\$DB->Query(\"SELECT " . EscapePHPString($source->name) . " FROM " . EscapePHPString($source->parent->name) . " WHERE 1=0\", true)";
         $this->conditions[$cond][] = "\t\t\tif ({$predicate2})\n" . "\t\t\t{\n" . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $ddl, "\");\n") . "\t\t\t}\n";
         $stmt = $this->createStatement("\$DB->Query(\"", $ddl, "\");");
         $stmt->addCondition("\$updater->CanUpdateDatabase()");
         $stmt->addCondition("\$DB->type == \"" . EscapePHPString($this->dbType) . "\"");
         $stmt->addCondition("\$updater->TableExists(\"" . EscapePHPString($source->parent->getLowercasedName()) . "\")");
         $stmt->addCondition("\$DB->Query(\"SELECT " . EscapePHPString($source->name) . " FROM " . EscapePHPString($source->parent->getLowercasedName()) . " WHERE 1=0\", true)");
     } elseif ($source instanceof Index) {
         $this->conditions["\t\tif (\$updater->TableExists(\"" . EscapePHPString($source->parent->name) . "\"))\n"][] = "\t\t\tif (\$DB->IndexExists(\"" . EscapePHPString($source->parent->name) . "\", array(" . $this->multiLinePhp("\"", $source->columns, "\", ") . ")))\n" . "\t\t\t{\n" . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $source->getDropDdl($this->dbType), "\");\n") . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\");\n") . "\t\t\t}\n";
         $dropStmt = $this->createStatement("\$DB->Query(\"", $source->getDropDdl($this->dbType), "\", true);");
         $createStmt = $this->createStatement("\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\", true);");
         $stmt = new Php\Statement();
         $stmt->merge($dropStmt);
         $stmt->merge($createStmt);
         $stmt->addCondition("\$updater->CanUpdateDatabase()");
         $stmt->addCondition("\$DB->type == \"" . EscapePHPString($this->dbType) . "\"");
         $stmt->addCondition("\$updater->TableExists(\"" . EscapePHPString($source->parent->getLowercasedName()) . "\")");
         $stmt->addCondition("\$DB->IndexExists(\"" . EscapePHPString($source->parent->getLowercasedName()) . "\", array(" . $this->multiLinePhp("\"", $source->columns, "\", ") . "))");
         $stmt->addCondition("!\$DB->IndexExists(\"" . EscapePHPString($target->parent->getLowercasedName()) . "\", array(" . $this->multiLinePhp("\"", $target->columns, "\", ") . "))");
     } elseif ($source instanceof Trigger || $source instanceof Constraint) {
         $ddl = $source->getModifyDdl($target, $this->dbType);
         $predicate = "\$updater->TableExists(\"" . EscapePHPString($source->parent->name) . "\")";
         $cond = "\t\tif ({$predicate})\n";
         $this->conditions[$cond][] = $this->multiLinePhp("\t\t\t\$DB->Query(\"", $ddl, "\", true);\n");
         $stmt = $this->createStatement("\$DB->Query(\"", $ddl, "\", true);");
         $stmt->addCondition("\$updater->CanUpdateDatabase()");
         $stmt->addCondition("\$DB->type == \"" . EscapePHPString($this->dbType) . "\"");
         $stmt->addCondition("\$updater->TableExists(\"" . EscapePHPString($source->parent->getLowercasedName()) . "\")");
     } else {
         $this->conditions[""][] = "\t\t//change for " . get_class($source) . " not supported yet\n";
         $stmt = $this->createStatement("", "//change for " . get_class($source) . " not supported yet", "");
     }
     if ($stmt) {
         $this->statements[] = $stmt;
     }
 }
Beispiel #3
0
 /**
  * @param BaseObject $source Source object.
  * @param BaseObject $target Target object.
  *
  * @return void
  */
 protected function handleChange(BaseObject $source, BaseObject $target)
 {
     if ($source instanceof Sequence || $source instanceof Procedure) {
         $this->conditions[""][] = $this->multiLinePhp("\t\t\$DB->Query(\"", $source->getDropDdl($this->dbType), "\", true);\n") . $this->multiLinePhp("\t\t\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\", true);\n");
     } elseif ($target instanceof Column) {
         $this->conditions["\t\tif (\$DB->TableExists(\"" . EscapePHPString($source->parent->name) . "\"))\n"][] = "\t\t\tif (\$DB->Query(\"SELECT " . EscapePHPString($source->name) . " FROM " . EscapePHPString($source->parent->name) . " WHERE 1=0\", true))\n" . "\t\t\t{\n" . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $source->getModifyDdl($target, $this->dbType), "\");\n") . "\t\t\t}\n";
     } elseif ($source instanceof Index) {
         $this->conditions["\t\tif (\$DB->TableExists(\"" . EscapePHPString($source->parent->name) . "\"))\n"][] = "\t\t\tif (\$DB->IndexExists(\"" . EscapePHPString($source->parent->name) . "\", array(" . $this->multiLinePhp("\"", $source->columns, "\", ") . ")))\n" . "\t\t\t{\n" . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $source->getDropDdl($this->dbType), "\");\n") . $this->multiLinePhp("\t\t\t\t\$DB->Query(\"", $target->getCreateDdl($this->dbType), "\");\n") . "\t\t\t}\n";
     } elseif ($source instanceof Trigger || $source instanceof Constraint) {
         $this->conditions["\t\tif (\$DB->TableExists(\"" . EscapePHPString($source->parent->name) . "\"))\n"][] = $this->multiLinePhp("\t\t\t\$DB->Query(\"", $source->getModifyDdl($target, $this->dbType), "\", true);\n");
     } else {
         $this->conditions[""][] = "\t\t//change for " . get_class($source) . " not supported yet\n";
     }
 }
Beispiel #4
0
 /**
  * Return DDL for trigger modification (drop with subsequent create).
  *
  * @param BaseObject $target Target object.
  * @param string $dbType Database type (MYSQL, ORACLE or MSSQL).
  *
  * @return array|string
  */
 public function getModifyDdl(BaseObject $target, $dbType = '')
 {
     return array($this->getDropDdl($dbType), $target->getCreateDdl($dbType));
 }