diff options
Diffstat (limited to 'src/components/policy/src/policy/src/sql_pt_queries.cc')
-rw-r--r-- | src/components/policy/src/policy/src/sql_pt_queries.cc | 992 |
1 files changed, 510 insertions, 482 deletions
diff --git a/src/components/policy/src/policy/src/sql_pt_queries.cc b/src/components/policy/src/policy/src/sql_pt_queries.cc index efc2d60c2f..86b70bebd4 100644 --- a/src/components/policy/src/policy/src/sql_pt_queries.cc +++ b/src/components/policy/src/policy/src/sql_pt_queries.cc @@ -1,4 +1,4 @@ -/* +/* Copyright (c) 2013, " Ford Motor Company All rights reserved. @@ -38,483 +38,506 @@ namespace sql_pt { const std::string kSelectPriority = "SELECT `priority_value` FROM `application` WHERE `id` = ? LIMIT 1"; const std::string kCreateSchema = - "BEGIN; " - "CREATE TABLE IF NOT EXISTS `device`( " - " `id` VARCHAR(100) PRIMARY KEY NOT NULL, " - " `hardware` VARCHAR(45), " - " `firmware_rev` VARCHAR(45), " - " `os` VARCHAR(45), " - " `os_version` VARCHAR(45), " - " `carrier` VARCHAR(45), " - " `max_number_rfcom_ports` INTEGER," - " `connection_type` VARCHAR(45), " - " `unpaired` BOOL " - "); " - "CREATE TABLE IF NOT EXISTS `usage_and_error_count`( " - " `count_of_iap_buffer_full` INTEGER, " - " `count_sync_out_of_memory` INTEGER, " - " `count_of_sync_reboots` INTEGER " - "); " - "CREATE TABLE IF NOT EXISTS `module_meta`( " - " `ccpu_version` VARCHAR(45), " - " `language` VARCHAR(45), " - " `wers_country_code` VARCHAR(45), " - " `pt_exchanged_at_odometer_x` INTEGER NOT NULL DEFAULT 0, " - " `pt_exchanged_x_days_after_epoch` INTEGER NOT NULL DEFAULT 0, " - " `ignition_cycles_since_last_exchange` INTEGER NOT NULL DEFAULT 0, " - " `vin` VARCHAR(45)," - " `flag_update_required` BOOL NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `module_config`( " - " `preloaded_pt` BOOL NOT NULL, " - " `is_first_run` BOOL NOT NULL, " - " `exchange_after_x_ignition_cycles` INTEGER NOT NULL, " - " `exchange_after_x_kilometers` INTEGER NOT NULL, " - " `exchange_after_x_days` INTEGER NOT NULL, " - " `timeout_after_x_seconds` INTEGER NOT NULL, " - " `vehicle_make` VARCHAR(45), " - " `vehicle_model` VARCHAR(45), " - " `vehicle_year` VARCHAR(4) " - "); " - "CREATE TABLE IF NOT EXISTS `functional_group`( " - " `id` INTEGER PRIMARY KEY NOT NULL, " - " `user_consent_prompt` TEXT UNIQUE ON CONFLICT REPLACE, " - " `name` VARCHAR(100) NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `priority`( " - " `value` VARCHAR(45) PRIMARY KEY NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `hmi_level`( " - " `value` VARCHAR(45) PRIMARY KEY NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `notifications_by_priority`( " - " `priority_value` VARCHAR(45) PRIMARY KEY NOT NULL, " - " `value` INTEGER NOT NULL, " - " CONSTRAINT `fk_notifications_by_priority_priority1` " - " FOREIGN KEY(`priority_value`) " - " REFERENCES `priority`(`value`) " - "); " - "CREATE INDEX IF NOT EXISTS " - "`notifications_by_priority.fk_notifications_by_priority_priority1_idx` " - " ON `notifications_by_priority`(`priority_value`); " - "CREATE TABLE IF NOT EXISTS `language`( " - " `code` VARCHAR(25) PRIMARY KEY NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `message_type`( " - " `name` VARCHAR(45) PRIMARY KEY NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `version`( " - " `number` VARCHAR(45) NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `rpc`( " - " `id` INTEGER PRIMARY KEY NOT NULL, " - " `name` VARCHAR(45) NOT NULL, " - " `parameter` VARCHAR(45), " - " `hmi_level_value` VARCHAR(45) NOT NULL, " - " `functional_group_id` INTEGER NOT NULL, " - " CONSTRAINT `fk_rpc_hmi_level1` " - " FOREIGN KEY(`hmi_level_value`) " - " REFERENCES `hmi_level`(`value`), " - " CONSTRAINT `fk_rpc_functional_group1` " - " FOREIGN KEY(`functional_group_id`) " - " REFERENCES `functional_group`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS `rpc.fk_rpc_hmi_level1_idx` " - " ON `rpc`(`hmi_level_value`); " - "CREATE INDEX IF NOT EXISTS `rpc.fk_rpc_functional_group1_idx` " - " ON `rpc`(`functional_group_id`); " - "CREATE INDEX `rpc.select_rpc_name_hmi_level` " - " ON `rpc`(`name`,`hmi_level_value`);" - "CREATE TABLE IF NOT EXISTS `application`( " - " `id` VARCHAR(45) PRIMARY KEY NOT NULL, " - " `keep_context` BOOLEAN, " - " `steal_focus` BOOLEAN, " - " `default_hmi` VARCHAR(45), " - " `priority_value` VARCHAR(45), " - " `is_revoked` BOOLEAN, " - " `is_default` BOOLEAN, " - " `is_predata` BOOLEAN, " - " `memory_kb` INTEGER NOT NULL, " - " `heart_beat_timeout_ms` INTEGER NOT NULL, " - " `certificate` VARCHAR(45), " - " CONSTRAINT `fk_application_hmi_level1` " - " FOREIGN KEY(`default_hmi`) " - " REFERENCES `hmi_level`(`value`), " - " CONSTRAINT `fk_application_priorities1` " - " FOREIGN KEY(`priority_value`) " - " REFERENCES `priority`(`value`) " - "); " - "CREATE INDEX IF NOT EXISTS `application.fk_application_hmi_level1_idx` " - " ON `application`(`default_hmi`); " - "CREATE INDEX IF NOT EXISTS `application.fk_application_priorities1_idx` " - " ON `application`(`priority_value`); " - "CREATE TABLE IF NOT EXISTS `app_group`( " - " `application_id` VARCHAR(45) NOT NULL, " - " `functional_group_id` INTEGER NOT NULL, " - " PRIMARY KEY(`application_id`,`functional_group_id`), " - " CONSTRAINT `fk_application_has_functional_group_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`), " - " CONSTRAINT `fk_application_has_functional_group_functional_group1` " - " FOREIGN KEY(`functional_group_id`) " - " REFERENCES `functional_group`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS `app_group.fk_application_has_functional_group_functional_group1_idx` " - " ON `app_group`(`functional_group_id`); " - "CREATE INDEX IF NOT EXISTS `app_group.fk_application_has_functional_group_application1_idx` " - " ON `app_group`(`application_id`); " - "CREATE TABLE IF NOT EXISTS `preconsented_group`( " - " `application_id` VARCHAR(45) NOT NULL, " - " `functional_group_id` INTEGER NOT NULL, " - " PRIMARY KEY(`application_id`,`functional_group_id`), " - " CONSTRAINT `fk_application_has_functional_group_application2` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`), " - " CONSTRAINT `fk_application_has_functional_group_functional_group2` " - " FOREIGN KEY(`functional_group_id`) " - " REFERENCES `functional_group`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS " - "`preconsented_group.fk_application_has_functional_group_functional_group2_idx` " - " ON `preconsented_group`(`functional_group_id`); " - "CREATE INDEX IF NOT EXISTS " - "`preconsented_group.fk_application_has_functional_group_application2_idx` " - " ON `preconsented_group`(`application_id`); " - "CREATE TABLE IF NOT EXISTS `seconds_between_retry`( " - " `index` INTEGER PRIMARY KEY NOT NULL, " - " `value` INTEGER NOT NULL " - "); " - "CREATE TABLE IF NOT EXISTS `device_consent_group`( " - " `device_id` VARCHAR(100) NOT NULL, " - " `functional_group_id` INTEGER NOT NULL, " - " `is_consented` BOOL NOT NULL, " - " `input` VARCHAR(45), " - " `time_stamp` VARCHAR(45), " - " PRIMARY KEY(`device_id`,`functional_group_id`), " - " CONSTRAINT `fk_device_has_functional_group_device1` " - " FOREIGN KEY(`device_id`) " - " REFERENCES `device`(`id`), " - " CONSTRAINT `fk_device_has_functional_group_functional_group1` " - " FOREIGN KEY(`functional_group_id`) " - " REFERENCES `functional_group`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS " - "`device_consent_group.fk_device_has_functional_group_functional_group1_idx` " - " ON `device_consent_group`(`functional_group_id`); " - "CREATE INDEX IF NOT EXISTS " - "`device_consent_group.fk_device_has_functional_group_device1_idx` " - " ON `device_consent_group`(`device_id`); " - "CREATE TABLE IF NOT EXISTS `app_level`( " - " `application_id` VARCHAR(45) PRIMARY KEY NOT NULL, " - " `minutes_in_hmi_full` INTEGER DEFAULT 0, " - " `minutes_in_hmi_limited` INTEGER DEFAULT 0, " - " `minutes_in_hmi_background` INTEGER DEFAULT 0, " - " `minutes_in_hmi_none` INTEGER DEFAULT 0, " - " `count_of_user_selections` INTEGER DEFAULT 0, " - " `count_of_rejections_sync_out_of_memory` INTEGER DEFAULT 0, " - " `count_of_rejections_nickname_mismatch` INTEGER DEFAULT 0, " - " `count_of_rejections_duplicate_name` INTEGER DEFAULT 0, " - " `count_of_rejected_rpcs_calls` INTEGER DEFAULT 0, " - " `count_of_rpcs_sent_in_hmi_none` INTEGER DEFAULT 0, " - " `count_of_removals_for_bad_behavior` INTEGER DEFAULT 0, " - " `count_of_run_attempts_while_revoked` INTEGER DEFAULT 0, " - " `app_registration_language_gui` VARCHAR(25), " - " `app_registration_language_vui` VARCHAR(25), " - " CONSTRAINT `fk_app_levels_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`), " - " CONSTRAINT `fk_app_level_language1` " - " FOREIGN KEY(`app_registration_language_gui`) " - " REFERENCES `language`(`code`), " - " CONSTRAINT `fk_app_level_language2` " - " FOREIGN KEY(`app_registration_language_vui`) " - " REFERENCES `language`(`code`) " - "); " - "CREATE INDEX IF NOT EXISTS `app_level.fk_app_levels_application1_idx` " - " ON `app_level`(`application_id`); " - "CREATE INDEX IF NOT EXISTS `app_level.fk_app_level_language1_idx` " - " ON `app_level`(`app_registration_language_gui`); " - "CREATE INDEX IF NOT EXISTS `app_level.fk_app_level_language2_idx` " - " ON `app_level`(`app_registration_language_vui`); " - "CREATE TABLE IF NOT EXISTS `nickname`( " - " `name` VARCHAR(100) NOT NULL, " - " `application_id` VARCHAR(45) NOT NULL, " - " PRIMARY KEY(`name`,`application_id`), " - " CONSTRAINT `fk_nickname_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS `nickname.fk_nickname_application1_idx` " - " ON `nickname`(`application_id`); " - "CREATE TABLE IF NOT EXISTS `app_type`( " - " `name` VARCHAR(50) NOT NULL, " - " `application_id` VARCHAR(45) NOT NULL, " - " PRIMARY KEY(`name`,`application_id`), " - " CONSTRAINT `fk_app_type_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`) " - "); " - "CREATE TABLE IF NOT EXISTS `request_type`( " - " `request_type` VARCHAR(50) NOT NULL, " - " `application_id` VARCHAR(45) NOT NULL, " - " PRIMARY KEY(`request_type`,`application_id`), " - " CONSTRAINT `fk_app_type_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS `app_type.fk_app_type_application1_idx` " - " ON `app_type`(`application_id`); " - "CREATE TABLE IF NOT EXISTS `consent_group`( " - " `device_id` VARCHAR(100) NOT NULL, " - " `application_id` VARCHAR(45) NOT NULL, " - " `functional_group_id` INTEGER NOT NULL, " - " `is_consented` BOOL NOT NULL, " - " `input` VARCHAR(45), " - " `time_stamp` VARCHAR(45), " - " PRIMARY KEY(`application_id`,`functional_group_id`,`device_id`), " - " CONSTRAINT `fk_consent_group_device1` " - " FOREIGN KEY(`device_id`) " - " REFERENCES `device`(`id`), " - " CONSTRAINT `fk_consent_group_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`), " - " CONSTRAINT `fk_consent_group_functional_group1` " - " FOREIGN KEY(`functional_group_id`) " - " REFERENCES `functional_group`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS " - "`consent_group.fk_consent_group_device1_idx` " - " ON `device_consent_group`(`device_id`); " - "CREATE INDEX IF NOT EXISTS `consent_group.fk_consent_group_functional_group1_idx` " - " ON `consent_group`(`functional_group_id`); " - "CREATE TABLE IF NOT EXISTS `endpoint`( " - " `service` VARCHAR(100) NOT NULL, " - " `url` VARCHAR(100) NOT NULL, " - " `application_id` VARCHAR(45) NOT NULL, " - " CONSTRAINT `fk_endpoint_application1` " - " FOREIGN KEY(`application_id`) " - " REFERENCES `application`(`id`) " - "); " - "CREATE INDEX IF NOT EXISTS `endpoint.fk_endpoint_application1_idx` " - " ON `endpoint`(`application_id`); " - "CREATE TABLE IF NOT EXISTS `message`( " - " `id` INTEGER PRIMARY KEY NOT NULL, " - " `tts` TEXT, " - " `label` TEXT, " - " `line1` TEXT, " - " `line2` TEXT, " - " `textBody` TEXT, " - " `language_code` VARCHAR(25) NOT NULL, " - " `message_type_name` VARCHAR(45) NOT NULL, " - " CONSTRAINT `fk_messages_languages1` " - " FOREIGN KEY(`language_code`) " - " REFERENCES `language`(`code`), " - " CONSTRAINT `fk_message_consumer_friendly_messages1` " - " FOREIGN KEY(`message_type_name`) " - " REFERENCES `message_type`(`name`) " - "); " - "CREATE INDEX IF NOT EXISTS `message.fk_messages_languages1_idx` " - " ON `message`(`language_code`);" - "CREATE INDEX IF NOT EXISTS `message.fk_message_consumer_friendly_messages1_idx` " - " ON `message`(`message_type_name`);" - "COMMIT;"; + "BEGIN; " + "CREATE TABLE IF NOT EXISTS `device`( " + " `id` VARCHAR(100) PRIMARY KEY NOT NULL, " + " `hardware` VARCHAR(45), " + " `firmware_rev` VARCHAR(45), " + " `os` VARCHAR(45), " + " `os_version` VARCHAR(45), " + " `carrier` VARCHAR(45), " + " `max_number_rfcom_ports` INTEGER," + " `connection_type` VARCHAR(45), " + " `unpaired` BOOL " + "); " + "CREATE TABLE IF NOT EXISTS `usage_and_error_count`( " + " `count_of_iap_buffer_full` INTEGER, " + " `count_sync_out_of_memory` INTEGER, " + " `count_of_sync_reboots` INTEGER " + "); " + "CREATE TABLE IF NOT EXISTS `module_meta`( " + " `ccpu_version` VARCHAR(45), " + " `language` VARCHAR(45), " + " `wers_country_code` VARCHAR(45), " + " `pt_exchanged_at_odometer_x` INTEGER NOT NULL DEFAULT 0, " + " `pt_exchanged_x_days_after_epoch` INTEGER NOT NULL DEFAULT 0, " + " `ignition_cycles_since_last_exchange` INTEGER NOT NULL DEFAULT 0, " + " `vin` VARCHAR(45)," + " `flag_update_required` BOOL NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `module_config`( " + " `preloaded_pt` BOOL NOT NULL, " + " `is_first_run` BOOL NOT NULL, " + " `exchange_after_x_ignition_cycles` INTEGER NOT NULL, " + " `exchange_after_x_kilometers` INTEGER NOT NULL, " + " `exchange_after_x_days` INTEGER NOT NULL, " + " `timeout_after_x_seconds` INTEGER NOT NULL, " + " `vehicle_make` VARCHAR(45), " + " `vehicle_model` VARCHAR(45), " + " `vehicle_year` VARCHAR(4), " + " `certificate` VARCHAR (45) " + "); " + "CREATE TABLE IF NOT EXISTS `functional_group`( " + " `id` INTEGER PRIMARY KEY NOT NULL, " + " `user_consent_prompt` TEXT UNIQUE ON CONFLICT REPLACE, " + " `name` VARCHAR(100) NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `priority`( " + " `value` VARCHAR(45) PRIMARY KEY NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `hmi_level`( " + " `value` VARCHAR(45) PRIMARY KEY NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `notifications_by_priority`( " + " `priority_value` VARCHAR(45) PRIMARY KEY NOT NULL, " + " `value` INTEGER NOT NULL, " + " CONSTRAINT `fk_notifications_by_priority_priority1` " + " FOREIGN KEY(`priority_value`) " + " REFERENCES `priority`(`value`) " + "); " + "CREATE INDEX IF NOT EXISTS " + "`notifications_by_priority.fk_notifications_by_priority_priority1_idx` " + " ON `notifications_by_priority`(`priority_value`); " + "CREATE TABLE IF NOT EXISTS `language`( " + " `code` VARCHAR(25) PRIMARY KEY NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `message_type`( " + " `name` VARCHAR(45) PRIMARY KEY NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `version`( " + " `number` VARCHAR(45) NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `rpc`( " + " `id` INTEGER PRIMARY KEY NOT NULL, " + " `name` VARCHAR(45) NOT NULL, " + " `parameter` VARCHAR(45), " + " `hmi_level_value` VARCHAR(45) NOT NULL, " + " `functional_group_id` INTEGER NOT NULL, " + " CONSTRAINT `fk_rpc_hmi_level1` " + " FOREIGN KEY(`hmi_level_value`) " + " REFERENCES `hmi_level`(`value`), " + " CONSTRAINT `fk_rpc_functional_group1` " + " FOREIGN KEY(`functional_group_id`) " + " REFERENCES `functional_group`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS `rpc.fk_rpc_hmi_level1_idx` " + " ON `rpc`(`hmi_level_value`); " + "CREATE INDEX IF NOT EXISTS `rpc.fk_rpc_functional_group1_idx` " + " ON `rpc`(`functional_group_id`); " + "CREATE INDEX `rpc.select_rpc_name_hmi_level` " + " ON `rpc`(`name`,`hmi_level_value`);" + "CREATE TABLE IF NOT EXISTS `application`( " + " `id` VARCHAR(45) PRIMARY KEY NOT NULL, " + " `keep_context` BOOLEAN, " + " `steal_focus` BOOLEAN, " + " `default_hmi` VARCHAR(45), " + " `priority_value` VARCHAR(45), " + " `is_revoked` BOOLEAN, " + " `is_default` BOOLEAN, " + " `is_predata` BOOLEAN, " + " `memory_kb` INTEGER NOT NULL, " + " `heart_beat_timeout_ms` INTEGER NOT NULL, " + " `certificate` VARCHAR(45), " + " CONSTRAINT `fk_application_hmi_level1` " + " FOREIGN KEY(`default_hmi`) " + " REFERENCES `hmi_level`(`value`), " + " CONSTRAINT `fk_application_priorities1` " + " FOREIGN KEY(`priority_value`) " + " REFERENCES `priority`(`value`) " + "); " + "CREATE INDEX IF NOT EXISTS `application.fk_application_hmi_level1_idx` " + " ON `application`(`default_hmi`); " + "CREATE INDEX IF NOT EXISTS `application.fk_application_priorities1_idx` " + " ON `application`(`priority_value`); " + "CREATE TABLE IF NOT EXISTS `app_group`( " + " `application_id` VARCHAR(45) NOT NULL, " + " `functional_group_id` INTEGER NOT NULL, " + " PRIMARY KEY(`application_id`,`functional_group_id`), " + " CONSTRAINT `fk_application_has_functional_group_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`), " + " CONSTRAINT `fk_application_has_functional_group_functional_group1` " + " FOREIGN KEY(`functional_group_id`) " + " REFERENCES `functional_group`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS " + "`app_group.fk_application_has_functional_group_functional_group1_idx` " + " ON `app_group`(`functional_group_id`); " + "CREATE INDEX IF NOT EXISTS " + "`app_group.fk_application_has_functional_group_application1_idx` " + " ON `app_group`(`application_id`); " + "CREATE TABLE IF NOT EXISTS `preconsented_group`( " + " `application_id` VARCHAR(45) NOT NULL, " + " `functional_group_id` INTEGER NOT NULL, " + " PRIMARY KEY(`application_id`,`functional_group_id`), " + " CONSTRAINT `fk_application_has_functional_group_application2` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`), " + " CONSTRAINT `fk_application_has_functional_group_functional_group2` " + " FOREIGN KEY(`functional_group_id`) " + " REFERENCES `functional_group`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS " + "`preconsented_group.fk_application_has_functional_group_functional_group2_" + "idx` " + " ON `preconsented_group`(`functional_group_id`); " + "CREATE INDEX IF NOT EXISTS " + "`preconsented_group.fk_application_has_functional_group_application2_idx` " + " ON `preconsented_group`(`application_id`); " + "CREATE TABLE IF NOT EXISTS `seconds_between_retry`( " + " `index` INTEGER PRIMARY KEY NOT NULL, " + " `value` INTEGER NOT NULL " + "); " + "CREATE TABLE IF NOT EXISTS `device_consent_group`( " + " `device_id` VARCHAR(100) NOT NULL, " + " `functional_group_id` INTEGER NOT NULL, " + " `is_consented` BOOL NOT NULL, " + " `input` VARCHAR(45), " + " `time_stamp` VARCHAR(45), " + " PRIMARY KEY(`device_id`,`functional_group_id`), " + " CONSTRAINT `fk_device_has_functional_group_device1` " + " FOREIGN KEY(`device_id`) " + " REFERENCES `device`(`id`), " + " CONSTRAINT `fk_device_has_functional_group_functional_group1` " + " FOREIGN KEY(`functional_group_id`) " + " REFERENCES `functional_group`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS " + "`device_consent_group.fk_device_has_functional_group_functional_group1_" + "idx` " + " ON `device_consent_group`(`functional_group_id`); " + "CREATE INDEX IF NOT EXISTS " + "`device_consent_group.fk_device_has_functional_group_device1_idx` " + " ON `device_consent_group`(`device_id`); " + "CREATE TABLE IF NOT EXISTS `app_level`( " + " `application_id` VARCHAR(45) PRIMARY KEY NOT NULL, " + " `minutes_in_hmi_full` INTEGER DEFAULT 0, " + " `minutes_in_hmi_limited` INTEGER DEFAULT 0, " + " `minutes_in_hmi_background` INTEGER DEFAULT 0, " + " `minutes_in_hmi_none` INTEGER DEFAULT 0, " + " `count_of_user_selections` INTEGER DEFAULT 0, " + " `count_of_rejections_sync_out_of_memory` INTEGER DEFAULT 0, " + " `count_of_rejections_nickname_mismatch` INTEGER DEFAULT 0, " + " `count_of_rejections_duplicate_name` INTEGER DEFAULT 0, " + " `count_of_rejected_rpcs_calls` INTEGER DEFAULT 0, " + " `count_of_rpcs_sent_in_hmi_none` INTEGER DEFAULT 0, " + " `count_of_removals_for_bad_behavior` INTEGER DEFAULT 0, " + " `count_of_run_attempts_while_revoked` INTEGER DEFAULT 0, " + " `app_registration_language_gui` VARCHAR(25), " + " `app_registration_language_vui` VARCHAR(25), " + " CONSTRAINT `fk_app_levels_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`), " + " CONSTRAINT `fk_app_level_language1` " + " FOREIGN KEY(`app_registration_language_gui`) " + " REFERENCES `language`(`code`), " + " CONSTRAINT `fk_app_level_language2` " + " FOREIGN KEY(`app_registration_language_vui`) " + " REFERENCES `language`(`code`) " + "); " + "CREATE INDEX IF NOT EXISTS `app_level.fk_app_levels_application1_idx` " + " ON `app_level`(`application_id`); " + "CREATE INDEX IF NOT EXISTS `app_level.fk_app_level_language1_idx` " + " ON `app_level`(`app_registration_language_gui`); " + "CREATE INDEX IF NOT EXISTS `app_level.fk_app_level_language2_idx` " + " ON `app_level`(`app_registration_language_vui`); " + "CREATE TABLE IF NOT EXISTS `nickname`( " + " `name` VARCHAR(100) NOT NULL, " + " `application_id` VARCHAR(45) NOT NULL, " + " PRIMARY KEY(`name`,`application_id`), " + " CONSTRAINT `fk_nickname_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS `nickname.fk_nickname_application1_idx` " + " ON `nickname`(`application_id`); " + "CREATE TABLE IF NOT EXISTS `app_type`( " + " `name` VARCHAR(50) NOT NULL, " + " `application_id` VARCHAR(45) NOT NULL, " + " PRIMARY KEY(`name`,`application_id`), " + " CONSTRAINT `fk_app_type_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`) " + "); " + "CREATE TABLE IF NOT EXISTS `request_type`( " + " `request_type` VARCHAR(50) NOT NULL, " + " `application_id` VARCHAR(45) NOT NULL, " + " PRIMARY KEY(`request_type`,`application_id`), " + " CONSTRAINT `fk_app_type_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS `app_type.fk_app_type_application1_idx` " + " ON `app_type`(`application_id`); " + "CREATE TABLE IF NOT EXISTS `consent_group`( " + " `device_id` VARCHAR(100) NOT NULL, " + " `application_id` VARCHAR(45) NOT NULL, " + " `functional_group_id` INTEGER NOT NULL, " + " `is_consented` BOOL NOT NULL, " + " `input` VARCHAR(45), " + " `time_stamp` VARCHAR(45), " + " PRIMARY KEY(`application_id`,`functional_group_id`,`device_id`), " + " CONSTRAINT `fk_consent_group_device1` " + " FOREIGN KEY(`device_id`) " + " REFERENCES `device`(`id`), " + " CONSTRAINT `fk_consent_group_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`), " + " CONSTRAINT `fk_consent_group_functional_group1` " + " FOREIGN KEY(`functional_group_id`) " + " REFERENCES `functional_group`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS " + "`consent_group.fk_consent_group_device1_idx` " + " ON `device_consent_group`(`device_id`); " + "CREATE INDEX IF NOT EXISTS " + "`consent_group.fk_consent_group_functional_group1_idx` " + " ON `consent_group`(`functional_group_id`); " + "CREATE TABLE IF NOT EXISTS `endpoint`( " + " `service` VARCHAR(100) NOT NULL, " + " `url` VARCHAR(100) NOT NULL, " + " `application_id` VARCHAR(45) NOT NULL, " + " CONSTRAINT `fk_endpoint_application1` " + " FOREIGN KEY(`application_id`) " + " REFERENCES `application`(`id`) " + "); " + "CREATE INDEX IF NOT EXISTS `endpoint.fk_endpoint_application1_idx` " + " ON `endpoint`(`application_id`); " + "CREATE TABLE IF NOT EXISTS `message`( " + " `id` INTEGER PRIMARY KEY NOT NULL, " + " `tts` TEXT, " + " `label` TEXT, " + " `line1` TEXT, " + " `line2` TEXT, " + " `textBody` TEXT, " + " `language_code` VARCHAR(25) NOT NULL, " + " `message_type_name` VARCHAR(45) NOT NULL, " + " CONSTRAINT `fk_messages_languages1` " + " FOREIGN KEY(`language_code`) " + " REFERENCES `language`(`code`), " + " CONSTRAINT `fk_message_consumer_friendly_messages1` " + " FOREIGN KEY(`message_type_name`) " + " REFERENCES `message_type`(`name`) " + "); " + "CREATE INDEX IF NOT EXISTS `message.fk_messages_languages1_idx` " + " ON `message`(`language_code`);" + "CREATE INDEX IF NOT EXISTS " + "`message.fk_message_consumer_friendly_messages1_idx` " + " ON `message`(`message_type_name`);" + "COMMIT;"; const std::string kInsertInitData = - "INSERT OR IGNORE INTO `usage_and_error_count` ( " - " `count_of_iap_buffer_full`, `count_sync_out_of_memory`, " - " `count_of_sync_reboots`) VALUES (0, 0, 0); " - "INSERT OR IGNORE INTO `module_meta` (`pt_exchanged_at_odometer_x`, " - " `pt_exchanged_x_days_after_epoch`, `ignition_cycles_since_last_exchange`," - " `flag_update_required`) " - " VALUES (0, 0, 0, 0); " - "INSERT OR IGNORE INTO `module_config` (`preloaded_pt`, `is_first_run`," - " `exchange_after_x_ignition_cycles`, `exchange_after_x_kilometers`, " - " `exchange_after_x_days`, `timeout_after_x_seconds`) " - " VALUES(1, 0, 0, 0, 0, 0); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('EMERGENCY'); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NAVIGATION'); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('VOICECOMMUNICATION'); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('COMMUNICATION'); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NORMAL'); " - "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NONE'); " - "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('FULL'); " - "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('LIMITED'); " - "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('BACKGROUND'); " - "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('NONE'); " - "INSERT OR IGNORE INTO `version` (`number`) VALUES('0'); " - ""; + "INSERT OR IGNORE INTO `usage_and_error_count` ( " + " `count_of_iap_buffer_full`, `count_sync_out_of_memory`, " + " `count_of_sync_reboots`) VALUES (0, 0, 0); " + "INSERT OR IGNORE INTO `module_meta` (`pt_exchanged_at_odometer_x`, " + " `pt_exchanged_x_days_after_epoch`, " + "`ignition_cycles_since_last_exchange`," + " `flag_update_required`) " + " VALUES (0, 0, 0, 0); " + "INSERT OR IGNORE INTO `module_config` (`preloaded_pt`, `is_first_run`," + " `exchange_after_x_ignition_cycles`, `exchange_after_x_kilometers`, " + " `exchange_after_x_days`, `timeout_after_x_seconds`) " + " VALUES(1, 0, 0, 0, 0, 0); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('EMERGENCY'); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NAVIGATION'); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('VOICECOMMUNICATION'); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('COMMUNICATION'); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NORMAL'); " + "INSERT OR IGNORE INTO `priority`(`value`) VALUES ('NONE'); " + "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('FULL'); " + "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('LIMITED'); " + "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('BACKGROUND'); " + "INSERT OR IGNORE INTO `hmi_level`(`value`) VALUES ('NONE'); " + "INSERT OR IGNORE INTO `version` (`number`) VALUES('0'); " + ""; const std::string kDropSchema = - "BEGIN; " - "DROP INDEX IF EXISTS `message.fk_messages_languages1_idx`; " - "DROP INDEX IF EXISTS `message.fk_message_consumer_friendly_messages1_idx`; " - "DROP TABLE IF EXISTS `message`; " - "DROP INDEX IF EXISTS `endpoint.fk_endpoint_application1_idx`; " - "DROP TABLE IF EXISTS `endpoint`; " - "DROP INDEX IF EXISTS `consent_group.fk_consent_group_device1_idx`; " - "DROP INDEX IF EXISTS `consent_group.fk_consent_group_functional_group1_idx`; " - "DROP TABLE IF EXISTS `consent_group`; " - "DROP INDEX IF EXISTS `app_type.fk_app_type_application1_idx`; " - "DROP TABLE IF EXISTS `app_type`; " - "DROP INDEX IF EXISTS `nickname.fk_nickname_application1_idx`; " - "DROP TABLE IF EXISTS `nickname`; " - "DROP INDEX IF EXISTS `app_level.fk_app_level_language2_idx`; " - "DROP INDEX IF EXISTS `app_level.fk_app_level_language1_idx`; " - "DROP INDEX IF EXISTS `app_level.fk_app_levels_application1_idx`; " - "DROP TABLE IF EXISTS `app_level`; " - "DROP INDEX IF EXISTS `device_consent_group.fk_device_has_functional_group_device1_idx`; " - "DROP INDEX IF EXISTS `device_consent_group.fk_device_has_functional_group_functional_group1_idx`; " - "DROP TABLE IF EXISTS `device_consent_group`; " - "DROP TABLE IF EXISTS `seconds_between_retry`; " - "DROP INDEX IF EXISTS `preconsented_group.fk_application_has_functional_group_application2_idx`; " - "DROP INDEX IF EXISTS `preconsented_group.fk_application_has_functional_group_functional_group2_idx`; " - "DROP TABLE IF EXISTS `preconsented_group`; " - "DROP INDEX IF EXISTS `app_group.fk_application_has_functional_group_application1_idx`; " - "DROP INDEX IF EXISTS `app_group.fk_application_has_functional_group_functional_group1_idx`; " - "DROP TABLE IF EXISTS `app_group`; " - "DROP INDEX IF EXISTS `application.fk_application_priorities1_idx`; " - "DROP INDEX IF EXISTS `application.fk_application_hmi_level1_idx`; " - "DROP TABLE IF EXISTS `application`; " - "DROP INDEX IF EXISTS `rpc.select_rpc_name_hmi_level`; " - "DROP INDEX IF EXISTS `rpc.fk_rpc_functional_group1_idx`; " - "DROP INDEX IF EXISTS `rpc.fk_rpc_hmi_level1_idx`; " - "DROP TABLE IF EXISTS `rpc`; " - "DROP TABLE IF EXISTS `version`; " - "DROP TABLE IF EXISTS `message_type`; " - "DROP TABLE IF EXISTS `language`; " - "DROP INDEX IF EXISTS `notifications_by_priority.fk_notifications_by_priority_priority1_idx`; " - "DROP TABLE IF EXISTS `notifications_by_priority`; " - "DROP TABLE IF EXISTS `hmi_level`; " - "DROP TABLE IF EXISTS `priority`; " - "DROP TABLE IF EXISTS `functional_group`; " - "DROP TABLE IF EXISTS `module_config`; " - "DROP TABLE IF EXISTS `module_meta`; " - "DROP TABLE IF EXISTS `usage_and_error_count`; " - "DROP TABLE IF EXISTS `device`; " - "COMMIT; " - "VACUUM;"; - -const std::string kDeleteData = - "BEGIN; " - "DELETE FROM `message`; " - "DELETE FROM `endpoint`; " - "DELETE FROM `consent_group`; " - "DELETE FROM `app_type`; " - "DELETE FROM `nickname`; " - "DELETE FROM `app_level`; " - "DELETE FROM `device_consent_group`; " - "DELETE FROM `seconds_between_retry`; " - "DELETE FROM `preconsented_group`; " - "DELETE FROM `app_group`; " - "DELETE FROM `application`; " - "DELETE FROM `rpc`; " - "DELETE FROM `version`; " - "DELETE FROM `message_type`; " - "DELETE FROM `language`; " - "DELETE FROM `notifications_by_priority`; " - "DELETE FROM `hmi_level`; " - "DELETE FROM `priority`; " - "DELETE FROM `functional_group`; " - "DELETE FROM `module_config`; " - "DELETE FROM `module_meta`; " - "DELETE FROM `usage_and_error_count`; " - "DELETE FROM `device`; " - "COMMIT; " - "VACUUM;"; + "BEGIN; " + "DROP INDEX IF EXISTS `message.fk_messages_languages1_idx`; " + "DROP INDEX IF EXISTS " + "`message.fk_message_consumer_friendly_messages1_idx`; " + "DROP TABLE IF EXISTS `message`; " + "DROP INDEX IF EXISTS `endpoint.fk_endpoint_application1_idx`; " + "DROP TABLE IF EXISTS `endpoint`; " + "DROP INDEX IF EXISTS `consent_group.fk_consent_group_device1_idx`; " + "DROP INDEX IF EXISTS " + "`consent_group.fk_consent_group_functional_group1_idx`; " + "DROP TABLE IF EXISTS `consent_group`; " + "DROP INDEX IF EXISTS `app_type.fk_app_type_application1_idx`; " + "DROP TABLE IF EXISTS `app_type`; " + "DROP INDEX IF EXISTS `nickname.fk_nickname_application1_idx`; " + "DROP TABLE IF EXISTS `nickname`; " + "DROP INDEX IF EXISTS `app_level.fk_app_level_language2_idx`; " + "DROP INDEX IF EXISTS `app_level.fk_app_level_language1_idx`; " + "DROP INDEX IF EXISTS `app_level.fk_app_levels_application1_idx`; " + "DROP TABLE IF EXISTS `app_level`; " + "DROP INDEX IF EXISTS " + "`device_consent_group.fk_device_has_functional_group_device1_idx`; " + "DROP INDEX IF EXISTS " + "`device_consent_group.fk_device_has_functional_group_functional_group1_" + "idx`; " + "DROP TABLE IF EXISTS `device_consent_group`; " + "DROP TABLE IF EXISTS `seconds_between_retry`; " + "DROP INDEX IF EXISTS " + "`preconsented_group.fk_application_has_functional_group_application2_idx`;" + " " + "DROP INDEX IF EXISTS " + "`preconsented_group.fk_application_has_functional_group_functional_group2_" + "idx`; " + "DROP TABLE IF EXISTS `preconsented_group`; " + "DROP INDEX IF EXISTS " + "`app_group.fk_application_has_functional_group_application1_idx`; " + "DROP INDEX IF EXISTS " + "`app_group.fk_application_has_functional_group_functional_group1_idx`; " + "DROP TABLE IF EXISTS `app_group`; " + "DROP INDEX IF EXISTS `application.fk_application_priorities1_idx`; " + "DROP INDEX IF EXISTS `application.fk_application_hmi_level1_idx`; " + "DROP TABLE IF EXISTS `application`; " + "DROP INDEX IF EXISTS `rpc.select_rpc_name_hmi_level`; " + "DROP INDEX IF EXISTS `rpc.fk_rpc_functional_group1_idx`; " + "DROP INDEX IF EXISTS `rpc.fk_rpc_hmi_level1_idx`; " + "DROP TABLE IF EXISTS `rpc`; " + "DROP TABLE IF EXISTS `version`; " + "DROP TABLE IF EXISTS `message_type`; " + "DROP TABLE IF EXISTS `language`; " + "DROP INDEX IF EXISTS " + "`notifications_by_priority.fk_notifications_by_priority_priority1_idx`; " + "DROP TABLE IF EXISTS `notifications_by_priority`; " + "DROP TABLE IF EXISTS `hmi_level`; " + "DROP TABLE IF EXISTS `priority`; " + "DROP TABLE IF EXISTS `functional_group`; " + "DROP TABLE IF EXISTS `module_config`; " + "DROP TABLE IF EXISTS `module_meta`; " + "DROP TABLE IF EXISTS `usage_and_error_count`; " + "DROP TABLE IF EXISTS `device`; " + "COMMIT; " + "VACUUM;"; + +const std::string kDeleteData = "BEGIN; " + "DELETE FROM `message`; " + "DELETE FROM `endpoint`; " + "DELETE FROM `consent_group`; " + "DELETE FROM `app_type`; " + "DELETE FROM `nickname`; " + "DELETE FROM `app_level`; " + "DELETE FROM `device_consent_group`; " + "DELETE FROM `seconds_between_retry`; " + "DELETE FROM `preconsented_group`; " + "DELETE FROM `app_group`; " + "DELETE FROM `application`; " + "DELETE FROM `rpc`; " + "DELETE FROM `version`; " + "DELETE FROM `message_type`; " + "DELETE FROM `language`; " + "DELETE FROM `notifications_by_priority`; " + "DELETE FROM `hmi_level`; " + "DELETE FROM `priority`; " + "DELETE FROM `functional_group`; " + "DELETE FROM `module_config`; " + "DELETE FROM `module_meta`; " + "DELETE FROM `usage_and_error_count`; " + "DELETE FROM `device`; " + "COMMIT; " + "VACUUM;"; const std::string kCheckDBIntegrity = "PRAGMA integrity_check"; const std::string kCheckPgNumber = "PRAGMA page_count"; const std::string kSelectRpc = - "SELECT DISTINCT `rpc`.`parameter` FROM `rpc` " - " JOIN `app_group` AS `g` ON (`g`.`functional_group_id` = `rpc`.`functional_group_id` " - " AND (`g`.`application_id` = ?)) " - "WHERE `rpc`.`hmi_level_value` = ? AND `rpc`.`name` = ?"; + "SELECT DISTINCT `rpc`.`parameter` FROM `rpc` " + " JOIN `app_group` AS `g` ON (`g`.`functional_group_id` = " + "`rpc`.`functional_group_id` " + " AND (`g`.`application_id` = ?)) " + "WHERE `rpc`.`hmi_level_value` = ? AND `rpc`.`name` = ?"; const std::string kSelectPreloaded = - "SELECT `preloaded_pt` FROM `module_config` " - "WHERE `preloaded_pt` = 1 LIMIT 1"; + "SELECT `preloaded_pt` FROM `module_config` " + "WHERE `preloaded_pt` = 1 LIMIT 1"; const std::string kUpdatePreloaded = - "UPDATE `module_config` SET `preloaded_pt` = ?"; + "UPDATE `module_config` SET `preloaded_pt` = ?"; -const std::string kIsFirstRun = - "SELECT `is_first_run` FROM `module_config` "; +const std::string kIsFirstRun = "SELECT `is_first_run` FROM `module_config` "; const std::string kSetNotFirstRun = - "UPDATE `module_config` SET `is_first_run`= 0 "; + "UPDATE `module_config` SET `is_first_run`= 0 "; const std::string kSelectEndpoint = - "SELECT `url`, `application_id` FROM `endpoint` WHERE `service` = ? "; + "SELECT `url`, `application_id` FROM `endpoint` WHERE `service` = ? "; const std::string kSelectLockScreenIcon = - "SELECT `url` FROM `endpoint` WHERE `service` = ? AND `application_id` = ?"; + "SELECT `url` FROM `endpoint` WHERE `service` = ? AND `application_id` = ?"; const std::string kInsertFunctionalGroup = - "INSERT INTO `functional_group` (`id`, `name`, `user_consent_prompt`) " - " VALUES (?, ?, ?)"; + "INSERT INTO `functional_group` (`id`, `name`, `user_consent_prompt`) " + " VALUES (?, ?, ?)"; const std::string kInsertRpc = - "INSERT INTO `rpc` (`name`, `hmi_level_value`, `functional_group_id`) " - " VALUES (?, ?, ?)"; + "INSERT INTO `rpc` (`name`, `hmi_level_value`, `functional_group_id`) " + " VALUES (?, ?, ?)"; -const std::string kInsertRpcWithParameter = - "INSERT INTO `rpc` (`name`, `hmi_level_value`, `parameter`, `functional_group_id`) " - " VALUES (?, ?, ?, ?)"; +const std::string kInsertRpcWithParameter = "INSERT INTO `rpc` (`name`, " + "`hmi_level_value`, `parameter`, " + "`functional_group_id`) " + " VALUES (?, ?, ?, ?)"; const std::string kInsertApplication = - "INSERT OR IGNORE INTO `application` (`id`, `priority_value`, `is_revoked`, `memory_kb`," - " `heart_beat_timeout_ms`, `certificate`) VALUES (?,?,?,?,?,?)"; + "INSERT OR IGNORE INTO `application` (`id`, `priority_value`, " + "`is_revoked`, `memory_kb`," + " `heart_beat_timeout_ms`, `certificate`) VALUES (?,?,?,?,?,?)"; const std::string kInsertAppGroup = - "INSERT INTO `app_group` (`application_id`, `functional_group_id`)" - " SELECT ?, `id` FROM `functional_group` WHERE `name` = ? LIMIT 1"; + "INSERT INTO `app_group` (`application_id`, `functional_group_id`)" + " SELECT ?, `id` FROM `functional_group` WHERE `name` = ? LIMIT 1"; const std::string kInsertNickname = - "INSERT OR IGNORE INTO `nickname` (`application_id`, `name`) VALUES (?, ?)"; + "INSERT OR IGNORE INTO `nickname` (`application_id`, `name`) VALUES (?, ?)"; const std::string kInsertAppType = - "INSERT OR IGNORE INTO `app_type` (`application_id`, `name`) VALUES (?, ?)"; + "INSERT OR IGNORE INTO `app_type` (`application_id`, `name`) VALUES (?, ?)"; -const std::string kInsertRequestType = - "INSERT OR IGNORE INTO `request_type` (`application_id`, `request_type`) VALUES (?, ?)"; +const std::string kInsertRequestType = "INSERT OR IGNORE INTO `request_type` " + "(`application_id`, `request_type`) " + "VALUES (?, ?)"; const std::string kUpdateVersion = "UPDATE `version` SET `number`= ?"; const std::string kInsertMessageType = - "INSERT OR IGNORE INTO `message_type` (`name`) VALUES (?)"; + "INSERT OR IGNORE INTO `message_type` (`name`) VALUES (?)"; const std::string kInsertLanguage = - "INSERT OR IGNORE INTO `language` (`code`) VALUES (?)"; + "INSERT OR IGNORE INTO `language` (`code`) VALUES (?)"; const std::string kInsertMessageString = - "INSERT INTO `message` (`tts`, `label`, `line1`, `line2`, `language_code`, " - " `message_type_name`, `textBody`) VALUES (?, ?, ?, ?, ?, ?, ?)"; + "INSERT INTO `message` (`tts`, `label`, `line1`, `line2`, `language_code`, " + " `message_type_name`, `textBody`) VALUES (?, ?, ?, ?, ?, ?, ?)"; const std::string kUpdateModuleConfig = - "UPDATE `module_config` SET `preloaded_pt` = ?, " - " `exchange_after_x_ignition_cycles` = ?," - " `exchange_after_x_kilometers` = ?, `exchange_after_x_days` = ?, " - " `timeout_after_x_seconds` = ?, `vehicle_make` = ?, " - " `vehicle_model` = ?, `vehicle_year` = ?"; + "UPDATE `module_config` SET `preloaded_pt` = ?, " + " `exchange_after_x_ignition_cycles` = ?," + " `exchange_after_x_kilometers` = ?, `exchange_after_x_days` = ?, " + " `timeout_after_x_seconds` = ?, `vehicle_make` = ?, " + " `vehicle_model` = ?, `vehicle_year` = ?, `certificate` = ?"; const std::string kInsertEndpoint = - "INSERT INTO `endpoint` (`service`, `url`, `application_id`) " - " VALUES (?, ?, ?)"; + "INSERT INTO `endpoint` (`service`, `url`, `application_id`) " + " VALUES (?, ?, ?)"; const std::string kInsertSecondsBetweenRetry = - "INSERT INTO `seconds_between_retry` (`index`, `value`) VALUES (?, ?)"; + "INSERT INTO `seconds_between_retry` (`index`, `value`) VALUES (?, ?)"; const std::string kInsertNotificationsByPriority = - "INSERT OR REPLACE INTO `notifications_by_priority` (`priority_value`, `value`) " - " VALUES (?, ?)"; + "INSERT OR REPLACE INTO `notifications_by_priority` (`priority_value`, " + "`value`) " + " VALUES (?, ?)"; const std::string kInsertDeviceData = - "INSERT OR IGNORE INTO `device` (`id`) VALUES (?)"; + "INSERT OR IGNORE INTO `device` (`id`) VALUES (?)"; const std::string kInsertAppLevel = - "INSERT INTO `app_level` (`application_id`, `minutes_in_hmi_full`," + "INSERT INTO `app_level` (`application_id`, `minutes_in_hmi_full`," "`minutes_in_hmi_limited` ,`minutes_in_hmi_background`," "`minutes_in_hmi_none`,`count_of_user_selections`," "`count_of_rejections_sync_out_of_memory`," @@ -525,7 +548,7 @@ const std::string kInsertAppLevel = "`app_registration_language_vui`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; const std::string kDeleteSecondsBetweenRetries = - "DELETE FROM `seconds_between_retry`"; + "DELETE FROM `seconds_between_retry`"; const std::string kDeleteEndpoint = "DELETE FROM `endpoint`"; @@ -540,17 +563,17 @@ const std::string kDeleteRpc = "DELETE FROM `rpc`"; const std::string kDeleteAppGroup = "DELETE FROM `app_group`"; const std::string kSelectModuleConfig = - "SELECT `preloaded_pt`, `exchange_after_x_ignition_cycles`, " - " `exchange_after_x_kilometers`, `exchange_after_x_days`, " - " `timeout_after_x_seconds`, `vehicle_make`," - " `vehicle_model`, `vehicle_year` " - " FROM `module_config`"; + "SELECT `preloaded_pt`, `exchange_after_x_ignition_cycles`, " + " `exchange_after_x_kilometers`, `exchange_after_x_days`, " + " `timeout_after_x_seconds`, `vehicle_make`," + " `vehicle_model`, `vehicle_year`, `certificate` " + " FROM `module_config`"; const std::string kSelectEndpoints = - "SELECT `url`, `service`, `application_id` FROM `endpoint` "; + "SELECT `url`, `service`, `application_id` FROM `endpoint` "; const std::string kSelectNotificationsPerMin = - "SELECT `priority_value`, `value` FROM notifications_by_priority"; + "SELECT `priority_value`, `value` FROM notifications_by_priority"; const std::string kSelectNotificationsPerPriority = "SELECT `value` FROM notifications_by_priority WHERE `priority_value` = ? "; @@ -560,23 +583,25 @@ const std::string kSelectAppLevels = "SELECT `application_id` FROM `app_level`"; const std::string kSelectDeviceData = "SELECT * FROM `device`"; const std::string kSelectFunctionalGroups = - "SELECT `id`,`name`, `user_consent_prompt` " - "FROM `functional_group`"; + "SELECT `id`,`name`, `user_consent_prompt` " + "FROM `functional_group`"; const std::string kSelectAllRpcs = - "SELECT `name`, `hmi_level_value`, `parameter` " - "FROM `rpc` WHERE `functional_group_id` = ? "; + "SELECT `name`, `hmi_level_value`, `parameter` " + "FROM `rpc` WHERE `functional_group_id` = ? "; const std::string kSelectUserMsgsVersion = - "SELECT DISTINCT `number` FROM `version`"; + "SELECT DISTINCT `number` FROM `version`"; -const std::string kSelectAppPolicies = "SELECT `id`, `priority_value`, `memory_kb`, " - " `heart_beat_timeout_ms`, `certificate` FROM `application`"; +const std::string kSelectAppPolicies = + "SELECT `id`, `priority_value`, `memory_kb`, " + " `heart_beat_timeout_ms`, `certificate` FROM `application`"; -const std::string kSelectAppGroups = "SELECT `f`.`name` FROM `app_group` AS `a`" - " LEFT JOIN `functional_group` AS `f` " - " ON (`f`.`id` = `a`.`functional_group_id`)" - " WHERE `a`.`application_id` = ?"; +const std::string kSelectAppGroups = + "SELECT `f`.`name` FROM `app_group` AS `a`" + " LEFT JOIN `functional_group` AS `f` " + " ON (`f`.`id` = `a`.`functional_group_id`)" + " WHERE `a`.`application_id` = ?"; const std::string kSelectNicknames = "SELECT DISTINCT `name` FROM `nickname` " "WHERE `application_id` = ?"; @@ -584,85 +609,88 @@ const std::string kSelectNicknames = "SELECT DISTINCT `name` FROM `nickname` " const std::string kSelectAppTypes = "SELECT DISTINCT `name` FROM `app_type` " "WHERE `application_id` = ?"; -const std::string kSelectRequestTypes = - "SELECT DISTINCT `request_type` FROM `request_type` WHERE `application_id` = ?"; +const std::string kSelectRequestTypes = "SELECT DISTINCT `request_type` FROM " + "`request_type` WHERE `application_id` " + "= ?"; const std::string kSelectSecondsBetweenRetries = - "SELECT `value` FROM `seconds_between_retry` ORDER BY `index`"; + "SELECT `value` FROM `seconds_between_retry` ORDER BY `index`"; const std::string kSelectIgnitionCycles = - "SELECT `c`.`exchange_after_x_ignition_cycles`, " - " `m`.`ignition_cycles_since_last_exchange` " - " FROM `module_config` AS `c`, `module_meta` AS `m` " - "LIMIT 1"; + "SELECT `c`.`exchange_after_x_ignition_cycles`, " + " `m`.`ignition_cycles_since_last_exchange` " + " FROM `module_config` AS `c`, `module_meta` AS `m` " + "LIMIT 1"; const std::string kSelectKilometers = - "SELECT `c`.`exchange_after_x_kilometers`, " - " `m`.`pt_exchanged_at_odometer_x` " - " FROM `module_config` AS `c`, `module_meta` AS `m` " - "LIMIT 1"; + "SELECT `c`.`exchange_after_x_kilometers`, " + " `m`.`pt_exchanged_at_odometer_x` " + " FROM `module_config` AS `c`, `module_meta` AS `m` " + "LIMIT 1"; -const std::string kSelectDays = "SELECT `c`.`exchange_after_x_days`, " - " `m`.`pt_exchanged_x_days_after_epoch` " - " FROM `module_config` AS `c`, `module_meta` AS `m` " - "LIMIT 1"; +const std::string kSelectDays = + "SELECT `c`.`exchange_after_x_days`, " + " `m`.`pt_exchanged_x_days_after_epoch` " + " FROM `module_config` AS `c`, `module_meta` AS `m` " + "LIMIT 1"; const std::string kIncrementIgnitionCycles = - "UPDATE `module_meta` SET `ignition_cycles_since_last_exchange` = 1 + " - " `ignition_cycles_since_last_exchange`"; + "UPDATE `module_meta` SET `ignition_cycles_since_last_exchange` = 1 + " + " `ignition_cycles_since_last_exchange`"; const std::string kResetIgnitionCycles = - "UPDATE `module_meta` SET `ignition_cycles_since_last_exchange` = 0"; + "UPDATE `module_meta` SET `ignition_cycles_since_last_exchange` = 0"; const std::string kSelectTimeoutResponse = - "SELECT `timeout_after_x_seconds` FROM `module_config` LIMIT 1"; + "SELECT `timeout_after_x_seconds` FROM `module_config` LIMIT 1"; const std::string kUpdateFlagUpdateRequired = - "UPDATE `module_meta` SET `flag_update_required` = ?"; + "UPDATE `module_meta` SET `flag_update_required` = ?"; const std::string kSelectFlagUpdateRequired = - "SELECT `flag_update_required` FROM `module_meta` LIMIT 1"; + "SELECT `flag_update_required` FROM `module_meta` LIMIT 1"; const std::string kUpdateCountersSuccessfulUpdate = - "UPDATE `module_meta` SET `pt_exchanged_at_odometer_x` = ?," - "`pt_exchanged_x_days_after_epoch` = ?"; + "UPDATE `module_meta` SET `pt_exchanged_at_odometer_x` = ?," + "`pt_exchanged_x_days_after_epoch` = ?"; const std::string kDeleteApplication = "DELETE FROM `application`"; const std::string kDeleteRequestType = "DELETE FROM `request_type`"; const std::string kSelectApplicationRevoked = - "SELECT `is_revoked` FROM `application` WHERE `id` = ?"; + "SELECT `is_revoked` FROM `application` WHERE `id` = ?"; const std::string kUpdateApplicationCustomData = - "UPDATE `application` SET `is_revoked` = ?, `is_default` = ?," - "`is_predata` = ? WHERE `id` = ?"; + "UPDATE `application` SET `is_revoked` = ?, `is_default` = ?," + "`is_predata` = ? WHERE `id` = ?"; const std::string kSelectApplicationRepresented = - "SELECT COUNT(`id`) FROM `application` WHERE `id` = ?"; + "SELECT COUNT(`id`) FROM `application` WHERE `id` = ?"; const std::string kSelectApplicationIsDefault = - "SELECT `is_default` FROM `application` WHERE `id` = ?"; + "SELECT `is_default` FROM `application` WHERE `id` = ?"; const std::string kUpdateIsDefault = - "UPDATE `application` SET `is_default` = ? WHERE `id` = ?"; + "UPDATE `application` SET `is_default` = ? WHERE `id` = ?"; const std::string kDeleteDevice = "DELETE FROM `device` WHERE `id` = ?"; const std::string kDeleteAppGroupByApplicationId = - "DELETE FROM `app_group` WHERE `application_id` = ?"; + "DELETE FROM `app_group` WHERE `application_id` = ?"; const std::string kInsertApplicationFull = - "INSERT OR IGNORE INTO `application` (`id`, `keep_context`, `steal_focus`, " - " `default_hmi`, `priority_value`, `is_revoked`, `is_default`, `is_predata`, " - " `memory_kb`, `heart_beat_timeout_ms`, `certificate`) " - " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; + "INSERT OR IGNORE INTO `application` (`id`, `keep_context`, `steal_focus`, " + " `default_hmi`, `priority_value`, `is_revoked`, `is_default`, " + "`is_predata`, " + " `memory_kb`, `heart_beat_timeout_ms`, `certificate`) " + " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; const std::string kSelectApplicationFull = - "SELECT `keep_context`, `steal_focus`, `default_hmi`, `priority_value`, " - " `is_revoked`, `is_default`, `is_predata`, `memory_kb`," - " `heart_beat_timeout_ms`, `certificate` FROM `application` WHERE `id` = ?"; - -} // namespace sql_pt -} // namespace policy + "SELECT `keep_context`, `steal_focus`, `default_hmi`, `priority_value`, " + " `is_revoked`, `is_default`, `is_predata`, `memory_kb`," + " `heart_beat_timeout_ms`, `certificate` FROM `application` WHERE `id` = " + "?"; +} // namespace sql_pt +} // namespace policy |