{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'PatientId': 'VARCHAR(128) NOT NULL', 'FirstName': 'VARCHAR(128)', 'LastName': 'VARCHAR(128)', 'ValueMmol': 'DECIMAL(5,1) DEFAULT 0', 'ValueMgdl': 'INT DEFAULT 0', 'TrendArrow': 'INT DEFAULT 0', 'TrendLabel': 'VARCHAR(32)', 'MeasurementColor': 'INT DEFAULT 0', 'ColorLabel': 'VARCHAR(32)', 'IsHigh': 'TINYINT(1) DEFAULT 0', 'IsLow': 'TINYINT(1) DEFAULT 0', 'SensorSn': 'VARCHAR(32)', 'DeviceTimestamp': 'VARCHAR(64)', 'FactoryTimestamp': 'VARCHAR(64)', 'TargetLow': 'INT DEFAULT 0', 'TargetHigh': 'INT DEFAULT 0', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP'}
INSERT INTO data_glucose
(Guid, PatientId, FirstName, LastName,
ValueMmol, ValueMgdl,
TrendArrow, TrendLabel,
MeasurementColor, ColorLabel,
IsHigh, IsLow,
SensorSn, DeviceTimestamp, FactoryTimestamp,
TargetLow, TargetHigh,
Package, Module)
VALUES
('{guid}', '{patient_id}',
'{first_name}', '{last_name}',
{value_mmol}, {value_mgdl},
{trend_arrow}, '{trend_label}',
{measurement_color}, '{color_label}',
{is_high}, {is_low},
'{sensor_sn}', '{device_timestamp}',
'{factory_timestamp}',
{target_low}, {target_high},
'{package}', 'ObjServiceLibreGlucose')
SELECT * FROM data_glucose WHERE PatientId = '{patient_id}'
AND Package = '{package}'
ORDER BY CreateTime DESC LIMIT 1
SELECT COUNT(*) FROM data_glucose WHERE PatientId = '{patient_id}'
AND DeviceTimestamp = '{device_timestamp}'
AND Package = '{package}'
SELECT * FROM data_glucose WHERE PatientId = '{patient_id}'
AND Package = '{package}'
AND CreateTime BETWEEN '{start_time}' AND '{end_time}'
ORDER BY CreateTime
SELECT
DATE(CreateTime) AS ReadingDate,
MIN(ValueMmol) AS MinGlucose,
MAX(ValueMmol) AS MaxGlucose,
AVG(ValueMmol) AS AvgGlucose,
SUM(IsHigh) AS HighCount,
SUM(IsLow) AS LowCount,
SUM(CASE WHEN ColorLabel = 'in_range' THEN 1 ELSE 0 END) AS InRangeCount,
COUNT(*) AS ReadingCount
FROM data_glucose WHERE PatientId = '{patient_id}'
AND Package = '{package}'
AND CreateTime BETWEEN '{start_time}' AND '{end_time}'
GROUP BY DATE(CreateTime) ORDER BY ReadingDate
SELECT
DATE(CreateTime) AS ReadingDate,
HOUR(CreateTime) AS ReadingHour,
AVG(ValueMmol) AS AvgGlucose,
MIN(ValueMmol) AS MinGlucose,
MAX(ValueMmol) AS MaxGlucose,
COUNT(*) AS ReadingCount
FROM data_glucose WHERE PatientId = '{patient_id}'
AND Package = '{package}'
AND CreateTime BETWEEN '{start_time}' AND '{end_time}'
GROUP BY DATE(CreateTime), HOUR(CreateTime) ORDER BY ReadingDate, ReadingHour
SELECT
COUNT(*) AS TotalReadings,
SUM(CASE WHEN ValueMgdl BETWEEN {target_low} AND {target_high} THEN 1 ELSE 0 END) AS InRange,
SUM(CASE WHEN ValueMgdl > {target_high} THEN 1 ELSE 0 END) AS AboveRange,
SUM(CASE WHEN ValueMgdl < {target_low} THEN 1 ELSE 0 END) AS BelowRange,
ROUND(100.0 * SUM(CASE WHEN ValueMgdl BETWEEN {target_low} AND {target_high} THEN 1 ELSE 0 END) / COUNT(*), 1) AS TimeInRangePct
FROM data_glucose WHERE PatientId = '{patient_id}'
AND Package = '{package}'
AND CreateTime BETWEEN '{start_time}' AND '{end_time}'