def main():
logging.basicConfig(format='%(asctime)s %(message)s',
datefmt='%m/%d/%Y %I:%M:%S %p')
db = Store()
reader = CsvReader()
data = reader.get_data_from_csv('Monitoring report.csv')
if data is None:
exit
conn = db.create_connection(db_file='monitoring-report.db')
if conn is None:
exit
# Create the monitoring table
sql_create_table = "CREATE TABLE IF NOT EXISTS monitoring(date, energy, reactive_energy, power, maximeter, reactive_power, voltage, intensity, power_factor)"
if db.create_table(conn, sql_create_table) is None:
exit
values = []
for index, row in data.iterrows():
values.append(row)
db.insert_data(conn, values)
conn.close()
def get_active_power(self, date_from, date_to):
db = Store()
conn = db.create_connection('monitoring-report.db')
with conn:
cursor = conn.cursor()
cursor.execute(
"SELECT date, power FROM monitoring WHERE date BETWEEN ? AND ?",
[date_from, date_to])
data = cursor.fetchall()
return data
