Skip to content

Commit b157104

Browse files
yadvryadvr
committed
devcloud: user insert on duplicate update in devcloud.sql
This commit modifies insert statements to use the insert on duplicate update syntax to update configuration table name, values in case primary key already exists Signed-off-by: Rohit Yadav <rohit.yadav@shapeblue.com>
1 parent 0c77b20 commit b157104

1 file changed

Lines changed: 30 additions & 15 deletions

File tree

‎tools/devcloud/devcloud.sql‎

Lines changed: 30 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -19,21 +19,36 @@
1919
INSERT INTO `cloud`.`disk_offering` (id, name, uuid, display_text, created, use_local_storage, type, disk_size, provisioning_type) VALUES (17, 'tinyOffering', UUID(), 'tinyOffering', NOW(), 1, 'Service', 0, 'thin');
2020
INSERT INTO `cloud`.`service_offering` (id, cpu, speed, ram_size) VALUES (17, 1, 100, 100);
2121
INSERT INTO `cloud`.`disk_offering` (id, name, uuid, display_text, created, type, disk_size,provisioning_type) VALUES (18, 'tinyDiskOffering', UUID(), 'tinyDiskOffering', NOW(), 'Disk', 1073741824,'thin');
22-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','router.ram.size', '100');
23-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','router.cpu.mhz','100');
24-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','console.ram.size','100');
25-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','console.cpu.mhz', '100');
26-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','ssvm.ram.size','100');
27-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','ssvm.cpu.mhz','100');
28-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'system.vm.use.local.storage', 'true');
29-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.workers', '3');
30-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.delay', '60');
31-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.interval', '60');
32-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.ec2.api', 'true');
33-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.s3.api', 'true');
34-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'host', '192.168.56.1');
35-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'management.network.cidr', '192.168.56.0/24');
36-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'secstorage.allowed.internal.sites', '192.168.56.0/8');
22+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','router.ram.size', '100')
23+
ON DUPLICATE KEY UPDATE value = '100';
24+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','router.cpu.mhz','100')
25+
ON DUPLICATE KEY UPDATE value = '100';
26+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','console.ram.size','100')
27+
ON DUPLICATE KEY UPDATE value = '100';
28+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','console.cpu.mhz', '100')
29+
ON DUPLICATE KEY UPDATE value = '100';
30+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','ssvm.ram.size','100')
31+
ON DUPLICATE KEY UPDATE value = '100';
32+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT','ssvm.cpu.mhz','100')
33+
ON DUPLICATE KEY UPDATE value = '100';
34+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.workers', '3')
35+
ON DUPLICATE KEY UPDATE value = '3';
36+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.delay', '60')
37+
ON DUPLICATE KEY UPDATE value = '60';
38+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.interval', '60')
39+
ON DUPLICATE KEY UPDATE value = '60';
40+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.ec2.api', 'true')
41+
ON DUPLICATE KEY UPDATE value = 'true';
42+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.s3.api', 'true')
43+
ON DUPLICATE KEY UPDATE value = 'true';
44+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'host', '192.168.56.1')
45+
ON DUPLICATE KEY UPDATE value = '192.168.56.1';
46+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'management.network.cidr', '192.168.56.0/24')
47+
ON DUPLICATE KEY UPDATE value = '192.168.56.0/24';
48+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'secstorage.allowed.internal.sites', '192.168.56.0/8')
49+
ON DUPLICATE KEY UPDATE value = '192.168.56.0/8';
50+
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'system.vm.use.local.storage', 'true')
51+
ON DUPLICATE KEY UPDATE value = 'true';
3752
UPDATE `cloud`.`configuration` SET value='10' where name = 'storage.overprovisioning.factor';
3853
UPDATE `cloud`.`configuration` SET value='10' where name = 'cpu.overprovisioning.factor';
3954
UPDATE `cloud`.`configuration` SET value='10' where name = 'mem.overprovisioning.factor';

0 commit comments

Comments
 (0)