Changeset 407 for GearsORM/trunk/tests
- Timestamp:
- 03/15/08 09:57:00 (9 months ago)
- Files:
-
- 1 modified
-
GearsORM/trunk/tests/test_relations.html (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
GearsORM/trunk/tests/test_relations.html
r338 r407 12 12 <script> 13 13 GearsORM.dbName = "test.relations"; 14 var Corporation = new GearsORM.Model({ 15 name:"Corporation", 16 fields: 17 { 18 name:new GearsORM.Fields.String({maxLength:25}), 19 companies:new GearsORM.Fields.ManyToOne({related:"Company"}) 20 } 21 }); 22 14 23 var Company = new GearsORM.Model({ 15 24 name:"Company", … … 17 26 { 18 27 name:new GearsORM.Fields.String({maxLength:25}), 19 pepole:new GearsORM.Fields.ManyToOne({related:"Person"}) 28 pepole:new GearsORM.Fields.ManyToOne({related:"Person"}), 29 corporation:new GearsORM.Fields.OneToMany({related:"Corporation"}) 20 30 } 21 31 }); … … 37 47 Company.dropTable(); 38 48 Person.dropTable(); 49 Corporation.dropTable(); 50 Corporation.createTable(); 39 51 Company.createTable(); 40 52 Person.createTable(); 41 (new Company({name:"Company1"})).save(); 42 (new Company({name:"Company2"})).save(); 53 var corp = (new Corporation({name:"Corporation1"})).save(); 54 (new Company({name:"Company1",corporation:corp})).save(); 55 (new Company({name:"Company2",corporation:corp})).save(); 43 56 }, 44 57 "test if create works with relation":function() … … 47 60 someone.firstName = "Jhon"; 48 61 someone.lastName = "Doe"; 49 someone.company = Company.select(" name = ?",["Company1"]).getOne();62 someone.company = Company.select("Company.name = ?",["Company1"]).getOne(); 50 63 someone.save(); 51 64 UnitTest.assertDefined(someone.rowid); … … 53 66 someone2.firstName = "Jhon"; 54 67 someone2.lastName = "Doe"; 55 someone2.company = Company.select(" name = ?",["Company2"]).getOne();68 someone2.company = Company.select("Company.name = ?",["Company2"]).getOne(); 56 69 someone2.save(); 57 70 UnitTest.assertDefined(someone2.rowid); … … 59 72 "test select from backward relation":function() 60 73 { 61 var company1 = Company.select(" name = ?",["Company1"]).getOne();74 var company1 = Company.select("Company.name = ?",["Company1"]).getOne(); 62 75 UnitTest.assertTrue( 63 76 company1.pepole.select().toArray().length == 1, … … 67 80 "test remove from backward relation":function() 68 81 { 69 var company2 = Company.select(" name = ?",["Company2"]).getOne();82 var company2 = Company.select("Company.name = ?",["Company2"]).getOne(); 70 83 var someone2 = new Person(2); 71 84 someone2.remove(); … … 79 92 var aCompany = new Company(); 80 93 aCompany.name = "aCompany"; 94 aCompany.corporation = Corporation.select().getOne(); 81 95 aCompany.save(); 82 96 var aPerson = new Person(); … … 91 105 ); 92 106 aCompany.remove(); 107 }, 108 "test for 2+ level depth of relations":function() 109 { 110 var corp = new Corporation(); 111 corp.name = "Test Corporation 1"; 112 corp.save(); 113 var comp = new Company(); 114 comp.name = "Test Company 1"; 115 comp.corporation = corp; 116 comp.save(); 117 var person = new Person(); 118 person.firstName = "John"; 119 person.lastName = "Doe"; 120 person.company = comp; 121 person.save(); 122 123 var personFromDb = new Person(person.rowid); 124 UnitTest.assertTrue( 125 !!personFromDb.company && 126 !!personFromDb.company.corporation && 127 personFromDb.company.rowid == comp.rowid && 128 personFromDb.company.corporation.rowid == corp.rowid, 129 "related models weren`t selected" 130 ); 93 131 }, 94 132 "test if forigen key is enforced in a insert":function()
