{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Person': 'VARCHAR(64)', 'MemberId': 'VARCHAR(128)', 'CircleId': 'VARCHAR(128)', 'Lat': 'DECIMAL(10,7) DEFAULT 0', 'Lng': 'DECIMAL(10,7) DEFAULT 0', 'Accuracy': 'INT DEFAULT 0', 'Speed': 'DECIMAL(6,1) DEFAULT 0', 'IsDriving': 'TINYINT(1) DEFAULT 0', 'InTransit': 'TINYINT(1) DEFAULT 0', 'Address': 'VARCHAR(255)', 'ShortAddress': 'VARCHAR(128)', 'Place': 'VARCHAR(128)', 'Battery': 'INT DEFAULT 0', 'IsCharging': 'TINYINT(1) DEFAULT 0', 'WifiState': 'TINYINT(1) DEFAULT 0', 'SinceTs': 'BIGINT DEFAULT 0', 'LocationTs': 'BIGINT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_life360_location
(Guid, Package, Person, MemberId, CircleId,
Lat, Lng, Accuracy, Speed,
IsDriving, InTransit,
Address, ShortAddress, Place,
Battery, IsCharging, WifiState,
SinceTs, LocationTs, Module)
VALUES
('{guid}', '{package}', '{person}',
'{member_id}', '{circle_id}',
{lat}, {lng}, {accuracy}, {speed},
{is_driving}, {in_transit},
'{address}', '{short_address}', '{place}',
{battery}, {is_charging}, {wifi_state},
{since_ts}, {location_ts},
'ObjServiceLife360')
INSERT INTO data_household
(Package, Person, Lat, Lng, Accuracy,
Speed, IsDriving, Address, Place,
Battery, IsCharging, LocationSrc,
Status, LastSeen, UpdateTime)
VALUES
('{package}', '{person}', {lat}, {lng},
{accuracy}, {speed}, {is_driving},
'{address}', '{place}',
{battery}, {is_charging}, 'life360',
'away', NOW(), NOW())
ON DUPLICATE KEY UPDATE
Lat = {lat},
Lng = {lng},
Accuracy = {accuracy},
Speed = {speed},
IsDriving = {is_driving},
Address = '{address}',
Place = '{place}',
Battery = {battery},
IsCharging = {is_charging},
LocationSrc = 'life360',
UpdateTime = CURRENT_TIMESTAMP
SELECT Person, Lat, Lng, Speed, IsDriving,
Address, ShortAddress, Place,
Battery, IsCharging, CreateTime
FROM data_life360_location WHERE Package = '{package}'
AND Person = '{person}'
ORDER BY CreateTime DESC LIMIT 1