Changeset 3701 for trunk/tests/Ticket
- Timestamp:
- 02/03/08 21:29:57 (11 months ago)
- Location:
- trunk/tests/Ticket
- Files:
-
- 12 modified
-
428TestCase.php (modified) (2 diffs)
-
438TestCase.php (modified) (3 diffs)
-
480TestCase.php (modified) (1 diff)
-
626BTestCase.php (modified) (4 diffs)
-
626CTestCase.php (modified) (2 diffs)
-
626DTestCase.php (modified) (1 diff)
-
638TestCase.php (modified) (2 diffs)
-
642TestCase.php (modified) (1 diff)
-
673TestCase.php (modified) (1 diff)
-
697TestCase.php (modified) (3 diffs)
-
741TestCase.php (modified) (5 diffs)
-
NjeroTestCase.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tests/Ticket/428TestCase.php
r2401 r3701 14 14 class Doctrine_Ticket_428_TestCase extends Doctrine_UnitTestCase 15 15 { 16 public function prepareTables() 17 { 18 $this->tables = array('Album', 'Song'); 19 parent::prepareTables(); 20 } 21 16 22 public function prepareData() 17 23 { … … 39 45 $q->select('a.name, COUNT(s.id) count')->from('Album a')->leftJoin('a.Song s')->groupby('a.id'); 40 46 $albums = $q->execute(); 41 47 42 48 // Should not reuse the existing collection in this case 43 49 $this->assertEqual(count($albums[0]->Song), 1); -
trunk/tests/Ticket/438TestCase.php
r3293 r3701 110 110 class T438_Student extends Doctrine_Record 111 111 { 112 public function setTableDefinition()112 public static function initMetadata($class) 113 113 { 114 $this->setTableName('t438_student_record'); 115 116 $this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 117 $this->hasColumn('s_name as name', 'varchar', 50, array ()); 118 } 119 120 public function setUp() 121 { 122 $this->hasMany('T438_Course as StudyCourses', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_student_id', 'foreign' => 'sc_course_id')); 114 $class->setTableName('t438_student_record'); 115 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 116 $class->setColumn('s_name as name', 'varchar', 50, array ()); 117 $class->hasMany('T438_Course as StudyCourses', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_student_id', 'foreign' => 'sc_course_id')); 123 118 } 124 119 } … … 127 122 class T438_Course extends Doctrine_Record 128 123 { 129 public function setTableDefinition()124 public static function initMetadata($class) 130 125 { 131 $this->setTableName('t438_course'); 132 133 $this->hasColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 134 $this->hasColumn('c_name as name', 'varchar', 50, array ()); 135 } 136 137 public function setUp() 138 { 139 $this->hasMany('T438_Student as Students', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_course_id', 'foreign' => 'sc_student_id')); 126 $class->setTableName('t438_course'); 127 $class->setColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 128 $class->setColumn('c_name as name', 'varchar', 50, array ()); 129 $class->hasMany('T438_Student as Students', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_course_id', 'foreign' => 'sc_student_id')); 140 130 } 141 131 } … … 143 133 class T438_StudentCourse extends Doctrine_Record 144 134 { 145 public function setTableDefinition()135 public static function initMetadata($class) 146 136 { 147 $this->setTableName('t438_student_course'); 148 149 $this->hasColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 150 $this->hasColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 151 $this->hasColumn('sc_remark as remark', 'varchar', 500, array ()); 152 } 153 154 public function setUp() 155 { 156 $this->hasOne('T438_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 157 $this->hasOne('T438_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 137 $class->setTableName('t438_student_course'); 138 $class->setColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 139 $class->setColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 140 $class->setColumn('sc_remark as remark', 'varchar', 500, array ()); 141 $class->hasOne('T438_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 142 $class->hasOne('T438_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 158 143 } 159 144 } -
trunk/tests/Ticket/480TestCase.php
r3565 r3701 34 34 class stComment extends Doctrine_Record 35 35 { 36 public function setTableDefinition()36 public static function initMetadata($class) 37 37 { 38 $ this->setTableName('st_comment');39 $ this->hasColumn('title', 'string', 100, array());40 $ this->hasColumn('body', 'string', 1000, array());38 $class->setTableName('st_comment'); 39 $class->setColumn('title', 'string', 100, array()); 40 $class->setColumn('body', 'string', 1000, array()); 41 41 } 42 42 } -
trunk/tests/Ticket/626BTestCase.php
r3291 r3701 91 91 class T626B_Student extends Doctrine_Record 92 92 { 93 public function setTableDefinition()93 public static function initMetadata($class) 94 94 { 95 $ this->setTableName('T626B_Student_record');95 $class->setTableName('T626B_Student_record'); 96 96 97 $this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 98 $this->hasColumn('s_g_id as group_id', 'varchar', 30, array ('notnull'=>true)); 99 $this->hasColumn('s_name as name', 'varchar', 50, array ()); 100 } 101 102 public function setUp() 103 { 104 $this->hasMany('T626_Course as StudyCourses', array('refClass' => 'T626B_StudentCourse', 'local' => 'sc_student_id', 'foreign' => 'sc_course_id')); 105 $this->hasOne('T626_Group as Group', array('local' => 's_g_id', 'foreign' => 'g_id')); 97 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 98 $class->setColumn('s_g_id as group_id', 'varchar', 30, array ('notnull'=>true)); 99 $class->setColumn('s_name as name', 'varchar', 50, array ()); 100 101 $class->hasMany('T626_Course as StudyCourses', array('refClass' => 'T626B_StudentCourse', 'local' => 'sc_student_id', 'foreign' => 'sc_course_id')); 102 $class->hasOne('T626_Group as Group', array('local' => 's_g_id', 'foreign' => 'g_id')); 106 103 } 107 104 } … … 109 106 class T626_Group extends Doctrine_Record 110 107 { 111 public function setTableDefinition()108 public static function initMetadata($class) 112 109 { 113 $ this->setTableName('T626B_Student_group');110 $class->setTableName('T626B_Student_group'); 114 111 115 $this->hasColumn('g_id as id', 'varchar', 30, array ( 'primary' => true,)); 116 $this->hasColumn('g_name as name', 'varchar', 50, array ()); 117 } 118 119 public function setUp() 120 { 121 $this->hasMany('T626B_Student as Students', 122 array('local' => 'g_id', 'foreign' => 's_id')); 112 $class->setColumn('g_id as id', 'varchar', 30, array ( 'primary' => true,)); 113 $class->setColumn('g_name as name', 'varchar', 50, array ()); 114 115 $class->hasMany('T626B_Student as Students', array('local' => 'g_id', 'foreign' => 's_id')); 123 116 } 124 117 } … … 127 120 class T626_Course extends Doctrine_Record 128 121 { 129 public function setTableDefinition()122 public static function initMetadata($class) 130 123 { 131 $ this->setTableName('T626_course');124 $class->setTableName('T626_course'); 132 125 133 $this->hasColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 134 $this->hasColumn('c_name as name', 'varchar', 50, array ()); 135 } 136 137 public function setUp() 138 { 139 $this->hasMany('T626B_Student as Students', array('refClass' => 'T626B_StudentCourse', 'local' => 'sc_course_id', 'foreign' => 'sc_student_id')); 126 $class->setColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 127 $class->setColumn('c_name as name', 'varchar', 50, array ()); 128 $class->hasMany('T626B_Student as Students', array('refClass' => 'T626B_StudentCourse', 'local' => 'sc_course_id', 'foreign' => 'sc_student_id')); 140 129 } 141 130 } … … 143 132 class T626B_StudentCourse extends Doctrine_Record 144 133 { 145 public function setTableDefinition()134 public static function initMetadata($class) 146 135 { 147 $ this->setTableName('T626B_Student_course');136 $class->setTableName('T626B_Student_course'); 148 137 149 $this->hasColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 150 $this->hasColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 151 $this->hasColumn('sc_remark as remark', 'varchar', 500, array ()); 152 } 153 154 public function setUp() 155 { 156 $this->hasOne('T626B_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 157 $this->hasOne('T626_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 138 $class->setColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 139 $class->setColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 140 $class->setColumn('sc_remark as remark', 'varchar', 500, array ()); 141 $class->hasOne('T626B_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 142 $class->hasOne('T626_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 158 143 } 159 144 } -
trunk/tests/Ticket/626CTestCase.php
r3311 r3701 65 65 class T626C_Student1 extends Doctrine_Record 66 66 { 67 public function setTableDefinition()67 public static function initMetadata($class) 68 68 { 69 $ this->setTableName('T626C_Student_record_1');69 $class->setTableName('T626C_Student_record_1'); 70 70 71 $ this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,));72 $ this->hasColumn('s_name as name', 'varchar', 50, array ());71 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 72 $class->setColumn('s_name as name', 'varchar', 50, array ()); 73 73 } 74 74 } … … 76 76 class T626C_Student2 extends Doctrine_Record 77 77 { 78 public function setTableDefinition()78 public static function initMetadata($class) 79 79 { 80 $ this->setTableName('T626C_Student_record_2');80 $class->setTableName('T626C_Student_record_2'); 81 81 82 $ this->hasColumn('id', 'varchar', 30, array ( 'primary' => true,));83 $ this->hasColumn('name', 'varchar', 50, array ());82 $class->setColumn('id', 'varchar', 30, array ( 'primary' => true,)); 83 $class->setColumn('name', 'varchar', 50, array ()); 84 84 } 85 85 } -
trunk/tests/Ticket/626DTestCase.php
r3460 r3701 49 49 class T626D_Student1 extends Doctrine_Record 50 50 { 51 public function setTableDefinition()51 public static function initMetadata($class) 52 52 { 53 $ this->setTableName('T626D_Student_record_1');53 $class->setTableName('T626D_Student_record_1'); 54 54 55 $ this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,));56 $ this->hasColumn('s_name as name', 'varchar', 50, array ());55 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 56 $class->setColumn('s_name as name', 'varchar', 50, array ()); 57 57 } 58 58 } -
trunk/tests/Ticket/638TestCase.php
r3460 r3701 108 108 class T638_Student extends Doctrine_Record 109 109 { 110 public function setTableDefinition()110 public static function initMetadata($class) 111 111 { 112 $ this->setTableName('T638_student');112 $class->setTableName('T638_student'); 113 113 114 $ this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,));115 $ this->hasColumn('s_g_id as group_id', 'varchar', 30, array ('notnull'=>true));116 $ this->hasColumn('s_name as name', 'varchar', 50, array ('notnull'=>true));114 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 115 $class->setColumn('s_g_id as group_id', 'varchar', 30, array ('notnull'=>true)); 116 $class->setColumn('s_name as name', 'varchar', 50, array ('notnull'=>true)); 117 117 } 118 118 119 public function setUp()120 {121 }122 119 } 123 120 124 121 class T638_Course extends Doctrine_Record 125 122 { 126 public function setTableDefinition()123 public static function initMetadata($class) 127 124 { 128 $ this->setTableName('T638_course');125 $class->setTableName('T638_course'); 129 126 130 $this->hasColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 131 $this->hasColumn('c_name as name', 'varchar', 50, array ('notnull'=>true)); 132 } 133 134 public function setUp() 135 { 127 $class->setColumn('c_id as id', 'varchar', 20, array ( 'primary' => true,)); 128 $class->setColumn('c_name as name', 'varchar', 50, array ('notnull'=>true)); 136 129 } 137 130 … … 144 137 class T638_StudentCourse extends Doctrine_Record 145 138 { 146 public function setTableDefinition()139 public static function initMetadata($class) 147 140 { 148 $ this->setTableName('T638_Student_course');141 $class->setTableName('T638_Student_course'); 149 142 150 $this->hasColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 151 $this->hasColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 152 $this->hasColumn('sc_remark as remark', 'varchar', 500, array ('notnull'=>true)); 153 } 154 155 public function setUp() 156 { 157 $this->hasOne('T638_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 158 $this->hasOne('T638_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 143 $class->setColumn('sc_student_id as student_id', 'varchar', 30, array ( 'primary' => true,)); 144 $class->setColumn('sc_course_id as course_id', 'varchar', 20, array ( 'primary' => true,)); 145 $class->setColumn('sc_remark as remark', 'varchar', 500, array ('notnull'=>true)); 146 147 $class->hasOne('T638_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id')); 148 $class->hasOne('T638_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id')); 159 149 } 160 150 } -
trunk/tests/Ticket/642TestCase.php
r3297 r3701 53 53 class stDummyObj extends Doctrine_Record 54 54 { 55 public function setTableDefinition()55 public static function initMetadata($class) 56 56 { 57 $ this->setTableName('st_dummy_obj');58 $ this->hasColumn('startDate', 'timestamp', null, array(57 $class->setTableName('st_dummy_obj'); 58 $class->setColumn('startDate', 'timestamp', null, array( 59 59 'notnull' => true, 60 60 'default' => '0000-00-00 00:00:00' -
trunk/tests/Ticket/673TestCase.php
r3393 r3701 61 61 class T673_Student extends Doctrine_Record 62 62 { 63 public function setTableDefinition()63 public static function initMetadata($class) 64 64 { 65 $ this->setTableName('T673_Student_record');65 $class->setTableName('T673_Student_record'); 66 66 67 $ this->hasColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,));68 $ this->hasColumn('s_foo as foo', 'integer', 4, array ('notnull'=>true));69 $ this->hasColumn('s_name as name', 'varchar', 50, array ());67 $class->setColumn('s_id as id', 'varchar', 30, array ( 'primary' => true,)); 68 $class->setColumn('s_foo as foo', 'integer', 4, array ('notnull'=>true)); 69 $class->setColumn('s_name as name', 'varchar', 50, array ()); 70 70 } 71 71 } -
trunk/tests/Ticket/697TestCase.php
r3460 r3701 23 23 24 24 public function testIdsAreSetWhenSavingSubclassInstancesInCTI() 25 { 26 $personTable = $this->conn->getTable('T697_Person'); 27 $userTable = $this->conn->getTable('T697_User'); 28 //var_dump($userTable->getColumns()); 29 25 { 30 26 $p = new T697_Person(); 31 27 $p['name']='Rodrigo'; … … 43 39 class T697_Person extends Doctrine_Record 44 40 { 45 public function setTableDefinition()41 public static function initMetadata($class) 46 42 { 47 $this->setInheritanceType(Doctrine::INHERITANCETYPE_JOINED, 48 array('T697_Person' => array('dtype' => 1), 'T697_User' => array('dtype' => 2))); 49 $this->setTableName('t697_person'); 50 $this->hasColumn('name', 'string', 30); 51 $this->hasColumn('dtype', 'integer', 4); 43 $class->setInheritanceType(Doctrine::INHERITANCETYPE_JOINED, array( 44 'discriminatorColumn' => 'dtype', 45 'discriminatorMap' => array( 46 1 => 'T697_Person', 2 => 'T697_User' 47 ) 48 )); 49 $class->setSubclasses(array('T697_User')); 50 $class->setTableName('t697_person'); 51 $class->setColumn('name', 'string', 30); 52 $class->setColumn('dtype', 'integer', 4); 52 53 } 53 54 } … … 55 56 //Class table inheritance 56 57 class T697_User extends T697_Person { 57 public function setTableDefinition()58 public static function initMetadata($class) 58 59 { 59 $ this->setTableName('t697_user');60 $ this->hasColumn('password', 'string', 30);60 $class->setTableName('t697_user'); 61 $class->setColumn('password', 'string', 30); 61 62 } 62 63 } -
trunk/tests/Ticket/741TestCase.php
r3576 r3701 32 32 class Parent741 extends Doctrine_Record 33 33 { 34 public function setTableDefinition()34 public static function initMetadata($class) 35 35 { 36 $ this->hasColumn('id', 'integer', 4, array (36 $class->setColumn('id', 'integer', 4, array ( 37 37 'primary' => true, 38 38 'autoincrement' => true, … … 40 40 )); 41 41 42 $this->hasColumn('amount', 'integer'); 43 } 44 45 public function setUp() 46 { 47 $this->hasMany('Child741 as Cows', array('local' => 'id', 'foreign' => 'moo_id')); 42 $class->setColumn('amount', 'integer'); 43 $class->hasMany('Child741 as Cows', array('local' => 'id', 'foreign' => 'moo_id')); 48 44 } 49 45 } … … 51 47 class Child741 extends Doctrine_Record 52 48 { 53 public function setTableDefinition()49 public static function initMetadata($class) 54 50 { 55 $ this->hasColumn('id', 'integer', 4, array (51 $class->setColumn('id', 'integer', 4, array ( 56 52 'primary' => true, 57 53 'autoincrement' => true, … … 59 55 )); 60 56 61 $this->hasColumn('moo_id', 'integer'); 62 } 63 64 public function setUp() 65 { 66 $this->hasOne('Parent741 as Moo', array('local' => 'moo_id', 'foreign' => 'id')); 57 $class->setColumn('moo_id', 'integer'); 58 $class->hasOne('Parent741 as Moo', array('local' => 'moo_id', 'foreign' => 'id')); 67 59 } 68 60 … … 87 79 } 88 80 } 89 90 -
trunk/tests/Ticket/NjeroTestCase.php
r2488 r3701 17 17 public function prepareTables() 18 18 { 19 $this->tables = array(); 19 20 $this->tables[] = 'CoverageCodeN'; 20 21 $this->tables[] = 'PolicyCodeN';