Changeset 4584
- Timestamp:
- 06/28/08 08:04:49 (12 months ago)
- Files:
-
- 1 modified
-
branches/0.11/tests/Ticket/950TestCase.php (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/0.11/tests/Ticket/950TestCase.php
r4309 r4584 42 42 { 43 43 $sql = $this->conn->export->exportClassesSql(array('Ticket_950_AdresseRecord','Ticket_950_CountryRecord')); 44 $this->assertEqual(count($sql), 3);44 $this->assertEqual(count($sql), 4); 45 45 $this->assertEqual($sql[0], 'CREATE TABLE country_record (id BIGINT NOT NULL AUTO_INCREMENT, iso VARCHAR(2) NOT NULL, name VARCHAR(80), printable_name VARCHAR(80), iso3 VARCHAR(3), numcode BIGINT, INDEX iso_idx (iso), PRIMARY KEY(id)) ENGINE = INNODB'); 46 46 $this->assertEqual($sql[1], 'CREATE TABLE adresse_record (id BIGINT NOT NULL AUTO_INCREMENT, adresse VARCHAR(255), cp VARCHAR(60), ville VARCHAR(255), pays VARCHAR(2), INDEX pays_idx (pays), PRIMARY KEY(id)) ENGINE = INNODB'); 47 $this->assertEqual($sql[2], 'ALTER TABLE adresse_record ADD FOREIGN KEY (pays) REFERENCES country_record(iso)'); 47 $this->assertEqual($sql[2], 'ALTER TABLE country_record ADD FOREIGN KEY (iso) REFERENCES adresse_record(pays)'); 48 $this->assertEqual($sql[3], 'ALTER TABLE adresse_record ADD FOREIGN KEY (pays) REFERENCES country_record(iso)'); 48 49 } 49 50 } … … 51 52 class Ticket_950_AdresseRecord extends Doctrine_Record 52 53 { 53 54 54 public function setTableDefinition() 55 55 { … … 62 62 $this->hasColumn('cp', 'string', 60); 63 63 $this->hasColumn('ville', 'string', 255); 64 $this->hasColumn('pays', 'string', 2 );64 $this->hasColumn('pays', 'string', 2); 65 65 } 66 66 … … 69 69 $this->hasOne('Ticket_950_CountryRecord as Country', array('local' => 'pays', 'foreign' => 'iso')); 70 70 } 71 72 71 } 73 72 … … 88 87 $this->hasColumn('numcode', 'integer', 10); 89 88 } 89 90 public function setUp() 91 { 92 $this->hasOne('Ticket_950_AdresseRecord as Address', array('local' => 'iso', 'foreign' => 'pays')); 93 } 90 94 }