protected function createBuilder()
{
$builder = new PropelQuickBuilder();
$builder->setPlatform(new PgsqlPlatform());
$builder->setSchema($this->getXMLSchema());
return $builder;
}
public function testGetPlatform()
{
require_once dirname(__FILE__) . '/../../../../generator/lib/platform/MysqlPlatform.php';
$builder = new PropelQuickBuilder();
$builder->setPlatform(new MysqlPlatform());
$this->assertTrue($builder->getPLatform() instanceof MysqlPlatform);
$builder = new PropelQuickBuilder();
$this->assertTrue($builder->getPLatform() instanceof SqlitePlatform);
}
/**
* Drop the foreign key in the `_user` table and check whether it generates
* the correct `DROP` SQL.
*/
private function dropForeignKey()
{
/*
* Create issue617 tables without foreign keys
*/
$this->readDatabase();
$updatedSchema = '
<database name="reverse-bookstore">
<table name="issue617_user">
<vendor type="mysql">
<parameter name="Engine" value="InnoDB"/>
<parameter name="Charset" value="utf8"/>
</vendor>
<column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" />
<column name="full_name" type="VARCHAR" size="50" required="true" />
</table>
<table name="issue617_group">
<vendor type="mysql">
<parameter name="Engine" value="InnoDB"/>
<parameter name="Charset" value="utf8"/>
</vendor>
<column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" />
<column name="name" type="VARCHAR" size="50" required="true" />
</table>
</database>
';
$this->updatedBuilder = new PropelQuickBuilder();
$this->updatedBuilder->setPlatform($this->database->getPlatform());
$this->updatedBuilder->setSchema($updatedSchema);
$diff = PropelDatabaseComparator::computeDiff($this->database, $this->updatedBuilder->getDatabase());
$sql = $this->database->getPlatform()->getModifyDatabaseDDL($diff);
$expected = '
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `book`;
DROP TABLE IF EXISTS `foo`;
ALTER TABLE `issue617_user` DROP FOREIGN KEY `issue617_user_FK_1`;
DROP INDEX `issue617_user_FI_1` ON `issue617_user`;
ALTER TABLE `issue617_user` DROP `group_id`;
# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
';
$this->assertEquals($expected, $sql);
$this->updateSchema($this->updatedBuilder->getDatabase());
}
public function testIndex()
{
$updatedSchema = '
<database>
<table name="notification">
<column autoIncrement="true" name="id" primaryKey="true" required="true" type="INTEGER" />
<column name="target_user_id" required="true" type="INTEGER" />
<column name="notification_type_unique_name" required="true" size="255" type="VARCHAR" />
<column name="group_id" type="INTEGER" />
<column name="date" required="true" type="TIMESTAMP" />
<column name="objects" type="LONGVARCHAR" />
<column name="is_new" defaultValue="1" required="true" type="BOOLEAN" />
<foreign-key foreignTable="notification_type" name="FK_NOTIFICATION_TYPENOTIFICATION0">
<reference foreign="unique_name" local="notification_type_unique_name" />
</foreign-key>
<index name="FK_NOTIFICATION_TARGET_USER">
<index-column name="target_user_id" />
</index>
<index name="FK_NOTIFICATION_TYPENOTIFICATION">
<index-column name="notification_type_unique_name" />
</index>
</table>
<table name="notification_type">
<column name="module_unique_name" primaryKey="true" required="true" size="255" type="VARCHAR" />
<column name="unique_name" primaryKey="true" required="true" size="255" type="VARCHAR" />
<column name="is_correction" defaultValue="0" required="true" type="BOOLEAN" />
<column name="disabled_engine" size="255" type="VARCHAR" />
<foreign-key foreignTable="module" name="FK_TYPENOTIFICATION_MODULE0" onDelete="CASCADE" onUpdate="CASCADE">
<reference foreign="unique_name" local="module_unique_name" />
</foreign-key>
<index name="FK_TYPENOTIFICATION_MODULE">
<index-column name="module_unique_name" />
</index>
</table>
<table name="module">
<column autoIncrement="true" name="id" primaryKey="true" required="true" type="INTEGER" />
<column name="unique_name" required="true" size="255" type="VARCHAR" />
<column name="label" primaryString="true" required="true" size="255" type="VARCHAR" />
<column name="description" required="true" size="255" type="VARCHAR" />
</table>
</database>
';
$actual = "\n# This is a fix for InnoDB in MySQL >= 4.1.x\n# It \"suspends judgement\" for fkey relationships until are tables are set.\nSET FOREIGN_KEY_CHECKS = 0;\n\n-- ---------------------------------------------------------------------\n-- notification\n-- ---------------------------------------------------------------------\n\nDROP TABLE IF EXISTS `notification`;\n\nCREATE TABLE `notification`\n(\n `id` INTEGER NOT NULL AUTO_INCREMENT,\n `target_user_id` INTEGER NOT NULL,\n `notification_type_unique_name` VARCHAR(255) NOT NULL,\n `group_id` INTEGER,\n `date` DATETIME NOT NULL,\n `objects` TEXT,\n `is_new` TINYINT(1) DEFAULT 1 NOT NULL,\n PRIMARY KEY (`id`),\n INDEX `FK_NOTIFICATION_TARGET_USER` (`target_user_id`),\n INDEX `FK_NOTIFICATION_TYPENOTIFICATION` (`notification_type_unique_name`),\n CONSTRAINT `FK_NOTIFICATION_TYPENOTIFICATION0`\n FOREIGN KEY (`notification_type_unique_name`)\n REFERENCES `notification_type` (`unique_name`)\n) ENGINE=InnoDb;\n\n-- ---------------------------------------------------------------------\n-- notification_type\n-- ---------------------------------------------------------------------\n\nDROP TABLE IF EXISTS `notification_type`;\n\nCREATE TABLE `notification_type`\n(\n `module_unique_name` VARCHAR(255) NOT NULL,\n `unique_name` VARCHAR(255) NOT NULL,\n `is_correction` TINYINT(1) DEFAULT 0 NOT NULL,\n `disabled_engine` VARCHAR(255),\n PRIMARY KEY (`module_unique_name`,`unique_name`),\n INDEX `FK_TYPENOTIFICATION_MODULE` (`module_unique_name`),\n INDEX `I_referenced_FK_NOTIFICATION_TYPENOTIFICATION0_1` (`unique_name`),\n CONSTRAINT `FK_TYPENOTIFICATION_MODULE0`\n FOREIGN KEY (`module_unique_name`)\n REFERENCES `module` (`unique_name`)\n ON UPDATE CASCADE\n ON DELETE CASCADE\n) ENGINE=InnoDb;\n\n-- ---------------------------------------------------------------------\n-- module\n-- ---------------------------------------------------------------------\n\nDROP TABLE IF EXISTS `module`;\n\nCREATE TABLE `module`\n(\n `id` INTEGER NOT NULL AUTO_INCREMENT,\n `unique_name` VARCHAR(255) NOT NULL,\n `label` VARCHAR(255) NOT NULL,\n `description` VARCHAR(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDb;\n\n# This restores the fkey checks, after having unset them earlier\nSET FOREIGN_KEY_CHECKS = 1;\n";
$platform = new MysqlPlatform();
$platform->setDefaultTableEngine('InnoDb');
$updatedBuilder = new PropelQuickBuilder();
$updatedBuilder->setPlatform($platform);
$updatedBuilder->setSchema($updatedSchema);
$sql = $updatedBuilder->getSQL();
$this->assertEquals($actual, $sql);
}
/**
* Drop the foreign key in the `_user` table and check whether it generates
* the correct `DROP` SQL.
*/
private function dropForeignKey()
{
$this->readDatabase();
$updatedSchema = '
<database name="reverse-bookstore">
<table name="issue617_user">
<vendor type="mysql">
<parameter name="Engine" value="InnoDB"/>
<parameter name="Charset" value="utf8"/>
</vendor>
<column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" />
<column name="full_name" type="VARCHAR" size="50" required="true" />
</table>
<table name="issue617_group">
<vendor type="mysql">
<parameter name="Engine" value="InnoDB"/>
<parameter name="Charset" value="utf8"/>
</vendor>
<column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" />
<column name="name" type="VARCHAR" size="50" required="true" />
</table>
</database>
';
$this->updatedBuilder = new QuickBuilder();
$this->updatedBuilder->setPlatform($this->database->getPlatform());
$this->updatedBuilder->setSchema($updatedSchema);
$diff = DatabaseComparator::computeDiff($this->database, $this->updatedBuilder->getDatabase());
$sql = $this->database->getPlatform()->getModifyDatabaseDDL($diff);
$expected = '
ALTER TABLE `issue617_user` DROP FOREIGN KEY `issue617_user_fk_5936b3`;
DROP INDEX `issue617_user_fi_5936b3` ON `issue617_user`;
ALTER TABLE `issue617_user`
DROP `group_id`;
';
$this->assertContains($expected, $sql);
$this->updateSchema($this->updatedBuilder->getDatabase());
}
public function testGeneratedSqlForMySQL()
{
$schema = <<<XML
<database name="default">
<table name="thread">
<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" />
</table>
<table name="post">
<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" />
<column name="body" type="VARCHAR" required="true" primaryString="true" />
<foreign-key foreignTable="thread" onDelete="cascade">
<reference local="thread_id" foreign="id" />
</foreign-key>
<behavior name="nested_set">
<parameter name="use_scope" value="true" />
<parameter name="scope_column" value="thread_id" />
</behavior>
<vendor type="mysql">
<parameter name="Engine" value="InnoDB"/>
</vendor>
</table>
</database>
XML;
$expectedSql = <<<SQL
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;
-- ---------------------------------------------------------------------
-- thread
-- ---------------------------------------------------------------------
DROP TABLE IF EXISTS `thread`;
CREATE TABLE `thread`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
-- ---------------------------------------------------------------------
-- post
-- ---------------------------------------------------------------------
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`body` VARCHAR(255) NOT NULL,
`tree_left` INTEGER,
`tree_right` INTEGER,
`tree_level` INTEGER,
`thread_id` INTEGER,
PRIMARY KEY (`id`),
INDEX `post_FI_1` (`thread_id`),
CONSTRAINT `post_FK_1`
FOREIGN KEY (`thread_id`)
REFERENCES `thread` (`id`)
ON DELETE CASCADE
) ENGINE=InnoDB;
# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
SQL;
$builder = new PropelQuickBuilder();
$builder->setPlatform(new MysqlPlatform());
$builder->setSchema($schema);
$this->assertEquals($expectedSql, $builder->getSQL());
}
