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/sqlite/database.sql | 242 --------------------- 1 file changed, 242 deletions(-) delete mode 100644 tests/simple_unit/SqlMap/scripts/sqlite/database.sql (limited to 'tests/simple_unit/SqlMap/scripts/sqlite/database.sql') diff --git a/tests/simple_unit/SqlMap/scripts/sqlite/database.sql b/tests/simple_unit/SqlMap/scripts/sqlite/database.sql deleted file mode 100644 index 477b4b16..00000000 --- a/tests/simple_unit/SqlMap/scripts/sqlite/database.sql +++ /dev/null @@ -1,242 +0,0 @@ -# -# : A -# -DROP TABLE A; - -CREATE TABLE A -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - B_ID VARCHAR(50), - E_ID VARCHAR(50), - F_ID VARCHAR(50), - A_Libelle VARCHAR(50) -); - -INSERT INTO A VALUES ('a', 'b', 'e', NULL, 'aaa'); - - -# -# : Accounts -# -DROP TABLE Accounts; -CREATE TABLE Accounts -( - Account_Id INTEGER NOT NULL PRIMARY KEY, - Account_FirstName VARCHAR(32) NOT NULL, - Account_LastName VARCHAR(32) NOT NULL, - Account_Email VARCHAR(128), - Account_Banner_Option VARCHAR(255), - Account_Cart_Option INT -); - -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'); - - -# -# : B -# -DROP TABLE B; -CREATE TABLE B -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - C_ID VARCHAR(50), - D_ID VARCHAR(50), - B_Libelle VARCHAR(50) -); - -INSERT INTO B VALUES ('b', 'c', NULL, 'bbb'); - - -# -# : C -# -DROP TABLE C; -CREATE TABLE C -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - C_Libelle VARCHAR(50) -); - -INSERT INTO C VALUES ('c', 'ccc'); - - -# -# : Categories -# -DROP TABLE Categories; -create table Categories -( - Category_Id INTEGER NOT NULL PRIMARY KEY, - Category_Name varchar(32), - Category_Guid varchar(36) -); - - -# -# : D -# -DROP TABLE D; -CREATE TABLE D -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - D_Libelle VARCHAR(50) -); - -INSERT INTO D VALUES ('d', 'ddd'); - - -# -# : Documents -# -DROP TABLE Documents; -CREATE TABLE Documents -( - Document_Id INT NOT NULL PRIMARY KEY, - Document_Title VARCHAR(32), - Document_Type VARCHAR(32), - Document_PageNumber INT, - Document_City VARCHAR(32) -); - -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); - - -# -# : E -# -DROP TABLE E; -CREATE TABLE E -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - E_Libelle VARCHAR(50) -); - - -INSERT INTO E VALUES ('e', 'eee'); - - -# -# : Enumerations -# -DROP TABLE Enumerations; -create table Enumerations -( - Enum_Id int not null, - Enum_Day int not null, - Enum_Color int not null, - Enum_Month int -); - - -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); - - -# -# : F -# -DROP TABLE F; -CREATE TABLE F -( - ID VARCHAR(50) NOT NULL PRIMARY KEY, - F_Libelle VARCHAR(50) -); - -INSERT INTO F VALUES ('f', 'fff'); - - -# -# : LineItems -# -DROP TABLE LineItems; -CREATE TABLE LineItems -( - LineItem_Id INTEGER NOT NULL, - Order_Id INT NOT NULL, - LineItem_Code VARCHAR(32) NOT NULL, - LineItem_Quantity INT NOT NULL, - LineItem_Price DECIMAL(18,2), - LineItem_Picture BLOB -); - - -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); - - -# -# : Orders -# -DROP TABLE Orders; -CREATE TABLE Orders -( - Order_Id INTEGER NOT NULL PRIMARY KEY, - Account_Id INT, - Order_Date DATETIME, - Order_CardType VARCHAR(32), - Order_CardNumber VARCHAR(32), - Order_CardExpiry VARCHAR(32), - Order_Street VARCHAR(32), - Order_City VARCHAR(32), - Order_Province VARCHAR(32), - Order_PostalCode VARCHAR(32), - Order_FavouriteLineItem INT -); - -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'); - - -# -# : Others -# -DROP TABLE Others; -create table Others -( - Other_Int int, - Other_Long bigint, - Other_Bit bit not null default 0, - Other_String varchar(32) not null -); - -INSERT INTO Others VALUES ('1', '8888888', '0', 'Oui'); -INSERT INTO Others VALUES ('2', '9999999999', '1', 'Non'); - -- cgit v1.2.3