From 3d3f8d3832921f99daf8ce1953304763c2e76c62 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 14 Apr 2006 06:22:09 +0000
Subject: Importing SQLMap + sample + docs.

---
 demos/sqlmap-sample/tests/PersonTest.php | 57 ++++++++++++++++++++++++++++++++
 1 file changed, 57 insertions(+)
 create mode 100644 demos/sqlmap-sample/tests/PersonTest.php

(limited to 'demos/sqlmap-sample/tests/PersonTest.php')

diff --git a/demos/sqlmap-sample/tests/PersonTest.php b/demos/sqlmap-sample/tests/PersonTest.php
new file mode 100644
index 00000000..c40bffa0
--- /dev/null
+++ b/demos/sqlmap-sample/tests/PersonTest.php
@@ -0,0 +1,57 @@
+<?php
+
+class PersonTest extends UnitTestCase
+{
+	function testPersonList()
+	{
+		//try it
+		$people = TMapper::instance()->queryForList("SelectAll");
+
+		//test it
+		$this->assertNotNull($people, "Person list is not returned");
+		$this->assertTrue(count($people) > 0, "Person list is empty");
+		$person = $people[0];
+		$this->assertNotNull($person, "Person not returned");
+	}
+
+	function testPersonUpdate()
+	{
+		$expect = "wei";
+		$edited = "Nah";
+		
+		//get it;
+		$person = TMapper::instance()->queryForObject("Select", 1);
+
+		//test it
+		$this->assertNotNull($person);
+		$this->assertEqual($expect, $person->FirstName);
+
+		//change it
+		$person->FirstName = $edited;
+		TMapper::instance()->update("Update", $person);
+
+		//get it again
+		$person = TMapper::instance()->queryForObject("Select", 1);
+
+		//test it
+		$this->assertEqual($edited, $person->FirstName);
+
+		//change it back
+		$person->FirstName = $expect;
+		TMapper::instance()->update("Update", $person);
+	}
+
+	function testPersonDelete()
+	{
+		//insert it
+		$person = new Person;
+		$person->ID = -1;
+		TMapper::instance()->insert("Insert", $person);
+
+		//delte it
+		$count = TMapper::instance()->delete("Delete", -1);
+		$this->assertEqual(1, $count);
+	}
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3