def program_a():
"""
on 3 min
off 3 min
on 3 min
off
"""
three_mins = 3 * 60 # in seconds
start_time = pendulum.now().int_timestamp
on()
sleep(three_mins)
off()
sleep(three_mins)
on()
sleep(three_mins)
off()
end_time = pendulum.now().int_timestamp
with db_conn() as conn:
c = conn.cursor()
values = (start_time, end_time)
c.execute("INSERT INTO cron VALUES (?,?)", values)
conn.commit()
def latest_runs():
with db_conn() as conn:
c = conn.cursor()
c.execute("SELECT * FROM cron ORDER BY start DESC LIMIT 5;")
rows = c.fetchall()
res = {"latest_runs": [{"start": r[0], "end": r[1]} for r in rows]}
return jsonify(res)
def turn_off():
if is_on():
with db_conn() as conn:
c = conn.cursor()
c.execute("DELETE FROM state")
conn.commit()
off()
return redirect(url_for("index"))
def turn_on():
if not is_on():
with db_conn() as conn:
c = conn.cursor()
c.execute("INSERT INTO state VALUES (?)",
(pendulum.now().int_timestamp, ))
conn.commit()
on()
return redirect(url_for("index"))
def on_since():
with db_conn() as conn:
c = conn.cursor()
c.execute("SELECT * FROM state ORDER BY on_since DESC LIMIT 1;")
rows = c.fetchall()
res = None
try:
res = rows[0][0]
except IndexError:
pass
res = {"on_since": res}
return jsonify(res)
# 3rd party
from flask import Flask, render_template, redirect, url_for, jsonify
import RPi.GPIO as GPIO
import pendulum
from waitress import serve
from paste.translogger import TransLogger
# local
from common import PIN, MAIN_DB, db_conn, off, on, setup_gpio, is_on
logger = logging.getLogger("waitress")
logger.setLevel(logging.INFO)
app = Flask(__name__)
with db_conn() as conn:
c = conn.cursor()
c.execute("CREATE TABLE IF NOT EXISTS state (on_since INT)")
conn.commit()
@app.route("/")
def index():
current_state = "ON" if is_on() else "OFF"
data = {"current_state": current_state}
return render_template("index.j2", data=data)
@app.route("/on")
def turn_on():
if not is_on():