public function setUp() { $this->c1 = new FooColumnValue2(); $this->c1->bar = 1234; $this->c2 = new FooColumnValue2(); $this->c2->bar = 5678; if (!class_exists('ComplexColumnTypeEntity10')) { $schema = <<<EOF <database name="generated_query_complex_type_test_10"> \t<table name="complex_column_type_entity_10"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="OBJECT" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $e0 = new ComplexColumnTypeEntity10(); $e0->save(); $e1 = new ComplexColumnTypeEntity10(); $e1->setBar($this->c1); $e1->save(); $e2 = new ComplexColumnTypeEntity10(); $e2->setBar($this->c2); $e2->save(); ComplexColumnTypeEntity10Peer::clearInstancePool(); } }
public function setUp() { if (!class_exists('ArchivableConcretePagePeer')) { $schema = <<<EOF <database name="archivable_concrete_behavior_test_0"> <table name="parent_archivable_concrete_page"> <column name="id" type="integer" primaryKey="true" autoIncrement="true"/> <column name="content" type="longvarchar" required="true" /> <behavior name="archivable" /> </table> <table name="archivable_concrete_page"> <column name="paragraph" type="integer" required="true" /> <behavior name="concrete_inheritance"> <parameter name="extends" value="parent_archivable_concrete_page" /> </behavior> <behavior name="archivable" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } ArchivableConcretePagePeer::doDeleteAll(); ArchivableConcretePageArchivePeer::doDeleteAll(); }
public function setUp() { parent::setUp(); if (!class_exists('ConcreteContentSetPkQuery')) { $schema = <<<EOF <database name="concrete_content_set_pk"> <table name="concrete_content_set_pk" allowPkInsert="true"> <column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> <column name="title" type="VARCHAR" size="100" primaryString="true" /> <index> <index-column name="title" /> </index> </table> <table name="concrete_article_set_pk" allowPkInsert="true"> <column name="body" type="longvarchar" /> <column name="author_id" required="false" type="INTEGER" /> <behavior name="concrete_inheritance"> <parameter name="extends" value="concrete_content_set_pk" /> </behavior> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function testObjectColumnType() { $schema = <<<EOF <database name="generated_object_complex_type_test_1"> \t<table name="complex_column_type_entity_1"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="OBJECT" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $e = new ComplexColumnTypeEntity1(); $this->assertNull($e->getBar(), 'object columns are null by default'); $c = new FooColumnValue(); $c->bar = 1234; $e->setBar($c); $this->assertEquals($c, $e->getBar(), 'object columns can store objects'); $e->setBar(null); $this->assertNull($e->getBar(), 'object columns are nullable'); $e->setBar($c); $e->save(); ComplexColumnTypeEntity1Peer::clearInstancePool(); $e = ComplexColumnTypeEntity1Query::create()->findOne(); $this->assertEquals($c, $e->getBar(), 'object columns are persisted'); }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity11')) { $schema = <<<EOF <database name="generated_object_complex_type_test_11"> <table name="complex_column_type_entity_11"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="tags" type="ARRAY" /> <column name="value_set" type="ARRAY" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $e0 = new ComplexColumnTypeEntity11(); $e0->save(); $e1 = new ComplexColumnTypeEntity11(); $e1->setTags(array('foo', 'bar', 'baz')); $e1->save(); $e2 = new ComplexColumnTypeEntity11(); $e2->setTags(array('bar')); $e2->save(); $e3 = new ComplexColumnTypeEntity11(); $e3->setTags(array('bar23')); $e3->save(); } }
public function setUp() { if (!class_exists('I18nBehaviorTest11')) { $schema = <<<EOF <database name="i18n_behavior_test_10"> \t<table name="i18n_behavior_test_11"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="INTEGER" /> \t\t<column name="bar" type="VARCHAR" size="100" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="bar" /> \t\t</behavior> \t</table> \t<table name="i18n_behavior_test_12"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="INTEGER" /> \t\t<column name="bar1" type="VARCHAR" size="100" /> \t\t<column name="bar2" type="LONGVARCHAR" lazyLoad="true" /> \t\t<column name="bar3" type="TIMESTAMP" /> \t\t<column name="bar4" type="LONGVARCHAR" description="This is the Bar4 column" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="bar1,bar2,bar3,bar4" /> \t\t\t<parameter name="default_locale" value="fr_FR" /> \t\t\t<parameter name="locale_alias" value="culture" /> \t\t</behavior> \t</table> </database> EOF; //PropelQuickBuilder::debugClassesForTable($schema, 'i18n_behavior_test_11'); PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ArchivableTest10')) { $schema = <<<EOF <database name="archivable_behavior_test_10"> \t<table name="archivable_test_10"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t\t<column name="age" type="INTEGER" /> \t\t<column name="foo_id" type="INTEGER" /> \t\t<foreign-key foreignTable="archivable_test_20"> \t\t\t<reference local="foo_id" foreign="id" /> \t\t</foreign-key> \t\t<index> \t\t\t<index-column name="title" /> \t\t\t<index-column name="age" /> \t\t</index> \t\t<behavior name="archivable" /> \t</table> \t<table name="archivable_test_20"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t\t<behavior name="archivable" /> \t</table> \t<table name="archivable_test_20_archive"> \t\t<column name="id" required="true" primaryKey="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t</table> \t<table name="archivable_test_30"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t\t<column name="age" type="INTEGER" /> \t\t<column name="foo_id" type="INTEGER" /> \t\t<behavior name="archivable"> \t\t\t<parameter name="log_archived_at" value="false" /> \t\t\t<parameter name="archive_table" value="my_old_archivable_test_30" /> \t\t\t<parameter name="archive_on_insert" value="true" /> \t\t\t<parameter name="archive_on_update" value="true" /> \t\t\t<parameter name="archive_on_delete" value="false" /> \t\t</behavior> \t</table> \t<table name="archivable_test_40"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t\t<column name="age" type="INTEGER" /> \t\t<behavior name="archivable"> \t\t\t<parameter name="archive_class" value="FooArchive" /> \t\t</behavior> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('I18nBehaviorTest1')) { $schema = <<<EOF <database name="i18n_behavior_test_1"> \t<table name="i18n_behavior_test_1"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="INTEGER" /> \t\t<column name="bar" type="VARCHAR" size="100" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="bar" /> \t\t</behavior> \t</table> \t<table name="i18n_behavior_test_2"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="INTEGER" /> \t\t<column name="bar1" type="VARCHAR" size="100" /> \t\t<column name="bar2" type="LONGVARCHAR" lazyLoad="true" /> \t\t<column name="bar3" type="TIMESTAMP" /> \t\t<column name="bar4" type="LONGVARCHAR" description="This is the Bar4 column" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="bar1,bar2,bar3,bar4" /> \t\t\t<parameter name="default_locale" value="fr_FR" /> \t\t\t<parameter name="locale_alias" value="culture" /> \t\t</behavior> \t</table> \t<table name="movie"> \t\t<column name="id" type="integer" required="true" primaryKey="true" autoincrement="true" /> \t\t<column name="director" type="varchar" size="255" /> \t\t<column name="title" type="varchar" primaryString="true" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="title" /> \t\t\t<parameter name="locale_alias" value="culture" /> \t\t</behavior> \t</table> \t<table name="toy"> \t\t<column name="id" type="integer" required="true" primaryKey="true" autoincrement="true" /> \t\t<column name="ref" type="varchar" size="255" /> \t\t<column name="name" type="varchar" size="255" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="name" /> \t\t\t<parameter name="locale_alias" value="culture" /> \t\t</behavior> \t\t<column name="movie_id" type="integer" /> \t\t<foreign-key foreignTable="movie"> \t\t\t<reference local="movie_id" foreign="id" /> \t\t</foreign-key> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity103Peer')) { $schema = <<<EOF <database name="generated_object_complex_type_test_103"> <table name="complex_column_type_entity_103"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar" type="ENUM" valueSet="foo, bar, baz, 1, 4,(, foo bar " /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity1')) { $schema = <<<EOF <database name="generated_object_complex_type_test_1"> \t<table name="complex_column_type_entity_1"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="OBJECT" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('VersionableBehaviorTest10')) { $schema = <<<EOF <database name="versionable_behavior_test_10"> \t<table name="versionable_behavior_test_10"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable" /> \t</table> </database>> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity2')) { $schema = <<<EOF <database name="generated_object_complex_type_test_2"> <table name="complex_column_type_entity_2"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="tags" type="ARRAY" /> <column name="value_set" type="ARRAY" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('MyAuditableTable')) { $schema = <<<EOF <database name="auditable_behavior_test_applied_on_table"> <table name="my_auditable_table"> <column name="id" type="INTEGER" primaryKey="true" autoincrement="true" /> <column name="name" type="VARCHAR" size="255" /> <behavior name="auditable" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity5')) { $schema = <<<EOF <database name="generated_object_complex_type_test_5"> <table name="complex_column_type_entity_5"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar1" type="DATE" /> <column name="bar2" type="TIME" /> <column name="bar3" type="TIMESTAMP" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('LazyLoadActiveRecord2')) { $schema = <<<EOF <database name="lazy_load_active_record_2"> \t<table name="lazy_load_active_record_2"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="VARCHAR" size="100" /> \t\t<column name="bar" type="VARCHAR" size="100" lazyLoad="true" /> \t\t<column name="baz" type="VARCHAR" size="100" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity4')) { $schema = <<<EOF <database name="generated_object_complex_type_test_4"> <table name="complex_column_type_entity_4"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar" type="BOOLEAN" /> <column name="true_bar" type="BOOLEAN" defaultValue="true" /> <column name="false_bar" type="BOOLEAN" defaultValue="false" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('LazyLoadActiveRecord')) { $schema = <<<EOF <database name="lazy_load_active_record_1"> <table name="lazy_load_active_record"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="foo" type="VARCHAR" size="100" /> <column name="bar" type="VARCHAR" size="100" lazyLoad="true" /> <column name="baz" type="VARCHAR" size="100" defaultValue="world" lazyLoad="true" /> </table> </database> EOF; //PropelQuickBuilder::debugClassesForTable($schema, 'lazy_load_active_record'); PropelQuickBuilder::buildSchema($schema); } }
public function testFieldKeys() { $schema = <<<EOF <database name="i18n_behavior_test_0"> \t<table name="i18n_behavior_test_03"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo1" type="VARCHAR" /> \t\t<column name="foo2" type="VARCHAR" /> \t\t<column name="foo3" type="VARCHAR" /> \t\t<behavior name="i18n"> \t\t\t<parameter name="i18n_columns" value="foo2" /> \t\t</behavior> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $this->assertEquals(array(0, 1, 2), I18nBehaviorTest03Peer::getFieldNames(BasePeer::TYPE_NUM)); }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity3')) { $schema = <<<EOF <database name="generated_object_complex_type_test_3"> <table name="complex_column_type_entity_3"> <column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> <column name="bar" type="ENUM" valueSet="foo, bar, baz, 1, 4,(, foo bar " /> <column name="bar2" type="ENUM" valueSet="foo, bar" defaultValue="bar" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); // ok this is hackish but it makes testing of getter and setter independent of each other $publicAccessorCode = <<<EOF class PublicComplexColumnTypeEntity3 extends ComplexColumnTypeEntity3 { public \$bar; } EOF; eval($publicAccessorCode); } }
public function setUp() { if (!class_exists('ComplexColumnTypeEntity13')) { $schema = <<<EOF <database name="generated_object_complex_type_test_13"> \t<table name="complex_column_type_entity_13"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="ENUM" valueSet="foo, bar, baz, 1, 4,(, foo bar " /> \t\t<column name="bar2" type="ENUM" valueSet="foo, bar" defaultValue="bar" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $e0 = new ComplexColumnTypeEntity13(); $e0->save(); $e1 = new ComplexColumnTypeEntity13(); $e1->setBar('baz'); $e1->save(); $e2 = new ComplexColumnTypeEntity13(); $e2->setBar('4'); $e2->save(); ComplexColumnTypeEntity13Peer::clearInstancePool(); } }
public function setUp() { if (!class_exists('VersionableBehaviorTest1')) { $schema = <<<EOF <database name="versionable_behavior_test_1"> \t<table name="versionable_behavior_test_1"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable" /> \t</table> \t<table name="versionable_behavior_test_2"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="version_column" value="foo_ver" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_3"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="version_table" value="foo_ver" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_4"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="log_created_at" value="true" /> \t\t\t<parameter name="log_created_by" value="true" /> \t\t\t<parameter name="log_comment" value="true" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_5"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="VARCHAR" size="100" /> \t\t<column name="foreign_id" type="INTEGER" /> \t\t<foreign-key foreignTable="versionable_behavior_test_4"> \t\t\t<reference local="foreign_id" foreign="id" /> \t\t</foreign-key> \t\t<behavior name="versionable" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } if (!class_exists('VersionableBehaviorTest6')) { $schema2 = <<<EOF <database name="versionable_behavior_test_2" defaultPhpNamingMethod="nochange"> \t<table name="VersionableBehaviorTest6"> \t\t<column name="Id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="FooBar" type="VARCHAR" size="100" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="log_created_at" value="true" /> \t\t\t<parameter name="log_created_by" value="true" /> \t\t\t<parameter name="log_comment" value="true" /> \t\t</behavior> \t</table> \t \t<table name="VersionableBehaviorTest7"> \t\t<column name="Id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="FooBar" type="VARCHAR" size="100" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="log_created_at" value="true" /> \t\t\t<parameter name="log_created_by" value="true" /> \t\t\t<parameter name="log_comment" value="true" /> \t\t\t \t\t\t<parameter name="version_created_by_column" value="VersionCreatedBy" /> \t\t\t<parameter name="version_created_at_column" value="VersionCreatedAt" /> \t\t\t<parameter name="version_comment_column" value="MyComment" /> \t\t</behavior> \t</table> EOF; PropelQuickBuilder::buildSchema($schema2); } }
public function testTablePrefixSameDatabase() { $schema = <<<EOF <database name="testTablePrefixSameDatabase_database" tablePrefix="foo"> <table name="testTablePrefixSameDatabase_main"> <column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> <column name="title" type="VARCHAR" size="100" primaryString="true" /> <column name="delegate_id" type="INTEGER" /> <foreign-key foreignTable="testTablePrefixSameDatabase_delegate"> <reference local="delegate_id" foreign="id" /> </foreign-key> <behavior name="delegate"> <parameter name="to" value="testTablePrefixSameDatabase_delegate" /> </behavior> </table> <table name="testTablePrefixSameDatabase_delegate"> <column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> <column name="subtitle" type="VARCHAR" size="100" primaryString="true" /> </table> </database> EOF; PropelQuickBuilder::buildSchema($schema); $main = new TestTablePrefixSameDatabaseMain(); $main->setSubtitle('bar'); $delegate = $main->getTestTablePrefixSameDatabaseDelegate(); $this->assertInstanceOf('TestTablePrefixSameDatabaseDelegate', $delegate); $this->assertTrue($delegate->isNew()); $this->assertEquals('bar', $delegate->getSubtitle()); $this->assertEquals('bar', $main->getSubtitle()); }
public function setUp() { if (!class_exists('DelegateDelegate')) { $schema = <<<EOF <database name="delegate_behavior_test_1"> \t<table name="delegate_main"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="title" type="VARCHAR" size="100" primaryString="true" /> \t\t<column name="delegate_id" type="INTEGER" /> \t\t<foreign-key foreignTable="second_delegate_delegate"> \t\t\t<reference local="delegate_id" foreign="id" /> \t\t</foreign-key> \t\t<behavior name="delegate"> \t\t\t<parameter name="to" value="delegate_delegate, second_delegate_delegate" /> \t\t</behavior> \t</table> \t<table name="delegate_delegate"> \t\t<column name="subtitle" type="VARCHAR" size="100" primaryString="true" /> \t</table> \t<table name="second_delegate_delegate"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="summary" type="VARCHAR" size="100" primaryString="true" /> \t\t<behavior name="delegate"> \t\t\t<parameter name="to" value="third_delegate_delegate" /> \t\t</behavior> \t</table> \t<table name="third_delegate_delegate"> \t\t<column name="body" type="VARCHAR" size="100" primaryString="true" /> \t</table> \t<table name="delegate_player"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="first_name" type="VARCHAR" size="100" primaryString="true" /> \t\t<column name="last_name" type="VARCHAR" size="100" primaryString="true" /> \t</table> \t<table name="delegate_basketballer"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="points" type="INTEGER" /> \t\t<column name="field_goals" type="INTEGER" /> \t\t<column name="player_id" type="INTEGER" /> \t\t<foreign-key foreignTable="delegate_player"> \t\t\t<reference local="player_id" foreign="id" /> \t\t</foreign-key> \t\t<behavior name="delegate"> \t\t\t<parameter name="to" value="delegate_player" /> \t\t</behavior> \t</table> \t<table name="delegate_team"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="name" type="VARCHAR" size="100" primaryString="true" /> \t</table> \t<table name="delegate_footballer"> \t\t<column name="id" required="true" primaryKey="true" autoIncrement="true" type="INTEGER" /> \t\t<column name="goals_scored" type="INTEGER" /> \t\t<column name="fouls_committed" type="INTEGER" /> \t\t<column name="player_id" type="INTEGER" /> \t\t<foreign-key foreignTable="delegate_player"> \t\t\t<reference local="player_id" foreign="id" /> \t\t</foreign-key> \t\t<column name="team_id" type="INTEGER" /> \t\t<foreign-key foreignTable="delegate_team"> \t\t\t<reference local="team_id" foreign="id" /> \t\t</foreign-key> \t\t<behavior name="delegate"> \t\t\t<parameter name="to" value="delegate_player, delegate_team" /> \t\t</behavior> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } }
public function setUp() { if (!class_exists('VersionableBehaviorTest1')) { $schema = <<<EOF <database name="versionable_behavior_test_1"> \t<table name="versionable_behavior_test_1"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable" /> \t</table> \t<table name="versionable_behavior_test_2"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="version_column" value="foo_ver" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_3"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="version_table" value="foo_ver" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_4"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="bar" type="INTEGER" /> \t\t<behavior name="versionable"> \t\t\t<parameter name="log_created_at" value="true" /> \t\t\t<parameter name="log_created_by" value="true" /> \t\t\t<parameter name="log_comment" value="true" /> \t\t</behavior> \t</table> \t<table name="versionable_behavior_test_5"> \t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t<column name="foo" type="VARCHAR" size="100" /> \t\t<column name="foreign_id" type="INTEGER" /> \t\t<foreign-key foreignTable="versionable_behavior_test_4"> \t\t\t<reference local="foreign_id" foreign="id" /> \t\t</foreign-key> \t\t<behavior name="versionable" /> \t</table> </database> EOF; PropelQuickBuilder::buildSchema($schema); } if (!class_exists('VersionableBehaviorTest6')) { $schema2 = <<<EOF \t\t<database name="versionable_behavior_test_2" defaultPhpNamingMethod="nochange"> \t\t\t<table name="VersionableBehaviorTest6"> \t\t\t\t<column name="Id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="FooBar" type="VARCHAR" size="100" /> \t\t\t\t<behavior name="versionable"> \t\t\t\t\t<parameter name="log_created_at" value="true" /> \t\t\t\t\t<parameter name="log_created_by" value="true" /> \t\t\t\t\t<parameter name="log_comment" value="true" /> \t\t\t\t</behavior> \t\t\t</table> \t\t\t<table name="VersionableBehaviorTest7"> \t\t\t\t<column name="Id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="FooBar" type="VARCHAR" size="100" /> \t\t\t\t<column name="Style" type="ENUM" valueSet="novel, essay, poetry" /> \t\t\t\t<behavior name="versionable"> \t\t\t\t\t<parameter name="log_created_at" value="true" /> \t\t\t\t\t<parameter name="log_created_by" value="true" /> \t\t\t\t\t<parameter name="log_comment" value="true" /> \t\t\t\t\t<parameter name="version_created_by_column" value="VersionCreatedBy" /> \t\t\t\t\t<parameter name="version_created_at_column" value="VersionCreatedAt" /> \t\t\t\t\t<parameter name="version_comment_column" value="MyComment" /> \t\t\t\t</behavior> \t\t\t</table> EOF; PropelQuickBuilder::buildSchema($schema2); } if (!class_exists('VersionableBehaviorTest8')) { $schema3 = <<<EOF \t\t<database name="versionable_behavior_test_3"> \t\t\t<table name="VersionableBehaviorTest8"> \t\t\t\t<column name="alter_id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="FooBar" type="VARCHAR" size="100" /> \t\t\t\t<column name="class_key" type="INTEGER" required="true" default="1" inheritance="single"> \t\t\t\t\t<inheritance key="1" class="VersionableBehaviorTest8" /> \t\t\t\t\t<inheritance key="2" class="VersionableBehaviorTest8Foo" extends="VersionableBehaviorTest8" /> \t\t\t\t\t<inheritance key="3" class="VersionableBehaviorTest8Bar" extends="VersionableBehaviorTest8Foo" /> \t\t\t\t</column> \t\t\t\t<behavior name="versionable" /> \t\t\t</table> \t\t\t<table name="VersionableBehaviorTest9"> \t\t\t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="foo" type="VARCHAR" size="100" /> \t\t\t\t<column name="foreign_id" type="INTEGER" /> \t\t\t\t<foreign-key foreignTable="VersionableBehaviorTest8"> \t\t\t\t\t<reference local="foreign_id" foreign="alter_id" /> \t\t\t\t</foreign-key> \t\t\t\t<behavior name="versionable" /> \t\t\t</table> EOF; PropelQuickBuilder::buildSchema($schema3); } if (!class_exists('VersionableBehaviorTest10')) { $schema4 = <<<EOF \t\t<database name="versionable_behavior_test_4"> \t\t\t<table name="VersionableBehaviorTest10"> \t\t\t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="bar" type="INTEGER" /> \t\t\t\t<behavior name="versionable" /> \t\t\t</table> \t\t\t<table name="VersionableBehaviorTest11"> \t\t\t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="foo" type="VARCHAR" size="100" /> \t\t\t</table> \t\t\t<table name="VersionableBehaviorTest12"> \t\t\t\t<column name="id" primaryKey="true" type="INTEGER" autoIncrement="true" /> \t\t\t\t<column name="bar_id" type="INTEGER" /> \t\t\t\t<column name="foo_id" type="INTEGER" /> \t\t\t\t<column name="baz" type="VARCHAR" size="25" /> \t\t\t\t<behavior name="versionable" /> \t\t\t\t<foreign-key foreignTable="VersionableBehaviorTest10"> \t\t\t\t\t<reference local="bar_id" foreign="id" /> \t\t\t\t</foreign-key> \t\t\t\t<foreign-key foreignTable="VersionableBehaviorTest11"> \t\t\t\t\t<reference local="foo_id" foreign="id" /> \t\t\t\t</foreign-key> \t\t\t</table> \t\t</database> EOF; PropelQuickBuilder::buildSchema($schema4); } }