From 4b78404c20490a615459267426ce9e6737bf4485 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 14 Jul 2006 09:20:45 +0000
Subject: Moving files.

---
 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 5120 -> 0 bytes
 demos/sqlmap-sample/protected/person-sqlmap.xml    |  13 ----
 .../sqlmap-sample/protected/petshop-db/petshop.db  | Bin 61440 -> 0 bytes
 .../protected/petshop-db/products.xml              |  15 ----
 demos/sqlmap-sample/protected/petshop-sqlmap.xml   |  12 ----
 16 files changed, 327 deletions(-)
 delete mode 100644 demos/sqlmap-sample/protected/application.xml
 delete mode 100644 demos/sqlmap-sample/protected/business-objects/Person.php
 delete mode 100644 demos/sqlmap-sample/protected/pages/Home.page
 delete mode 100644 demos/sqlmap-sample/protected/pages/ProductList.page
 delete mode 100644 demos/sqlmap-sample/protected/pages/ProductList.php
 delete mode 100644 demos/sqlmap-sample/protected/pages/crud1.page
 delete mode 100644 demos/sqlmap-sample/protected/pages/crud1.php
 delete mode 100644 demos/sqlmap-sample/protected/pages/crud2.page
 delete mode 100644 demos/sqlmap-sample/protected/pages/crud2.php
 delete mode 100644 demos/sqlmap-sample/protected/person-db/person.xml
 delete mode 100644 demos/sqlmap-sample/protected/person-db/personHelper.xml
 delete mode 100644 demos/sqlmap-sample/protected/person-db/test.db
 delete mode 100644 demos/sqlmap-sample/protected/person-sqlmap.xml
 delete mode 100644 demos/sqlmap-sample/protected/petshop-db/petshop.db
 delete mode 100644 demos/sqlmap-sample/protected/petshop-db/products.xml
 delete mode 100644 demos/sqlmap-sample/protected/petshop-sqlmap.xml

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

diff --git a/demos/sqlmap-sample/protected/application.xml b/demos/sqlmap-sample/protected/application.xml
deleted file mode 100644
index 7cfb440f..00000000
--- a/demos/sqlmap-sample/protected/application.xml
+++ /dev/null
@@ -1,16 +0,0 @@
-<?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
deleted file mode 100644
index ad9da4b3..00000000
--- a/demos/sqlmap-sample/protected/business-objects/Person.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?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
deleted file mode 100644
index 6d059c7e..00000000
--- a/demos/sqlmap-sample/protected/pages/Home.page
+++ /dev/null
@@ -1,5 +0,0 @@
-<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
deleted file mode 100644
index 904d411d..00000000
--- a/demos/sqlmap-sample/protected/pages/ProductList.page
+++ /dev/null
@@ -1,9 +0,0 @@
-<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
deleted file mode 100644
index a35c40ea..00000000
--- a/demos/sqlmap-sample/protected/pages/ProductList.php
+++ /dev/null
@@ -1,18 +0,0 @@
-<?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
deleted file mode 100644
index ce467ffa..00000000
--- a/demos/sqlmap-sample/protected/pages/crud1.page
+++ /dev/null
@@ -1,19 +0,0 @@
-<!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
deleted file mode 100644
index 40733dc9..00000000
--- a/demos/sqlmap-sample/protected/pages/crud1.php
+++ /dev/null
@@ -1,21 +0,0 @@
-<?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
deleted file mode 100644
index 4d34e873..00000000
--- a/demos/sqlmap-sample/protected/pages/crud2.page
+++ /dev/null
@@ -1,36 +0,0 @@
-<!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
deleted file mode 100644
index 46fe3893..00000000
--- a/demos/sqlmap-sample/protected/pages/crud2.php
+++ /dev/null
@@ -1,79 +0,0 @@
-<?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
deleted file mode 100644
index 4ffe44d9..00000000
--- a/demos/sqlmap-sample/protected/person-db/person.xml
+++ /dev/null
@@ -1,16 +0,0 @@
-<?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
deleted file mode 100644
index ea2d4302..00000000
--- a/demos/sqlmap-sample/protected/person-db/personHelper.xml
+++ /dev/null
@@ -1,42 +0,0 @@
-<?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
deleted file mode 100644
index a40c91fe..00000000
Binary files a/demos/sqlmap-sample/protected/person-db/test.db and /dev/null differ
diff --git a/demos/sqlmap-sample/protected/person-sqlmap.xml b/demos/sqlmap-sample/protected/person-sqlmap.xml
deleted file mode 100644
index 8d5319e8..00000000
--- a/demos/sqlmap-sample/protected/person-sqlmap.xml
+++ /dev/null
@@ -1,13 +0,0 @@
-<?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
deleted file mode 100644
index 9a4404df..00000000
Binary files a/demos/sqlmap-sample/protected/petshop-db/petshop.db and /dev/null differ
diff --git a/demos/sqlmap-sample/protected/petshop-db/products.xml b/demos/sqlmap-sample/protected/petshop-db/products.xml
deleted file mode 100644
index 3c2899a7..00000000
--- a/demos/sqlmap-sample/protected/petshop-db/products.xml
+++ /dev/null
@@ -1,15 +0,0 @@
-<?xml version="1.0" encoding="utf-8" ?>
-<sqlmap>
-
-	<cacheModel id="product-cache" implementation="basic">
-		<!-- cache data for 60 seconds -->
-		<property name="expiry" value="60" /> 
-	</cacheModel>
-
-	<select id="SelectAllProducts" cacheModel="product-cache" >
-		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
deleted file mode 100644
index f77fe2b7..00000000
--- a/demos/sqlmap-sample/protected/petshop-sqlmap.xml
+++ /dev/null
@@ -1,12 +0,0 @@
-<?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
-- 
cgit v1.2.3