40 lines
1.8 KiB
PL/PgSQL
40 lines
1.8 KiB
PL/PgSQL
begin;
|
|
|
|
/* Exact match */
|
|
update collection set name = 'Hard Rock Cafe Amsterdam' where name = 'Amsterdam';
|
|
update collection set name = 'Hard Rock Cafe Barcelona' where name = 'Barcelona';
|
|
update collection set name = 'Hard Rock Cafe Berlin' where name = 'Berlin';
|
|
update collection set name = 'Hard Rock Cafe Brussels' where name = 'Brussels';
|
|
update collection set name = 'Hard Rock Cafe Dublin' where name = 'Dublin';
|
|
update collection set name = 'Hard Rock Cafe Hamburg' where name = 'Hamburg';
|
|
update collection set name = 'Hard Rock Cafe Hollywood on Hollywood Blvd' where name = 'Hollywood';
|
|
update collection set name = 'Hard Rock Cafe Lisbon' where name = 'Lisbon';
|
|
update collection set name = 'Hard Rock Cafe Orlando' where name = 'Orlando';
|
|
update collection set name = 'Hard Rock Cafe Paris' where name = 'Paris';
|
|
update collection set name = 'Hard Rock Cafe Prague' where name = 'Prague';
|
|
update collection set name = 'Hard Rock Cafe San Francisco' where name = 'San Francisco';
|
|
|
|
/* Multiple restaurants */
|
|
update collection set name = 'Hard Rock Cafe London' where name = 'London';
|
|
update collection set name = 'Hard Rock Cafe Miami' where name = 'Miami';
|
|
update collection set name = 'Hard Rock Cafe New York Times Square' where name = 'New York';
|
|
update collection set name = 'Hard Rock Cafe Yankee Stadium' where name = 'Yankee Stadium';
|
|
update collection set name = 'Hard Rock Cafe Changi Airport Singapore' where name = 'Singapore';
|
|
|
|
/* Multiple T-Shirts */
|
|
delete from collection where name = 'Los Angeles';
|
|
delete from collection where name = 'Miami Gardens';
|
|
|
|
/* Wrong match */
|
|
update collection set name = 'Hard Rock Cafe Angkor' where name = 'Angkor';
|
|
|
|
/* Closed restaurants */
|
|
delete from collection where name in (
|
|
'Antwerp',
|
|
'Boston',
|
|
'Detroit',
|
|
'Ho Chi Minh City',
|
|
'Oslo'
|
|
);
|
|
|
|
commit;
|