Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module to cache records.

22 files changed, 495 insertions, 0 deletions

diff --git a/tests/unit/SQLMap/domain/A.php b/tests/unit/SQLMap/domain/A.php
new file mode 100644
index 00000000..6830ea4d
--- /dev/null
+++ b/tests/unit/SQLMap/domain/A.php
@@ -0,0 +1,27 @@
+<?php

+

+class A

+{

+	private $_ID='';

+	private $_Libelle='';

+	private $_B='';

+	private $_E='';

+	private $_F='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+

+	public function getB(){ return $this->_B; }

+	public function setB($value){ $this->_B = $value; }

+

+	public function getE(){ return $this->_E; }

+	public function setE($value){ $this->_E = $value; }

+

+	public function getF(){ return $this->_F; }

+	public function setF($value){ $this->_F = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Account.php b/tests/unit/SQLMap/domain/Account.php
new file mode 100644
index 00000000..f01726ba
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Account.php
@@ -0,0 +1,36 @@
+<?php

+

+class Account

+{

+	private $_ID=0;

+	private $_FirstName='';

+	private $_LastName='';

+	private $_EmailAddress=null;

+	private $_IDS='';

+	private $_BannerOptions=0;

+	private $_CartOptions=0;

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = intval($value); }

+

+	public function getFirstName(){ return $this->_FirstName; }

+	public function setFirstName($value){ $this->_FirstName = $value; }

+

+	public function getLastName(){ return $this->_LastName; }

+	public function setLastName($value){ $this->_LastName = $value; }

+

+	public function getEmailAddress(){ return $this->_EmailAddress; }

+	public function setEmailAddress($value){ $this->_EmailAddress = $value; }

+

+	public function getIDS(){ return $this->_IDS; }

+	public function setIDS($value){ $this->_IDS = $value; }

+

+	public function getBannerOptions(){ return $this->_BannerOptions; }

+	public function setBannerOptions($value){ $this->_BannerOptions = $value; }

+

+	public function getCartOptions(){ return $this->_CartOptions; }

+	public function setCartOptions($value){ $this->_CartOptions = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/AccountBis.php b/tests/unit/SQLMap/domain/AccountBis.php
new file mode 100644
index 00000000..8c96d8e4
--- /dev/null
+++ b/tests/unit/SQLMap/domain/AccountBis.php
@@ -0,0 +1,13 @@
+<?php

+

+class AccountBis

+{

+	public $Id;

+	public $FirstName;

+	public $LastName;

+	public $EmailAddress;

+	public $More;

+}

+

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/AccountCollection.php b/tests/unit/SQLMap/domain/AccountCollection.php
new file mode 100644
index 00000000..9fc8edb7
--- /dev/null
+++ b/tests/unit/SQLMap/domain/AccountCollection.php
@@ -0,0 +1,17 @@
+<?php

+

+class AccountCollection extends TList

+{

+	public function addRange($accounts)

+	{

+		foreach($accounts as $account)

+			$this->add($account);

+	}

+

+	public function copyTo(TList $array)

+	{

+		$array->copyFrom($this);

+	}

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/B.php b/tests/unit/SQLMap/domain/B.php
new file mode 100644
index 00000000..a05e21d4
--- /dev/null
+++ b/tests/unit/SQLMap/domain/B.php
@@ -0,0 +1,23 @@
+<?php

+

+class B

+{

+	private $_C='';

+	private $_D='';

+	private $_ID='';

+	private $_Libelle='';

+

+	public function getC(){ return $this->_C; }

+	public function setC($value){ $this->_C = $value; }

+

+	public function getD(){ return $this->_D; }

+	public function setD($value){ $this->_D = $value; }

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Book.php b/tests/unit/SQLMap/domain/Book.php
new file mode 100644
index 00000000..cc12c30e
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Book.php
@@ -0,0 +1,11 @@
+<?php

+

+class Book extends Document

+{

+	private $_PageNumber='';

+

+	public function getPageNumber(){ return $this->_PageNumber; }

+	public function setPageNumber($value){ $this->_PageNumber = $value; }	

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/C.php b/tests/unit/SQLMap/domain/C.php
new file mode 100644
index 00000000..09fb456a
--- /dev/null
+++ b/tests/unit/SQLMap/domain/C.php
@@ -0,0 +1,15 @@
+<?php

+

+class C

+{

+	private $_ID='';

+	private $_Libelle='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Category.php b/tests/unit/SQLMap/domain/Category.php
new file mode 100644
index 00000000..83fecc7e
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Category.php
@@ -0,0 +1,19 @@
+<?php

+

+class Category

+{

+	private $_ID=-1;

+	private $_Name='';

+	private $_Guid='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getName(){ return $this->_Name; }

+	public function setName($value){ $this->_Name = $value; }

+

+	public function getGuidString(){ return $this->_Guid; }

+	public function setGuidString($value){ $this->_Guid = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Complex.php b/tests/unit/SQLMap/domain/Complex.php
new file mode 100644
index 00000000..92b500f4
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Complex.php
@@ -0,0 +1,11 @@
+<?php

+

+class Complex

+{

+	private $_map;

+

+	public function getMap(){ return $this->_map; }

+	public function setMap(TMap $map){ $this->_map = $map; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/D.php b/tests/unit/SQLMap/domain/D.php
new file mode 100644
index 00000000..5d1baabd
--- /dev/null
+++ b/tests/unit/SQLMap/domain/D.php
@@ -0,0 +1,16 @@
+<?php

+

+class D

+{

+	private $_ID='';

+	private $_Libelle='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Document.php b/tests/unit/SQLMap/domain/Document.php
new file mode 100644
index 00000000..63bcfd33
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Document.php
@@ -0,0 +1,16 @@
+<?php

+

+class Document

+{

+	private $_ID='';

+	private $_Title='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getTitle(){ return $this->_Title; }

+	public function setTitle($value){ $this->_Title = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/DocumentCollection.php b/tests/unit/SQLMap/domain/DocumentCollection.php
new file mode 100644
index 00000000..c15b6f7d
--- /dev/null
+++ b/tests/unit/SQLMap/domain/DocumentCollection.php
@@ -0,0 +1,8 @@
+<?php

+

+class DocumentCollection extends TList

+{

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/E.php b/tests/unit/SQLMap/domain/E.php
new file mode 100644
index 00000000..2c80bb46
--- /dev/null
+++ b/tests/unit/SQLMap/domain/E.php
@@ -0,0 +1,16 @@
+<?php

+

+class E

+{

+	private $_ID='';

+	private $_Libelle='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/F.php b/tests/unit/SQLMap/domain/F.php
new file mode 100644
index 00000000..b1090cc6
--- /dev/null
+++ b/tests/unit/SQLMap/domain/F.php
@@ -0,0 +1,16 @@
+<?php

+

+class F

+{

+	private $_ID='';

+	private $_Libelle='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getLibelle(){ return $this->_Libelle; }

+	public function setLibelle($value){ $this->_Libelle = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/LineItem.php b/tests/unit/SQLMap/domain/LineItem.php
new file mode 100644
index 00000000..d851da6c
--- /dev/null
+++ b/tests/unit/SQLMap/domain/LineItem.php
@@ -0,0 +1,32 @@
+<?php

+

+class LineItem

+{

+	private $_ID=-1;

+	private $_Order='';

+	private $_Code='';

+	private $_Quantity=-1;

+	private $_Price=0.0;

+	private $_PictureData='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getOrder(){ return $this->_Order; }

+	public function setOrder($value){ $this->_Order = $value; }

+

+	public function getCode(){ return $this->_Code; }

+	public function setCode($value){ $this->_Code = $value; }

+

+	public function getQuantity(){ return $this->_Quantity; }

+	public function setQuantity($value){ $this->_Quantity = $value; }

+

+	public function getPrice(){ return $this->_Price; }

+	public function setPrice($value){ $this->_Price = $value; }

+

+	public function getPictureData(){ return $this->_PictureData; }

+	public function setPictureData($value){ $this->_PictureData = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/LineItemCollection.php b/tests/unit/SQLMap/domain/LineItemCollection.php
new file mode 100644
index 00000000..f177487c
--- /dev/null
+++ b/tests/unit/SQLMap/domain/LineItemCollection.php
@@ -0,0 +1,8 @@
+<?php

+

+class LineItemCollection extends TList

+{

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Newspaper.php b/tests/unit/SQLMap/domain/Newspaper.php
new file mode 100644
index 00000000..4eb56aa2
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Newspaper.php
@@ -0,0 +1,12 @@
+<?php

+

+class Newspaper extends Document

+{

+	private $_City='';

+

+	public function getCity(){ return $this->_City; }

+	public function setCity($value){ $this->_City = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Order.php b/tests/unit/SQLMap/domain/Order.php
new file mode 100644
index 00000000..65d18b13
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Order.php
@@ -0,0 +1,71 @@
+<?php

+

+class Order

+{

+	private $_ID=-1;

+	private $_Account='';

+	private $_Date='';

+	private $_CardType='';

+	private $_CardExpiry='';

+	private $_CardNumber='';

+	private $_Street='';

+	private $_City='';

+	private $_Province='';

+	private $_PostalCode='';

+	private $_LineItemsList='';

+	private $_LineItems=null;

+	private $_LineItemsArray=array();

+	private $_FavouriteLineItem=null;

+

+	public function __construct()

+	{

+		$this->_LineItemsList = new TList;

+		$this->_LineItems = new TList;

+		$this->_FavouriteLineItem = new LineItem;

+	}

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getAccount(){ return $this->_Account; }

+	public function setAccount($value){ $this->_Account = $value; }

+

+	public function getDate(){ return $this->_Date; }

+	public function setDate($value){ $this->_Date = $value; }

+

+	public function getCardType(){ return $this->_CardType; }

+	public function setCardType($value){ $this->_CardType = $value; }

+

+	public function getCardExpiry(){ return $this->_CardExpiry; }

+	public function setCardExpiry($value){ $this->_CardExpiry = $value; }

+

+	public function getCardNumber(){ return $this->_CardNumber; }

+	public function setCardNumber($value){ $this->_CardNumber = $value; }

+

+	public function getStreet(){ return $this->_Street; }

+	public function setStreet($value){ $this->_Street = $value; }

+

+	public function getCity(){ return $this->_City; }

+	public function setCity($value){ $this->_City = $value; }

+

+	public function getProvince(){ return $this->_Province; }

+	public function setProvince($value){ $this->_Province = $value; }

+

+	public function getPostalCode(){ return $this->_PostalCode; }

+	public function setPostalCode($value){ $this->_PostalCode = $value; }

+

+	public function getLineItemsList(){ return $this->_LineItemsList; }

+	public function setLineItemsList($value){ $this->_LineItemsList = $value; }

+

+	public function getLineItems(){ return $this->_LineItems; }

+	public function setLineItems($value){ $this->_LineItems = $value; }

+

+	public function getLineItemsArray(){ return $this->_LineItemsArray; }

+	public function setLineItemsArray($value){ $this->_LineItemsArray = $value; }

+

+	public function getFavouriteLineItem(){ return $this->_FavouriteLineItem; }

+	public function setFavouriteLineItem($value){ $this->_FavouriteLineItem = $value; }

+

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Other.php b/tests/unit/SQLMap/domain/Other.php
new file mode 100644
index 00000000..32d85e90
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Other.php
@@ -0,0 +1,23 @@
+<?php

+

+class Other

+{

+	private $_Int=-1;

+	private $_Long=-1;

+	private $_Bool=false;

+	private $_Bool2=false;

+

+	public function getBool2(){ return $this->_Bool2; }

+	public function setBool2($value){ $this->_Bool2 = $value; }

+

+	public function getBool(){ return $this->_Bool; }

+	public function setBool($value){ $this->_Bool = $value; }

+

+	public function getInt(){ return $this->_Int; }

+	public function setInt($value){ $this->_Int = $value; }

+

+	public function getLong(){ return $this->_Long; }

+	public function setLong($value){ $this->_Long = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Sample.php b/tests/unit/SQLMap/domain/Sample.php
new file mode 100644
index 00000000..c9a34601
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Sample.php
@@ -0,0 +1,55 @@
+<?php

+

+class Sample

+{

+	private $_FirstID='';

+	private $_SecondID='';

+	private $_ThirdID='';

+	private $_FourthID='';

+	private $_FifthID='';

+	private $_SequenceID='';

+	private $_DistributedID='';

+	private $_SampleChar='';

+	private $_SampleDecimal='';

+	private $_SampleMoney='';

+	private $_SampleDate='';

+	private $_SequenceDate='';

+

+	public function getFirstID(){ return $this->_FirstID; }

+	public function setFirstID($value){ $this->_FirstID = $value; }

+

+	public function getSecondID(){ return $this->_SecondID; }

+	public function setSecondID($value){ $this->_SecondID = $value; }

+

+	public function getThirdID(){ return $this->_ThirdID; }

+	public function setThirdID($value){ $this->_ThirdID = $value; }

+

+	public function getFourthID(){ return $this->_FourthID; }

+	public function setFourthID($value){ $this->_FourthID = $value; }

+

+	public function getFifthID(){ return $this->_FifthID; }

+	public function setFifthID($value){ $this->_FifthID = $value; }

+

+	public function getSequenceID(){ return $this->_SequenceID; }

+	public function setSequenceID($value){ $this->_SequenceID = $value; }

+

+	public function getDistributedID(){ return $this->_DistributedID; }

+	public function setDistributedID($value){ $this->_DistributedID = $value; }

+

+	public function getSampleChar(){ return $this->_SampleChar; }

+	public function setSampleChar($value){ $this->_SampleChar = $value; }

+

+	public function getSampleDecimal(){ return $this->_SampleDecimal; }

+	public function setSampleDecimal($value){ $this->_SampleDecimal = $value; }

+

+	public function getSampleMoney(){ return $this->_SampleMoney; }

+	public function setSampleMoney($value){ $this->_SampleMoney = $value; }

+

+	public function getSampleDate(){ return $this->_SampleDate; }

+	public function setSampleDate($value){ $this->_SampleDate = $value; }

+

+	public function getSequenceDate(){ return $this->_SequenceDate; }

+	public function setSequenceDate($value){ $this->_SequenceDate = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/Search.php b/tests/unit/SQLMap/domain/Search.php
new file mode 100644
index 00000000..a09ca6e6
--- /dev/null
+++ b/tests/unit/SQLMap/domain/Search.php
@@ -0,0 +1,23 @@
+<?php

+

+class Search

+{

+	private $_NumberSearch='';

+	private $_StartDate='';

+	private $_Operande='';

+	private $_StartDateAnd='';

+

+	public function getNumberSearch(){ return $this->_NumberSearch; }

+	public function setNumberSearch($value){ $this->_NumberSearch = $value; }

+

+	public function getStartDate(){ return $this->_StartDate; }

+	public function setStartDate($value){ $this->_StartDate = $value; }

+

+	public function getOperande(){ return $this->_Operande; }

+	public function setOperande($value){ $this->_Operande = $value; }

+

+	public function getStartDateAnd(){ return $this->_StartDateAnd; }

+	public function setStartDateAnd($value){ $this->_StartDateAnd = $value; }

+}

+

+?>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/domain/User.php b/tests/unit/SQLMap/domain/User.php
new file mode 100644
index 00000000..0c3a547f
--- /dev/null
+++ b/tests/unit/SQLMap/domain/User.php
@@ -0,0 +1,27 @@
+<?php

+

+class User

+{

+	private $_ID='';

+	private $_UserName='';

+	private $_Password='';

+	private $_EmailAddress='';

+	private $_LastLogon='';

+

+	public function getID(){ return $this->_ID; }

+	public function setID($value){ $this->_ID = $value; }

+

+	public function getUserName(){ return $this->_UserName; }

+	public function setUserName($value){ $this->_UserName = $value; }

+

+	public function getPassword(){ return $this->_Password; }

+	public function setPassword($value){ $this->_Password = $value; }

+

+	public function getEmailAddress(){ return $this->_EmailAddress; }

+	public function setEmailAddress($value){ $this->_EmailAddress = $value; }

+

+	public function getLastLogon(){ return $this->_LastLogon; }

+	public function setLastLogon($value){ $this->_LastLogon = $value; }

+}

+

+?>
\ No newline at end of file