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. --- .../simple_unit/SqlMap/scripts/mysql/DataBase.sql | 356 --------------------- .../SqlMap/scripts/mysql/account-init.sql | 7 - .../SqlMap/scripts/mysql/account-procedure.sql | 1 - .../SqlMap/scripts/mysql/category-init.sql | 1 - .../SqlMap/scripts/mysql/category-procedure.sql | 0 .../SqlMap/scripts/mysql/documents-init.sql | 8 - .../SqlMap/scripts/mysql/enumeration-init.sql | 6 - .../SqlMap/scripts/mysql/line-item-init.sql | 24 -- .../SqlMap/scripts/mysql/more-account-records.sql | 7 - .../SqlMap/scripts/mysql/order-init.sql | 15 - .../SqlMap/scripts/mysql/other-init.sql | 18 -- .../SqlMap/scripts/mysql/swap-procedure.sql | 0 .../simple_unit/SqlMap/scripts/mysql/user-init.sql | 2 - 13 files changed, 445 deletions(-) delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/DataBase.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/account-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/account-procedure.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/category-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/category-procedure.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/enumeration-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/more-account-records.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/order-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/other-init.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/swap-procedure.sql delete mode 100644 tests/simple_unit/SqlMap/scripts/mysql/user-init.sql (limited to 'tests/simple_unit/SqlMap/scripts/mysql') diff --git a/tests/simple_unit/SqlMap/scripts/mysql/DataBase.sql b/tests/simple_unit/SqlMap/scripts/mysql/DataBase.sql deleted file mode 100644 index 2cf1e502..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/DataBase.sql +++ /dev/null @@ -1,356 +0,0 @@ --- --- Table structure for table `A` --- - -DROP TABLE IF EXISTS `A`; -CREATE TABLE `A` ( - `ID` varchar(50) NOT NULL, - `B_ID` varchar(50) default NULL, - `E_ID` varchar(50) default NULL, - `F_ID` varchar(50) default NULL, - `A_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`), - KEY `FK_A_B` (`B_ID`), - KEY `FK_A_E` (`E_ID`), - KEY `FK_A_F` (`F_ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `A` --- - -INSERT INTO `A` (`ID`, `B_ID`, `E_ID`, `F_ID`, `A_Libelle`) VALUES ('a', 'b', 'e', NULL, 'aaa'); - --- -------------------------------------------------------- - --- --- Table structure for table `Accounts` --- - -DROP TABLE IF EXISTS `Accounts`; -CREATE TABLE `Accounts` ( - `Account_Id` int(11) NOT NULL, - `Account_FirstName` varchar(32) NOT NULL, - `Account_LastName` varchar(32) NOT NULL, - `Account_Email` varchar(128) default NULL, - `Account_Banner_Option` varchar(255) default NULL, - `Account_Cart_Option` int(11) default NULL, - PRIMARY KEY (`Account_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Accounts` --- - -INSERT INTO `Accounts` (`Account_Id`, `Account_FirstName`, `Account_LastName`, `Account_Email`, `Account_Banner_Option`, `Account_Cart_Option`) VALUES (1, 'Joe', 'Dalton', 'Joe.Dalton@somewhere.com', 'Oui', 200), -(2, 'Averel', 'Dalton', 'Averel.Dalton@somewhere.com', 'Oui', 200), -(3, 'William', 'Dalton', NULL, 'Non', 100), -(4, 'Jack', 'Dalton', 'Jack.Dalton@somewhere.com', 'Non', 100), -(5, 'Gilles', 'Bayon', NULL, 'Oui', 100); - --- -------------------------------------------------------- - --- --- Table structure for table `B` --- - -DROP TABLE IF EXISTS `B`; -CREATE TABLE `B` ( - `ID` varchar(50) NOT NULL, - `C_ID` varchar(50) default NULL, - `D_ID` varchar(50) default NULL, - `B_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`), - KEY `FK_B_C` (`C_ID`), - KEY `FK_B_D` (`D_ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `B` --- - -INSERT INTO `B` (`ID`, `C_ID`, `D_ID`, `B_Libelle`) VALUES ('b', 'c', NULL, 'bbb'); - --- -------------------------------------------------------- - --- --- Table structure for table `C` --- - -DROP TABLE IF EXISTS `C`; -CREATE TABLE `C` ( - `ID` varchar(50) NOT NULL, - `C_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `C` --- - -INSERT INTO `C` (`ID`, `C_Libelle`) VALUES ('c', 'ccc'); - --- -------------------------------------------------------- - --- --- Table structure for table `Categories` --- - -DROP TABLE IF EXISTS `Categories`; -CREATE TABLE `Categories` ( - `Category_Id` int(11) NOT NULL auto_increment, - `Category_Name` varchar(32) default NULL, - `Category_Guid` varchar(36) default NULL, - PRIMARY KEY (`Category_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; - --- --- Dumping data for table `Categories` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `D` --- - -DROP TABLE IF EXISTS `D`; -CREATE TABLE `D` ( - `ID` varchar(50) NOT NULL, - `D_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `D` --- - -INSERT INTO `D` (`ID`, `D_Libelle`) VALUES ('d', 'ddd'); - --- -------------------------------------------------------- - --- --- Table structure for table `Documents` --- - -DROP TABLE IF EXISTS `Documents`; -CREATE TABLE `Documents` ( - `Document_Id` int(11) NOT NULL, - `Document_Title` varchar(32) default NULL, - `Document_Type` varchar(32) default NULL, - `Document_PageNumber` int(11) default NULL, - `Document_City` varchar(32) default NULL, - PRIMARY KEY (`Document_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Documents` --- - -INSERT INTO `Documents` (`Document_Id`, `Document_Title`, `Document_Type`, `Document_PageNumber`, `Document_City`) VALUES (1, 'The World of Null-A', 'Book', 55, NULL), -(2, 'Le Progres de Lyon', 'Newspaper', NULL, 'Lyon'), -(3, 'Lord of the Rings', 'Book', 3587, NULL), -(4, 'Le Canard enchaine', 'Tabloid', NULL, 'Paris'), -(5, 'Le Monde', 'Broadsheet', NULL, 'Paris'), -(6, 'Foundation', 'Monograph', 557, NULL); - --- -------------------------------------------------------- - --- --- Table structure for table `E` --- - -DROP TABLE IF EXISTS `E`; -CREATE TABLE `E` ( - `ID` varchar(50) NOT NULL, - `E_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `E` --- - -INSERT INTO `E` (`ID`, `E_Libelle`) VALUES ('e', 'eee'); - --- -------------------------------------------------------- - --- --- Table structure for table `Enumerations` --- - -DROP TABLE IF EXISTS `Enumerations`; -CREATE TABLE `Enumerations` ( - `Enum_Id` int(11) NOT NULL, - `Enum_Day` int(11) NOT NULL, - `Enum_Color` int(11) NOT NULL, - `Enum_Month` int(11) default NULL, - PRIMARY KEY (`Enum_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Enumerations` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `F` --- - -DROP TABLE IF EXISTS `F`; -CREATE TABLE `F` ( - `ID` varchar(50) NOT NULL, - `F_Libelle` varchar(50) default NULL, - PRIMARY KEY (`ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `F` --- - -INSERT INTO `F` (`ID`, `F_Libelle`) VALUES ('f', 'fff'); - --- -------------------------------------------------------- - --- --- Table structure for table `LineItems` --- - -DROP TABLE IF EXISTS `LineItems`; -CREATE TABLE `LineItems` ( - `LineItem_Id` int(11) NOT NULL, - `Order_Id` int(11) NOT NULL, - `LineItem_Code` varchar(32) NOT NULL, - `LineItem_Quantity` int(11) NOT NULL, - `LineItem_Price` decimal(18,2) default NULL, - `LineItem_Picture` blob, - PRIMARY KEY (`Order_Id`,`LineItem_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `LineItems` --- - -INSERT INTO `LineItems` (`LineItem_Id`, `Order_Id`, `LineItem_Code`, `LineItem_Quantity`, `LineItem_Price`, `LineItem_Picture`) VALUES (1, 1, 'ESM-48', 8, 87.60, NULL), -(2, 1, 'ESM-23', 1, 55.40, NULL), -(1, 2, 'DSM-37', 4, 7.80, NULL), -(2, 2, 'FSM-12', 2, 55.78, NULL), -(1, 3, 'DSM-59', 3, 5.70, NULL), -(2, 3, 'DSM-53', 3, 98.78, NULL), -(1, 4, 'RSM-57', 2, 78.90, NULL), -(2, 4, 'XSM-78', 9, 2.34, NULL), -(1, 5, 'ESM-48', 3, 43.87, NULL), -(2, 5, 'WSM-98', 7, 5.40, NULL), -(1, 6, 'QSM-39', 9, 12.12, NULL), -(2, 6, 'ASM-45', 6, 78.77, NULL), -(1, 7, 'WSM-27', 7, 52.10, NULL), -(2, 7, 'ESM-23', 2, 123.34, NULL), -(1, 8, 'DSM-16', 4, 41.30, NULL), -(2, 8, 'GSM-65', 1, 2.20, NULL), -(1, 9, 'DSM-78', 2, 45.40, NULL), -(2, 9, 'TSM-12', 2, 32.12, NULL), -(1, 10, 'ESM-34', 1, 45.43, NULL), -(2, 10, 'QSM-98', 8, 8.40, NULL); - --- -------------------------------------------------------- - --- --- Table structure for table `Orders` --- - -DROP TABLE IF EXISTS `Orders`; -CREATE TABLE `Orders` ( - `Order_Id` int(11) NOT NULL, - `Account_Id` int(11) default NULL, - `Order_Date` datetime default NULL, - `Order_CardType` varchar(32) default NULL, - `Order_CardNumber` varchar(32) default NULL, - `Order_CardExpiry` varchar(32) default NULL, - `Order_Street` varchar(32) default NULL, - `Order_City` varchar(32) default NULL, - `Order_Province` varchar(32) default NULL, - `Order_PostalCode` varchar(32) default NULL, - `Order_FavouriteLineItem` int(11) default NULL, - PRIMARY KEY (`Order_Id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Orders` --- - -INSERT INTO `Orders` (`Order_Id`, `Account_Id`, `Order_Date`, `Order_CardType`, `Order_CardNumber`, `Order_CardExpiry`, `Order_Street`, `Order_City`, `Order_Province`, `Order_PostalCode`, `Order_FavouriteLineItem`) VALUES (1, 1, '2003-02-15 08:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4', 2), -(2, 4, '2003-02-15 08:15:00', 'MC', '888888888888', '06/03', '222 That Street', 'Edmonton', 'AB', 'X4K 5Y4', 1), -(3, 3, '2003-02-15 08:15:00', 'AMEX', '777777777777', '07/03', '333 Other Street', 'Regina', 'SK', 'Z4U 6Y4', 2), -(4, 2, '2003-02-15 08:15:00', 'MC', '666666666666', '08/03', '444 His Street', 'Toronto', 'ON', 'K4U 3S4', 1), -(5, 5, '2003-02-15 08:15:00', 'VISA', '555555555555', '09/03', '555 Her Street', 'Calgary', 'AB', 'J4J 7S4', 2), -(6, 5, '2003-02-15 08:15:00', 'VISA', '999999999999', '10/03', '6 Their Street', 'Victoria', 'BC', 'T4H 9G4', 1), -(7, 4, '2003-02-15 08:15:00', 'MC', '888888888888', '11/03', '77 Lucky Street', 'Edmonton', 'AB', 'R4A 0Z4', 2), -(8, 3, '2003-02-15 08:15:00', 'AMEX', '777777777777', '12/03', '888 Our Street', 'Regina', 'SK', 'S4S 7G4', 1), -(9, 2, '2003-02-15 08:15:00', 'MC', '666666666666', '01/04', '999 Your Street', 'Toronto', 'ON', 'G4D 9F4', 2), -(10, 1, '2003-02-15 08:15:00', 'VISA', '555555555555', '02/04', '99 Some Street', 'Calgary', 'AB', 'W4G 7A4', 1), -(11, NULL, '2003-02-15 08:15:00', 'VISA', '555555555555', '02/04', 'Null order', 'Calgary', 'ZZ', 'XXX YYY', 1); - --- -------------------------------------------------------- - --- --- Table structure for table `Others` --- - -DROP TABLE IF EXISTS `Others`; -CREATE TABLE `Others` ( - `Other_Int` int(11) default NULL, - `Other_Long` bigint(20) default NULL, - `Other_Bit` bit(1) NOT NULL default '\0', - `Other_String` varchar(32) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Others` --- - -INSERT INTO `Others` (`Other_Int`, `Other_Long`, `Other_Bit`, `Other_String`) VALUES (1, 8888888, '\0', 'Oui'), -(2, 9999999999, '', 'Non'), -(99, 1966, '', 'Non'); - --- -------------------------------------------------------- - --- --- Table structure for table `Users` --- - -DROP TABLE IF EXISTS `Users`; -CREATE TABLE `Users` ( - `LogonId` varchar(20) NOT NULL default '0', - `Name` varchar(40) default NULL, - `Password` varchar(20) default NULL, - `EmailAddress` varchar(40) default NULL, - `LastLogon` datetime default NULL, - PRIMARY KEY (`LogonId`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - --- --- Dumping data for table `Users` --- - - --- --- Constraints for dumped tables --- - --- --- Constraints for table `A` --- -ALTER TABLE `A` - ADD CONSTRAINT `FK_A_B` FOREIGN KEY (`B_ID`) REFERENCES `B` (`ID`), - ADD CONSTRAINT `FK_A_E` FOREIGN KEY (`E_ID`) REFERENCES `E` (`ID`), - ADD CONSTRAINT `FK_A_F` FOREIGN KEY (`F_ID`) REFERENCES `F` (`ID`); - --- --- Constraints for table `B` --- -ALTER TABLE `B` - ADD CONSTRAINT `FK_B_C` FOREIGN KEY (`C_ID`) REFERENCES `C` (`ID`), - ADD CONSTRAINT `FK_B_D` FOREIGN KEY (`D_ID`) REFERENCES `D` (`ID`); diff --git a/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql deleted file mode 100644 index afe8dab1..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/account-init.sql +++ /dev/null @@ -1,7 +0,0 @@ -TRUNCATE `Accounts`; - -INSERT INTO Accounts VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com', 'Oui', 200); -INSERT INTO Accounts VALUES(2,'Averel', 'Dalton', 'Averel.Dalton@somewhere.com', 'Oui', 200); -INSERT INTO Accounts VALUES(3,'William', 'Dalton', null, 'Non', 100); -INSERT INTO Accounts VALUES(4,'Jack', 'Dalton', 'Jack.Dalton@somewhere.com', 'Non', 100); -INSERT INTO Accounts VALUES(5,'Gilles', 'Bayon', null, 'Oui', 100); \ No newline at end of file diff --git a/tests/simple_unit/SqlMap/scripts/mysql/account-procedure.sql b/tests/simple_unit/SqlMap/scripts/mysql/account-procedure.sql deleted file mode 100644 index d3f5a12f..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/account-procedure.sql +++ /dev/null @@ -1 +0,0 @@ - diff --git a/tests/simple_unit/SqlMap/scripts/mysql/category-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/category-init.sql deleted file mode 100644 index 2030181d..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/category-init.sql +++ /dev/null @@ -1 +0,0 @@ -TRUNCATE `Categories`; diff --git a/tests/simple_unit/SqlMap/scripts/mysql/category-procedure.sql b/tests/simple_unit/SqlMap/scripts/mysql/category-procedure.sql deleted file mode 100644 index e69de29b..00000000 diff --git a/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql deleted file mode 100644 index 5a1cdb2a..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/documents-init.sql +++ /dev/null @@ -1,8 +0,0 @@ -TRUNCATE `Documents`; - -INSERT INTO Documents VALUES (1, 'The World of Null-A', 'Book', 55, null); -INSERT INTO Documents VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon'); -INSERT INTO Documents VALUES (3, 'Lord of the Rings', 'Book', 3587, null); -INSERT INTO Documents VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris'); -INSERT INTO Documents VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris'); -INSERT INTO Documents VALUES (6, 'Foundation', 'Monograph', 557, null); diff --git a/tests/simple_unit/SqlMap/scripts/mysql/enumeration-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/enumeration-init.sql deleted file mode 100644 index bc296957..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/enumeration-init.sql +++ /dev/null @@ -1,6 +0,0 @@ -TRUNCATE `Enumerations`; - -INSERT INTO Enumerations VALUES(1, 1, 1, 128); -INSERT INTO Enumerations VALUES(2, 2, 2, 2048); -INSERT INTO Enumerations VALUES(3, 3, 4, 256); -INSERT INTO Enumerations VALUES(4, 4, 8, null); diff --git a/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql deleted file mode 100644 index b0f7e424..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/line-item-init.sql +++ /dev/null @@ -1,24 +0,0 @@ - -TRUNCATE `LineItems`; - -INSERT INTO LineItems VALUES (1, 10, 'ESM-34', 1, 45.43, null); -INSERT INTO LineItems VALUES (2, 10, 'QSM-98', 8, 8.40, null); -INSERT INTO LineItems VALUES (1, 9, 'DSM-78', 2, 45.40, null); -INSERT INTO LineItems VALUES (2, 9, 'TSM-12', 2, 32.12, null); -INSERT INTO LineItems VALUES (1, 8, 'DSM-16', 4, 41.30, null); -INSERT INTO LineItems VALUES (2, 8, 'GSM-65', 1, 2.20, null); -INSERT INTO LineItems VALUES (1, 7, 'WSM-27', 7, 52.10, null); -INSERT INTO LineItems VALUES (2, 7, 'ESM-23', 2, 123.34, null); -INSERT INTO LineItems VALUES (1, 6, 'QSM-39', 9, 12.12, null); -INSERT INTO LineItems VALUES (2, 6, 'ASM-45', 6, 78.77, null); -INSERT INTO LineItems VALUES (1, 5, 'ESM-48', 3, 43.87, null); -INSERT INTO LineItems VALUES (2, 5, 'WSM-98', 7, 5.40, null); -INSERT INTO LineItems VALUES (1, 4, 'RSM-57', 2, 78.90, null); -INSERT INTO LineItems VALUES (2, 4, 'XSM-78', 9, 2.34, null); -INSERT INTO LineItems VALUES (1, 3, 'DSM-59', 3, 5.70, null); -INSERT INTO LineItems VALUES (2, 3, 'DSM-53', 3, 98.78, null); -INSERT INTO LineItems VALUES (1, 2, 'DSM-37', 4, 7.80, null); -INSERT INTO LineItems VALUES (2, 2, 'FSM-12', 2, 55.78, null); -INSERT INTO LineItems VALUES (1, 1, 'ESM-48', 8, 87.60, null); -INSERT INTO LineItems VALUES (2, 1, 'ESM-23', 1, 55.40, null); - diff --git a/tests/simple_unit/SqlMap/scripts/mysql/more-account-records.sql b/tests/simple_unit/SqlMap/scripts/mysql/more-account-records.sql deleted file mode 100644 index e9fd4ac2..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/more-account-records.sql +++ /dev/null @@ -1,7 +0,0 @@ - -INSERT INTO Accounts VALUES(6,'Jane', 'Calamity', 'Jane.Calamity@somewhere.com', 'Oui', 200); -INSERT INTO Accounts VALUES(7,'Lucky', 'Luke', 'Lucky.Luke@somewhere.com', 'Oui', 200); -INSERT INTO Accounts VALUES(8,'Ming', 'Li Foo', null, 'Non', 100); -INSERT INTO Accounts VALUES(9,'O''Hara', 'Steve', 'Jack.OHara@somewhere.com', 'Oui', 200); -INSERT INTO Accounts VALUES(10,'Robert', 'O''Timmins', null, 'Non', 100); - diff --git a/tests/simple_unit/SqlMap/scripts/mysql/order-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/order-init.sql deleted file mode 100644 index 5c23081f..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/order-init.sql +++ /dev/null @@ -1,15 +0,0 @@ -TRUNCATE `Orders`; - - -INSERT INTO Orders VALUES (1, 1, '2003-02-15 8:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4',2); -INSERT INTO Orders VALUES (2, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '06/03', '222 That Street', 'Edmonton', 'AB', 'X4K 5Y4',1); -INSERT INTO Orders VALUES (3, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '07/03', '333 Other Street', 'Regina', 'SK', 'Z4U 6Y4',2); -INSERT INTO Orders VALUES (4, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '08/03', '444 His Street', 'Toronto', 'ON', 'K4U 3S4',1); -INSERT INTO Orders VALUES (5, 5, '2003-02-15 8:15:00', 'VISA', '555555555555', '09/03', '555 Her Street', 'Calgary', 'AB', 'J4J 7S4',2); -INSERT INTO Orders VALUES (6, 5, '2003-02-15 8:15:00', 'VISA', '999999999999', '10/03', '6 Their Street', 'Victoria', 'BC', 'T4H 9G4',1); -INSERT INTO Orders VALUES (7, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '11/03', '77 Lucky Street', 'Edmonton', 'AB', 'R4A 0Z4',2); -INSERT INTO Orders VALUES (8, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '12/03', '888 Our Street', 'Regina', 'SK', 'S4S 7G4',1); -INSERT INTO Orders VALUES (9, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '01/04', '999 Your Street', 'Toronto', 'ON', 'G4D 9F4',2); -INSERT INTO Orders VALUES (10, 1, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', '99 Some Street', 'Calgary', 'AB', 'W4G 7A4',1); -INSERT INTO Orders VALUES (11, null, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', 'Null order', 'Calgary', 'ZZ', 'XXX YYY',1); - diff --git a/tests/simple_unit/SqlMap/scripts/mysql/other-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/other-init.sql deleted file mode 100644 index e3ed6b32..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/other-init.sql +++ /dev/null @@ -1,18 +0,0 @@ - -TRUNCATE `Others`; -TRUNCATE `A`; -TRUNCATE `B`; -TRUNCATE `C`; -TRUNCATE `D`; -TRUNCATE `E`; -TRUNCATE `F`; - -INSERT INTO Others VALUES(1, 8888888, 0, 'Oui'); -INSERT INTO Others VALUES(2, 9999999999, 1, 'Non'); - -INSERT INTO F VALUES('f', 'fff'); -INSERT INTO E VALUES('e', 'eee'); -INSERT INTO D VALUES('d', 'ddd'); -INSERT INTO C VALUES('c', 'ccc'); -INSERT INTO B VALUES('b', 'c', null, 'bbb'); -INSERT INTO A VALUES('a', 'b', 'e', null, 'aaa'); \ No newline at end of file diff --git a/tests/simple_unit/SqlMap/scripts/mysql/swap-procedure.sql b/tests/simple_unit/SqlMap/scripts/mysql/swap-procedure.sql deleted file mode 100644 index e69de29b..00000000 diff --git a/tests/simple_unit/SqlMap/scripts/mysql/user-init.sql b/tests/simple_unit/SqlMap/scripts/mysql/user-init.sql deleted file mode 100644 index 0bcd6a65..00000000 --- a/tests/simple_unit/SqlMap/scripts/mysql/user-init.sql +++ /dev/null @@ -1,2 +0,0 @@ - -TRUNCATE `users`; -- cgit v1.2.3