CyberData parameter related with Door Sensor Settings

Signed-off-by: Ted Trask <ttrask01@yahoo.com>
(cherry picked from commit 08a1f90869fae30a55bf90df709e4b9d1253092b)

1 files changed, 28 insertions, 0 deletions

diff --git a/upgradeprovisioning b/upgradeprovisioning
index 3d41489..9d69d96 100755
--- a/upgradeprovisioning
+++ b/upgradeprovisioning
@@ -710,4 +710,32 @@ if [ "$version" -lt "10" ]; then
 	# database
 	psql -U postgres -c "UPDATE provisioning_params SET value='10' WHERE name='databaseversion'" provisioning
 fi
+
+if [ "$version" -lt "11" ]; then
+	echo "Upgrading to database version 11"
+
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensornormallyclosed', 'boolean', 'Door Sensor Normally Closed Enable', '', 'false', '36', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensortimeout', 'text', 'Door Sensor Open Timeout', 'Value in seconds', '0', '37', '^%d*\$', E'local value, functions, params = ...\nif value == \'\' then\n return value, \'Empty not accepted\'\nend\nlocal value = tonumber(value)\nif value == nil then\n return value, \'Only numbers are allowed\'\nend\nif value >= 99999 then\n return value, \'Maximum 99999\'\nend\nreturn value')" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorflashled', 'boolean', 'Door Sensor Flash Button LED Enable', '', 'false', '38', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensoractivaterelay', 'boolean', 'Door Sensor Activate Relay Enable', '', 'false', '39', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorplaylocally', 'boolean', 'Door Sensor Play Audio Locally Enable', '', 'false', '40', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorcall', 'boolean', 'Door Sensor Call to Extension Enable', '', 'false', '41', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensordialoutextension', 'text', 'Door Sensor Dial Out Extension', '', '', '42', '^[*#0-9]*\$', E'local value, functions, params = ...\nif value ~= \'\' then\nlocal len = string.len(value)\n if len >= 65 then\n  return value, \'Maximum 64 digits\'\n end\nend\nreturn value')" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensordialoutid', 'text', 'Door Sensor Dial Out ID', '', '', '43', '', E'local value, functions, params = ...\nif value ~= \'\' then\nlocal len = string.len(value)\n if len >= 65 then\n  return value, \'Maximum 64 characters\'\n end\nend\nreturn value')" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorrepeat', 'text', 'Door Sensor Repeat Message', '', '1', '44', '', E'local value, functions, params = ...\nif value == \'\' then\n return value, \'Empty not accepted\'\nend\nlocal value = tonumber(value)\nif value == nil then\n return value, \'Only numbers are allowed\'\nend\nif value >= 65537 then\n return value, \'Maximum 65536\'\nend\nreturn value')" provisioning
+	psql -U postgres -c "INSERT INTO provisioning_params values(default, 'sensorplayremotely', 'boolean', 'Door Sensor Play Audio Enable', '', 'false', '45', '', null)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensornormallyclosed'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensortimeout'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensorflashled'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensoractivaterelay'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensorplaylocally'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensorcall'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensordialoutextension'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensordialoutid'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensorrepeat'), null, true)" provisioning
+	psql -U postgres -c "INSERT INTO param_groups_to_params VALUES((SELECT group_id FROM provisioning_groups WHERE label='CyberData Intercom Device'), (SELECT param_id FROM provisioning_params WHERE name='sensorplayremotely'), null, true)" provisioning
+
+	# database
+	psql -U postgres -c "UPDATE provisioning_params SET value='11' WHERE name='databaseversion'" provisioning
+fi
 exit 0