{'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', 'PumpWas': 'VARCHAR(8)', 'PumpNow': '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
SELECT CreateTime FROM data_pool_schedule WHERE PumpWas != 'on'
AND PumpNow = 'on'
ORDER BY CreateTime DESC LIMIT 1
INSERT INTO data_pool_schedule
(Guid, Package, PvPowerW, BatterySoc,
PumpWas, PumpNow, Reason, Module)
VALUES
('{guid}', '{package}', {pv_power}, {soc},
'{pump_was}', '{pump_now}', '{reason}',
'ObjServicePoolScheduler')