From acb5bc002de09dff8cf7490671c18f2a707d01e2 Mon Sep 17 00:00:00 2001 From: Alan Lacerda Date: Tue, 12 May 2015 20:49:28 +0000 Subject: split polycom vvx models Signed-off-by: Ted Trask --- provisioning-scripts.lua | 183 +++++++++++++++++++++++++++++++++++++---------- upgradeprovisioning | 15 ++-- 2 files changed, 157 insertions(+), 41 deletions(-) diff --git a/provisioning-scripts.lua b/provisioning-scripts.lua index 2048e15..188f9df 100644 --- a/provisioning-scripts.lua +++ b/provisioning-scripts.lua @@ -46,7 +46,13 @@ mymodule.provisioning_classes = { "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom SoundPoint IP 650/670 SIP', '4')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom SoundStation IP 5000/6000/7000 SIP', '5')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 1500', '6')", - "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310/400/410/500/600', '7')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310', '7')", + + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 400/410', '8')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 500', '9')", + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 600', '10')", + + "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Linksys Internet Phone Adapter PAP2T', '100')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Cisco 2 Port Phone Adapter SPA112', '200')", "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Snom 300', '300')", @@ -124,41 +130,146 @@ mymodule.classes_to_param_groups = { "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundPoint IP 650/670 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundStation IP 5000/6000/7000 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom SoundStation IP 5000/6000/7000 SIP'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 8 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 9 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 10 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 13 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 14 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 15 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 16 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 17 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 18 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 19 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 20 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 21 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 22 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 23 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 24 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 25 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 26 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 27 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 28 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 29 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 30 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 31 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 32 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 33 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 34 (Polycom)'))", - "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 8 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 9 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 10 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 13 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 14 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 15 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 16 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 17 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 18 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 19 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 20 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 21 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 22 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 23 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 24 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 25 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 26 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 27 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 28 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 29 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 30 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 31 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 32 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 33 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 34 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 8 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 9 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 10 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 13 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 14 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 15 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 16 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 17 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 18 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 19 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 20 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 21 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 22 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 23 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 24 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 25 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 26 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 27 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 28 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 29 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 30 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 31 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 32 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 33 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 34 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 400/410'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 8 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 9 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 10 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 13 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 14 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 15 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 16 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 17 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 18 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 19 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 20 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 21 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 22 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 23 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 24 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 25 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 26 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 27 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 28 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 29 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 30 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 31 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 32 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 33 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 34 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 500'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 4 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 5 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 6 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 7 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 8 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 9 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 10 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 11 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 12 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 13 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 14 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 15 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 16 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 17 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 18 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 19 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 20 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 21 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 22 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 23 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 24 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 25 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 26 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 27 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 28 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 29 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 30 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 31 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 32 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 33 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 34 (Polycom)'))", + "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 600'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 1 (Polycom)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 2 (Polycom)'))", "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 1500'), (SELECT group_id FROM provisioning_groups WHERE label='Registration 3 (Polycom)'))", diff --git a/upgradeprovisioning b/upgradeprovisioning index df1e2cf..d498c51 100755 --- a/upgradeprovisioning +++ b/upgradeprovisioning @@ -279,11 +279,16 @@ fi if [ "$version" -lt "3" ]; then echo "Upgrading to database version 3" - psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310/400/410/500/600', '7')" provisioning - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning - - for a in $(seq 1 34); do - psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX 300/310/400/410/500/600'), (SELECT group_id FROM provisioning_groups WHERE label='Registration $a (Polycom)'))" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 300/310', '7')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 400/410', '8')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 500', '9')" provisioning + psql -U postgres -c "INSERT INTO provisioning_classes VALUES(default, (SELECT class_group_id FROM provisioning_class_groups WHERE name='device'), 'Polycom VVX 600', '10')" provisioning + + for polycom_model in "300/310" "400/410" "500" "600"; do + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX $polycom_model'), (SELECT group_id FROM provisioning_groups WHERE label='Polycom Device'))" provisioning + for a in $(seq 1 34); do + psql -U postgres -c "INSERT INTO classes_to_param_groups VALUES((SELECT class_id FROM provisioning_classes WHERE label='Polycom VVX $polycom_model'), (SELECT group_id FROM provisioning_groups WHERE label='Registration $a (Polycom)'))" provisioning + done done psql -U postgres -c "UPDATE provisioning_classes SET seq='100' WHERE label='Linksys Internet Phone Adapter PAP2T'" provisioning -- cgit v1.2.3