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/protected/application.xml      |  16 +++++
 .../protected/business-objects/Person.php          |  26 +++++++
 demos/sqlmap-sample/protected/pages/Home.page      |   5 ++
 .../sqlmap-sample/protected/pages/ProductList.page |   9 +++
 .../sqlmap-sample/protected/pages/ProductList.php  |  18 +++++
 demos/sqlmap-sample/protected/pages/crud1.page     |  19 +++++
 demos/sqlmap-sample/protected/pages/crud1.php      |  21 ++++++
 demos/sqlmap-sample/protected/pages/crud2.page     |  36 ++++++++++
 demos/sqlmap-sample/protected/pages/crud2.php      |  79 +++++++++++++++++++++
 demos/sqlmap-sample/protected/person-db/person.xml |  16 +++++
 .../protected/person-db/personHelper.xml           |  42 +++++++++++
 demos/sqlmap-sample/protected/person-db/test.db    | Bin 0 -> 5120 bytes
 demos/sqlmap-sample/protected/person-sqlmap.xml    |  13 ++++
 .../sqlmap-sample/protected/petshop-db/petshop.db  | Bin 0 -> 61440 bytes
 .../protected/petshop-db/products.xml              |  10 +++
 demos/sqlmap-sample/protected/petshop-sqlmap.xml   |  12 ++++
 .../protected/runtime/application.xml/config.cache | Bin 0 -> 2101 bytes
 .../protected/runtime/application.xml/global.cache |   1 +
 .../protected/runtime/application.xml/sqlite.cache | Bin 0 -> 19456 bytes
 19 files changed, 323 insertions(+)
 create mode 100644 demos/sqlmap-sample/protected/application.xml
 create mode 100644 demos/sqlmap-sample/protected/business-objects/Person.php
 create mode 100644 demos/sqlmap-sample/protected/pages/Home.page
 create mode 100644 demos/sqlmap-sample/protected/pages/ProductList.page
 create mode 100644 demos/sqlmap-sample/protected/pages/ProductList.php
 create mode 100644 demos/sqlmap-sample/protected/pages/crud1.page
 create mode 100644 demos/sqlmap-sample/protected/pages/crud1.php
 create mode 100644 demos/sqlmap-sample/protected/pages/crud2.page
 create mode 100644 demos/sqlmap-sample/protected/pages/crud2.php
 create mode 100644 demos/sqlmap-sample/protected/person-db/person.xml
 create mode 100644 demos/sqlmap-sample/protected/person-db/personHelper.xml
 create mode 100644 demos/sqlmap-sample/protected/person-db/test.db
 create mode 100644 demos/sqlmap-sample/protected/person-sqlmap.xml
 create mode 100644 demos/sqlmap-sample/protected/petshop-db/petshop.db
 create mode 100644 demos/sqlmap-sample/protected/petshop-db/products.xml
 create mode 100644 demos/sqlmap-sample/protected/petshop-sqlmap.xml
 create mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/config.cache
 create mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/global.cache
 create mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache

(limited to 'demos/sqlmap-sample/protected')

diff --git a/demos/sqlmap-sample/protected/application.xml b/demos/sqlmap-sample/protected/application.xml
new file mode 100644
index 00000000..7cfb440f
--- /dev/null
+++ b/demos/sqlmap-sample/protected/application.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<application id="Database" Mode="Debug">
+  <paths>
+	<alias id="Example" path="business-objects" />
+  </paths>
+  <modules>
+  	<module id="cache" class="System.Caching.TSqliteCache" />
+  	<module id="petshop-sqlmap" 
+  			enableConfigCache="true"
+  			class="System.DataAccess.TSQLMap" 
+  			configFile="Application.petshop-sqlmap" />
+  	<module id="person-sample"
+  			class="System.DataAccess.TSQLMap"
+  			configFile="Application.person-sqlmap" />
+  </modules>
+</application>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/business-objects/Person.php b/demos/sqlmap-sample/protected/business-objects/Person.php
new file mode 100644
index 00000000..ad9da4b3
--- /dev/null
+++ b/demos/sqlmap-sample/protected/business-objects/Person.php
@@ -0,0 +1,26 @@
+<?php
+
+class Person
+{
+    public $ID = -1;
+    public $FirstName = '';
+    public $LastName = '';
+
+    public $WeightInKilograms = 0.0;
+    public $HeightInMeters = 0.0;
+
+    private $_birthDate = '';
+
+    //setters and getter for BirthDate
+    public function getBirthDate()
+    {
+        return $this->_birthDate;
+    }
+
+    public function setBirthDate($value)
+    {
+        $this->_birthDate = $value;
+    }
+}
+
+?>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/Home.page b/demos/sqlmap-sample/protected/pages/Home.page
new file mode 100644
index 00000000..6d059c7e
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/Home.page
@@ -0,0 +1,5 @@
+<ul>
+	<li><a href="index.php?page=crud1">Tutorial 1</a></li>
+	<li><a href="index.php?page=crud2">Tutorial 2</a></li>
+	<li><a href="index.php?page=ProductList">Product List</a></li>
+</ul>	
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/ProductList.page b/demos/sqlmap-sample/protected/pages/ProductList.page
new file mode 100644
index 00000000..904d411d
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/ProductList.page
@@ -0,0 +1,9 @@
+<h1>Database Examples</h1>
+<com:TRepeater id="productList">
+	<prop:ItemTemplate>
+	<div>
+		Code: <%# $this->DataItem['productid'] %>
+		Category: <%# $this->DataItem['category'] %>
+	</div>
+	</prop:ItemTemplate>
+</com:TRepeater>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/ProductList.php b/demos/sqlmap-sample/protected/pages/ProductList.php
new file mode 100644
index 00000000..a35c40ea
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/ProductList.php
@@ -0,0 +1,18 @@
+<?php
+
+class ProductList extends TPage
+{
+	public function onLoad($param)
+	{
+		parent::onLoad($param);
+		if(!$this->IsPostBack)
+		{
+			$sqlmap = $this->Application->Modules['petshop-sqlmap'];
+			$products = $sqlmap->queryForList('SelectAllProducts');
+			$this->productList->setDataSource($products);
+			$this->productList->dataBind();
+		}
+	} 	
+}
+
+?>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/crud1.page b/demos/sqlmap-sample/protected/pages/crud1.page
new file mode 100644
index 00000000..ce467ffa
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/crud1.page
@@ -0,0 +1,19 @@
+<!doctype html public "-//W3C//DTD XHTML 1.0 Strict//EN" 
+	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+	
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
+<head>
+	<title>Person</title>
+</head>
+
+<body>
+
+<com:TForm>
+	<h1>Person List</h1>
+	<com:TDataGrid id="personList">
+		<com:TBoundColumn DataField="BirthDate" 
+				HeaderText="Birth Date"/>
+	</com:TDataGrid>
+</com:TForm>
+</body>
+</html>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/crud1.php b/demos/sqlmap-sample/protected/pages/crud1.php
new file mode 100644
index 00000000..40733dc9
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/crud1.php
@@ -0,0 +1,21 @@
+<?php
+
+Prado::using('Example.Person');
+
+class crud1 extends TPage
+{
+    private function loadData()
+    {
+        $sqlmap = $this->Application->Modules['person-sample'];
+        $this->personList->DataSource = $sqlmap->queryForList('SelectAll');
+        $this->personList->dataBind();
+    }
+
+	public function onLoad($param)
+	{		
+		if(!$this->IsPostBack)
+			$this->loadData();
+	}
+}
+
+?>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/crud2.page b/demos/sqlmap-sample/protected/pages/crud2.page
new file mode 100644
index 00000000..4d34e873
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/crud2.page
@@ -0,0 +1,36 @@
+<!doctype html public "-//W3C//DTD XHTML 1.0 Strict//EN" 
+	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+	
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
+<head>
+	<title>Person</title>
+</head>
+
+<body>
+
+<com:TForm>
+	<h1>Person List</h1>
+	<com:TDataGrid id="personList" 
+			DataKeyField="ID"
+			AutoGenerateColumns="False"
+			OnEditCommand="editPerson"
+			OnUpdateCommand="updatePerson"
+			OnCancelCommand="refreshList"
+			OnDeleteCommand="deletePerson">
+		<com:TBoundColumn DataField="FirstName" HeaderText="First Name" />
+		<com:TBoundColumn DataField="LastName" HeaderText="Last Name" />
+		<com:TBoundColumn DataField="HeightInMeters" HeaderText="Height" />
+		<com:TBoundColumn DataField="WeightInKilograms" HeaderText="Weight" />
+
+		<com:TEditCommandColumn
+				HeaderText="Edit"
+				UpdateText="Save" />
+		<com:TButtonColumn
+				HeaderText="Delete"
+				Text="Delete"
+				CommandName="delete"/>
+	</com:TDataGrid>
+	<com:TButton Text="Add" OnClick="addNewPerson" />
+</com:TForm>
+</body>
+</html>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/pages/crud2.php b/demos/sqlmap-sample/protected/pages/crud2.php
new file mode 100644
index 00000000..46fe3893
--- /dev/null
+++ b/demos/sqlmap-sample/protected/pages/crud2.php
@@ -0,0 +1,79 @@
+<?php
+
+Prado::using('Example.Person');
+
+class crud2 extends TPage
+{
+	private function sqlmap()
+	{
+		return $this->Application->Modules['person-sample'];
+	}
+
+	private function loadData()
+	{
+		$this->personList->DataSource = 
+				$this->sqlmap()->queryForList('SelectAll');
+		$this->personList->dataBind();
+	}
+
+	public function onLoad($param)
+	{		
+		if(!$this->IsPostBack)
+			$this->loadData();
+	}
+
+	protected function editPerson($sender,$param)
+	{
+		$this->personList->EditItemIndex=$param->Item->ItemIndex;
+		$this->loadData();
+	}
+
+	protected function deletePerson($sender, $param)
+	{
+		$id = $this->getKey($sender, $param);
+
+		$this->sqlmap()->update("Delete", $id);
+		$this->loadData();
+	}
+
+	protected function updatePerson($sender, $param)
+	{
+		$person = new Person();
+		$person->FirstName = $this->getText($param, 0);
+		$person->LastName = $this->getText($param, 1);
+		$person->HeightInMeters = $this->getText($param, 2);
+		$person->WeightInKilograms = $this->getText($param, 3);
+		$person->ID = $this->getKey($sender, $param);
+		
+		$this->sqlmap()->update("Update", $person);
+		$this->refreshList($sender, $param);
+	}
+
+	protected function addNewPerson($sender, $param)
+	{
+		$person = new Person;
+		$person->FirstName = "-- New Person --";
+		$this->sqlmap()->insert("Insert", $person);
+
+		$this->loadData();;
+	}
+
+	protected function refreshList($sender, $param)
+	{
+		$this->personList->EditItemIndex=-1;
+		$this->loadData();
+	}
+
+	private function getText($param, $index)
+	{
+		$item = $param->Item;
+		return $item->Cells[$index]->Controls[0]->Text;
+	}
+
+	private function getKey($sender, $param)
+	{
+		return $sender->DataKeys[$param->Item->DataSourceIndex];
+	}
+}
+
+?>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/person-db/person.xml b/demos/sqlmap-sample/protected/person-db/person.xml
new file mode 100644
index 00000000..4ffe44d9
--- /dev/null
+++ b/demos/sqlmap-sample/protected/person-db/person.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlMap>
+
+	<select id="SelectAll" resultClass="Person">
+		SELECT
+			per_id as ID,
+			per_first_name as FirstName,
+			per_last_name as LastName,
+			per_birth_date as BirthDate,
+			per_weight_kg as WeightInKilograms,
+			per_height_m as HeightInMeters
+		FROM 
+			person
+	</select>
+
+</sqlMap>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/person-db/personHelper.xml b/demos/sqlmap-sample/protected/person-db/personHelper.xml
new file mode 100644
index 00000000..ea2d4302
--- /dev/null
+++ b/demos/sqlmap-sample/protected/person-db/personHelper.xml
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8" ?> 
+
+<sqlMap Name="PersonHelper">
+
+  <select id="Select" parameterClass="int" resultClass="Person">
+   select
+    PER_ID as ID,
+    PER_FIRST_NAME as FirstName,
+    PER_LAST_NAME as LastName,
+    PER_BIRTH_DATE as BirthDate,
+    PER_WEIGHT_KG as WeightInKilograms,
+    PER_HEIGHT_M as HeightInMeters
+    from PERSON
+	WHERE
+      PER_ID = #value#
+  </select>
+
+  <insert id="Insert" parameterClass="Person">
+   insert into PERSON 
+    (PER_ID, PER_FIRST_NAME, PER_LAST_NAME,
+    PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M)
+   values 
+    (#ID#, #FirstName#, #LastName#, 
+    #BirthDate#, #WeightInKilograms#, #HeightInMeters#)
+  </insert>
+
+  <update id="Update" parameterClass="Person">
+   update PERSON set
+    PER_FIRST_NAME = #FirstName#,
+    PER_LAST_NAME = #LastName#, 
+    PER_BIRTH_DATE = #BirthDate#,
+    PER_WEIGHT_KG = #WeightInKilograms#,
+    PER_HEIGHT_M = #HeightInMeters#
+   where PER_ID = #ID#
+  </update>
+
+  <delete id="Delete" parameterClass="int">
+   delete from PERSON
+   where PER_ID = #value#
+  </delete>
+
+</sqlMap>
diff --git a/demos/sqlmap-sample/protected/person-db/test.db b/demos/sqlmap-sample/protected/person-db/test.db
new file mode 100644
index 00000000..a40c91fe
Binary files /dev/null and b/demos/sqlmap-sample/protected/person-db/test.db differ
diff --git a/demos/sqlmap-sample/protected/person-sqlmap.xml b/demos/sqlmap-sample/protected/person-sqlmap.xml
new file mode 100644
index 00000000..8d5319e8
--- /dev/null
+++ b/demos/sqlmap-sample/protected/person-sqlmap.xml
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<sqlMapConfig>
+
+	<provider class="TAdodbProvider">
+		<datasource driver="sqlite" host="protected/person-db/test.db" />
+	</provider>
+
+	<sqlMaps>
+		<sqlMap resource="person-db/person.xml"/>
+		<sqlMap resource="person-db/personHelper.xml"/>
+	</sqlMaps>
+
+</sqlMapConfig>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/petshop-db/petshop.db b/demos/sqlmap-sample/protected/petshop-db/petshop.db
new file mode 100644
index 00000000..9a4404df
Binary files /dev/null and b/demos/sqlmap-sample/protected/petshop-db/petshop.db differ
diff --git a/demos/sqlmap-sample/protected/petshop-db/products.xml b/demos/sqlmap-sample/protected/petshop-db/products.xml
new file mode 100644
index 00000000..bf1453b2
--- /dev/null
+++ b/demos/sqlmap-sample/protected/petshop-db/products.xml
@@ -0,0 +1,10 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlmap>
+
+	<select id="SelectAllProducts">
+		SELECT * 
+		FROM 
+			product
+	</select>
+
+</sqlmap>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/petshop-sqlmap.xml b/demos/sqlmap-sample/protected/petshop-sqlmap.xml
new file mode 100644
index 00000000..f77fe2b7
--- /dev/null
+++ b/demos/sqlmap-sample/protected/petshop-sqlmap.xml
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<sqlMapConfig>
+
+	<provider class="TAdodbProvider">
+		<datasource driver="sqlite" host="protected/petshop-db/petshop.db" />
+	</provider>
+
+	<sqlMaps>
+		<sqlMap resource="petshop-db/products.xml"/>
+	</sqlMaps>
+
+</sqlMapConfig>
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/config.cache b/demos/sqlmap-sample/protected/runtime/application.xml/config.cache
new file mode 100644
index 00000000..ce7bd76a
Binary files /dev/null and b/demos/sqlmap-sample/protected/runtime/application.xml/config.cache differ
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/global.cache b/demos/sqlmap-sample/protected/runtime/application.xml/global.cache
new file mode 100644
index 00000000..b35e9768
--- /dev/null
+++ b/demos/sqlmap-sample/protected/runtime/application.xml/global.cache
@@ -0,0 +1 @@
+a:1:{s:35:"prado:securitymanager:validationkey";s:32:"e632288aebf1e51c0447ab4b701f1aa7";}
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache b/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache
new file mode 100644
index 00000000..be9b9cc0
Binary files /dev/null and b/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache differ
-- 
cgit v1.2.3