paw/insert2.txt at master · amarseillan-zz/paw · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
INSERT INTO SYS_USER(id, email, "password", dtype, phone, username, lastname, "name", companyname, photo_id)
select userid, email, "password", 'PrivatePerson', phone, nick, lastname, "name", null, null from OLD_SYS_USER;


INSERT INTO PUBLICATION (id, "access", active, address, age, city, covered, description, environments, operationtype, price,
 propertytype, reserved, uncovered, publisher_id)
SELECT publicationid, 0, active, address, age, city, covered, description,environments, operation_type-1, price, "type"-1, false, uncovered, userid FROM OLD_PUBLICATION;

INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN cable=true THEN 'CABLE'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;
INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN phone=true THEN 'PHONE'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;
INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN pool=true THEN 'POOL'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;
INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN living=true THEN 'LIVING'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;
INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN paddle=true THEN 'PADDLE'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;
INSERT INTO PROPERTY_SERVICES (publication_id, services) SELECT publicationid,
	       CASE WHEN barbecue=true THEN 'BARBACUE'
	            ELSE 'mark'
	       END
	    FROM OLD_PUBLICATION;

DELETE FROM PROPERTY_SERVICES WHERE SERVICES like 'mark';


INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (2, 1, 5, 10000);
INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (2, 1, 5, 10002);
INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (2, 2, 5, 10003);
INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (2, 2, 5, 10000);
INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (4, 2, 2, 10005);
INSERT INTO ENVIRONMENT (depth, "type", width, publicationid) values (7, 3, 5, 10000);


DROP TABLE OLD_OPERATION_TYPE;
DROP TABLE OLD_PHOTO;
DROP TABLE OLD_PROPERTY_TYPE;
DROP TABLE OLD_PUBLICATION;
DROP TABLE OLD_SYS_USER;