htsg_operations_log.sql

htsg_operations_log.sql

CREATE TABLE `htsg_operations_log` (
  `id` bigint(20) unsigned NOT NULL,
  `namespace` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `txnid` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_date` bigint(20) unsigned NOT NULL,
  `update_date` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_language` (`namespace`, `name`, `operation`, `txnid`),
  KEY `name` (`namespace`, `name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

-- EXAMPLES OF INSERTING VALUES INTO TABLE WHEN WE PERFORM THE "EXTRACTION" STEPS:
----

-- UPLOAD ANDROID FILE SUCCESSFULLY
INSERT INTO `htsg_operations_log` (`namespace`, `name`, `operation`, `txnid`, `status`)
VALUES ('CLIENTID_PROJECTID', 'strings.xml', 'upload', 'MASTER_GIT_SHA', 'success');

-- ANALYSIS COMPLETE FOR ANDROID FILE SUCCESSFULLY
INSERT INTO `htsg_operations_log` (`namespace`, `name`, `operation`, `txnid`, `status`)
VALUES ('CLIENTID_PROJECTID', 'strings.xml', 'analysis_complete', 'MASTER_GIT_SHA', 'success');

-- EXAMPLES OF INSERTING VALUES INTO TABLE WHEN WE PERFORM THE "REFRESH TRANSLATED FILES CACHE" STEPS:
----

-- TRIGGER REFRESH TRANSLATED ANDROID FILES (TRIGGER TRANSLATED FILE GENERATION)
INSERT INTO `htsg_operations_log` (`namespace`, `name`, `operation`, `txnid`, `status`)
VALUES ('CLIENTID_PROJECTID', 'strings.xml', 'trigger_translated_refresh', 'TRIGGER_TIMESTAMP', 'success');

-- DOWNLOAD TRANSLATED ANDROID FILES
INSERT INTO `htsg_operations_log` (`namespace`, `name`, `operation`, `txnid`, `status`)
VALUES ('CLIENTID_PROJECTID', 'strings.xml', 'download_latest_translated', 'TRIGGER_TIMESTAMP', 'success');

-- SAVE LATEST TRANSLATED ANDROID FILES TO CACHE TABLE
INSERT INTO `htsg_operations_log` (`namespace`, `name`, `operation`, `txnid`, `status`)
VALUES ('CLIENTID_PROJECTID', 'strings.xml', 'save_latest_translated_cache', 'TRIGGER_TIMESTAMP', 'success');