/
stubs.py
156 lines (152 loc) · 10.8 KB
/
stubs.py
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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
# coding: utf-8
utf8_migration = u"""
SQL_UP = u\"\"\"
CREATE TABLE keyword (global_id varchar(255) null, name_txt varchar(255) null);
INSERT INTO keyword (global_id,name_txt) values ('7a77acb8-306c-4ce2-8fbc-e1567e49b149','G1');
INSERT INTO keyword (global_id,name_txt) values ('42aaa103-5832-44c4-a364-0f723187e1d6','EGO');
INSERT INTO keyword (global_id,name_txt) values ('43ef7059-95d5-43f4-adfb-d53e1e6ccf19','Carros');
INSERT INTO keyword (global_id,name_txt) values ('bc993119-215b-47e1-b245-0bc74fa0ebd4','Brasil');
INSERT INTO keyword (global_id,name_txt) values ('0a1cd303-5634-4562-8fc4-52b6bc30188b','Mundo');
INSERT INTO keyword (global_id,name_txt) values ('0885f758-0d96-419c-b0f1-9a8c6cff79cb','Rio de Janeiro');
INSERT INTO keyword (global_id,name_txt) values ('bb814909-00ad-4309-bc97-6542e1bd05e4','jornalismo');
INSERT INTO keyword (global_id,name_txt) values ('7da66618-380e-46dc-b954-84773aa3d2b8','notícias');
INSERT INTO keyword (global_id,name_txt) values ('42301542-56c6-4a25-9b79-6239fc7fbbf9','noticiário');
INSERT INTO keyword (global_id,name_txt) values ('47b7f4ae-ea7e-4d59-91b6-48fbf44ffd34','plantão');
INSERT INTO keyword (global_id,name_txt) values ('dd43e2f9-5828-4160-8cb2-96815dfe0075','carros nacionais');
INSERT INTO keyword (global_id,name_txt) values ('bd775b3c-1574-4c7f-a1cb-0a1a147e481a','carros importados');
INSERT INTO keyword (global_id,name_txt) values ('535dd1d2-f320-4702-8fc2-fa54c3089631','automóvel');
INSERT INTO keyword (global_id,name_txt) values ('25b0c0f9-05bf-4c7d-a380-d9dc41cc2b3d','veiculos');
INSERT INTO keyword (global_id,name_txt) values ('79a1915f-677d-418b-95fe-86d8916122cc','automotivos');
INSERT INTO keyword (global_id,name_txt) values ('1fa5ab83-63e4-4b9d-b32d-8192db6d77ba','automóveis');
INSERT INTO keyword (global_id,name_txt) values ('66f52b89-031c-4153-bfec-d7f79a9e9b57','automobilismo');
INSERT INTO keyword (global_id,name_txt) values ('8565f25e-52ec-47ff-8f65-785cb6d652cf','automobilística');
INSERT INTO keyword (global_id,name_txt) values ('608761e8-e528-4e89-a48b-2b31544e81ef','lançamentos');
INSERT INTO keyword (global_id,name_txt) values ('c4e86250-79fd-411a-8f77-01e82037beaf','carros antigos');
INSERT INTO keyword (global_id,name_txt) values ('aa283576-d634-426e-b821-d398c5227c70','marcas de carros');
INSERT INTO keyword (global_id,name_txt) values ('210a0b42-4adf-4275-9323-5f61f351c67e','detran');
INSERT INTO keyword (global_id,name_txt) values ('0e3ebb0d-d9fd-40e9-a1ae-bba0ce9879b8','dnit');
INSERT INTO keyword (global_id,name_txt) values ('3c680fec-6ad7-45a8-b9e1-7f0c12374ed1','licenciamento anual');
INSERT INTO keyword (global_id,name_txt) values ('cd9e52af-e0a8-4547-abf8-dc7f66a85cf5','motorista');
INSERT INTO keyword (global_id,name_txt) values ('38e9c109-85e2-4141-8798-4fc5155a81c4','moto');
INSERT INTO keyword (global_id,name_txt) values ('6bf3a034-8cfd-4111-943b-4ff46e0fd683','concessionárias');
INSERT INTO keyword (global_id,name_txt) values ('0fcff43e-06fb-45ee-b265-b3e0381adf90','montadoras');
INSERT INTO keyword (global_id,name_txt) values ('e0708192-b63f-487f-8aae-99c1f6b89543','fabricantes');
INSERT INTO keyword (global_id,name_txt) values ('3fc03513-d73b-4246-8989-63fa17e602ef','Dutra');
INSERT INTO keyword (global_id,name_txt) values ('4ed04f89-9f35-4ee6-a15d-c542242bd6dd','transito');
INSERT INTO keyword (global_id,name_txt) values ('040a9935-a22c-40e2-9d5c-343d99088827','trafego');
INSERT INTO keyword (global_id,name_txt) values ('3a4e1932-2dec-4d4a-ae83-c796f43cded9','rodovias');
INSERT INTO keyword (global_id,name_txt) values ('de946979-cf1b-4c27-88e2-449fbd02a4b3','estradas');
INSERT INTO keyword (global_id,name_txt) values ('30a3eb8a-76ef-4b1b-85df-968c00e91113','gasolina');
INSERT INTO keyword (global_id,name_txt) values ('6e8b39fc-5655-42eb-9dbb-f7c5bbf63118','alcool');
INSERT INTO keyword (global_id,name_txt) values ('0d263852-4a38-4ebd-ae4f-bb39dff94aba','combustíveis');
INSERT INTO keyword (global_id,name_txt) values ('d93ca1b8-ef77-4ab3-ae27-86e6841b9fcf','carro a gás');
INSERT INTO keyword (global_id,name_txt) values ('058131c3-8306-44f0-8b66-6e9b45480f69','Alfa Romeo');
INSERT INTO keyword (global_id,name_txt) values ('83bf05d7-cafb-4111-8337-4288da715818','Audi');
INSERT INTO keyword (global_id,name_txt) values ('8e7dfdf3-4ac1-4c49-a0f6-93e7e90f9c0e','BMW');
INSERT INTO keyword (global_id,name_txt) values ('84e529d5-f9e4-4807-9333-15e54c85c2ce','Celta');
INSERT INTO keyword (global_id,name_txt) values ('b86d81ba-782b-4d77-8ca2-d7cd5e9759b3','Corsa');
INSERT INTO keyword (global_id,name_txt) values ('27fa6461-c452-4ea4-9c8e-4e0cf6db287b','Cross Lander');
INSERT INTO keyword (global_id,name_txt) values ('166381d1-11cf-4608-8416-f3569eb92c72','Citroen');
INSERT INTO keyword (global_id,name_txt) values ('9a8046c4-0b08-49b9-8314-4af7a50882b4','DaimlerChrysler');
INSERT INTO keyword (global_id,name_txt) values ('99514799-e2a4-4c51-b675-bcdf8557b35a','Daimler Chrysler');
INSERT INTO keyword (global_id,name_txt) values ('e8219998-c6c4-4ee0-9250-6407e94e21b1','Ferrari');
INSERT INTO keyword (global_id,name_txt) values ('cf0f35a8-3099-41d1-9a25-c9fde9132749','Fiat');
INSERT INTO keyword (global_id,name_txt) values ('5f1d0e9e-3bb9-4f32-a2db-71fbe02012ef','Ford');
INSERT INTO keyword (global_id,name_txt) values ('4af65b8c-e2b1-4a9b-be3d-ebf3258a1ca1','General Motors');
INSERT INTO keyword (global_id,name_txt) values ('559a57a9-4ff1-493a-acf5-c5ad1dcb4b41','GM');
INSERT INTO keyword (global_id,name_txt) values ('f0c52a71-8f99-4d8b-9571-a82f907a35a1','Chevrolet');
INSERT INTO keyword (global_id,name_txt) values ('6d607b85-ae9e-44a8-8e0b-f9f87c40ac80','Honda');
INSERT INTO keyword (global_id,name_txt) values ('c38f2ab5-142a-4b5a-be8d-e65041e48c49','Hyundai');
INSERT INTO keyword (global_id,name_txt) values ('974b65f8-b1de-4623-808d-0c3ea50a6fb1','Jaguar');
INSERT INTO keyword (global_id,name_txt) values ('b00b194d-50ea-4b7d-8c1c-ba6a64629e70','Jeep');
INSERT INTO keyword (global_id,name_txt) values ('4fd422df-31e0-438c-b9d2-3639cffb2310','Kia');
INSERT INTO keyword (global_id,name_txt) values ('75f86b20-7aef-48ff-ba02-11048a259be8','Land Rover');
INSERT INTO keyword (global_id,name_txt) values ('dc633a8e-e5e2-495d-ade7-230ad41bc18a','Mitsubishi');
INSERT INTO keyword (global_id,name_txt) values ('a9ca9235-0f9a-402c-8a85-7cab25ca2cda','Nissan');
INSERT INTO keyword (global_id,name_txt) values ('83c6ef54-dfdf-4f3b-a5e9-78df09d587ab','Pajero');
INSERT INTO keyword (global_id,name_txt) values ('e1b91d9a-e895-4267-a33c-4a2baece9eb7','Palio');
INSERT INTO keyword (global_id,name_txt) values ('0c166940-4bf2-4b49-9c73-f1441b037cdf','Peugeot');
INSERT INTO keyword (global_id,name_txt) values ('ff1acbb9-6d93-44f9-afcd-cf9b54417433','Porsche');
INSERT INTO keyword (global_id,name_txt) values ('17421bd1-8465-4c0f-a1fc-7af61ee40e72','Renault');
INSERT INTO keyword (global_id,name_txt) values ('0b25ea92-928b-44b2-a47d-e1239e3b1d4f','Seat');
INSERT INTO keyword (global_id,name_txt) values ('0850f36c-fa42-4f1d-9ef0-8853963d290a','SsangYong');
INSERT INTO keyword (global_id,name_txt) values ('ecfc985b-7d61-4743-9880-3f9cb0f77d53','Subaru');
INSERT INTO keyword (global_id,name_txt) values ('4dd92826-c084-4744-a74e-975ee95bb100','Toyota');
INSERT INTO keyword (global_id,name_txt) values ('914513ae-9042-4d9c-b6fc-6dbb9b05841e','Troller');
INSERT INTO keyword (global_id,name_txt) values ('5f4dcf70-2092-4fc6-890b-9941b28d7f25','Volkswagen');
INSERT INTO keyword (global_id,name_txt) values ('2cfd5899-0837-4059-9abf-1e4607783e3d','Volvo');
INSERT INTO keyword (global_id,name_txt) values ('066372f9-9611-47b3-8f82-39fe141f4c78','Picapes');
INSERT INTO keyword (global_id,name_txt) values ('f9628111-c2f5-4a9a-9bf7-2da0f88a133b','Pickup');
\"\"\"
SQL_DOWN = u\"\"\"
DELETE from keyword where name_txt='jornalismo';
DELETE from keyword where name_txt='notícias';
DELETE from keyword where name_txt='noticiário';
DELETE from keyword where name_txt='plantão';
DELETE from keyword where name_txt='carros nacionais';
DELETE from keyword where name_txt='carros importados';
DELETE from keyword where name_txt='automóvel';
DELETE from keyword where name_txt='veiculos';
DELETE from keyword where name_txt='automotivos';
DELETE from keyword where name_txt='automóveis';
DELETE from keyword where name_txt='automobilismo';
DELETE from keyword where name_txt='automobilística';
DELETE from keyword where name_txt='lançamentos';
DELETE from keyword where name_txt='carros antigos';
DELETE from keyword where name_txt='marcas de carros';
DELETE from keyword where name_txt='detran';
DELETE from keyword where name_txt='dnit';
DELETE from keyword where name_txt='licenciamento anual';
DELETE from keyword where name_txt='motorista';
DELETE from keyword where name_txt='moto';
DELETE from keyword where name_txt='concessionárias';
DELETE from keyword where name_txt='montadoras';
DELETE from keyword where name_txt='fabricantes';
DELETE from keyword where name_txt='Dutra';
DELETE from keyword where name_txt='transito';
DELETE from keyword where name_txt='trafego';
DELETE from keyword where name_txt='rodovias';
DELETE from keyword where name_txt='estradas';
DELETE from keyword where name_txt='gasolina';
DELETE from keyword where name_txt='alcool';
DELETE from keyword where name_txt='combustíveis';
DELETE from keyword where name_txt='carro a gás';
DELETE from keyword where name_txt='Alfa Romeo';
DELETE from keyword where name_txt='Audi';
DELETE from keyword where name_txt='BMW';
DELETE from keyword where name_txt='Celta';
DELETE from keyword where name_txt='Corsa';
DELETE from keyword where name_txt='Cross Lander';
DELETE from keyword where name_txt='Citroen';
DELETE from keyword where name_txt='DaimlerChrysler';
DELETE from keyword where name_txt='Daimler Chrysler';
DELETE from keyword where name_txt='Ferrari';
DELETE from keyword where name_txt='Fiat';
DELETE from keyword where name_txt='Ford';
DELETE from keyword where name_txt='General Motors';
DELETE from keyword where name_txt='GM';
DELETE from keyword where name_txt='Chevrolet';
DELETE from keyword where name_txt='Honda';
DELETE from keyword where name_txt='Hyundai';
DELETE from keyword where name_txt='Jaguar';
DELETE from keyword where name_txt='Jeep';
DELETE from keyword where name_txt='Kia';
DELETE from keyword where name_txt='Land Rover';
DELETE from keyword where name_txt='Mitsubishi';
DELETE from keyword where name_txt='Nissan';
DELETE from keyword where name_txt='Pajero';
DELETE from keyword where name_txt='Palio';
DELETE from keyword where name_txt='Peugeot';
DELETE from keyword where name_txt='Porsche';
DELETE from keyword where name_txt='Renault';
DELETE from keyword where name_txt='Seat';
DELETE from keyword where name_txt='SsangYong';
DELETE from keyword where name_txt='Subaru';
DELETE from keyword where name_txt='Toyota';
DELETE from keyword where name_txt='Troller';
DELETE from keyword where name_txt='Volkswagen';
DELETE from keyword where name_txt='Volvo';
DELETE from keyword where name_txt='Picapes';
DELETE from keyword where name_txt='Pickup';
\"\"\"
"""