ammeter/cmd/test.sql

-- SQLite
SELECT user, mqtt_url, uid, name, pswd, qos, tenants
FROM gateway_configs;

SELECT * FROM gateway_configs

drop table ammeter_models
drop table s_air_models

CREATE TABLE meter_persists AS SELECT dev_name,ts_sample,total_energy,db_status from ammeters

DELETE FROM meter_persists WHERE dev_name = ""

DROP TABLE db_energes