def print_device(query):
db = dbfn.Db("../edge.sqlite3")
q_sel = "SELECT section, device FROM ems_mb_device where query = ?"
query_data = db.get_recs(q_sel, (query, ))
db.close()
for k in query_data:
print(" Device:", k[0], k[1])
def print_messages():
db = dbfn.Db("../edge.sqlite3")
q_sel = "SELECT msg, message_type, server_address, server_port, event_on FROM ems_msg"
slave_data = db.get_recs(q_sel)
db.close()
for k in slave_data:
print("Message " + k[1] + ":", k[0], "@", k[2], ":", k[3], "~", k[4])
print_query(k[0])
def print_slaves():
db = dbfn.Db("../edge.sqlite3")
q_sel = "SELECT slave, modbus_address, modbus_port FROM ems_mb_slave"
slave_data = db.get_recs(q_sel)
db.close()
for k in slave_data:
print("Slaves:", k[0], "@", k[1], ":", k[2])
print_query(k[0])
def print_query(slave):
db = dbfn.Db("../edge.sqlite3")
q_sel = "SELECT query, unit, start_address, length FROM ems_mb_query where slave = ?"
query_data = db.get_recs(q_sel, (slave, ))
db.close()
for k in query_data:
print(" Query:", k[0], "Uint:", k[1], "Address:", k[2], "to",
k[2] + k[3] - 1)
print_device(k[0])
import dbfn
db = dbfn.Db("../ems_parsa.sqlite3")
site = "parsa"
slaves = " where slave in ('Parsa_plc')"
process = " where process in ('Parsa')"
slaves = " where slave in ( select slave from ems_mb_slave " + process + ")"
# sections = " where section in ('ParsaInverterBlock','ParsaBatteryBlock','ParsaMeterBlock','ParsaPlcBlock')"
sections = """ where section in (select section from ems_mb_device where query in
(select query from ems_mb_query """ + slaves + """ ) ) """
messages = " WHERE msg in (select msg from ems_msg " + process + ")"
q_sel = "select * from ems_function " + process
table = "ems_function"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_device " + sections
table = "ems_mb_device"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_field " + sections
table = "ems_mb_field"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_query " + slaves
table = "ems_mb_query"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_section " + sections
import dbfn
db = dbfn.Db("../ems.sqlite3")
site = "bheldi"
process = " where process in ('Bheldi')"
#########################
slaves = " where slave in ( select slave from ems_mb_slave " + process + ")"
messages = " WHERE msg in (select msg from ems_msg " + process + ")"
sections = """ where section in (select section from ems_mb_device where query in
(select query from ems_mb_query """ + slaves + """ ) ) """
q_sel = "select * from ems_function " + process
table = "ems_function"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_device " + sections
table = "ems_mb_device"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_field " + sections
table = "ems_mb_field"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_query " + slaves
table = "ems_mb_query"
db.export(q_sel, table, site)
q_sel = "select * from ems_mb_section " + sections