summaryrefslogtreecommitdiff
path: root/demos/sqlmap-sample/protected
diff options
context:
space:
mode:
Diffstat (limited to 'demos/sqlmap-sample/protected')
-rw-r--r--demos/sqlmap-sample/protected/application.xml16
-rw-r--r--demos/sqlmap-sample/protected/business-objects/Person.php26
-rw-r--r--demos/sqlmap-sample/protected/pages/Home.page5
-rw-r--r--demos/sqlmap-sample/protected/pages/ProductList.page9
-rw-r--r--demos/sqlmap-sample/protected/pages/ProductList.php18
-rw-r--r--demos/sqlmap-sample/protected/pages/crud1.page19
-rw-r--r--demos/sqlmap-sample/protected/pages/crud1.php21
-rw-r--r--demos/sqlmap-sample/protected/pages/crud2.page36
-rw-r--r--demos/sqlmap-sample/protected/pages/crud2.php79
-rw-r--r--demos/sqlmap-sample/protected/person-db/person.xml16
-rw-r--r--demos/sqlmap-sample/protected/person-db/personHelper.xml42
-rw-r--r--demos/sqlmap-sample/protected/person-db/test.dbbin5120 -> 0 bytes
-rw-r--r--demos/sqlmap-sample/protected/person-sqlmap.xml13
-rw-r--r--demos/sqlmap-sample/protected/petshop-db/petshop.dbbin61440 -> 0 bytes
-rw-r--r--demos/sqlmap-sample/protected/petshop-db/products.xml15
-rw-r--r--demos/sqlmap-sample/protected/petshop-sqlmap.xml12
16 files changed, 0 insertions, 327 deletions
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
--- a/demos/sqlmap-sample/protected/person-db/test.db
+++ /dev/null
Binary files 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
--- a/demos/sqlmap-sample/protected/petshop-db/petshop.db
+++ /dev/null
Binary files 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