sqlite> .read dashboardv3.sql .read dashboardv3.sql .echo on .headers on .mode column --.system ls -lha /dev/ttyU* --select load_extension('libsqlitefunctions.so'); .open 'ramdisk/aiox.db' Error: near line 8: near "PRAGMA": syntax error select load_extension('/usr/lib/arm-linux-gnueabihf/libsqlitefunctions.so'); load_extension('/usr/lib/arm-linux-gnueabihf/libsqlitefunctions.so') -------------------------------------------------------------------- .databases main: /var/www/html/AIO/ramdisk/aiox.db .tables ACInModels SystemStatuses hrs ir period25hrs BatteryTypes bms hrv1 ire period49hrs ChargeConfigs eod hrvp irv1 period97hrs Etoday gwdisplay hrx irx periodhrs13 OutputConfigs hr interval10min kwhs .show echo: on eqp: off explain: auto headers: on mode: column nullvalue: "" output: stdout colseparator: "|" rowseparator: "\n" stats: off width: filename: ramdisk/aiox.db --.schema -- lists latest row of hr and ir tables .schema hr CREATE TABLE hr ( serial text , dt text , Standby text --0 0-1 P04 , OutputConfigId text --1 0-3 P01 , ChargeConfigId text --2 0-2 P14 , ACInModelId text --8 0-2 P03 , OutputVoltTypeId text --9 0-6 P08 , MaxChargeCurr num --34 A P02 , BulkChargeVolt num --35 0.1V P19 , FloatChargeVolt num --36 0.1V P20 , BatLowToUtiVolt num --37 0.1V P12 , ACChargeCurr num --38 0.1V P11 , BatteryTypeId text --39 0-4 P05 , BatCutOffVol num --82 0.1V P21 , Uti2BatVolt num --95 0.1V P13 , PRIMARY KEY(serial, dt) ); .mode line select * from hr order by dt desc limit 1; serial = PAH0B0401T dt = 2024-01-20 11:59:06 Standby = 1 OutputConfigId = 0 ChargeConfigId = 1 ACInModelId = 0 OutputVoltTypeId = 6 MaxChargeCurr = 60 BulkChargeVolt = 28.2 FloatChargeVolt = 27.6 BatLowToUtiVolt = 24 ACChargeCurr = 10 BatteryTypeId = 2 BatCutOffVol = 23 Uti2BatVolt = 26 select * from hrv1 order by dt desc limit 1; dt = 2024-01-20 11:59:06 ACInModelId = 0 ACInModel = APL,65-140VAC BatteryTypeId = 2 BatteryType = USE ChargeConfigId = 1 ChargeConfig = S&U,PV&UTI OutputConfigId = 0 OutputConfig = SBU,PV>Bat>UTI --.schema ir select * from irv1 order by dt desc limit 1; dt = 2024-01-20 12:30:03 SystemStatusId = 12 SystemStatus = PV charge and Discharge select *, round(ACChr_Watt/BatVolt) dACCur, (AC_InWatt - ACChr_Watt) dBypass from ir order by dt desc limit 1; serial = PAH0B0401T dt = 2024-01-20 12:30:03 SystemStatusId = 12 Vpv1 = 55.6 Ppv1 = 135 Buck1Cur = 4.8 OP_Watt = 110 OP_VA = 113 ACChr_Watt = 0 ACChr_VA = 0 BatVolt = 27.63 BatSOC = 100 BusVolt = 243.6 GridVolt = 123.7 LineFreq = 60 OutputVolt = 119.7 OutputFreq = 59.99 InvTemp = 16.5 DCDCTemp = 17.3 WorkTime = 0 AC_InWatt = 0 AC_InVA = 0 Epv1_today = 0.4 Epv1_total = 1164 Eac_chrToday = 0 Eac_chrTotal = 433.3 Ebat_dischrToday = 1.6 Ebat_dischrTotal = 916.8 Eac_dischrToday = 0 Eac_dischrTotal = 271.1 Bat_Watt = -19 Eop_dischrToday = 2 Eop_dischrTotal = 1537.8 dACCur = 0.0 dBypass = 0 sqlite>