{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'PersonGuid': 'VARCHAR(128) NOT NULL', 'FirstName': 'VARCHAR(128)', 'LastName': 'VARCHAR(128)', 'IdNumber': 'VARCHAR(16)', 'Category': 'VARCHAR(32)', 'Status': 'VARCHAR(32)', 'HitCount': 'INT DEFAULT 0', 'ResultSummary': 'TEXT', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'UpdateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'}
{'ErrorGuid': 'VARCHAR(64) NOT NULL', 'ProcessGuid': 'VARCHAR(64) NOT NULL', 'TimeNow': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'ErrorMessage': 'TEXT', 'UserName': 'VARCHAR(100)', 'Param1': 'VARCHAR(255)', 'Param2': 'VARCHAR(255)', 'Param3': 'VARCHAR(255)', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'PRIMARY_KEY': 'ProcessGuid, ErrorGuid'}
SELECT Username, Password, Url, GrantType FROM def_truvalidate_credentials WHERE Package = '{package}' LIMIT 1
SELECT
FirstName, Surname, DateOfBirth
FROM {application_table} WHERE ApplicationGuid = '{guid}' LIMIT 1
INSERT INTO {error_table}
(ErrorGuid, ProcessGuid, ErrorMessage,
UserName, Param1, Param2, Param3,
Package, Module)
VALUES
('{error_guid}', '{process_guid}',
'{message}', '{user_name}',
'{param1}', '{param2}', '{param3}',
'{package}', 'ObjServiceTruValidate')
SELECT PersonGuid, Category, Status, HitCount,
ResultSummary, UpdateTime
FROM data_truvalidate WHERE PersonGuid = '{person_guid}'
AND Category = '{category}'
AND Package = '{package}'
ORDER BY UpdateTime DESC LIMIT 1
INSERT INTO data_truvalidate
(Guid, PersonGuid, FirstName, LastName,
IdNumber, Category, Status, HitCount,
ResultSummary, Package, Module)
VALUES
('{guid}', '{person_guid}',
'{first_name}', '{last_name}',
'{id_number}', '{category}',
'{status}', {hit_count},
'{result_summary}',
'{package}', 'ObjServiceTruValidate')
ON DUPLICATE KEY UPDATE
Status = VALUES(Status),
HitCount = VALUES(HitCount),
ResultSummary = VALUES(ResultSummary),
FirstName = VALUES(FirstName),
LastName = VALUES(LastName)
SELECT PersonGuid, FirstName, LastName,
Category, Status, HitCount, UpdateTime
FROM data_truvalidate WHERE Package = '{package}' ORDER BY UpdateTime DESC
SELECT
Status,
COUNT(*) AS Total
FROM data_truvalidate WHERE Package = '{package}' GROUP BY Status ORDER BY Total DESC