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 db_energes AS SELECT dev_name,total_energy,ts_sample from ammeters

DELETE FROM meter_persists WHERE dev_name = ""