def main():
db = database_connection()
picloud = SubClient(
url=PICLOUD_SUB_URL,
api_key=PICLOUD_API_KEY,
client_name='THPL-Data-Logger')
def on_thpl_data(data):
cursor = db.cursor()
cursor.callproc('thpl_data_insert', ['home', data])
cursor.close()
picloud.subscribe(event='home:thpl', callback=on_thpl_data)
while True:
picloud.process_subscriptions()
from app.utils.database import database_connection
db = database_connection()
class DatabaseCursorOpen(object):
def process_resource(self, req, resp, resource):
resource.db = db
resource.cursor = db.cursor()
class DatabaseCursorClose(object):
def process_response(self, req, resp, resource):
resource.cursor.close()
import falcon from app.middleware.body_parser import JSONBodyParser from app.middleware.auth import AuthUser from app.utils.database import database_connection db = database_connection() middleware = [JSONBodyParser(), AuthUser()] api = falcon.API(middleware=middleware) from app import routes
def main():
db = database_connection()
cursor = db.cursor()
for proc in PROCS:
cursor.callproc(proc)
