From a3388622287e218beddfa14a47ed677d4307b36b Mon Sep 17 00:00:00 2001 From: Fabio Bas Date: Fri, 25 Mar 2016 17:55:51 +0100 Subject: Removed simpletest and moved all tests in the unit tree Tests are executed now, but a lot of them need fixing. --- tests/unit/Data/SqlMap/maps/MySql/Account.xml | 624 ++++++++++++++++++++ tests/unit/Data/SqlMap/maps/MySql/ActiveRecord.xml | 16 + tests/unit/Data/SqlMap/maps/MySql/Category.xml | 162 ++++++ tests/unit/Data/SqlMap/maps/MySql/Complex.xml | 23 + tests/unit/Data/SqlMap/maps/MySql/Document.xml | 53 ++ .../unit/Data/SqlMap/maps/MySql/DynamicAccount.xml | 449 +++++++++++++++ tests/unit/Data/SqlMap/maps/MySql/Enumeration.xml | 59 ++ tests/unit/Data/SqlMap/maps/MySql/LineItem.xml | 188 ++++++ tests/unit/Data/SqlMap/maps/MySql/Order.xml | 468 +++++++++++++++ tests/unit/Data/SqlMap/maps/MySql/Other.xml | 170 ++++++ tests/unit/Data/SqlMap/maps/MySql/ResultClass.xml | 130 +++++ tests/unit/Data/SqlMap/maps/mssql/Account.xml | 606 +++++++++++++++++++ tests/unit/Data/SqlMap/maps/mssql/Category.xml | 171 ++++++ tests/unit/Data/SqlMap/maps/mssql/Complex.xml | 21 + tests/unit/Data/SqlMap/maps/mssql/Document.xml | 53 ++ .../unit/Data/SqlMap/maps/mssql/DynamicAccount.xml | 438 ++++++++++++++ tests/unit/Data/SqlMap/maps/mssql/Enumeration.xml | 47 ++ tests/unit/Data/SqlMap/maps/mssql/LineItem.xml | 182 ++++++ tests/unit/Data/SqlMap/maps/mssql/Order.xml | 475 +++++++++++++++ tests/unit/Data/SqlMap/maps/mssql/Other.xml | 171 ++++++ tests/unit/Data/SqlMap/maps/mssql/ResultClass.xml | 125 ++++ tests/unit/Data/SqlMap/maps/sqlite/Account.xml | 641 +++++++++++++++++++++ .../unit/Data/SqlMap/maps/sqlite/ActiveRecord.xml | 16 + tests/unit/Data/SqlMap/maps/sqlite/Category.xml | 162 ++++++ tests/unit/Data/SqlMap/maps/sqlite/Complex.xml | 23 + tests/unit/Data/SqlMap/maps/sqlite/Document.xml | 53 ++ .../Data/SqlMap/maps/sqlite/DynamicAccount.xml | 447 ++++++++++++++ tests/unit/Data/SqlMap/maps/sqlite/Enumeration.xml | 55 ++ tests/unit/Data/SqlMap/maps/sqlite/LineItem.xml | 183 ++++++ tests/unit/Data/SqlMap/maps/sqlite/Order.xml | 503 ++++++++++++++++ tests/unit/Data/SqlMap/maps/sqlite/Other.xml | 170 ++++++ tests/unit/Data/SqlMap/maps/sqlite/ResultClass.xml | 130 +++++ tests/unit/Data/SqlMap/maps/tests.xml | 19 + 33 files changed, 7033 insertions(+) create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Account.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/ActiveRecord.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Category.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Complex.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Document.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/DynamicAccount.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Enumeration.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/LineItem.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Order.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/Other.xml create mode 100644 tests/unit/Data/SqlMap/maps/MySql/ResultClass.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Account.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Category.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Complex.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Document.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/DynamicAccount.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Enumeration.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/LineItem.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Order.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/Other.xml create mode 100644 tests/unit/Data/SqlMap/maps/mssql/ResultClass.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Account.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/ActiveRecord.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Category.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Complex.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Document.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/DynamicAccount.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Enumeration.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/LineItem.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Order.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/Other.xml create mode 100644 tests/unit/Data/SqlMap/maps/sqlite/ResultClass.xml create mode 100644 tests/unit/Data/SqlMap/maps/tests.xml (limited to 'tests/unit/Data/SqlMap/maps') diff --git a/tests/unit/Data/SqlMap/maps/MySql/Account.xml b/tests/unit/Data/SqlMap/maps/MySql/Account.xml new file mode 100644 index 00000000..d6dd1c1d --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Account.xml @@ -0,0 +1,624 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option) + values + (?, ?, ?, ?, ?, ?) + + + + update Accounts set + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_Id = ? + + + + update Accounts set + Account_Id = ?, + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_Id = ? + + + + delete from Accounts + where + Account_Id = #Id# + + + + + + + + + + + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress# + ) + + + + + + update Accounts set + Account_FirstName = #FirstName#, + Account_LastName = #LastName#, + Account_Email = #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com# + where + Account_Id = #Id# + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com# + ) + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + delete from Accounts + where Account_Id = #Id# + and Account_Id = #Id# + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT * + FROM + Accounts + + + + + INSERT INTO Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + VALUES(#Id#, #FirstName#, #LastName# + + + #EmailAddress# + + + null + + + ) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ps_InsertAccount + + + + ps_swap_email_address + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/ActiveRecord.xml b/tests/unit/Data/SqlMap/maps/MySql/ActiveRecord.xml new file mode 100644 index 00000000..1c48010f --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/ActiveRecord.xml @@ -0,0 +1,16 @@ + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/Category.xml b/tests/unit/Data/SqlMap/maps/MySql/Category.xml new file mode 100644 index 00000000..05c51fb5 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Category.xml @@ -0,0 +1,162 @@ + + + + + + + + + + + + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #GuidString:Varchar#); + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #GuidString:Varchar#) + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + + + + update Categories set + Category_Name =?, + Category_Guid = ? + where + Category_Id = ? + + + + ps_InsertCategorie + + + + + select LAST_INSERT_ID() as value + + + + + + + + + + + + + + + + + + select + Category_ID as Id, + Category_Name as Name, + Category_Guid as Guid + from Categories + + + Category_Guid=#GuidString:Varchar# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/MySql/Complex.xml b/tests/unit/Data/SqlMap/maps/MySql/Complex.xml new file mode 100644 index 00000000..c596e555 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Complex.xml @@ -0,0 +1,23 @@ + + + + + + + select Account_ID from Accounts where Account_ID = #obj.Map.Id# + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + (#obj.Map.acct.Id#, #obj.Map.acct.FirstName#, #obj.Map.acct.LastName#, #obj.Map.acct.EmailAddress:Varchar:no_email@provided.com# + ) + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/MySql/Document.xml b/tests/unit/Data/SqlMap/maps/MySql/Document.xml new file mode 100644 index 00000000..805ad9d4 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Document.xml @@ -0,0 +1,53 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + * + from Documents + order by Document_Type, Document_Id + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/DynamicAccount.xml b/tests/unit/Data/SqlMap/maps/MySql/DynamicAccount.xml new file mode 100644 index 00000000..5696ac65 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/DynamicAccount.xml @@ -0,0 +1,449 @@ + + + + + + + + + + + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = 'Joe' + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + + + $statement$ + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #Ids[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + and Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + Account_ID in + + #Ids[]# + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + Account_Email = 'clinton.begin@ibatis.com' + + + Account_Email = #EmailAddress# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #[]# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #Id# + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + (Account_FirstName = #FirstName# + + Account_LastName = #LastName# + + ) + + + Account_Email like #EmailAddress# + + + Account_ID = #Id# + + + order by Account_LastName + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + ((Account_ID $Operande$ #NumberSearch#) or + (Account_ID $Operande$ #NumberSearch#)) + + + = #StartDate# ]]> + + + = #StartDate# ]]> + + + + order by Account_LastName + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/Enumeration.xml b/tests/unit/Data/SqlMap/maps/MySql/Enumeration.xml new file mode 100644 index 00000000..930f2e5e --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Enumeration.xml @@ -0,0 +1,59 @@ + + + + + + + + + + + + + + + + + + + + + + + + insert into Enumerations + (Enum_ID, Enum_Day, Enum_Color, Enum_Month) + values + (?, ?, ?, ?) + + + + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/MySql/LineItem.xml b/tests/unit/Data/SqlMap/maps/MySql/LineItem.xml new file mode 100644 index 00000000..c29524c2 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/LineItem.xml @@ -0,0 +1,188 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + LineItem_Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + order by LineItem_Code + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price, + LineItem_Picture as PictureData + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + + + select + LineItem_ID, + LineItem_Code, + LineItem_Quantity, + LineItem_Price + from LineItems + where LineItem_ID = #value# + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price, LineItem_Picture) + values + (?, ?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + + + + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + + + + + delete from LineItems where Order_ID = 10; + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/Order.xml b/tests/unit/Data/SqlMap/maps/MySql/Order.xml new file mode 100644 index 00000000..a62df9e1 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Order.xml @@ -0,0 +1,468 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select * from Orders where Order_Id = #value# + + + + select Order_Date from Orders where Order_Id = #value# + + + + select + Order_Id, + Order_Date, + Order_CardExpiry, + Order_CardType, + Order_CardNumber, + Order_Street, + Order_City, + Order_Province, + Order_PostalCode + from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders + + + + select + Order_Date as 'datetime' + from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select * from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select + Orders.Order_Id as Id, + Order_Date as Date, + Order_CardExpiry as CardExpiry, + Order_CardType as CardType, + Order_CardNumber as CardNumber, + Order_Street as Street, + Order_City as City, + Order_Province as Province, + Order_PostalCode as PostalCode, + LineItem_ID as "FavouriteLineItem.Id", + LineItem_Code as "FavouriteLineItem.Code", + LineItem_Quantity as "FavouriteLineItem.Quantity", + LineItem_Price as "FavouriteLineItem.Price" + from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select distinct Order_CardNumber from Orders + order by Order_CardNumber + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (#Id#, #Account.Id#, #Date#, #CardExpiry#, #CardType#, #CardNumber#, #Street#, #City#, #Province#, #PostalCode#) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/MySql/Other.xml b/tests/unit/Data/SqlMap/maps/MySql/Other.xml new file mode 100644 index 00000000..67862029 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/Other.xml @@ -0,0 +1,170 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + + + Other_Int = #year# + + + + Other_Long = #areaid# + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Bit = #Bool# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, 'Yes') + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( ?, ?, ?, ?) + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,type=bool,dbType=Varchar#) + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,typeHandler=OuiNonBool#) + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/MySql/ResultClass.xml b/tests/unit/Data/SqlMap/maps/MySql/ResultClass.xml new file mode 100644 index 00000000..3f82ac5f --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/MySql/ResultClass.xml @@ -0,0 +1,130 @@ + + + + + + select 1 from Orders where Order_ID = #dummy# + + + + + + select 155 from Orders where Order_ID = #value# + + + + + + + select cast('a' as char) from Orders where Order_ID = #value# + + + + + + select '2003-02-15 8:15:00' as datetime from Orders where Order_ID = #value# + + + + + + select 1.56 from Orders where Order_ID = #value# + + + + + + select 99.5 from Orders where Order_ID= #value# + + + + + + + select cast('CD5ABF17-4BBC-4C86-92F1-257735414CF4' as binary) from Orders where Order_ID = #value# + + + + + + select 32111 from Orders where Order_ID = #value# + + + + + + select 999999 from Orders where Order_ID = #value# + + + + + + select 9223372036854775800 from Orders where Order_ID = #value# + + + + + + select 92233.5 from Orders where Order_ID = #value# + + + + + + select 'VISA' + from Orders where Order_ID = #value# + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/Account.xml b/tests/unit/Data/SqlMap/maps/mssql/Account.xml new file mode 100644 index 00000000..8149d228 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Account.xml @@ -0,0 +1,606 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option) + values + (?, ?, ?, ?, ?, ?) + + + + update Accounts set + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_ID = ? + + + + update Accounts set + Account_ID = ?, + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_ID = ? + + + + delete from Accounts + where + Account_ID = #Id# + + + + + + + + + + + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress# + ) + + + + + update Accounts set + Account_FirstName = #FirstName#, + Account_LastName = #LastName#, + Account_Email = #EmailAddress, nullValue=no_email@provided.com# + where + Account_ID = #Id# + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress, nullValue=no_email@provided.com# + ) + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + delete from Accounts + where Account_ID = #Id, type=integer# + and Account_ID = #Id, type=integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + Accounts + + + + + INSERT INTO Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + VALUES(#Id#, #FirstName#, #LastName# + + + #EmailAddress# + + + null + + + ) + + + + + ps_InsertAccount + + + + ps_swap_email_address + + + + ps_SelectAccount + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/Category.xml b/tests/unit/Data/SqlMap/maps/mssql/Category.xml new file mode 100644 index 00000000..6756f1fa --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Category.xml @@ -0,0 +1,171 @@ + + + + + + + + + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #Guid:UniqueIdentifier#); + select SCOPE_IDENTITY() as value + + + + + insert into Categories + (Category_Name, Category_Guid) + values + ('toto', #value:UniqueIdentifier#); + select SCOPE_IDENTITY() as value + + + + + insert into Categories + (Category_Name, Category_Guid) + values + ('toto', #value#); + select SCOPE_IDENTITY() as value + + + + + ${selectKey} + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #Guid:UniqueIdentifier#) + + + + + ${selectKey} + + insert into Categories + (Category_Name, Category_Guid) + values + (${MyCategoryName}, #Guid:UniqueIdentifier#) + + + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + select SCOPE_IDENTITY() as value + + + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + select SCOPE_IDENTITY() as value + + + + update Categories set + Category_Name =?, + Category_Guid = ? + where + Category_Id = ? + + + + ps_InsertCategorie + + + + + select @@IDENTITY as value + + + + + + + + + + + + + + + + + + select + Category_ID as Id, + Category_Name as Name, + Category_Guid as Guid + from Categories + + + Category_Guid=#Guid:UniqueIdentifier# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/mssql/Complex.xml b/tests/unit/Data/SqlMap/maps/mssql/Complex.xml new file mode 100644 index 00000000..91b346ca --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Complex.xml @@ -0,0 +1,21 @@ + + + + + + select Account_ID from Accounts where Account_ID = #obj.Map.Id# + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + (#obj.Map.acct.Id#, #obj.Map.acct.FirstName#, #obj.Map.acct.LastName#, #obj.Map.acct.EmailAddress:VarChar:no_email@provided.com# + ) + + + + + diff --git a/tests/unit/Data/SqlMap/maps/mssql/Document.xml b/tests/unit/Data/SqlMap/maps/mssql/Document.xml new file mode 100644 index 00000000..de02c1ab --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Document.xml @@ -0,0 +1,53 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/DynamicAccount.xml b/tests/unit/Data/SqlMap/maps/mssql/DynamicAccount.xml new file mode 100644 index 00000000..492cd0c8 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/DynamicAccount.xml @@ -0,0 +1,438 @@ + + + + + + + + + SELECT + Account_ID as Id, + + + Account_FirstName as FirstName, + + + Account_LastName as LastName, + + + + Account_Email as EmailAddress + FROM + Accounts + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = 'Joe' + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + + + $statement$ + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #Ids[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + and Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + Account_ID in + + #Ids[]# + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + Account_Email = 'clinton.begin@ibatis.com' + + + Account_Email = #EmailAddress# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #[]# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #Id# + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + (Account_FirstName = #FirstName# + + Account_LastName = #LastName# + + ) + + + Account_Email like #EmailAddress# + + + Account_ID = #Id# + + + order by Account_LastName + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + ((Account_ID $Operande$ #NumberSearch#) or + (Account_ID $Operande$ #NumberSearch#)) + + + = #StartDate# ]]> + + + = #StartDate# ]]> + + + + order by Account_LastName + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/Enumeration.xml b/tests/unit/Data/SqlMap/maps/mssql/Enumeration.xml new file mode 100644 index 00000000..c010a8eb --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Enumeration.xml @@ -0,0 +1,47 @@ + + + + + + + + + + + + + + + + insert into Enumerations + (Enum_ID, Enum_Day, Enum_Color, Enum_Month) + values + (?, ?, ?, ?) + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/mssql/LineItem.xml b/tests/unit/Data/SqlMap/maps/mssql/LineItem.xml new file mode 100644 index 00000000..33cb9294 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/LineItem.xml @@ -0,0 +1,182 @@ + + + + + + + + + + + + + + + + + + + + + + + + select + LineItem_Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + order by LineItem_Code + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price, + LineItem_Picture as PictureData + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + + + select + LineItem_ID, + LineItem_Code, + LineItem_Quantity, + LineItem_Price + from LineItems + where LineItem_ID = #value# + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price, LineItem_Picture) + values + (?, ?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, dbType=Decimal#) + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + + + + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, dbType=Decimal#) + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, dbType=Decimal#) + + + + + + delete from LineItems where Order_ID = 10 + + delete from LineItems where Order_ID = 9 + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/Order.xml b/tests/unit/Data/SqlMap/maps/mssql/Order.xml new file mode 100644 index 00000000..87a2d1a0 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Order.xml @@ -0,0 +1,475 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select Order_Date from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select + Order_ID, + Order_Date, + Order_CardExpiry, + Order_CardType, + Order_CardNumber, + Order_Street, + Order_City, + Order_Province, + Order_PostalCode + from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders + + + + select + Order_Date as datetime + from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders, LineItems + where Orders.Order_ID = LineItems.Order_ID + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_ID = #value# + + + + select * from Orders, LineItems + where Orders.Order_ID = LineItems.Order_ID + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_ID = #value# + + + + select + Orders.Order_ID as Id, + Order_Date as Date, + Order_CardExpiry as CardExpiry, + Order_CardType as CardType, + Order_CardNumber as CardNumber, + Order_Street as Street, + Order_City as City, + Order_Province as Province, + Order_PostalCode as PostalCode, + LineItem_ID as "FavouriteLineItem.Id", + LineItem_Code as "FavouriteLineItem.Code", + LineItem_Quantity as "FavouriteLineItem.Quantity", + LineItem_Price as "FavouriteLineItem.Price" + from Orders, LineItems + where Orders.Order_ID = LineItems.Order_ID + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select * from Orders where Order_ID = #value# + + + + select distinct Order_CardNumber from Orders + order by Order_CardNumber + + + + insert into Orders + (Order_ID, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_ID, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_ID, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (#Id#, #Account.Id#, #Date#, #CardExpiry#, #CardType#, #CardNumber#, #Street#, #City#, #Province#, #PostalCode#) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select * from Orders where Order_ID = #value# + + + + + + + + select * from Orders where Order_ID = #value# + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/mssql/Other.xml b/tests/unit/Data/SqlMap/maps/mssql/Other.xml new file mode 100644 index 00000000..5d64f357 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/Other.xml @@ -0,0 +1,171 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + + + Other_Int = #year# + + + + Other_Long = #areaid# + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Bit = #Bool# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, 'Yes') + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( ?, ?, ?, ?) + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,type=bool,dbType=Varchar#) + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,typeHandler=OuiNonBool#) + + + + + + + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/mssql/ResultClass.xml b/tests/unit/Data/SqlMap/maps/mssql/ResultClass.xml new file mode 100644 index 00000000..ac705ac1 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/mssql/ResultClass.xml @@ -0,0 +1,125 @@ + + + + + + select cast(1 as bit) from Orders where Order_ID = #dummy# + + + + + + select cast(155 as tinyint) from Orders where Order_ID = #value# + + + + + + select cast('a' as char) from Orders where Order_ID = #value# + + + + + + + select cast('2003-02-15 8:15:00' as datetime) as datetime from Orders where Order_ID = #value# + + + + + + select cast(1.56 as decimal(9,2)) from Orders where Order_ID = #value# + + + + + + select cast(99.5 as float) from Orders where Order_ID= #value# + + + + + + select cast('CD5ABF17-4BBC-4C86-92F1-257735414CF4' as UniqueIdentifier) from Orders where Order_ID = #value# + + + + + + select cast(32111 as SmallInt) from Orders where Order_ID = #value# + + + + + + select cast(999999 as int) from Orders where Order_ID = #value# + + + + + + select cast(9223372036854775800 as bigint) from Orders where Order_ID = #value# + + + + + + select cast(92233.5 as real) from Orders where Order_ID = #value# + + + + + + select 'VISA' + from Orders where Order_ID = #value# + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Account.xml b/tests/unit/Data/SqlMap/maps/sqlite/Account.xml new file mode 100644 index 00000000..aa175459 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Account.xml @@ -0,0 +1,641 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option) + values + (?, ?, ?, ?, ?, ?) + + + + update Accounts set + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_Id = ? + + + + update Accounts set + Account_Id = ?, + Account_FirstName = ?, + Account_LastName = ?, + Account_Email = ? + where + Account_Id = ? + + + + delete from Accounts + where + Account_Id = #Id# + + + + + + + + + + + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress# + ) + + + + + + update Accounts set + Account_FirstName = #FirstName#, + Account_LastName = #LastName#, + Account_Email = #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com# + where + Account_Id = #Id# + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + (#Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com# + ) + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + insert into Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + values + ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# ) + + + + delete from Accounts + where Account_Id = #Id# + and Account_Id = #Id# + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT * + FROM + Accounts + + + + + INSERT INTO Accounts + (Account_Id, Account_FirstName, Account_LastName, Account_Email) + VALUES(#Id#, #FirstName#, #LastName# + + + #EmailAddress# + + + null + + + ) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ps_InsertAccount + + + + ps_swap_email_address + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/ActiveRecord.xml b/tests/unit/Data/SqlMap/maps/sqlite/ActiveRecord.xml new file mode 100644 index 00000000..1c48010f --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/ActiveRecord.xml @@ -0,0 +1,16 @@ + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Category.xml b/tests/unit/Data/SqlMap/maps/sqlite/Category.xml new file mode 100644 index 00000000..05c51fb5 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Category.xml @@ -0,0 +1,162 @@ + + + + + + + + + + + + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #GuidString:Varchar#); + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (#Name#, #GuidString:Varchar#) + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + + + + + + select LAST_INSERT_ID() as value + + insert into Categories + (Category_Name, Category_Guid) + values + (?,?); + + + + update Categories set + Category_Name =?, + Category_Guid = ? + where + Category_Id = ? + + + + ps_InsertCategorie + + + + + select LAST_INSERT_ID() as value + + + + + + + + + + + + + + + + + + select + Category_ID as Id, + Category_Name as Name, + Category_Guid as Guid + from Categories + + + Category_Guid=#GuidString:Varchar# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Complex.xml b/tests/unit/Data/SqlMap/maps/sqlite/Complex.xml new file mode 100644 index 00000000..c596e555 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Complex.xml @@ -0,0 +1,23 @@ + + + + + + + select Account_ID from Accounts where Account_ID = #obj.Map.Id# + + + + insert into Accounts + (Account_ID, Account_FirstName, Account_LastName, Account_Email) + values + (#obj.Map.acct.Id#, #obj.Map.acct.FirstName#, #obj.Map.acct.LastName#, #obj.Map.acct.EmailAddress:Varchar:no_email@provided.com# + ) + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Document.xml b/tests/unit/Data/SqlMap/maps/sqlite/Document.xml new file mode 100644 index 00000000..83028e05 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Document.xml @@ -0,0 +1,53 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + * + from Documents + order by Document_Type, Document_Id + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/DynamicAccount.xml b/tests/unit/Data/SqlMap/maps/sqlite/DynamicAccount.xml new file mode 100644 index 00000000..429a745a --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/DynamicAccount.xml @@ -0,0 +1,447 @@ + + + + + + + + + + + + + + + + SELECT + Account_ID as Id, + + + Account_FirstName as FirstName, + + + Account_LastName as LastName, + + + + Account_Email as EmailAddress + FROM + Accounts + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = 'Joe' + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_FirstName = #value# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + where Account_ID = 1 + + + + + + + $statement$ + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #Ids[]# + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + WHERE Account_ID IN + + #[]# + + and Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + Account_ID in + + #Ids[]# + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + Account_Email = 'clinton.begin@ibatis.com' + + + Account_Email = #EmailAddress# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + Account_ID IN + + #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #[]# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #[]# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + + Account_ID = #Id# + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + Account_ID = #Id# + + + + + Account_FirstName = #FirstName# + + + Account_LastName = #LastName# + + + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + (Account_FirstName = #FirstName# + + Account_LastName = #LastName# + + ) + + + Account_Email like #EmailAddress# + + + Account_ID = #Id# + + + order by Account_LastName + + + + select + Account_ID as Id, + Account_FirstName as FirstName, + Account_LastName as LastName, + Account_Email as EmailAddress + from Accounts + + + ((Account_ID $Operande$ #NumberSearch#) or + (Account_ID $Operande$ #NumberSearch#)) + + + = #StartDate# ]]> + + + = #StartDate# ]]> + + + + order by Account_LastName + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Enumeration.xml b/tests/unit/Data/SqlMap/maps/sqlite/Enumeration.xml new file mode 100644 index 00000000..58391c5d --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Enumeration.xml @@ -0,0 +1,55 @@ + + + + + + + + + + + + + + + + + + + + insert into Enumerations + (Enum_ID, Enum_Day, Enum_Color, Enum_Month) + values + (?, ?, ?, ?) + + + + + + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/sqlite/LineItem.xml b/tests/unit/Data/SqlMap/maps/sqlite/LineItem.xml new file mode 100644 index 00000000..95cc4af7 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/LineItem.xml @@ -0,0 +1,183 @@ + + + + + + + + + + + + + + + + + + + + + + + + + select + LineItem_Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems where Order_ID = #value# + order by LineItem_Code + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + select + LineItem_ID as Id, + LineItem_Code as Code, + LineItem_Quantity as Quantity, + LineItem_Price as Price, + LineItem_Picture as PictureData + from LineItems + where Order_ID = #Order_ID# + and LineItem_ID = #LineItem_ID# + + + + + + select + LineItem_ID, + LineItem_Code, + LineItem_Quantity, + LineItem_Price + from LineItems + where LineItem_ID = #value# + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price, LineItem_Picture) + values + (?, ?, ?, ?, ?, ?); + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + + + + + select 99 from LineItems where LineItem_ID = 1 and Order_ID=1 + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + + + insert into LineItems + (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price) + values + (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#) + + + + + + delete from LineItems where Order_ID = 10; + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Order.xml b/tests/unit/Data/SqlMap/maps/sqlite/Order.xml new file mode 100644 index 00000000..17b45d35 --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Order.xml @@ -0,0 +1,503 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select * from Orders where Order_Id = #value# + + + + select Order_Date from Orders where Order_Id = #value# + + + + select + Order_Id, + Order_Date, + Order_CardExpiry, + Order_CardType, + Order_CardNumber, + Order_Street, + Order_City, + Order_Province, + Order_PostalCode + from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders + + + + select + Order_Date as 'datetime' + from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select + Orders.Order_Id as Order_Id, + Orders.Account_Id as Account_Id, + Orders.Order_Date as Order_Date, + Orders.Order_CardType as Order_CardType, + Orders.Order_CardNumber as Order_CardNumber, + Orders.Order_CardExpiry as Order_CardExpiry, + Orders.Order_Street as Order_Street, + Orders.Order_City as Order_City, + Orders.Order_Province as Order_Province, + Orders.Order_PostalCode as Order_PostalCode, + Orders.Order_FavouriteLineItem as Order_FavouriteLineItem, + LineItems.LineItem_Id as LineItem_Id, + LineItems.Order_Id as Order_Id, + LineItems.LineItem_Code as LineItem_Code, + LineItems.LineItem_Quantity as LineItem_Quantity, + LineItems.LineItem_Price as LineItem_Price, + LineItems.LineItem_Picture as LineItem_Picture + + from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select + + Orders.Order_Id as Order_Id, + Orders.Account_Id as Account_Id, + Orders.Order_Date as Order_Date, + Orders.Order_CardType as Order_CardType, + Orders.Order_CardNumber as Order_CardNumber, + Orders.Order_CardExpiry as Order_CardExpiry, + Orders.Order_Street as Order_Street, + Orders.Order_City as Order_City, + Orders.Order_Province as Order_Province, + Orders.Order_PostalCode as Order_PostalCode, + Orders.Order_FavouriteLineItem as Order_FavouriteLineItem, + LineItems.LineItem_Id as LineItem_Id, + LineItems.Order_Id as Order_Id, + LineItems.LineItem_Code as LineItem_Code, + LineItems.LineItem_Quantity as LineItem_Quantity, + LineItems.LineItem_Price as LineItem_Price, + LineItems.LineItem_Picture as LineItem_Picture + + from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select + Orders.Order_Id as Id, + Order_Date as Date, + Order_CardExpiry as CardExpiry, + Order_CardType as CardType, + Order_CardNumber as CardNumber, + Order_Street as Street, + Order_City as City, + Order_Province as Province, + Order_PostalCode as PostalCode, + LineItem_ID as "FavouriteLineItem.Id", + LineItem_Code as "FavouriteLineItem.Code", + LineItem_Quantity as "FavouriteLineItem.Quantity", + LineItem_Price as "FavouriteLineItem.Price" + from Orders, LineItems + where Orders.Order_Id = LineItems.Order_Id + and Order_FavouriteLineItem = LineItems.LineItem_ID + and Orders.Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select * from Orders where Order_Id = #value# + + + + select distinct Order_CardNumber from Orders + order by Order_CardNumber + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) + + + + insert into Orders + (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType, + Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode ) + values + (#Id#, #Account.Id#, #Date#, #CardExpiry#, #CardType#, #CardNumber#, #Street#, #City#, #Province#, #PostalCode#) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/sqlite/Other.xml b/tests/unit/Data/SqlMap/maps/sqlite/Other.xml new file mode 100644 index 00000000..f8683f7e --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/Other.xml @@ -0,0 +1,170 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + + + Other_Int = #year# + + + + Other_Long = #areaid# + + + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Bit = #Bool# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, 'Yes') + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( ?, ?, ?, ?) + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + select + Other_Int, + Other_Long, + Other_Bit, + Other_String + from Others + Where Other_Int = #value# + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,type=bool,dbType=Varchar#) + + + + Insert into Others + ( Other_Int, Other_Long, Other_Bit, Other_String ) + values + ( #Int#, #Long#, #Bool#, #Bool2,typeHandler=OuiNonBool#) + + + + + + + + + diff --git a/tests/unit/Data/SqlMap/maps/sqlite/ResultClass.xml b/tests/unit/Data/SqlMap/maps/sqlite/ResultClass.xml new file mode 100644 index 00000000..8be5fcca --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/sqlite/ResultClass.xml @@ -0,0 +1,130 @@ + + + + + + select 1 from Orders where Order_ID = #dummy# + + + + + + select 155 from Orders where Order_ID = #value# + + + + + + + select 'a' from Orders where Order_ID = #value# + + + + + + select '2003-02-15 8:15:00' as datetime from Orders where Order_ID = #value# + + + + + + select 1.56 from Orders where Order_ID = #value# + + + + + + select 99.5 from Orders where Order_ID= #value# + + + + + + + select cast('CD5ABF17-4BBC-4C86-92F1-257735414CF4' as binary) from Orders where Order_ID = #value# + + + + + + select 32111 from Orders where Order_ID = #value# + + + + + + select 999999 from Orders where Order_ID = #value# + + + + + + select 9223372036854775800 from Orders where Order_ID = #value# + + + + + + select 92233.5 from Orders where Order_ID = #value# + + + + + + select 'VISA' + from Orders where Order_ID = #value# + + + + + \ No newline at end of file diff --git a/tests/unit/Data/SqlMap/maps/tests.xml b/tests/unit/Data/SqlMap/maps/tests.xml new file mode 100644 index 00000000..d2f45c2f --- /dev/null +++ b/tests/unit/Data/SqlMap/maps/tests.xml @@ -0,0 +1,19 @@ + + + + + = #fromdt# and img_requested_ap_dt <= #todt#) + ]]> + + + + + \ No newline at end of file -- cgit v1.2.3