| 1 |
<html> |
|---|
| 2 |
<head> |
|---|
| 3 |
<script src="../gears_init.js"></script> |
|---|
| 4 |
<script src="../GearsORM.js"></script> |
|---|
| 5 |
<script src="../GearsORM.Events.js"></script> |
|---|
| 6 |
<script src="../GearsORM.ResultIterator.js"></script> |
|---|
| 7 |
<script src="../GearsORM.Sql.js"></script> |
|---|
| 8 |
<script src="../GearsORM.Fields.js"></script> |
|---|
| 9 |
<script src="../GearsORM.Model.js"></script> |
|---|
| 10 |
<script src="../GearsORM.Introspection.js"></script> |
|---|
| 11 |
<script src="../GearsORM.Transaction.js"></script> |
|---|
| 12 |
<script> |
|---|
| 13 |
GearsORM.dbName = "test.simple1"; |
|---|
| 14 |
var Person = new GearsORM.Model({ |
|---|
| 15 |
name:"Person", |
|---|
| 16 |
fields: |
|---|
| 17 |
{ |
|---|
| 18 |
firstName:new GearsORM.Fields.String({maxLength:25}), |
|---|
| 19 |
lastName:new GearsORM.Fields.String({maxLength:25}) |
|---|
| 20 |
} |
|---|
| 21 |
}); |
|---|
| 22 |
|
|---|
| 23 |
var Tests = |
|---|
| 24 |
{ |
|---|
| 25 |
up:function() |
|---|
| 26 |
{ |
|---|
| 27 |
Person.dropTable(); |
|---|
| 28 |
Person.createTable(); |
|---|
| 29 |
}, |
|---|
| 30 |
"test if create works":function() |
|---|
| 31 |
{ |
|---|
| 32 |
var someone = new Person(); |
|---|
| 33 |
someone.firstName = "Jhon"; |
|---|
| 34 |
someone.lastName = "Doe"; |
|---|
| 35 |
someone.save(); |
|---|
| 36 |
UnitTest.assertDefined(someone.rowid,"someone wasn`t inserted"); |
|---|
| 37 |
}, |
|---|
| 38 |
"test if retrive using constructor work":function() |
|---|
| 39 |
{ |
|---|
| 40 |
var someone = new Person(1); |
|---|
| 41 |
UnitTest.assertTrue(someone.firstName == "Jhon","first name is wrong"); |
|---|
| 42 |
UnitTest.assertTrue(someone.lastName == "Doe","last name is wrong"); |
|---|
| 43 |
}, |
|---|
| 44 |
"test if update works":function() |
|---|
| 45 |
{ |
|---|
| 46 |
var someone = new Person(1); |
|---|
| 47 |
someone.firstName = "updated"; |
|---|
| 48 |
someone.save(); |
|---|
| 49 |
var fromDb = new Person(1); |
|---|
| 50 |
UnitTest.assertTrue(fromDb.firstName == "updated","someone wasn`t updated"); |
|---|
| 51 |
}, |
|---|
| 52 |
"test if count works":function() |
|---|
| 53 |
{ |
|---|
| 54 |
UnitTest.assertEqual(1,Person.count()); |
|---|
| 55 |
new Person({firstName:"test",lastName:"test"}).save(); |
|---|
| 56 |
UnitTest.assertEqual(2,Person.count()); |
|---|
| 57 |
UnitTest.assertEqual(1,Person.count("firstName = ?",["test"])); |
|---|
| 58 |
}, |
|---|
| 59 |
"test if delete works":function() |
|---|
| 60 |
{ |
|---|
| 61 |
var someone = Person.select().getOne(); |
|---|
| 62 |
var id = someone.rowid; |
|---|
| 63 |
someone.remove(); |
|---|
| 64 |
UnitTest.assertTrue( |
|---|
| 65 |
Person.select("rowid = ?",[id]).getOne() == false, |
|---|
| 66 |
"someone wasn`t delete" |
|---|
| 67 |
); |
|---|
| 68 |
}, |
|---|
| 69 |
down:function() |
|---|
| 70 |
{ |
|---|
| 71 |
Person.dropTable(); |
|---|
| 72 |
} |
|---|
| 73 |
}; |
|---|
| 74 |
</script> |
|---|
| 75 |
<script src="unit_test.js"></script> |
|---|
| 76 |
</head> |
|---|
| 77 |
<body> |
|---|
| 78 |
|
|---|
| 79 |
</body> |
|---|
| 80 |
</html> |
|---|