{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'PvPowerW': 'DECIMAL(10,2) DEFAULT 0', 'BatterySoc': 'DECIMAL(5,1) DEFAULT 0', 'GeyserWas': 'VARCHAR(8)', 'GeyserNow': 'VARCHAR(8)', 'Reason': 'VARCHAR(255)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
SELECT PvPowerTotal, BatterySoc FROM data_solarman_realtime ORDER BY CreateTime DESC LIMIT 1
INSERT INTO data_geyser_schedule
(Guid, Package, PvPowerW, BatterySoc,
GeyserWas, GeyserNow, Reason, Module)
VALUES
('{guid}', '{package}', {pv_power}, {soc},
'{geyser_was}', '{geyser_now}', '{reason}',
'ObjServiceGeyserScheduler')